DBA Data[Home] [Help]

APPS.OPI_EDW_COGS_F_C dependencies on MTL_MATERIAL_TRANSACTIONS

Line 78: mtl_material_transactions mmt

74: oe_order_headers_all h,
75: oe_order_lines_all pl,
76: oe_order_lines_all l,
77: mtl_transaction_accounts mta,
78: mtl_material_transactions mmt
79: where ( (mmt.transaction_source_type_id = 2
80: and mta.transaction_source_type_id = 2)
81: or
82: (mmt.transaction_source_type_id = 13

Line 119: mtl_material_transactions mmt

115: oe_order_lines_all pl,
116: oe_order_lines_all cl,
117: oe_order_lines_all l,
118: mtl_transaction_accounts mta,
119: mtl_material_transactions mmt
120: where ( (mmt.transaction_source_type_id = 12
121: and mta.transaction_source_type_id = 12)
122: or
123: (mmt.transaction_source_type_id = 13

Line 161: mtl_material_transactions mmt,

157: oe_order_lines_all l, /* child line */
158: ra_customer_trx_lines_all rcl,
159: ap_invoice_distributions_all aid,
160: ap_invoices_all ai,
161: mtl_material_transactions mmt,
162: mtl_parameters mp
163: WHERE ai.source = 'Intercompany'
164: AND aid.invoice_id = ai.invoice_id
165: and translate( lower(aid.REFERENCE_1), 'abcdefghijklmnopqrstuvwxyz_ -+0123456789',