VIEW: APPS.OKL_CS_CREDIT_MEMO_REQUEST_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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