APPS.CST_REVENUECOGSMATCH_PVT dependencies on OE_ORDER_LINES_ALL

Line 878: oe_order_lines_all ool,

874: cce.parent_event_id prior_event_id,
875: cce.cogs_percentage cogs_percentage,
876: sum(cce.event_quantity) prior_event_quantity
877: FROM mtl_material_transactions mmt,
878: oe_order_lines_all ool,
879: cst_revenue_cogs_match_lines crcml,
880: cst_cogs_events cce,
881: mtl_system_items_b item
882: ,cst_acct_info_v caiv --BUG#7463298

Line 946: oe_order_lines_all ool,

942: cce.parent_event_id prior_event_id,
943: cce.cogs_percentage cogs_percentage,
944: sum(cce.event_quantity) prior_event_quantity
945: FROM mtl_material_transactions mmt,
946: oe_order_lines_all ool,
947: cst_revenue_cogs_match_lines crcml,
948: cst_cogs_events cce,
949: mtl_system_items_b item
950: ,cst_acct_info_v caiv --BUG#7463298

Line 1423: oe_order_lines_all ool,

1419: 1, -- Logical Txn
1420: ccqa.adj_new_cogs_percentage
1421: FROM cst_cogs_qty_adj_events_temp ccqa,
1422: mtl_sales_orders mso,
1423: oe_order_lines_all ool,
1424: oe_order_headers_all ooh,
1425: oe_transaction_types_tl ott
1426: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
1427: AND ool.header_id = ooh.header_id

Line 2362: oe_order_lines_all ool,

2358: UPDATE mtl_cogs_recognition_temp mcr
2359: SET (transaction_source_id, transaction_source_name) = (
2360: SELECT mkts.sales_order_id, mkts.segment1
2361: FROM mtl_sales_orders mkts,
2362: oe_order_lines_all ool,
2363: oe_order_headers_all ooh,
2364: oe_transaction_types_tl ott
2365: WHERE ool.line_id = mcr.trx_source_line_id
2366: AND ool.header_id = ooh.header_id

Line 3324: oe_order_lines_all ool,

3320: 1, -- Logical Txn
3321: ccqa.adj_new_cogs_percentage
3322: FROM cst_cogs_qty_adj_events_temp ccqa,
3323: mtl_sales_orders mso,
3324: oe_order_lines_all ool,
3325: oe_order_headers_all ooh,
3326: oe_transaction_types_tl ott
3327: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
3328: AND ool.header_id = ooh.header_id

Line 6091: OE_ORDER_LINES_ALL OOL,

6087: FROM
6088: CST_REVENUE_COGS_MATCH_LINES CRCML,
6089: CST_COGS_EVENTS CCE,
6090: GL_PERIOD_STATUSES GPS,
6091: OE_ORDER_LINES_ALL OOL,
6092: OE_ORDER_HEADERS_ALL OOH,
6093: MTL_TRANSACTION_ACCOUNTS MTA
6094: WHERE
6095: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high

Line 6139: OE_ORDER_LINES_ALL OOL,

6135: FROM
6136: CST_REVENUE_COGS_MATCH_LINES CRCML,
6137: CST_COGS_EVENTS CCE,
6138: GL_PERIOD_STATUSES GPS,
6139: OE_ORDER_LINES_ALL OOL,
6140: OE_ORDER_HEADERS_ALL OOH,
6141: MTL_TRANSACTION_ACCOUNTS MTA
6142: WHERE
6143: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high

Line 6470: OE_ORDER_LINES_ALL OOL,

6466: sum(decode(CAL.ae_line_type_code, 36, nvl(CAL.accounted_dr,0) - nvl(CAL.accounted_cr,0),0)) DEF_COGS_BALANCE
6467: FROM
6468: CST_REVENUE_COGS_MATCH_LINES CRCML,
6469: CST_COGS_EVENTS CCE,
6470: OE_ORDER_LINES_ALL OOL,
6471: OE_ORDER_HEADERS_ALL OOH,
6472: CST_COST_GROUP_ASSIGNMENTS CCGA,
6473: CST_PAC_PERIODS CPP,
6474: CST_AE_HEADERS CAH,