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_C dependencies on OE_ORDER_LINES_ALL

Line 75: oe_order_lines_all pl,

71: SELECT /*+ parallel(mmt) */
72: DISTINCT mmt.transaction_id, l_seq_id, 1
73: FROM
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

Line 76: oe_order_lines_all l,

72: DISTINCT mmt.transaction_id, l_seq_id, 1
73: FROM
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)

Line 115: oe_order_lines_all pl,

111: SELECT /*+ parallel(mmt) */
112: DISTINCT mmt.transaction_id, l_seq_id, 2
113: FROM
114: oe_order_headers_all h,
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

Line 116: oe_order_lines_all cl,

112: DISTINCT mmt.transaction_id, l_seq_id, 2
113: FROM
114: oe_order_headers_all h,
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

Line 117: oe_order_lines_all l,

113: FROM
114: oe_order_headers_all h,
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)

Line 156: oe_order_lines_all pl, /* parent line */

152: aid.distribution_line_number,
153: l_seq_id, 3
154: FROM
155: oe_order_headers_all h,
156: oe_order_lines_all pl, /* parent line */
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,

Line 157: oe_order_lines_all l, /* child line */

153: l_seq_id, 3
154: FROM
155: oe_order_headers_all h,
156: oe_order_lines_all pl, /* parent line */
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,