FND Design Data [Home] [Help]

View: OKL_LS_RT_FCTR_SETS_V

Product: OKL - Lease and Finance Management
Description: MLS view over base tables - OKL_LS_RT_FCTR_SETS_B and OKL_LS_RT_FCTR_SETS_TL
Implementation/DBA Data: ViewAPPS.OKL_LS_RT_FCTR_SETS_V
View Text

SELECT LRT.ROWID
, 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.RATE RATE
, LRT.FRQ_CODE FRQ_CODE
, LRT.ARREARS_YN ARREARS_YN
, LRT.START_DATE START_DATE
, LRT.END_DATE END_DATE
, LRT.NAME NAME
, LRTT.DESCRIPTION DESCRIPTION
, 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.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LRT.ATTRIBUTE1 ATTRIBUTE1
, LRT.ATTRIBUTE2 ATTRIBUTE2
, LRT.ATTRIBUTE3 ATTRIBUTE3
, LRT.ATTRIBUTE4 ATTRIBUTE4
, LRT.ATTRIBUTE5 ATTRIBUTE5
, LRT.ATTRIBUTE6 ATTRIBUTE6
, LRT.ATTRIBUTE7 ATTRIBUTE7
, LRT.ATTRIBUTE8 ATTRIBUTE8
, LRT.ATTRIBUTE9 ATTRIBUTE9
, LRT.ATTRIBUTE10 ATTRIBUTE10
, LRT.ATTRIBUTE11 ATTRIBUTE11
, LRT.ATTRIBUTE12 ATTRIBUTE12
, LRT.ATTRIBUTE13 ATTRIBUTE13
, LRT.ATTRIBUTE14 ATTRIBUTE14
, LRT.ATTRIBUTE15 ATTRIBUTE15
, 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
WHERE LRT.ID = LRTT.ID
AND LRTT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
TRY_ID
PDT_ID
RATE
FRQ_CODE
ARREARS_YN
START_DATE
END_DATE
NAME
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
STS_CODE
ORG_ID
CURRENCY_CODE
LRS_TYPE_CODE
END_OF_TERM_ID
ORIG_RATE_SET_ID