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.

VIEW: APPS.AHL_ITEM_CLASS_UOM_V

Source

View Text - Preformatted


SELECT uom2.unit_of_measure, uom2.uom_code, uom2.uom_class, uom2.description, f1.meaning BASE_UOM , itm.inventory_item_id, itm.organization_id inventory_org_id, itm.concatenated_segments concatenated_segments from mtl_units_of_measure_vl uom1, mtl_system_items_kfv itm, mtl_units_of_measure_vl uom2, fnd_lookup_values_vl f1 WHERE itm.primary_uom_code = uom1.uom_code and uom1.uom_class = uom2.uom_class and trunc(nvl(uom2.disable_date, sysdate+1)) > trunc(sysdate) and uom2.base_uom_flag = f1.lookup_code and f1.lookup_type = 'AHL_YES_NO_TYPE'

View Text - HTML Formatted

SELECT UOM2.UNIT_OF_MEASURE
, UOM2.UOM_CODE
, UOM2.UOM_CLASS
, UOM2.DESCRIPTION
, F1.MEANING BASE_UOM
, ITM.INVENTORY_ITEM_ID
, ITM.ORGANIZATION_ID INVENTORY_ORG_ID
, ITM.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
FROM MTL_UNITS_OF_MEASURE_VL UOM1
, MTL_SYSTEM_ITEMS_KFV ITM
, MTL_UNITS_OF_MEASURE_VL UOM2
, FND_LOOKUP_VALUES_VL F1
WHERE ITM.PRIMARY_UOM_CODE = UOM1.UOM_CODE
AND UOM1.UOM_CLASS = UOM2.UOM_CLASS
AND TRUNC(NVL(UOM2.DISABLE_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)
AND UOM2.BASE_UOM_FLAG = F1.LOOKUP_CODE
AND F1.LOOKUP_TYPE = 'AHL_YES_NO_TYPE'