View: OKL_LA_TNA_REQUEST_UV

Product:	OKL - Leasing and Finance Management
Description:	Page View definition for Transfer and Assumption requests
Implementation/DBA Data:	APPS.OKL_LA_TNA_REQUEST_UV

View Text

SELECT NEW_CONTRACT_NUMBER NEW_CONTRACT_NUMBER
, TRX_NUMBER TNA_REQUEST_NUMBER
, TRX.ID TRX_ID
, TRX.TRX_NUMBER TRX_NUMBER
, TRX.KHR_ID_OLD KHR_ID_OLD
, TRX.TSU_CODE TSU_CODE
FROM OKL_TRX_CONTRACTS TRX
, OKL_TRX_TYPES_TL TTYT
, OKL_TAA_REQUEST_DETAILS_B TAADB
WHERE TRX.TRY_ID = TTYT.ID
AND TTYT.LANGUAGE = 'US'
AND TTYT.NAME = 'TRANSFER
AND ASSUMPTION'
AND TRX.TSU_CODE = 'APPROVED'
AND TAADB.TCN_ID = TRX.ID

Columns