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_VL

Line 1178: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1174: , mil.locator_segments concatenated_segments
1175: , mil.description
1176: , mil.status_id
1177: , mmsv.status_code
1178: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1179: WHERE mil.organization_id = p_organization_id
1180: AND mil.subinventory_code = p_subinventory_code
1181: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1182: AND mmsv.status_id = mil.status_id

Line 1217: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1213: , mil.locator_segments concatenated_segments
1214: , mil.description
1215: , mil.status_id
1216: , mmsv.status_code
1217: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1218: WHERE mil.organization_id = p_organization_id
1219: AND mil.subinventory_code = p_subinventory_code
1220: AND mil.alias = p_alias
1221: AND mmsv.status_id = mil.status_id

Line 1700: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv

1696: , asset_inventory
1697: , mmsv.status_id
1698: , status_code
1699: , enable_locator_alias
1700: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv
1701: WHERE organization_id = p_organization_id
1702: AND mmsv.status_id = msi.status_id
1703: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1704: AND secondary_inventory_name LIKE (p_subinventory_code);