[Home] [Help]
2212: OPEN x_sub_lov FOR
2213: SELECT s.secondary_inventory_name
2214: , s.description
2215: , NVL(s.locator_type, 1)
2216: FROM mtl_secondary_inventories s,
2217: mtl_item_sub_inventories i
2218: WHERE s.secondary_inventory_name = i.secondary_inventory
2219: AND s.organization_id = i.organization_id
2220: AND s.organization_id = p_organization_id
2227: OPEN x_sub_lov FOR
2228: SELECT secondary_inventory_name
2229: , description
2230: , NVL(locator_type, 1)
2231: FROM mtl_secondary_inventories
2232: WHERE organization_id = p_organization_id
2233: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2234: AND secondary_inventory_name LIKE (p_subinv_code)
2235: AND quantity_tracked = 1
2267: IF l_ind = 1 THEN
2268: OPEN x_sub_lov FOR
2269: SELECT DISTINCT sub.secondary_inventory_name, sub.description,
2270: NVL(sub.locator_type, 1)
2271: FROM mtl_secondary_inventories sub, mtl_onhand_sub_v onh
2272: WHERE sub.organization_id = onh.organization_id
2273: AND sub.secondary_inventory_name = onh.subinventory_code
2274: AND NVL(sub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2275: AND sub.quantity_tracked = 1
2321: ,NVL(d.secondary_dispensed_qty,0)
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)
2373: OPEN x_sub_lov FOR
2374: SELECT DISTINCT msi.secondary_inventory_name
2375: , msi.description
2376: , NVL(msi.locator_type, 1)
2377: FROM mtl_secondary_inventories msi,
2378: mtl_reservations mr
2379: WHERE mr.organization_id = p_organization_id
2380: AND mr.inventory_item_id = p_item_id
2381: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2410: SELECT DISTINCT msi.secondary_inventory_name
2411: , msi.description
2412: , NVL(msi.locator_type, 1)
2413: , mr.revision
2414: FROM mtl_secondary_inventories msi,
2415: mtl_reservations mr
2416: WHERE mr.subinventory_code = msi.secondary_inventory_name
2417: AND mr.organization_id = p_organization_id
2418: AND mr.inventory_item_id = p_item_id
2458: SELECT t.subinventory_code,
2459: msi.description,
2460: NVL(msi.locator_type, 1),
2461: t.atr
2462: FROM mtl_secondary_inventories msi,
2463: mtl_rsv_quantities_temp t
2464: WHERE node_level = 4
2465: AND t.organization_id = p_organization_id
2466: AND t.inventory_item_id = p_item_id