APPS.CTO_UPDATE_BOM_RTG_PK dependencies on OE_ORDER_HEADERS_ALL

Line 1047: oe_order_headers_all oeh

1043: oeh.order_number order_num,
1044: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number)) line_num
1045: from bom_cto_order_lines_upg bcolu,
1046: oe_order_lines_all oel,
1047: oe_order_headers_all oeh
1048: where bcolu.config_item_id = pConfigId
1049: and nvl(bcolu.program_id, -99) <> 99
1050: and bcolu.line_id = oel.ato_line_id
1051: and oel.item_type_code = 'CONFIG'

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

1849: select substrb(msi.concatenated_segments,1,50),
1850: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1851: oeh.order_number
1852: into v_missed_item,v_missed_line_number,v_order_number
1853: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1854: where msi.organization_id = oel.ship_from_org_id
1855: and msi.inventory_item_id = oel.inventory_item_id
1856: and oel.header_id = oeh.header_id
1857: and oel.line_id = v_missed_line_id;

Line 2075: oe_order_headers_all oeh

2071: l_order_num,
2072: l_line_number
2073: from bom_cto_order_lines_upg bcolu,
2074: oe_order_lines_all oel,
2075: oe_order_headers_all oeh
2076: where bcolu.line_id = pLineId
2077: and bcolu.ato_line_id = oel.ato_line_id /* BUG 3396081 dropped component in lower config */
2078: and oel.item_type_code = 'CONFIG'
2079: and oel.header_id = oeh.header_id;