View: OKL_CS_CREDIT_MEMO_REQUEST_UV

Product:	OKL - Lease and Finance Management
Description:	List of Credit memo Requests
Implementation/DBA Data:	APPS.OKL_CS_CREDIT_MEMO_REQUEST_UV

View Text

SELECT TRQ.REQUEST_NUMBER
, TRQ.ID
, TRQ.OBJECT1_ID1
, TRQ.DNZ_KHR_ID
, TRQ.LSM_ID
, TRQ.AMOUNT
, TRQ.CURRENCY_CODE
, TRQ.CREATED_BY
, TRQ.REQUEST_STATUS_CODE STATUS_CODE
, STAT.MEANING STATUS
, USR.USER_NAME
, TRQ.CREATION_DATE
, TRQ.REQUEST_TYPE_CODE
FROM FND_LOOKUPS STAT
, OKL_TRX_REQUESTS TRQ
, FND_USER USR
WHERE TRQ.REQUEST_TYPE_CODE='CREDIT_MEMO'
AND REQUEST_STATUS_CODE NOT IN ('ENTERED')
AND TRQ.REQUEST_STATUS_CODE = STAT.LOOKUP_CODE
AND STAT.LOOKUP_TYPE = 'OKL_REQUEST_STATUS'
AND TRQ.CREATED_BY = USR.USER_ID UNION SELECT TRQ.REQUEST_NUMBER
, TRQ.ID
, TRQ.OBJECT1_ID1
, TRQ.DNZ_KHR_ID
, TRQ.LSM_ID
, TRQ.AMOUNT
, TRQ.CURRENCY_CODE
, TRQ.CREATED_BY
, INV.TRX_STATUS_CODE STATUS_CODE
, INV_STAT.MEANING STATUS
, USR.USER_NAME
, TRQ.CREATION_DATE
, TRQ.REQUEST_TYPE_CODE
FROM OKL_TRX_REQUESTS TRQ
, OKL_TRX_AR_INVOICES_B INV
, FND_USER USR
, FND_LOOKUPS STAT
, FND_LOOKUPS INV_STAT
WHERE TRQ.REQUEST_TYPE_CODE='CREDIT_MEMO'
AND TRQ.OBJECT1_ID1=INV.ID
AND TRQ.REQUEST_STATUS_CODE = STAT.LOOKUP_CODE
AND STAT.LOOKUP_TYPE = 'OKL_REQUEST_STATUS'
AND INV.TRX_STATUS_CODE = INV_STAT.LOOKUP_CODE
AND INV_STAT.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND TRQ.CREATED_BY = USR.USER_ID

Columns