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 1553: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1549: , mil.locator_segments concatenated_segments
1550: , mil.description
1551: , mil.status_id
1552: , mmsv.status_code
1553: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1554: WHERE mil.organization_id = p_organization_id
1555: AND mil.subinventory_code = p_subinventory_code
1556: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1557: AND mmsv.status_id = mil.status_id

Line 1592: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1588: , mil.locator_segments concatenated_segments
1589: , mil.description
1590: , mil.status_id
1591: , mmsv.status_code
1592: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1593: WHERE mil.organization_id = p_organization_id
1594: AND mil.subinventory_code = p_subinventory_code
1595: AND mil.alias = p_alias
1596: AND mmsv.status_id = mil.status_id

Line 2075: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv

2071: , asset_inventory
2072: , mmsv.status_id
2073: , status_code
2074: , enable_locator_alias
2075: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv
2076: WHERE organization_id = p_organization_id
2077: AND mmsv.status_id = msi.status_id
2078: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2079: AND secondary_inventory_name LIKE (p_subinventory_code);