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_PHYSICAL_INVENTORY_TAGS

Line 2288: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

2284: SELECT UNIQUE mil.inventory_location_id
2285: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
2286: , mil.locator_segments concatenated_segments
2287: , mil.description
2288: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
2289: WHERE mil.organization_id = p_organization_id
2290: AND mil.subinventory_code = p_subinventory_code
2291: AND mil.concatenated_segments LIKE (p_concatenated_segments)
2292: AND mil.inventory_location_id = mpit.locator_id

Line 2362: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

2358: SELECT UNIQUE mil.inventory_location_id
2359: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
2360: , mil.locator_segments concatenated_segments
2361: , mil.description
2362: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
2363: WHERE mil.organization_id = p_organization_id
2364: AND mil.subinventory_code = p_subinventory_code
2365: AND mil.alias = p_alias
2366: AND mil.inventory_location_id = mpit.locator_id