VIEW: APPS.FA_CAPITALIZE_CIP_V

Source

View Text - Preformatted

SELECT AD.ROWID AD_ROWID , AD.ASSET_ID , AD.ASSET_NUMBER , ADT.DESCRIPTION , AD.TAG_NUMBER , AD.ASSET_KEY_CCID , AD.CURRENT_UNITS , AD.ASSET_TYPE , AD.ASSET_CATEGORY_ID , AD.PARENT_ASSET_ID , BK.BOOK_TYPE_CODE , BK.COST , BK.TRANSACTION_HEADER_ID_IN , AH.ROWID ASSET_HIST_ROWID , AD.LAST_UPDATE_DATE , AD.LAST_UPDATED_BY , AD.LAST_UPDATE_LOGIN , AD.CREATED_BY , AD.CREATION_DATE , 'NO ' CAPITALIZE_OR_REVERSE FROM FA_BOOKS BK, FA_ASSET_HISTORY AH, FA_ADDITIONS_B AD, FA_ADDITIONS_TL ADT WHERE ((AD.ASSET_TYPE = 'CAPITALIZED' AND EXISTS (SELECT 'CURRENT PERIOD ADDITION' FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP WHERE TH.ASSET_ID = AD.ASSET_ID AND TH.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE AND TH.TRANSACTION_TYPE_CODE||'' = 'ADDITION' AND TH.DATE_EFFECTIVE >= DP.PERIOD_OPEN_DATE AND DP.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE AND DP.PERIOD_CLOSE_DATE IS NULL)) OR AD.ASSET_TYPE = 'CIP') AND AD.ASSET_ID = BK.ASSET_ID AND BK.DATE_INEFFECTIVE IS NULL AND BK.PERIOD_COUNTER_FULLY_RETIRED IS NULL AND AD.ASSET_ID = AH.ASSET_ID AND AD.ASSET_CATEGORY_ID = AH.CATEGORY_ID AND AH.DATE_INEFFECTIVE IS NULL AND ADT.ASSET_ID = AD.ASSET_ID AND ADT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT AD.ROWID AD_ROWID
, AD.ASSET_ID
, AD.ASSET_NUMBER
, ADT.DESCRIPTION
, AD.TAG_NUMBER
, AD.ASSET_KEY_CCID
, AD.CURRENT_UNITS
, AD.ASSET_TYPE
, AD.ASSET_CATEGORY_ID
, AD.PARENT_ASSET_ID
, BK.BOOK_TYPE_CODE
, BK.COST
, BK.TRANSACTION_HEADER_ID_IN
, AH.ROWID ASSET_HIST_ROWID
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_LOGIN
, AD.CREATED_BY
, AD.CREATION_DATE
, 'NO ' CAPITALIZE_OR_REVERSE
FROM FA_BOOKS BK
, FA_ASSET_HISTORY AH
, FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADT
WHERE ((AD.ASSET_TYPE = 'CAPITALIZED'
AND EXISTS (SELECT 'CURRENT PERIOD ADDITION'
FROM FA_TRANSACTION_HEADERS TH
, FA_DEPRN_PERIODS DP
WHERE TH.ASSET_ID = AD.ASSET_ID
AND TH.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND TH.TRANSACTION_TYPE_CODE||'' = 'ADDITION'
AND TH.DATE_EFFECTIVE >= DP.PERIOD_OPEN_DATE
AND DP.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND DP.PERIOD_CLOSE_DATE IS NULL)) OR AD.ASSET_TYPE = 'CIP')
AND AD.ASSET_ID = BK.ASSET_ID
AND BK.DATE_INEFFECTIVE IS NULL
AND BK.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND AD.ASSET_ID = AH.ASSET_ID
AND AD.ASSET_CATEGORY_ID = AH.CATEGORY_ID
AND AH.DATE_INEFFECTIVE IS NULL
AND ADT.ASSET_ID = AD.ASSET_ID
AND ADT.LANGUAGE = USERENV('LANG')