VIEW: APPS.OKL_LKE_REP_ASSET_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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