DBA Data[Home] [Help]

APPS.OPI_EDW_COGS_F_C dependencies on OE_ORDER_HEADERS_ALL

Line 74: oe_order_headers_all h,

70: INTO opi_edw_cogs_inc(primary_key1, seq_id, view_id)
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

Line 114: oe_order_headers_all h,

110: INTO opi_edw_cogs_inc(primary_key1, seq_id, view_id)
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,

Line 155: oe_order_headers_all h,

151: DISTINCT aid.invoice_id,
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,