DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on OE_ORDER_HEADERS_ALL

Line 1785: oe_order_headers_all oeh

1781: CURSOR c_order_details IS
1782: Select distinct(bcmm.order_line_id),oeh.order_number
1783: from bom_cto_mlsupply_main_temp bcmm,
1784: oe_order_lines_all oel,
1785: oe_order_headers_all oeh
1786: where bcmm.order_line_id = oel.line_id
1787: and oel.header_id = oeh.header_id
1788: order by oeh.order_number, bcmm.order_line_id;
1789:

Line 2156: oe_order_headers_all oeh,

2152: l_order_number,
2153: l_cfm_routing_flag,
2154: l_routing_sequence_id
2155: FROM oe_order_lines_all oel,
2156: oe_order_headers_all oeh,
2157: mtl_system_items_kfv mtl,
2158: bom_operational_routings bor
2159: WHERE oel.line_id = p_Top_Assembly_LineId
2160: AND oeh.header_id = oel.header_id