INV_ITEM_UOMS_EXPLOSION_V

Details

• Schema: FUSION

• Object owner: RCS

• Object type: VIEW

Columns

Name
ORGANIZATION_ID INVENTORY_ITEM_ID UOM_TYPE UOM_CODE UNIT_OF_MEASURE UOM_PLURAL_DESC UOM_RECIPROCAL_DESC DESCRIPTION UOM_CLASS

Query

SQL_Statement

SELECT ITEMS.ORGANIZATION_ID , ITEMS.INVENTORY_ITEM_ID , ITEMS.ALLOWED_UNITS_LOOKUP_CODE AS UOM_TYPE , UOM.UOM_CODE , UOM.UNIT_OF_MEASURE , UOM.UOM_PLURAL_DESC, UOM.UOM_RECIPROCAL_DESC, UOM.DESCRIPTION , UOM.UOM_CLASS FROM EGP_SYSTEM_ITEMS_VL ITEMS, INV_UNITS_OF_MEASURE_VL UOM WHERE ( rcs_interface.convert_is_feature_enabled_boolean_to_char('COMBO','ORA_RCS_USE_ITEM_UOMS') = 'Y' AND ( ( UOM.uom_code IN (select transaction_uom_code from RCS_ITEM_UOM_CONVERSIONS ITEMSCONV where ITEMSCONV.primary_uom_code = ITEMS.PRIMARY_UOM_CODE and ( ITEMSCONV.inventory_item_id = ITEMS.inventory_item_id or ITEMSCONV.inventory_item_id= 0 ) and conversion_rate!=-99999 and (UOM.disable_date is null or UOM.disable_date>=SYSDATE) ) ) ) )