APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1495: , mtl_secondary_inventories msi

1491: SELECT NVL(SUM(mtlt.primary_quantity),0)
1492: FROM mtl_material_transactions_temp mmtt
1493: , mtl_transaction_lots_temp mtlt
1494: , mtl_lot_numbers mln
1495: , mtl_secondary_inventories msi
1496: , mtl_item_locations mil
1497: WHERE mmtt.reservation_id = p_rsv_id
1498: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1499: AND mln.organization_id = p_organization_id

Line 1514: , mtl_secondary_inventories msi

1510:
1511: CURSOR c_rsv_qty(p_rsv_id IN NUMBER) IS
1512: SELECT NVL(SUM(mmtt.primary_quantity),0)
1513: FROM mtl_material_transactions_temp mmtt
1514: , mtl_secondary_inventories msi
1515: , mtl_item_locations mil
1516: WHERE mmtt.reservation_id = p_rsv_id
1517: AND msi.organization_id = mmtt.organization_id
1518: AND msi.secondary_inventory_name = mmtt.subinventory_code

Line 1789: , mtl_secondary_inventories sub

1785: INTO l_subinv_code
1786: , l_sub_reservable
1787: , l_locator_id
1788: FROM wms_license_plate_numbers wlpn
1789: , mtl_secondary_inventories sub
1790: WHERE wlpn.lpn_id = p_lpn_id
1791: AND sub.organization_id = wlpn.organization_id
1792: AND sub.secondary_inventory_name = wlpn.subinventory_code;
1793: EXCEPTION

Line 2093: , mtl_secondary_inventories sub

2089: INTO l_subinv_code
2090: , l_sub_reservable
2091: , l_locator_id
2092: FROM wms_license_plate_numbers wlpn
2093: , mtl_secondary_inventories sub
2094: WHERE wlpn.lpn_id = p_lpn_id
2095: AND sub.organization_id = wlpn.organization_id
2096: AND sub.secondary_inventory_name = wlpn.subinventory_code;
2097: EXCEPTION