View: OKL_POOL_TRANSACTIONS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for securitization pool transactions
Implementation/DBA Data:	APPS.OKL_POOL_TRANSACTIONS_UV

View Text

SELECT POXB.ID POX_ID
, POXB.POL_ID POL_ID
, POXB.TRANSACTION_NUMBER
, POXB.TRANSACTION_DATE
, POXB.TRANSACTION_TYPE
, LTTP.MEANING TRANSACTION_TYPE_VALUE
, POXB.TRANSACTION_REASON
, LTRN.MEANING TRANSACTION_REASON_VALUE
, POXB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, POXB.TRANSACTION_STATUS TRANSACTION_STATUS
FROM OKL_POOL_TRANSACTIONS POXB
, FND_LOOKUPS LTTP
, FND_LOOKUPS LTRN
WHERE LTTP.LOOKUP_TYPE = 'OKL_POOL_TRANSACTION_TYPE'
AND POXB.TRANSACTION_TYPE = LTTP.LOOKUP_CODE
AND LTRN.LOOKUP_TYPE = 'OKL_POOL_TRANSACTION_REASON'
AND POXB.TRANSACTION_REASON = LTRN.LOOKUP_CODE

Columns