[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 ;
2396: select reservation_id
2397: into lReserveId
2398: from mtl_reservations mr,
2399: oe_order_lines_all oel,
2400: oe_order_headers_all oeh,
2401: oe_transaction_types_all ota,
2402: oe_transaction_types_tl otl,
2403: mtl_sales_orders mso
2404: where mr.demand_source_line_id = oel.line_id --ato item line id
2484: select count(*)
2485: into lRsvCount
2486: from mtl_reservations mr,
2487: oe_order_lines_all oel,
2488: oe_order_headers_all oeh,
2489: oe_transaction_types_all ota,
2490: oe_transaction_types_tl otl,
2491: mtl_sales_orders mso
2492: where mr.demand_source_line_id = oel.line_id --ato item line id
4444: select wip_entity_id
4445: into lWipEntityId
4446: from wip_flow_schedules wfs,
4447: oe_order_lines_all oel,
4448: oe_order_headers_all oeh,
4449: oe_transaction_types_all ota,
4450: oe_transaction_types_tl otl,
4451: mtl_sales_orders mso
4452: where wfs.demand_source_line = to_char(pLineId) --config line id