View: OKL_LS_RT_FCTR_SETS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_LS_RT_FCTR_SETS_UV

View Text

SELECT LRT.ID ID
, LRT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LRTT.SFWT_FLAG SFWT_FLAG
, LRT.TRY_ID TRY_ID
, LRT.PDT_ID PDT_ID
, LRT.FRQ_CODE FRQ_CODE
, LU.MEANING FREQUENCY
, LRT.ARREARS_YN ARREARS_YN
, L2.MEANING ARREARS
, LRT.START_DATE START_DATE
, LRT.END_DATE END_DATE
, LRT.NAME NAME
, LRTT.DESCRIPTION DESCRIPTION
, DECODE(SIGN(NVL(LRT.START_DATE
, SYSDATE) - SYSDATE)
, 0
, 'I'
, DECODE(SIGN(NVL(LRT.END_DATE
, SYSDATE) - SYSDATE)
, -1
, 'I'
, DECODE(SIGN(NVL(LRT.START_DATE
, SYSDATE) - SYSDATE)
, 1
, 'I'
, 'A'))) STATUS
, LRT.CREATED_BY CREATED_BY
, LRT.CREATION_DATE CREATION_DATE
, LRT.LAST_UPDATED_BY LAST_UPDATED_BY
, LRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LRT.STS_CODE STS_CODE
, LRT.ORG_ID ORG_ID
, LRT.CURRENCY_CODE CURRENCY_CODE
, LRT.LRS_TYPE_CODE LRS_TYPE_CODE
, LRT.END_OF_TERM_ID END_OF_TERM_ID
, LRT.ORIG_RATE_SET_ID ORIG_RATE_SET_ID
FROM OKL_LS_RT_FCTR_SETS_B LRT
, OKL_LS_RT_FCTR_SETS_TL LRTT
, FND_LOOKUPS LU
, FND_LOOKUPS L2
WHERE LRT.ID = LRTT.ID
AND LRTT.LANGUAGE = USERENV('LANG')
AND LU.LOOKUP_TYPE = 'OKL_FREQUENCY'
AND LU.LOOKUP_CODE = LRT.FRQ_CODE
AND L2.LOOKUP_TYPE = 'OKL_YES_NO'
AND L2.LOOKUP_CODE = LRT.ARREARS_YN

Columns