VIEW: IGI.IGI_IMP_IAC_EXCEP_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, SOB_BOOK SOB_BOOK, ORGANISATION_NAME ORGANISATION_NAME, CORP_BOOK CORP_BOOK, TAX_BOOK TAX_BOOK, PERIOD PERIOD, FISCAL_YEAR_NAME FISCAL_YEAR_NAME, WARNING_MESSAGE WARNING_MESSAGE, WARNING_MESSAGE_CODE WARNING_MESSAGE_CODE, ASSET_NUMBER ASSET_NUMBER, ASSET_DESCRIPTION ASSET_DESCRIPTION, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, DPIS_CORP DPIS_CORP, DPIS_TAX DPIS_TAX, ASSET_LIFE_CORP ASSET_LIFE_CORP, ASSET_LIFE_TAX ASSET_LIFE_TAX, CONCAT_CATEGORY CONCAT_CATEGORY, HIST_COST_CORP HIST_COST_CORP, HIST_COST_TAX HIST_COST_TAX, SALVAGE_VALUE_CORP SALVAGE_VALUE_CORP, SALVAGE_VALUE_TAX SALVAGE_VALUE_TAX, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LSAT_UPDATE_DATE LSAT_UPDATE_DATE from "IGI"."IGI_IMP_IAC_EXCEP_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, SOB_BOOK SOB_BOOK
, ORGANISATION_NAME ORGANISATION_NAME
, CORP_BOOK CORP_BOOK
, TAX_BOOK TAX_BOOK
, PERIOD PERIOD
, FISCAL_YEAR_NAME FISCAL_YEAR_NAME
, WARNING_MESSAGE WARNING_MESSAGE
, WARNING_MESSAGE_CODE WARNING_MESSAGE_CODE
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESCRIPTION ASSET_DESCRIPTION
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, DPIS_CORP DPIS_CORP
, DPIS_TAX DPIS_TAX
, ASSET_LIFE_CORP ASSET_LIFE_CORP
, ASSET_LIFE_TAX ASSET_LIFE_TAX
, CONCAT_CATEGORY CONCAT_CATEGORY
, HIST_COST_CORP HIST_COST_CORP
, HIST_COST_TAX HIST_COST_TAX
, SALVAGE_VALUE_CORP SALVAGE_VALUE_CORP
, SALVAGE_VALUE_TAX SALVAGE_VALUE_TAX
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LSAT_UPDATE_DATE LSAT_UPDATE_DATE
FROM "IGI"."IGI_IMP_IAC_EXCEP_REP_ITF"