View: SY_UOMS_MST_V

Product:	GMA - Process Manufacturing Systems
Description:	View of unit of measure master
Implementation/DBA Data:	APPS.SY_UOMS_MST_V

View Text

SELECT DECODE(LENGTHB(UOM.UNIT_OF_MEASURE)
, 1
, UOM.UNIT_OF_MEASURE
, 2
, UOM.UNIT_OF_MEASURE
, 3
, UOM.UNIT_OF_MEASURE
, 4
, UOM.UNIT_OF_MEASURE
, UOM.UOM_CODE) UM_CODE
, SUBSTR(UOM.DESCRIPTION
, 1
, 40)
, UOM.UOM_CLASS
, CONVERSION_RATE
, UOM.UNIT_OF_MEASURE
, UOM.UOM_CODE
, UOM.LAST_UPDATE_LOGIN
, UOM.LAST_UPDATE_DATE
, UOM.LAST_UPDATED_BY
, UOM.CREATION_DATE
, UOM.CREATED_BY
, DECODE(SIGN(SYSDATE-UOM.DISABLE_DATE)
, 1
, 1
, 0)
, 0
, 0
, NULL
, 0
FROM MTL_UNITS_OF_MEASURE UOM
, MTL_UOM_CONVERSIONS UOMC
WHERE UOMC.UNIT_OF_MEASURE = UOM.UNIT_OF_MEASURE
AND UOMC.INVENTORY_ITEM_ID = 0

Columns