VIEW: APPS.OKL_CS_LEASE_RENEWALS_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.YIELD YIELD ,TRQ.START_DATE START_DATE ,TRQ.END_DATE END_DATE ,TRQ.TERM_DURATION TERM ,TRQ.RESIDUAL RESIDUAL ,TRQ.PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE ,TRQ.RESTRUCTURE_DATE RESTRUCTURE_DATE ,TRQ.PAST_DUE_YN PAST_DUE_YN ,TRQ.PARENT_KHR_ID PARENT_KHR_ID ,TRQ.YIELD_TYPE YIELD_TYPE ,TRQ.CREATED_BY CREATED_BY ,USR.USER_NAME REQUESTED_BY FROM FND_USER USR,OKL_TRX_REQUESTS TRQ,FND_LOOKUPS STAT,FND_LOOKUPS TYPE 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.LAST_UPDATED_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.YIELD YIELD
, TRQ.START_DATE START_DATE
, TRQ.END_DATE END_DATE
, TRQ.TERM_DURATION TERM
, TRQ.RESIDUAL RESIDUAL
, TRQ.PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE
, TRQ.RESTRUCTURE_DATE RESTRUCTURE_DATE
, TRQ.PAST_DUE_YN PAST_DUE_YN
, TRQ.PARENT_KHR_ID PARENT_KHR_ID
, TRQ.YIELD_TYPE YIELD_TYPE
, TRQ.CREATED_BY CREATED_BY
, USR.USER_NAME REQUESTED_BY
FROM FND_USER USR
, OKL_TRX_REQUESTS TRQ
, FND_LOOKUPS STAT
, FND_LOOKUPS TYPE
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.LAST_UPDATED_BY = USR.USER_ID