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_UI_ITEM_ATT_LOVS dependencies on WMS_ALLOCATIONS_GTMP

Line 2598: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms

2594: , msn.lot_number
2595: , 0
2596: , msn.current_status
2597: , mms.status_code
2598: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2599: WHERE msn.inventory_item_id = p_item_id
2600: AND msn.current_organization_id = p_organization_id
2601: AND msn.current_status = 3
2602: AND msn.current_subinventory_code = p_subinv_code

Line 2624: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms

2620: , msn.lot_number
2621: , 0
2622: , msn.current_status
2623: , mms.status_code
2624: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2625: WHERE msn.inventory_item_id = p_item_id
2626: AND msn.current_organization_id = p_organization_id
2627: AND msn.current_status = 3
2628: AND msn.current_subinventory_code = p_subinv_code