INV_UOMINTRACLASS_V

Details

• Schema: FUSION

• Object owner: RCS

• Object type: VIEW

Columns

Name
TO_UOM_CODE FROM_UOM_CODE CONVERSION_RATE TO_UOM_DISABLE_DATE CONV_DISABLE_DATE INVENTORY_ITEM_ID TO_UOM_LAST_UPDATE_DATE CONV_LAST_UPDATE_DATE

Query

SQL_Statement

SELECT UOM.UOM_CODE TO_UOM_CODE, INTRACONV.UOM_CODE FROM_UOM_CODE, INTRACONV.CONVERSION_RATE CONVERSION_RATE, UOM.DISABLE_DATE TO_UOM_DISABLE_DATE, INTRACONV.DISABLE_DATE CONV_DISABLE_DATE, INTRACONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, UOM.LAST_UPDATE_DATE TO_UOM_LAST_UPDATE_DATE, INTRACONV.LAST_UPDATE_DATE CONV_LAST_UPDATE_DATE FROM FUSION.INV_UOM_CONVERSIONS INTRACONV, FUSION.INV_UNITS_OF_MEASURE_B UOM WHERE INTRACONV.INVENTORY_ITEM_ID > 0 AND UOM.UOM_CLASS = INTRACONV.UOM_CLASS AND UOM.BASE_UOM_FLAG = 'Y'