[Home] [Help]
88: nvl(mr.secondary_reservation_quantity,0), /*Bug7041074*/
89: mr.reservation_id,
90: lo.inventory_location_id
91: FROM mtl_reservations mr,
92: wms_item_locations_kfv lo,
93: wms_license_plate_numbers lpn
94: WHERE lo.inventory_location_id(+) = mr.locator_id
95: AND mr.organization_id = p_org_id
96: AND mr.demand_source_type_id = 5
137: d.secondary_dispensed_qty,
138: d.dispense_id,
139: lo.inventory_location_id
140: FROM gme_material_dispensing_gtmp d,
141: wms_item_locations_kfv lo
142: WHERE lo.inventory_location_id(+) = d.locator_id
143: AND lo.subinventory_code(+) = d.subinventory_code
144: ORDER BY d.dispense_id;
145:
2349: ,d.dispense_uom
2350: , dispense_id
2351: ,d.revision
2352: FROM mtl_secondary_inventories s,
2353: wms_item_locations_kfv b,
2354: gme_material_dispensing_gtmp d
2355: WHERE
2356: d.subinventory_code LIKE (p_subinv_code)
2357: AND s.secondary_inventory_name = d.subinventory_code
2542:
2543: sqlstmt := ' SELECT a.concatenated_segments, '
2544: ||' a.description, '
2545: ||' a.inventory_location_id '
2546: ||' FROM wms_item_locations_kfv a, '
2547: ||' mtl_secondary_locators b '
2548: ||' WHERE b.organization_id = :p_organization_Id '
2549: ||' AND b.inventory_item_id = :p_Inventory_Item_Id '
2550: ||' AND b.subinventory_code = :p_Subinventory_Code '
2558:
2559: sqlstmt := ' SELECT concatenated_segments, '
2560: ||' description, '
2561: ||' inventory_location_id '
2562: ||' FROM wms_item_locations_kfv '
2563: ||' WHERE organization_id = :p_organization_id '
2564: ||' AND subinventory_code = :p_subinventory_code '
2565: ||' AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) '
2566: ||' AND concatenated_segments LIKE (:p_concatenated_segments) '
2600: IF l_ind = 1 THEN
2601: OPEN x_locators FOR
2602: SELECT DISTINCT loc.concatenated_segments locator, loc.description,
2603: onh.locator_id
2604: FROM wms_item_locations_kfv loc, mtl_onhand_locator_v onh
2605: WHERE loc.organization_id = onh.organization_id
2606: AND loc.inventory_location_id = onh.locator_id
2607: AND NVL(loc.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2608: AND loc.organization_id = p_organization_id
2660: OPEN x_Locators FOR
2661: SELECT a.concatenated_segments,
2662: a.description,
2663: a.inventory_location_id
2664: FROM wms_item_locations_kfv a,
2665: mtl_reservations mr
2666: WHERE mr.organization_id = p_organization_id
2667: AND mr.inventory_item_id = p_item_id
2668: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2696: OPEN x_Locators FOR
2697: SELECT a.concatenated_segments,
2698: a.description,
2699: a.inventory_location_id
2700: FROM wms_item_locations_kfv a,
2701: mtl_reservations mr
2702: WHERE mr.locator_id = a.inventory_location_id
2703: AND mr.organization_id = p_organization_id
2704: AND mr.inventory_item_id = p_item_id
2747: ||' ,NVL(t.secondary_dispensed_qty, 0) '
2748: ||' ,dispense_uom '
2749: ||' ,dispense_id '
2750: ||' ,t.revision '
2751: ||' FROM wms_item_locations_kfv a, '
2752: ||' gme_material_dispensing_gtmp t '
2753: ||' WHERE '
2754: ||' t.subinventory_code = :p_subinv_code '
2755: ||' AND a.subinventory_code = t.subinventory_code '
2798: SELECT a.concatenated_segments,
2799: a.description,
2800: a.inventory_location_id,
2801: ROUND(SUM(atr),4) atr
2802: FROM wms_item_locations_kfv a,
2803: mtl_rsv_quantities_temp t
2804: WHERE ((t.node_level = 4
2805: AND t.subinventory_code not in (select subinventory_code from
2806: mtl_rsv_quantities_temp where node_level = 5)) OR
3354: lo.pending_product_lot_id,
3355: NVL(m.locator_id,-1)
3356: FROM gme_material_details m,
3357: gme_pending_product_lots lo,
3358: wms_item_locations_kfv loc,
3359: mtl_lot_numbers mln
3360: WHERE m.batch_id = lo.batch_id
3361: AND m.material_detail_id = lo.material_detail_id
3362: AND m.locator_id = loc.inventory_location_id(+)