View: OKL_CS_TRX_CONTRACTS_UV

Product:	OKL - Lease and Finance Management
Description:	View to display Service Contracts
Implementation/DBA Data:	APPS.OKL_CS_TRX_CONTRACTS_UV

View Text

SELECT TRX.KHR_ID HEADER_CONTRACT_ID
, TRX.DATE_TRANSACTION_OCCURRED TRANSACTION_DATE
, TRX.TSU_CODE TRANSACTION_TYPE_CODE
, LOOKUP.MEANING TRANSACTION_TYPE_DESC
, TRX.TRX_NUMBER TRANSACTION_NUMBER
, TRX.CHR_ID SERVICE_CONTRACT_ID
, TRX.DESCRIPTION TRX_DESCRIPTION
, TRX.ID TRX_ID
, TRX.TRY_ID TRY_ID
FROM OKL_TRX_CONTRACTS TRX
, FND_LOOKUPS LOOKUP
WHERE TCN_TYPE = 'SER'
AND LOOKUP.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND TRX.TSU_CODE = LOOKUP.LOOKUP_CODE ORDER BY TRX_NUMBER DESC

Columns