1306: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1307: ||to_char(option_number)),
1308: oeh.order_number
1309: into v_missed_item,v_missed_line_number,v_order_number
1310: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1311: where msi.organization_id = oel.ship_from_org_id
1312: and msi.inventory_item_id = oel.inventory_item_id
1313: and oel.header_id = oeh.header_id
1314: and oel.line_id = v_missed_line_id;