DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1243: oe_order_headers_all ooh,

1239: ccqa.adj_new_cogs_percentage
1240: FROM cst_cogs_qty_adj_events_temp ccqa,
1241: mtl_sales_orders mso,
1242: oe_order_lines_all ool,
1243: oe_order_headers_all ooh,
1244: oe_transaction_types_tl ott
1245: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
1246: AND ool.header_id = ooh.header_id
1247: AND TO_CHAR(ooh.order_number) = mso.segment1

Line 2315: oe_order_headers_all ooh,

2311: SET (transaction_source_id) = (
2312: SELECT mkts.sales_order_id
2313: FROM mtl_sales_orders mkts,
2314: oe_order_lines_all ool,
2315: oe_order_headers_all ooh,
2316: oe_transaction_types_tl ott
2317: WHERE ool.line_id = mcr.trx_source_line_id
2318: AND ool.header_id = ooh.header_id
2319: AND to_char(ooh.order_number) = mkts.segment1

Line 3299: oe_order_headers_all ooh,

3295: ccqa.adj_new_cogs_percentage
3296: FROM cst_cogs_qty_adj_events_temp ccqa,
3297: mtl_sales_orders mso,
3298: oe_order_lines_all ool,
3299: oe_order_headers_all ooh,
3300: oe_transaction_types_tl ott
3301: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
3302: AND ool.header_id = ooh.header_id
3303: AND TO_CHAR(ooh.order_number) = mso.segment1

Line 5972: OE_ORDER_HEADERS_ALL OOH,

5968: CST_REVENUE_COGS_MATCH_LINES CRCML,
5969: CST_COGS_EVENTS CCE,
5970: GL_PERIOD_STATUSES GPS,
5971: OE_ORDER_LINES_ALL OOL,
5972: OE_ORDER_HEADERS_ALL OOH,
5973: MTL_TRANSACTION_ACCOUNTS MTA
5974: WHERE
5975: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high
5976: AND CRCML.OPERATING_UNIT_ID = :i_operating_unit

Line 6182: OE_ORDER_HEADERS_ALL OOH,

6178: FROM
6179: CST_REVENUE_COGS_MATCH_LINES CRCML,
6180: CST_COGS_EVENTS CCE,
6181: OE_ORDER_LINES_ALL OOL,
6182: OE_ORDER_HEADERS_ALL OOH,
6183: CST_COST_GROUP_ASSIGNMENTS CCGA,
6184: CST_PAC_PERIODS CPP,
6185: CST_AE_HEADERS CAH,
6186: CST_AE_LINES CAL