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 2511: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms

2507: , msn.lot_number
2508: , 0
2509: , msn.current_status
2510: , mms.status_code
2511: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2512: WHERE msn.inventory_item_id = p_item_id
2513: AND msn.current_organization_id = p_organization_id
2514: AND msn.current_status = 3
2515: AND msn.current_subinventory_code = p_subinv_code

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

2533: , msn.lot_number
2534: , 0
2535: , msn.current_status
2536: , mms.status_code
2537: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2538: WHERE msn.inventory_item_id = p_item_id
2539: AND msn.current_organization_id = p_organization_id
2540: AND msn.current_status = 3
2541: AND msn.current_subinventory_code = p_subinv_code