View: AHL_ITEM_CLASS_UOM_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view retrieves items and all the UOMs which are in the same UOM class as the base UOM of the item.
Implementation/DBA Data:	APPS.AHL_ITEM_CLASS_UOM_V

View Text

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'

Columns