DBA Data[Home] [Help]

APPS.INV_FA_INTERFACE_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 24: , ra_customer_trx_lines_all RCTL

20: BEGIN
21: SELECT MMT.trx_source_line_id
22: INTO l_trx_src_line_id
23: FROM ap_invoice_distributions_all APINVD
24: , ra_customer_trx_lines_all RCTL
25: , mtl_material_transactions MMT
26: WHERE APINVD.invoice_distribution_id = p_inv_dist_id
27: AND RCTL.customer_trx_line_id = to_number(APINVD.reference_1)
28: AND RCTL.interface_line_context = 'INTERCOMPANY'

Line 86: FROM ra_customer_trx_lines_all RCTL

82:
83: BEGIN
84: SELECT MMT.trx_source_line_id
85: INTO l_trx_src_line_id
86: FROM ra_customer_trx_lines_all RCTL
87: , mtl_material_transactions MMT
88: WHERE RCTL.customer_trx_line_id = to_number(p_inv_ref_id)
89: AND RCTL.interface_line_context = 'INTERCOMPANY'
90: AND MMT.transaction_id = to_number(RCTL.interface_line_attribute7)