FND_UNITS_OF_MEASURE_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
UOM_CODE UOM_CLASS UOM_CLASS_CODE BASE_UOM_FLAG UNIT_OF_MEASURE DESCRIPTION DISABLE_DATE

Query

SQL_Statement
SELECT U.UOM_CODE as UOM_CODE, U.UOM_CLASS as UOM_CLASS, C.UOM_CLASS_CODE as UOM_CLASS_CODE, U.BASE_UOM_FLAG as BASE_UOM_FLAG, U.UNIT_OF_MEASURE as UNIT_OF_MEASURE, U.DESCRIPTION as DESCRIPTION, U.DISABLE_DATE as DISABLE_DATE FROM INV_UNITS_OF_MEASURE_VL U, INV_UOM_CLASSES_B C WHERE U.UOM_CLASS = C.UOM_CLASS