VIEW: FA.FA_DEPRN_TAX_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, YEAR YEAR, ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, ASSET_DESCRIPTION ASSET_DESCRIPTION, NEW_USED NEW_USED, BOOK_TYPE_CODE BOOK_TYPE_CODE, MINOR_CATEGORY MINOR_CATEGORY, TAX_ASSET_TYPE TAX_ASSET_TYPE, MINOR_CAT_DESC MINOR_CAT_DESC, STATE STATE, START_UNITS_ASSIGNED START_UNITS_ASSIGNED, END_UNITS_ASSIGNED END_UNITS_ASSIGNED, START_COST START_COST, END_COST END_COST, INCREASE_COST INCREASE_COST, DECREASE_COST DECREASE_COST, THEORETICAL_NBV THEORETICAL_NBV, EVALUATED_NBV EVALUATED_NBV, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, ERA_NAME_NUM ERA_NAME_NUM, ADD_ERA_YEAR ADD_ERA_YEAR, ADD_MONTH ADD_MONTH, START_LIFE START_LIFE, END_LIFE END_LIFE, THEORETICAL_RESIDUAL_RATE THEORETICAL_RESIDUAL_RATE, EVALUATED_RESIDUAL_RATE EVALUATED_RESIDUAL_RATE, ADJUSTED_RATE ADJUSTED_RATE, EXCEPTION_CODE EXCEPTION_CODE, EXCEPTION_RATE EXCEPTION_RATE, THEORETICAL_TAXABLE_COST THEORETICAL_TAXABLE_COST, EVALUATED_TAXABLE_COST EVALUATED_TAXABLE_COST, ALL_REASON_TYPE ALL_REASON_TYPE, ALL_REASON_CODE ALL_REASON_CODE, ALL_DESCRIPTION ALL_DESCRIPTION, ADDDEC_REASON_TYPE ADDDEC_REASON_TYPE, ADDDEC_REASON_CODE ADDDEC_REASON_CODE, DEC_TYPE DEC_TYPE, ADDDEC_DESCRIPTION ADDDEC_DESCRIPTION, ADD_DEC_FLAG ADD_DEC_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME from "FA"."FA_DEPRN_TAX_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, YEAR YEAR
, ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESCRIPTION ASSET_DESCRIPTION
, NEW_USED NEW_USED
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, MINOR_CATEGORY MINOR_CATEGORY
, TAX_ASSET_TYPE TAX_ASSET_TYPE
, MINOR_CAT_DESC MINOR_CAT_DESC
, STATE STATE
, START_UNITS_ASSIGNED START_UNITS_ASSIGNED
, END_UNITS_ASSIGNED END_UNITS_ASSIGNED
, START_COST START_COST
, END_COST END_COST
, INCREASE_COST INCREASE_COST
, DECREASE_COST DECREASE_COST
, THEORETICAL_NBV THEORETICAL_NBV
, EVALUATED_NBV EVALUATED_NBV
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, ERA_NAME_NUM ERA_NAME_NUM
, ADD_ERA_YEAR ADD_ERA_YEAR
, ADD_MONTH ADD_MONTH
, START_LIFE START_LIFE
, END_LIFE END_LIFE
, THEORETICAL_RESIDUAL_RATE THEORETICAL_RESIDUAL_RATE
, EVALUATED_RESIDUAL_RATE EVALUATED_RESIDUAL_RATE
, ADJUSTED_RATE ADJUSTED_RATE
, EXCEPTION_CODE EXCEPTION_CODE
, EXCEPTION_RATE EXCEPTION_RATE
, THEORETICAL_TAXABLE_COST THEORETICAL_TAXABLE_COST
, EVALUATED_TAXABLE_COST EVALUATED_TAXABLE_COST
, ALL_REASON_TYPE ALL_REASON_TYPE
, ALL_REASON_CODE ALL_REASON_CODE
, ALL_DESCRIPTION ALL_DESCRIPTION
, ADDDEC_REASON_TYPE ADDDEC_REASON_TYPE
, ADDDEC_REASON_CODE ADDDEC_REASON_CODE
, DEC_TYPE DEC_TYPE
, ADDDEC_DESCRIPTION ADDDEC_DESCRIPTION
, ADD_DEC_FLAG ADD_DEC_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
FROM "FA"."FA_DEPRN_TAX_REP_ITF"