eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_PRINCIPAL_PAYDOWN_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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