View: OKL_LKE_REP_ASSET_UV

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

View Text

SELECT FAD.ASSET_ID REP_ASSET_ID
, FAD.ASSET_NUMBER REP_ASSET_NUMBER
, FAB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FAD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, FAB.ORIGINAL_COST ORIGINAL_COST
, FAB.COST CURRENT_COST
, FAB.DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, FAM.NAME DEPRN_METHOD
, FAB.LIFE_IN_MONTHS LIFE_IN_MONTHS
FROM FA_BOOKS FAB
, FA_ADDITIONS_B FAD
, FA_BOOK_CONTROLS FBC
, FA_METHODS FAM
, 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.DEPRN_METHOD_CODE = FAM.METHOD_CODE
AND FAB.LIFE_IN_MONTHS = FAM.LIFE_IN_MONTHS
AND FAB.COST > 0
AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
AND NOT EXISTS (SELECT '1'
FROM FA_BOOKS FAB2
WHERE FAB2.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND FAB2.ASSET_ID = FAB.ASSET_ID
AND FAB2.RETIREMENT_ID IS NOT NULL)
AND FAB.DATE_PLACED_IN_SERVICE BETWEEN (SYSDATE-OKLSYS.LKE_HOLD_DAYS)
AND SYSDATE

Columns