VIEW: IGI.IGI_IAC_ASSET_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, COMPANY_NAME COMPANY_NAME, BOOK_TYPE_CODE BOOK_TYPE_CODE, PERIOD PERIOD, FISCAL_YEAR_NAME FISCAL_YEAR_NAME, MAJOR_CATEGORY MAJOR_CATEGORY, MINOR_CATEGORY MINOR_CATEGORY, COST_CENTER COST_CENTER, ASSET_NUMBER ASSET_NUMBER, ASSET_DESCRIPTION ASSET_DESCRIPTION, REVAL_COST REVAL_COST, REVAL_RESERVE REVAL_RESERVE, GENERAL_FUND GENERAL_FUND, OPER_ACCT OPER_ACCT, DEPRN_RESV DEPRN_RESV, BACKLOG BACKLOG, DEPRN_PERIOD DEPRN_PERIOD, YTD_DEPRN YTD_DEPRN, DEPRN_BACKLOG DEPRN_BACKLOG, DEPRN_TOTAL DEPRN_TOTAL, REVAL_RESV_COST REVAL_RESV_COST, REVAL_RESV_BLOG REVAL_RESV_BLOG, REVAL_RESV_GEN_FUND REVAL_RESV_GEN_FUND, REVAL_RESV_NET REVAL_RESV_NET, OPER_EXP OPER_EXP, OPER_EXP_BACKLOG OPER_EXP_BACKLOG, OPER_EXP_NET OPER_EXP_NET, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANISATION_NAME ORGANISATION_NAME, PARENT_NO PARENT_NO, CURR_REVAL_FACTOR CURR_REVAL_FACTOR, CUM_REVAL_FACTOR CUM_REVAL_FACTOR, ASSET_TAG ASSET_TAG, BALANCING_SEGMENT BALANCING_SEGMENT, SERIAL_NO SERIAL_NO, DPIS DPIS, LIFE_MONTHS LIFE_MONTHS, STL_RATE STL_RATE, DEPRECIATION_METHOD DEPRECIATION_METHOD, CONC_ASSET_KEY CONC_ASSET_KEY, CONC_LOCATION CONC_LOCATION, COST_ACCT COST_ACCT, IAC_REVAL_RESV_ACCT IAC_REVAL_RESV_ACCT, DEPRN_RES_ACCT DEPRN_RES_ACCT, DEPRN_BACKLOG_ACCT DEPRN_BACKLOG_ACCT, GEN_FUND_ACCT GEN_FUND_ACCT, DEPRN_EXP_ACCT DEPRN_EXP_ACCT, OPER_EXP_ACCT OPER_EXP_ACCT, CONCAT_CATEGORY CONCAT_CATEGORY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE from "IGI"."IGI_IAC_ASSET_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, COMPANY_NAME COMPANY_NAME
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, PERIOD PERIOD
, FISCAL_YEAR_NAME FISCAL_YEAR_NAME
, MAJOR_CATEGORY MAJOR_CATEGORY
, MINOR_CATEGORY MINOR_CATEGORY
, COST_CENTER COST_CENTER
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESCRIPTION ASSET_DESCRIPTION
, REVAL_COST REVAL_COST
, REVAL_RESERVE REVAL_RESERVE
, GENERAL_FUND GENERAL_FUND
, OPER_ACCT OPER_ACCT
, DEPRN_RESV DEPRN_RESV
, BACKLOG BACKLOG
, DEPRN_PERIOD DEPRN_PERIOD
, YTD_DEPRN YTD_DEPRN
, DEPRN_BACKLOG DEPRN_BACKLOG
, DEPRN_TOTAL DEPRN_TOTAL
, REVAL_RESV_COST REVAL_RESV_COST
, REVAL_RESV_BLOG REVAL_RESV_BLOG
, REVAL_RESV_GEN_FUND REVAL_RESV_GEN_FUND
, REVAL_RESV_NET REVAL_RESV_NET
, OPER_EXP OPER_EXP
, OPER_EXP_BACKLOG OPER_EXP_BACKLOG
, OPER_EXP_NET OPER_EXP_NET
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANISATION_NAME ORGANISATION_NAME
, PARENT_NO PARENT_NO
, CURR_REVAL_FACTOR CURR_REVAL_FACTOR
, CUM_REVAL_FACTOR CUM_REVAL_FACTOR
, ASSET_TAG ASSET_TAG
, BALANCING_SEGMENT BALANCING_SEGMENT
, SERIAL_NO SERIAL_NO
, DPIS DPIS
, LIFE_MONTHS LIFE_MONTHS
, STL_RATE STL_RATE
, DEPRECIATION_METHOD DEPRECIATION_METHOD
, CONC_ASSET_KEY CONC_ASSET_KEY
, CONC_LOCATION CONC_LOCATION
, COST_ACCT COST_ACCT
, IAC_REVAL_RESV_ACCT IAC_REVAL_RESV_ACCT
, DEPRN_RES_ACCT DEPRN_RES_ACCT
, DEPRN_BACKLOG_ACCT DEPRN_BACKLOG_ACCT
, GEN_FUND_ACCT GEN_FUND_ACCT
, DEPRN_EXP_ACCT DEPRN_EXP_ACCT
, OPER_EXP_ACCT OPER_EXP_ACCT
, CONCAT_CATEGORY CONCAT_CATEGORY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "IGI"."IGI_IAC_ASSET_REP_ITF"