eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_EDW_COGS_F_SZ dependencies on MTL_MATERIAL_TRANSACTIONS

Line 17: mtl_material_transactions mmt

13: oe_order_lines_all pl,
14: oe_order_lines_all l,
15: wsh_delivery_details wdd,
16: mtl_transaction_accounts mta,
17: mtl_material_transactions mmt
18: where mmt.transaction_source_type_id = 2
19: and mta.transaction_source_type_id = 2
20: and mmt.transaction_id = mta.transaction_id
21: and mta.accounting_line_type in (2, 35)

Line 45: mtl_material_transactions mmt

41: oe_order_lines_all pl,
42: oe_order_lines_all cl,
43: oe_order_lines_all l,
44: mtl_transaction_accounts mta,
45: mtl_material_transactions mmt
46: where mmt.transaction_source_type_id = 12
47: and mta.transaction_source_type_id = 12
48: and mmt.transaction_id = mta.transaction_id
49: and mta.accounting_line_type in (2, 35)

Line 72: mtl_material_transactions mmt,

68: oe_order_lines_all l, /* child line */
69: ra_customer_trx_lines_all rcl,
70: ap_invoice_distributions_all aid,
71: ap_invoices_all ai,
72: mtl_material_transactions mmt,
73: mtl_parameters mp
74: WHERE ai.source = 'Intercompany'
75: AND aid.invoice_id = ai.invoice_id
76: and aid.org_id = ai.org_id

Line 124: FROM mtl_material_transactions

120: avg(nvl(vsize(subinventory_code), 0)) sub_code,
121: avg(nvl(vsize(locator_id), 0)) locator,
122: avg(nvl(vsize(primary_quantity), 0)) qty,
123: avg(nvl(vsize(inventory_item_id), 0)) item_id
124: FROM mtl_material_transactions
125: WHERE last_update_date between p_from_date and p_to_date;
126:
127: CURSOR c_mta IS
128: SELECT avg(nvl(vsize(cost_element_id), 0)) cost_element_id,