DBA Data[Home] [Help]

APPS.INV_FA_INTERFACE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 25: , mtl_material_transactions MMT

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'
29: AND MMT.transaction_id = to_number(RCTL.interface_line_attribute7)

Line 87: , mtl_material_transactions MMT

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)
91: AND MMT.transaction_source_type_id = 8