VIEW: APPS.OKL_LS_RT_FCTR_SETS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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