APPS.MTL_INV_UTIL_GRP dependencies on WMS_LOADED_QUANTITIES_V

Line 1286: from wms_loaded_quantities_v

1282:
1283: --bug 2640378 start
1284: select nvl(sum(quantity),0)
1285: into l_loaded_sys_qty
1286: from wms_loaded_quantities_v
1287: where nvl(content_lpn_id,nvl(lpn_id,-1)) = p_lpn_id
1288: and inventory_item_id = p_inventory_item_id
1289: and NVL(lot_number, '@') = NVL(p_lot_number, '@')
1290: and NVL(revision, '@') = NVL(p_revision, '@');

Line 1468: FROM wms_loaded_quantities_v

1464: SELECT NVL (SUM (quantity), 0)
1465: , NVL (SUM (secondary_quantity), 0)
1466: INTO l_loaded_sys_qty
1467: , l_loaded_sec_sys_qty
1468: FROM wms_loaded_quantities_v
1469: WHERE NVL (content_lpn_id, NVL (lpn_id, -1) ) = p_lpn_id
1470: AND inventory_item_id = p_inventory_item_id
1471: AND NVL (lot_number, '@') = NVL (p_lot_number, '@')
1472: AND NVL (revision, '@') = NVL (p_revision, '@');