View: OKL_TRX_ASSETS_LKE_UV

Product:	OKL - Lease and Finance Management
Description:	A supplementry view used to simplify user interface coding.
Implementation/DBA Data:	APPS.OKL_TRX_ASSETS_LKE_UV

View Text

SELECT TRX.REQ_ASSET_ID RELINQUISHED_ASSET_ID
, LKE.ASSET_NUMBER ASSET_NUMBER
, LKE.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, LKE.BOOK_TYPE_CODE BOOK_TYPE_CODE
, LKE.PROCEEDS_OF_SALE ORIG_SALE_PROCEEDS
, LKE.GAIN_LOSS_AMOUNT ORIG_GAIN_LOSS
, OKL_LIKE_KIND_EXCHANGE_PVT.GET_TOTAL_MATCH_AMT(TRX.REQ_ASSET_ID
, LKE.BOOK_TYPE_CODE) TOTAL_MATCH_AMOUNT
, OKL_LIKE_KIND_EXCHANGE_PVT.GET_BALANCE_SALE_PROCEEDS(TRX.REQ_ASSET_ID
, LKE.BOOK_TYPE_CODE) BALANCE_SALE_PROCEEDS
, OKL_LIKE_KIND_EXCHANGE_PVT.GET_DEFERRED_GAIN(TRX.REQ_ASSET_ID
, LKE.BOOK_TYPE_CODE) BALANCE_GAIN_LOSS
, FAD1.ASSET_NUMBER REPLACEMENT_ASSET_NUMBER
, FAD2.ASSET_NUMBER LKE_ASSET_NUMBER
, TXL.MATCH_AMOUNT MATCH_AMOUNT
, TRX.DATE_TRANS_OCCURRED TRANSACTION_DATE
FROM OKL_TRX_ASSETS TRX
, OKL_LIKE_KIND_EXCHANGE_V LKE
, OKL_TXL_ASSETS_B TXL
, FA_ADDITIONS_B FAD1
, FA_ADDITIONS_B FAD2
, FA_BOOK_CONTROLS FAB
WHERE TRX.REQ_ASSET_ID = LKE.ASSET_ID
AND TRX.ID = TXL.TAS_ID
AND TXL.REP_ASSET_ID = FAD1.ASSET_ID
AND TXL.LKE_ASSET_ID = FAD2.ASSET_ID
AND LKE.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND FAB.BOOK_CLASS = 'TAX'

Columns