[Home] [Help]
View: OKL_LA_TNA_REQUEST_UV
Product: | OKL - Lease 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
Name |
NEW_CONTRACT_NUMBER |
TNA_REQUEST_NUMBER |
TRX_ID |
TRX_NUMBER |
KHR_ID_OLD |
TSU_CODE |