APPS.OPI_EDW_COGS_F_SZ dependencies on MTL_TRANSACTION_ACCOUNTS

Line 16: mtl_transaction_accounts mta,

12: oe_order_headers_all h,
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

Line 44: mtl_transaction_accounts mta,

40: oe_order_headers_all h,
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

Line 131: FROM mtl_transaction_accounts

127: CURSOR c_mta IS
128: SELECT avg(nvl(vsize(cost_element_id), 0)) cost_element_id,
129: avg(nvl(vsize(transaction_value), 0)) transaction_value,
130: avg(nvl(vsize(reference_account), 0)) account
131: FROM mtl_transaction_accounts
132: WHERE last_update_date between p_from_date and p_to_date;
133:
134: CURSOR c_line IS
135: SELECT avg(nvl(vsize(line_id), 0)) line_id,