VIEW: IGI.IGI_IMP_IAC_ITF#

Source

View Text - Preformatted

select BOOK_TYPE_CODE BOOK_TYPE_CODE, REQUEST_ID REQUEST_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ASSET_ID ASSET_ID, CATEGORY_ID CATEGORY_ID, DISTRIBUTION_ID DISTRIBUTION_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, FISCAL_YEAR_NAME FISCAL_YEAR_NAME, PERIOD PERIOD, COST_CENTER COST_CENTER, ASSET_NUMBER ASSET_NUMBER, ASSET_DESCRIPTION ASSET_DESCRIPTION, MAJOR_CATEGORY MAJOR_CATEGORY, MINOR_CATEGORY MINOR_CATEGORY, CONCAT_CATEGORY CONCAT_CATEGORY, REVAL_COST REVAL_COST, NET_REVAL_RESERVE NET_REVAL_RESERVE, REVAL_RES_BLOG REVAL_RES_BLOG, REVAL_YTD_DEPRN REVAL_YTD_DEPRN, REVAL_DEPRN_RESERVE REVAL_DEPRN_RESERVE, OPER_ACCT OPER_ACCT, OPER_EXP_BACKLOG OPER_EXP_BACKLOG, GENERAL_FUND GENERAL_FUND, PARENT_NO PARENT_NO, CURR_REVAL_FACTOR CURR_REVAL_FACTOR, CUMM_REVAL_FACTOR CUMM_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, HIST_COST HIST_COST, HIST_YTD_DEPRN HIST_YTD_DEPRN, HIST_ACC_DEPRN HIST_ACC_DEPRN, ORGANIZATION_NAME ORGANIZATION_NAME, 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_IMP_IAC_ITF"

View Text - HTML Formatted

SELECT BOOK_TYPE_CODE BOOK_TYPE_CODE
, REQUEST_ID REQUEST_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ASSET_ID ASSET_ID
, CATEGORY_ID CATEGORY_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, FISCAL_YEAR_NAME FISCAL_YEAR_NAME
, PERIOD PERIOD
, COST_CENTER COST_CENTER
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESCRIPTION ASSET_DESCRIPTION
, MAJOR_CATEGORY MAJOR_CATEGORY
, MINOR_CATEGORY MINOR_CATEGORY
, CONCAT_CATEGORY CONCAT_CATEGORY
, REVAL_COST REVAL_COST
, NET_REVAL_RESERVE NET_REVAL_RESERVE
, REVAL_RES_BLOG REVAL_RES_BLOG
, REVAL_YTD_DEPRN REVAL_YTD_DEPRN
, REVAL_DEPRN_RESERVE REVAL_DEPRN_RESERVE
, OPER_ACCT OPER_ACCT
, OPER_EXP_BACKLOG OPER_EXP_BACKLOG
, GENERAL_FUND GENERAL_FUND
, PARENT_NO PARENT_NO
, CURR_REVAL_FACTOR CURR_REVAL_FACTOR
, CUMM_REVAL_FACTOR CUMM_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
, HIST_COST HIST_COST
, HIST_YTD_DEPRN HIST_YTD_DEPRN
, HIST_ACC_DEPRN HIST_ACC_DEPRN
, ORGANIZATION_NAME ORGANIZATION_NAME
, 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_IMP_IAC_ITF"