Product: | OKL - Lease and Finance Management |
---|---|
Description: | List of Principal Paydown Requests |
Implementation/DBA Data: | APPS.OKL_CS_PRINCIPAL_PAYDOWN_UV |
SELECT TRQ.REQUEST_NUMBER REQUEST_NUMBER
, TRQ.ID REQUEST_ID
, TRQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRQ.DNZ_KHR_ID KHR_ID
, TRQ.REQUEST_STATUS_CODE REQUEST_STATUS_CODE
, STAT.MEANING REQUEST_STATUS
, TRQ.REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, TYPE.MEANING REQUEST_TYPE
, TRQ.COMMENTS COMMENTS
, TRQ.LAST_UPDATE_DATE REQUEST_DATE
, TRQ.AMOUNT RENT
, TRQ.CURRENCY_CODE CURRENCY_CODE
, TRQ.PAYMENT_DATE PAYMENT_DATE
, TRQ.PAYMENT_AMOUNT PAYMENT_AMOUNT
, TRQ.PAYDOWN_TYPE
, TRQ.PARENT_KHR_ID PARENT_KHR_ID
, TRQ.YIELD_TYPE YIELD_TYPE
, TRQ.CREATED_BY CREATED_BY
, USR.USER_NAME REQUESTED_BY
, TRQ.START_DATE NEXT_PAYMENT_DATE
, TRQ.RECEIPT_ID
, TRQ.TCN_ID
, TRQ.CUR_PRINCIPAL_BALANCE
, TRQ.CUR_ACCUM_INTEREST
FROM OKL_TRX_REQUESTS TRQ
, FND_USER USR
, FND_LOOKUPS TYPE
, FND_LOOKUPS STAT
WHERE TRQ.REQUEST_STATUS_CODE = STAT.LOOKUP_CODE
AND STAT.LOOKUP_TYPE = 'OKL_REQUEST_STATUS'
AND TRQ.REQUEST_TYPE_CODE = TYPE.LOOKUP_CODE
AND TYPE.LOOKUP_TYPE = 'OKL_REQUEST_TYPE'
AND TRQ.CREATED_BY = USR.USER_ID