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: |
![]() |
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')