View: OKX_TUOM_V

Product:	OKX - Contracts Integration
Description:	View on mtl_units_of_measure tl . Will be usedto fetch time units of measure.
Implementation/DBA Data:	APPS.OKX_TUOM_V

View Text

SELECT UOM.UOM_CODE ID1
, '#' ID2
, UOM.UNIT_OF_MEASURE NAME
, UOM.DESCRIPTION DESCRIPTION
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, UOM.UOM_CODE UOM_CODE
, UOM.UOM_CLASS UOM_CLASS
, UOM.BASE_UOM_FLAG BASE_UOM_FLAG
, UOM.UNIT_OF_MEASURE_TL UNIT_OF_MEASURE_TL
, UOM.SOURCE_LANG SOURCE_LANG
, SYSDATE START_DATE_ACTIVE
, UOM.DISABLE_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TRUNC(SYSDATE)
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(UOM.DISABLE_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, UOM.UOM_CODE PRIMARY_UOM_CODE
FROM MTL_UNITS_OF_MEASURE_TL UOM
WHERE LANGUAGE = USERENV('LANG')

Columns