Oracle Business Intelligence Applications (Oracle BI Apps) OOTB Integration_id

w_sales_order_line_f.integration_id  = oe_order_lines_all.line_id

w_sales_invoice_line_f.integration_id  = RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID

w_product_d.integration_id = MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID

w_product_lot_xact_f.integration_id = MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID~MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER

w_product_xact_f.integration_id =  MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID~MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER

SIL_ARTransactionFact
w_ar_xact_f.integration_id = w_ar_xact_fs.integration_id 
SDE_ORA_ARTransactionFact_ReceivableApplication
w_ar_xact_fs.integration_id = 
IIF(
ISNULL(SQ_AR_XACTS_APPREC.ORIGINAL_LINE_ID) OR SQ_AR_XACTS_APPREC.UPG_FLG = 'Y',
'R'||'~'||
TO_CHAR(SQ_AR_XACTS_APPREC.LINE_ID),
'R~RECEIPTREVERSE~'||
TO_CHAR(SQ_AR_XACTS_APPREC.LINE_ID)||'~'||
TO_CHAR(SQ_AR_XACTS_APPREC.ORIGINAL_LINE_ID)
)

SQ_AR_XACTS_APPREC.LINE_ID = AR_DISTRIBUTIONS_ALL.LINE_ID