eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1496: , mtl_item_locations mil

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
1500: AND mln.inventory_item_id = p_inventory_item_id

Line 1515: , mtl_item_locations mil

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
1519: AND NVL(msi.reservable_type,1) = 1