VIEW: APPS.FA_DEPRN_OVERRIDE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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