INV_UOMINTERCLASS_V
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: VIEW
Columns
Name |
---|
INVENTORY_ITEM_ID TO_UOM_CODE FROM_UOM_CODE CONVERSION_RATE TO_UOM_DISABLE_DATE CONV_DISABLE_DATE FROM_UOM_DISABLE_DATE CONV_LAST_UPDATE_DATE TO_UOM_LAST_UPDATE_DATE FROM_UOM_LAST_UPDATE_DATE |
Query
SQL_Statement |
---|
SELECT conv.INVENTORY_ITEM_ID Inventory_item_id, to_uom.UOM_CODE to_uom_code, from_uom.UOM_CODE from_uom_code, conv.conversion_rate, to_uom.DISABLE_DATE to_uom_disable_date, conv.DISABLE_DATE conv_disable_date, from_uom.DISABLE_DATE from_uom_disable_date, conv.LAST_UPDATE_DATE conv_last_update_date, to_uom.LAST_UPDATE_DATE to_uom_last_update_date, from_uom.LAST_UPDATE_DATE from_uom_last_update_date FROM INV_UOM_CLASS_CONVERSIONS conv, INV_UNITS_OF_MEASURE_b from_uom, INV_UNITS_OF_MEASURE_b to_uom WHERE conv.TO_UOM_CODE = to_uom.UOM_CODE AND conv.FROM_UOM_CODE = from_uom.UOM_CODE |