[Home] [Help]
547: select oeh.order_number , msi.segment1, oel.line_number || '.' || oel.shipment_number
548: , msi.inventory_item_id , msi.organization_id
549: into v_order_number, v_top_model_name, v_top_model_line_num
550: , v_top_model_id, v_ship_from_org_id
551: from oe_order_headers_all oeh , oe_order_lines_all oel , mtl_system_items msi
552: where oeh.header_id = oel.header_id
553: and oel.line_id = lTopAtoLineId
554: and oel.inventory_item_id = msi.inventory_item_id
555: and oel.ship_from_org_id = msi.organization_id ;
701: oe_debug_pub.add( 'DROPPED component count > 0 ' , 1 ) ;
702:
703: select oeh.order_number , msi.segment1, oel.line_number || '.' || oel.shipment_number
704: into v_order_number, v_top_model_name, v_top_model_line_num
705: from oe_order_headers_all oeh , oe_order_lines_all oel , mtl_system_items msi
706: where oeh.header_id = oel.header_id
707: and oel.line_id = lTopAtoLineId
708: and oel.inventory_item_id = msi.inventory_item_id
709: and oel.ship_from_org_id = msi.organization_id ;
2429: select reservation_id
2430: into lReserveId
2431: from mtl_reservations mr,
2432: oe_order_lines_all oel,
2433: oe_order_headers_all oeh,
2434: oe_transaction_types_all ota,
2435: oe_transaction_types_tl otl,
2436: mtl_sales_orders mso
2437: where mr.demand_source_line_id = oel.line_id --ato item line id
2517: select count(*)
2518: into lRsvCount
2519: from mtl_reservations mr,
2520: oe_order_lines_all oel,
2521: oe_order_headers_all oeh,
2522: oe_transaction_types_all ota,
2523: oe_transaction_types_tl otl,
2524: mtl_sales_orders mso
2525: where mr.demand_source_line_id = oel.line_id --ato item line id
4543: select wip_entity_id
4544: into lWipEntityId
4545: from wip_flow_schedules wfs,
4546: oe_order_lines_all oel,
4547: oe_order_headers_all oeh,
4548: oe_transaction_types_all ota,
4549: oe_transaction_types_tl otl,
4550: mtl_sales_orders mso
4551: where wfs.demand_source_line = to_char(pLineId) --config line id