View: OKL_REVISIONS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view used in rebook summary page
Implementation/DBA Data:	APPS.OKL_REVISIONS_UV

View Text

SELECT NEWK.CONTRACT_NUMBER NEW_CONTRACT_NUMBER
, OLDK.CONTRACT_NUMBER OLD_CONTRACT_NUMBER
, OLDK.SHORT_DESCRIPTION OLD_CONTRACT_DESC
, NEWK.ID NEW_CONTRACT_ID
, OLDK.ID OLD_CONTRACT_ID
, TRX.RBR_CODE RBR_CODE
, TRX.TSU_CODE TSU_CODE
, TRX.ORG_ID ORG_ID
FROM OKL_K_HEADERS_FULL_V OLDK
, OKL_K_HEADERS_FULL_V NEWK
, OKL_TRX_CONTRACTS_ALL TRX
WHERE OLDK.ID = TRX.KHR_ID
AND NEWK.ID = TRX.KHR_ID_NEW
AND TRX.TSU_CODE <> 'PROCESSED'
AND NEWK.STS_CODE <> 'ABANDONED'

Columns