View: OKL_LKE_REQ_ASSET_UV

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

View Text

SELECT FAD.ASSET_ID REQ_ASSET_ID
, FAD.ASSET_NUMBER REQ_ASSET_NUMBER
, FAB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FAD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, FAB.ORIGINAL_COST ORIGINAL_COST
, FAR.DATE_RETIRED DATE_RETIRED
, FAR.PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, FAR.GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT
, NVL(OKL_LIKE_KIND_EXCHANGE_PVT.GET_BALANCE_SALE_PROCEEDS(FAD.ASSET_ID
, FAB.BOOK_TYPE_CODE)
, FAR.PROCEEDS_OF_SALE) BALANCE_SALE_PROCEEDS
, NVL(OKL_LIKE_KIND_EXCHANGE_PVT.GET_DEFERRED_GAIN(FAD.ASSET_ID
, FAB.BOOK_TYPE_CODE)
, FAR.GAIN_LOSS_AMOUNT) BALANCE_GAIN_LOSS
, 0 MATCH_AMOUNT
FROM FA_BOOKS FAB
, FA_ADDITIONS_B FAD
, FA_BOOK_CONTROLS FBC
, FA_RETIREMENTS FAR
, OKC_K_ITEMS CIM
, OKC_K_LINES_B FA_LINE
, OKC_LINE_STYLES_B FA_LSE
, OKL_ASSET_RETURNS_ALL_B OKLAR
, OKL_SYS_ACCT_OPTS OKLSYS
WHERE FBC.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND FBC.BOOK_CLASS = 'TAX'
AND NVL(FBC.DATE_INEFFECTIVE
, SYSDATE+1) > SYSDATE
AND FAB.ASSET_ID = FAD.ASSET_ID
AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FAD.ASSET_ID = FAR.ASSET_ID
AND FAR.STATUS = 'PROCESSED'
AND FAB.BOOK_TYPE_CODE = FAR.BOOK_TYPE_CODE
AND CIM.OBJECT1_ID1 = TO_CHAR(FAR.ASSET_ID)
AND CIM.OBJECT1_ID2 = '#'
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CIM.CLE_ID = FA_LINE.ID
AND CIM.DNZ_CHR_ID = FA_LINE.DNZ_CHR_ID
AND FA_LINE.LSE_ID = FA_LSE.ID
AND FA_LSE.LTY_CODE = 'FIXED_ASSET'
AND FA_LINE.CLE_ID = OKLAR.KLE_ID
AND OKLAR.LIKE_KIND_YN = 'Y'
AND FAR.DATE_RETIRED BETWEEN (SYSDATE-OKLSYS.LKE_HOLD_DAYS)
AND SYSDATE

Columns