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_SUB_LOC_LOVS dependencies on MTL_MATERIAL_STATUSES_TL

Line 3394: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3390: , milv.locator_segments concatenated_segments
3391: , milv.description
3392: , 0 dummy
3393: , mmsv.status_code
3394: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3395: WHERE milv.organization_id = p_organization_id
3396: AND milv.subinventory_code = p_subinventory_code
3397: AND milv.concatenated_segments LIKE (p_concatenated_segments)
3398: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )

Line 3438: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3434: , milv.locator_segments concatenated_segments
3435: , milv.description
3436: , 0 dummy
3437: , mmsv.status_code
3438: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3439: WHERE milv.organization_id = p_organization_id
3440: AND milv.subinventory_code = p_subinventory_code
3441: AND milv.alias = p_alias
3442: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )