[Home] [Help]
2239: OPEN x_sub_lov FOR
2240: SELECT s.secondary_inventory_name
2241: , s.description
2242: , NVL(s.locator_type, 1)
2243: FROM mtl_secondary_inventories s,
2244: mtl_item_sub_inventories i
2245: WHERE s.secondary_inventory_name = i.secondary_inventory
2246: AND s.organization_id = i.organization_id
2247: AND s.organization_id = p_organization_id
2254: OPEN x_sub_lov FOR
2255: SELECT secondary_inventory_name
2256: , description
2257: , NVL(locator_type, 1)
2258: FROM mtl_secondary_inventories
2259: WHERE organization_id = p_organization_id
2260: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2261: AND secondary_inventory_name LIKE (p_subinv_code)
2262: AND quantity_tracked = 1
2294: IF l_ind = 1 THEN
2295: OPEN x_sub_lov FOR
2296: SELECT DISTINCT sub.secondary_inventory_name, sub.description,
2297: NVL(sub.locator_type, 1)
2298: FROM mtl_secondary_inventories sub, mtl_onhand_sub_v onh
2299: WHERE sub.organization_id = onh.organization_id
2300: AND sub.secondary_inventory_name = onh.subinventory_code
2301: AND NVL(sub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2302: AND sub.quantity_tracked = 1
2348: ,NVL(d.secondary_dispensed_qty,0)
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)
2400: OPEN x_sub_lov FOR
2401: SELECT DISTINCT msi.secondary_inventory_name
2402: , msi.description
2403: , NVL(msi.locator_type, 1)
2404: FROM mtl_secondary_inventories msi,
2405: mtl_reservations mr
2406: WHERE mr.organization_id = p_organization_id
2407: AND mr.inventory_item_id = p_item_id
2408: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2437: SELECT DISTINCT msi.secondary_inventory_name
2438: , msi.description
2439: , NVL(msi.locator_type, 1)
2440: , mr.revision
2441: FROM mtl_secondary_inventories msi,
2442: mtl_reservations mr
2443: WHERE mr.subinventory_code = msi.secondary_inventory_name
2444: AND mr.organization_id = p_organization_id
2445: AND mr.inventory_item_id = p_item_id
2485: SELECT t.subinventory_code,
2486: msi.description,
2487: NVL(msi.locator_type, 1),
2488: t.atr
2489: FROM mtl_secondary_inventories msi,
2490: mtl_rsv_quantities_temp t
2491: WHERE node_level = 4
2492: AND t.organization_id = p_organization_id
2493: AND t.inventory_item_id = p_item_id