APPS.CST_REVENUECOGSMATCH_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1424: oe_order_headers_all ooh,

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
1428: AND TO_CHAR(ooh.order_number) = mso.segment1

Line 2363: oe_order_headers_all ooh,

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
2367: AND to_char(ooh.order_number) = mkts.segment1

Line 3325: oe_order_headers_all ooh,

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
3329: AND TO_CHAR(ooh.order_number) = mso.segment1

Line 6092: OE_ORDER_HEADERS_ALL OOH,

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
6096: AND CRCML.OPERATING_UNIT_ID = :i_operating_unit

Line 6140: OE_ORDER_HEADERS_ALL OOH,

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
6144: AND CRCML.OPERATING_UNIT_ID = :i_operating_unit

Line 6471: OE_ORDER_HEADERS_ALL OOH,

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,
6475: CST_AE_LINES CAL