View: OKL_TIME_UNITS_V

Product:	OKL - Leasing and Finance Management
Description:	OKL_TIME_UNITS_V contains all the frequency time units used in Lease Management.It based on lookup code 'OKL_FREQUENCY'. This view is used as object source for jtf_object OKL_TUOM.
Implementation/DBA Data:	APPS.OKL_TIME_UNITS_V

View Text

SELECT LUP.LOOKUP_CODE ID1
, '#' ID2
, LUP. MEANING NAME
, LUP.DESCRIPTION DESCRIPTION
, LUP.START_DATE_ACTIVE START_DATE_ACTIVE
, LUP.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(LUP.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(LUP.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, LUP.ENABLED_FLAG ENABLED_FLAG
, NULL PRIMARY_UOM_CODE
FROM FND_LOOKUP_VALUES LUP
WHERE LANGUAGE = USERENV('LANG')
AND LOOKUP_TYPE = 'OKL_FREQUENCY'

Columns