[Home] [Help]
70: nvl(mr.secondary_reservation_quantity,0), /*Bug7041074*/
71: mr.reservation_id,
72: lo.inventory_location_id
73: FROM mtl_reservations mr,
74: wms_item_locations_kfv lo
75: WHERE lo.inventory_location_id(+) = mr.locator_id
76: AND mr.organization_id = p_org_id
77: AND mr.demand_source_type_id = 5
78: AND mr.demand_source_header_id = p_batch_id
110: d.secondary_dispensed_qty,
111: d.dispense_id,
112: lo.inventory_location_id
113: FROM gme_material_dispensing_gtmp d,
114: wms_item_locations_kfv lo
115: WHERE lo.inventory_location_id(+) = d.locator_id
116: AND lo.subinventory_code(+) = d.subinventory_code
117: ORDER BY d.dispense_id;
118:
2322: ,d.dispense_uom
2323: , dispense_id
2324: ,d.revision
2325: FROM mtl_secondary_inventories s,
2326: wms_item_locations_kfv b,
2327: gme_material_dispensing_gtmp d
2328: WHERE
2329: d.subinventory_code LIKE (p_subinv_code)
2330: AND s.secondary_inventory_name = d.subinventory_code
2515:
2516: sqlstmt := ' SELECT a.concatenated_segments, '
2517: ||' a.description, '
2518: ||' a.inventory_location_id '
2519: ||' FROM wms_item_locations_kfv a, '
2520: ||' mtl_secondary_locators b '
2521: ||' WHERE b.organization_id = :p_organization_Id '
2522: ||' AND b.inventory_item_id = :p_Inventory_Item_Id '
2523: ||' AND b.subinventory_code = :p_Subinventory_Code '
2531:
2532: sqlstmt := ' SELECT concatenated_segments, '
2533: ||' description, '
2534: ||' inventory_location_id '
2535: ||' FROM wms_item_locations_kfv '
2536: ||' WHERE organization_id = :p_organization_id '
2537: ||' AND subinventory_code = :p_subinventory_code '
2538: ||' AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) '
2539: ||' AND concatenated_segments LIKE (:p_concatenated_segments) '
2573: IF l_ind = 1 THEN
2574: OPEN x_locators FOR
2575: SELECT DISTINCT loc.concatenated_segments locator, loc.description,
2576: onh.locator_id
2577: FROM wms_item_locations_kfv loc, mtl_onhand_locator_v onh
2578: WHERE loc.organization_id = onh.organization_id
2579: AND loc.inventory_location_id = onh.locator_id
2580: AND NVL(loc.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2581: AND loc.organization_id = p_organization_id
2633: OPEN x_Locators FOR
2634: SELECT a.concatenated_segments,
2635: a.description,
2636: a.inventory_location_id
2637: FROM wms_item_locations_kfv a,
2638: mtl_reservations mr
2639: WHERE mr.organization_id = p_organization_id
2640: AND mr.inventory_item_id = p_item_id
2641: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2669: OPEN x_Locators FOR
2670: SELECT a.concatenated_segments,
2671: a.description,
2672: a.inventory_location_id
2673: FROM wms_item_locations_kfv a,
2674: mtl_reservations mr
2675: WHERE mr.locator_id = a.inventory_location_id
2676: AND mr.organization_id = p_organization_id
2677: AND mr.inventory_item_id = p_item_id
2720: ||' ,NVL(t.secondary_dispensed_qty, 0) '
2721: ||' ,dispense_uom '
2722: ||' ,dispense_id '
2723: ||' ,t.revision '
2724: ||' FROM wms_item_locations_kfv a, '
2725: ||' gme_material_dispensing_gtmp t '
2726: ||' WHERE '
2727: ||' t.subinventory_code = :p_subinv_code '
2728: ||' AND a.subinventory_code = t.subinventory_code '
2771: SELECT a.concatenated_segments,
2772: a.description,
2773: a.inventory_location_id,
2774: ROUND(SUM(atr),4) atr
2775: FROM wms_item_locations_kfv a,
2776: mtl_rsv_quantities_temp t
2777: WHERE ((t.node_level = 4
2778: AND t.subinventory_code not in (select subinventory_code from
2779: mtl_rsv_quantities_temp where node_level = 5)) OR
3270: lo.pending_product_lot_id,
3271: NVL(m.locator_id,-1)
3272: FROM gme_material_details m,
3273: gme_pending_product_lots lo,
3274: wms_item_locations_kfv loc,
3275: mtl_lot_numbers mln
3276: WHERE m.batch_id = lo.batch_id
3277: AND m.material_detail_id = lo.material_detail_id
3278: AND m.locator_id = loc.inventory_location_id(+)