View: FA_CAPITALIZE_CIP_V

Product:	OFA - Assets
Description:	Newly added or capitalized CIP assets
Implementation/DBA Data:	APPS.FA_CAPITALIZE_CIP_V

View Text

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')

Columns