View: SY_UOMS_TYP_V

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

View Text

SELECT UOMC.UOM_CLASS
, SUBSTR(UOMC.DESCRIPTION
, 1
, 40)
, UOMC.LAST_UPDATE_LOGIN
, UOMC.LAST_UPDATE_DATE
, UOMC.LAST_UPDATED_BY
, UOMC.CREATION_DATE
, UOMC.CREATED_BY
, DECODE(SIGN(SYSDATE-UOMC.DISABLE_DATE)
, 1
, 1
, 0)
, 0
, 0
, 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) STD_UM
FROM MTL_UNITS_OF_MEASURE UOM
, MTL_UOM_CLASSES UOMC
WHERE UOMC.UOM_CLASS = UOM.UOM_CLASS
AND UOM.BASE_UOM_FLAG = 'Y'

Columns