MSC_AP_UNITS_OF_MEASURE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
UNIT_OF_MEASURE UNIT_OF_MEASURE_ID UOM_CODE UOM_CLASS BASE_UOM_FLAG DISABLE_DATE DESCRIPTION

Query

SQL_Statement
SELECT uom.Unit_Of_Measure, uom.UNIT_OF_MEASURE_ID, uom.UOM_Code, class.UOM_Class_tl uom_class, uom.Base_UOM_Flag, uom.Disable_Date, uom.Description FROM INV_UNITS_OF_MEASURE_VL uom, INV_UOM_CLASSES_VL class where uom.uom_class=class.uom_class