VIEW: APPS.OKX_TUOM_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')