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.INV_INV_LOVS dependencies on WMS_ALLOCATIONS_GTMP

Line 2102: FROM mtl_lot_numbers mln, wms_allocations_gtmp mag,

2098: , mln.expiration_date
2099: , mmst.status_code
2100: , sum(mag.primary_quantity)
2101: , sum(mag.transaction_quantity)
2102: FROM mtl_lot_numbers mln, wms_allocations_gtmp mag,
2103: mtl_material_statuses_tl mmst
2104: WHERE mln.organization_id = p_organization_id
2105: AND mln.inventory_item_id = p_item_id
2106: AND mln.lot_number LIKE (p_lot_number)

Line 2125: mtl_transaction_lots_temp mtlt, wms_allocations_gtmp mag,

2121: , mmst.status_code
2122: , sum(mag.primary_quantity)
2123: , sum(mag.transaction_quantity)
2124: FROM mtl_lot_numbers mln,
2125: mtl_transaction_lots_temp mtlt, wms_allocations_gtmp mag,
2126: mtl_material_statuses_tl mmst
2127: WHERE mln.organization_id = p_organization_id
2128: AND mln.inventory_item_id = p_item_id
2129: AND mln.lot_number LIKE (p_lot_number)