VIEW: APPS.OKL_LA_TNA_REQUEST_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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