View: FA_DEPRN_OVERRIDE_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_DEPRN_OVERRIDE_V

View Text

SELECT FOV.DEPRN_OVERRIDE_ID
, FOV.BOOK_TYPE_CODE
, FOV.ASSET_ID
, FOV.PERIOD_NAME
, FOV.DEPRN_AMOUNT
, FOV.BONUS_DEPRN_AMOUNT
, FOV.SUBTRACTION_FLAG
, FOV.USED_BY
, FOV.STATUS
, FOV.TRANSACTION_HEADER_ID
, FOV.REQUEST_ID
, FOV.PROGRAM_APPLICATION_ID
, FOV.PROGRAM_UPDATE_DATE
, FOV.PROGRAM_ID
, FOV.CREATED_BY
, FOV.CREATION_DATE
, FOV.LAST_UPDATED_BY
, FOV.LAST_UPDATE_DATE
, FOV.LAST_UPDATE_LOGIN
, FOV.SUBTRACT_YTD_FLAG
, FAD.ASSET_NUMBER
, FCP.START_DATE
FROM FA_DEPRN_OVERRIDE FOV
, FA_ADDITIONS FAD
, FA_CALENDAR_PERIODS FCP
, FA_BOOK_CONTROLS FBC
WHERE FOV.ASSET_ID = FAD.ASSET_ID
AND FOV.BOOK_TYPE_CODE = FBC.BOOK_TYPE_CODE
AND FBC.DATE_INEFFECTIVE IS NULL
AND FBC.DEPRN_CALENDAR = FCP.CALENDAR_TYPE
AND FOV.PERIOD_NAME = FCP.PERIOD_NAME

Columns