APPS.CTO_UPDATE_BOM_RTG_PK dependencies on OE_ORDER_HEADERS_ALL

Line 988: oe_order_headers_all oeh

984: oeh.order_number order_num,
985: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number)) line_num
986: from bom_cto_order_lines_upg bcolu,
987: oe_order_lines_all oel,
988: oe_order_headers_all oeh
989: where bcolu.config_item_id = pConfigId
990: and nvl(bcolu.program_id, -99) <> 99
991: and bcolu.line_id = oel.ato_line_id
992: and oel.item_type_code = 'CONFIG'

Line 1794: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh

1790: select substrb(msi.concatenated_segments,1,50),
1791: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1792: oeh.order_number
1793: into v_missed_item,v_missed_line_number,v_order_number
1794: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1795: where msi.organization_id = oel.ship_from_org_id
1796: and msi.inventory_item_id = oel.inventory_item_id
1797: and oel.header_id = oeh.header_id
1798: and oel.line_id = v_missed_line_id;

Line 1986: oe_order_headers_all oeh

1982: l_order_num,
1983: l_line_number
1984: from bom_cto_order_lines_upg bcolu,
1985: oe_order_lines_all oel,
1986: oe_order_headers_all oeh
1987: where bcolu.line_id = pLineId
1988: and bcolu.ato_line_id = oel.ato_line_id /* BUG 3396081 dropped component in lower config */
1989: and oel.item_type_code = 'CONFIG'
1990: and oel.header_id = oeh.header_id;