DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on OE_ORDER_HEADERS_ALL

Line 1805: oe_order_headers_all oeh

1801: SELECT DISTINCT(bcmm.order_line_id) order_line_id,
1802: oeh.order_number order_number
1803: FROM bom_cto_mlsupply_main_temp bcmm,
1804: oe_order_lines_all oel,
1805: oe_order_headers_all oeh
1806: WHERE bcmm.order_line_id = oel.line_id
1807: AND oel.header_id = oeh.header_id
1808: ORDER BY oeh.order_number,
1809: bcmm.order_line_id;

Line 2164: oe_order_headers_all oeh,

2160: l_order_number,
2161: l_cfm_routing_flag,
2162: l_routing_sequence_id
2163: FROM oe_order_lines_all oel,
2164: oe_order_headers_all oeh,
2165: mtl_system_items_kfv mtl,
2166: bom_operational_routings bor
2167: WHERE oel.line_id = p_Top_Assembly_LineId
2168: AND oeh.header_id = oel.header_id