View: OKC_TIMEUNIT_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_TIMEUNIT_V

View Text

SELECT TCU.UOM_CODE UOM_CODE
, UOM.UNIT_OF_MEASURE_TL UNIT_OF_MEASURE
, UOM.DESCRIPTION DESCRIPTION
, TCU.TCE_CODE
, FNDL.MEANING TIMEUNIT
, TCU.QUANTITY
, UOM.DISABLE_DATE INACTIVE_DATE
, TCU.ACTIVE_FLAG ACTIVE_FLAG
FROM OKC_TIME_CODE_UNITS_B TCU
, OKX_UNITS_OF_MEASURE_V UOM
, FND_LOOKUPS FNDL
WHERE TCU.TCE_CODE = FNDL.LOOKUP_CODE
AND FNDL.LOOKUP_TYPE ='OKC_TIME'
AND UOM.UOM_CODE = TCU.UOM_CODE --AND NVL(UOM.DISABLE_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)

Columns