DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on OE_ORDER_HEADERS_ALL

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

1332: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1333: ||to_char(option_number)),
1334: oeh.order_number
1335: into v_missed_item,v_missed_line_number,v_order_number
1336: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1337: where msi.organization_id = oel.ship_from_org_id
1338: and msi.inventory_item_id = oel.inventory_item_id
1339: and oel.header_id = oeh.header_id
1340: and oel.line_id = v_missed_line_id;