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' |