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