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 1913: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

1909: SELECT UNIQUE mil.inventory_location_id
1910: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
1911: , mil.locator_segments concatenated_segments
1912: , mil.description
1913: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
1914: WHERE mil.organization_id = p_organization_id
1915: AND mil.subinventory_code = p_subinventory_code
1916: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1917: AND mil.inventory_location_id = mpit.locator_id

Line 1986: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

1982: SELECT UNIQUE mil.inventory_location_id
1983: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
1984: , mil.locator_segments concatenated_segments
1985: , mil.description
1986: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
1987: WHERE mil.organization_id = p_organization_id
1988: AND mil.subinventory_code = p_subinventory_code
1989: AND mil.alias = p_alias
1990: AND mil.inventory_location_id = mpit.locator_id