APPS.INV_ITEM_INQ dependencies on WMS_LOADED_QUANTITIES_V

Line 2285: from WMS_LOADED_QUANTITIES_V

2281: b.sec_packed_quantity, -- Bug : 4563072
2282: b.sec_loose_quantity, -- Bug : 4563072
2283: --bug12950736 Huawei ER
2284: (select nvl(sum(quantity),0)
2285: from WMS_LOADED_QUANTITIES_V
2286: where inventory_item_id = b.inventory_item_id
2287: and organization_id = b.organization_id
2288: and containerized_flag = 1
2289: and subinventory_code = b.subinventory_code

Line 2294: from WMS_LOADED_QUANTITIES_V

2290: and Nvl(lot_number,'@@ZZ@@') = Nvl(b.lot_number,'@@ZZ@@')
2291: and Nvl(locator_id,-1) = Nvl(b.locator_id,-1)
2292: and Nvl(revision,'@@ZZ@@') = Nvl(b.revision,'@@ZZ@@')) packed_loaded_qty,
2293: (select nvl(sum(quantity),0)
2294: from WMS_LOADED_QUANTITIES_V
2295: where inventory_item_id = b.inventory_item_id
2296: and organization_id = b.organization_id
2297: and containerized_flag = 2
2298: and subinventory_code = b.subinventory_code

Line 2953: from WMS_LOADED_QUANTITIES_V

2949: NULL,--b.task_number
2950: b.inventory_item_id,
2951: --bug12950736 Huawei ER
2952: (select nvl(sum(quantity),0)
2953: from WMS_LOADED_QUANTITIES_V
2954: where inventory_item_id = b.inventory_item_id
2955: and organization_id = b.organization_id
2956: and containerized_flag = 1
2957: and subinventory_code = b.subinventory_code

Line 2960: from WMS_LOADED_QUANTITIES_V

2956: and containerized_flag = 1
2957: and subinventory_code = b.subinventory_code
2958: and Nvl(locator_id,-1) = Nvl(b.locator_id,-1)) packed_loaded_qty,
2959: (select nvl(sum(quantity),0)
2960: from WMS_LOADED_QUANTITIES_V
2961: where inventory_item_id = b.inventory_item_id
2962: and organization_id = b.organization_id
2963: and containerized_flag = 2
2964: and subinventory_code = b.subinventory_code