VIEW: IGI.IGI_IMP_IAC_INTERFACE_PY_ADD#

Source

View Text - Preformatted

select ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, BOOK_TYPE_CODE BOOK_TYPE_CODE, CATEGORY_ID CATEGORY_ID, PERIOD_COUNTER PERIOD_COUNTER, NET_BOOK_VALUE NET_BOOK_VALUE, ADJUSTED_COST ADJUSTED_COST, OPERATING_ACCT OPERATING_ACCT, REVAL_RESERVE REVAL_RESERVE, DEPRN_AMOUNT DEPRN_AMOUNT, DEPRN_RESERVE DEPRN_RESERVE, BACKLOG_DEPRN_RESERVE BACKLOG_DEPRN_RESERVE, GENERAL_FUND GENERAL_FUND, LAST_REVAL_DATE LAST_REVAL_DATE, CURRENT_REVAL_FACTOR CURRENT_REVAL_FACTOR, CUMMULATIVE_REVAL_FACTOR CUMMULATIVE_REVAL_FACTOR, HIST_COST HIST_COST, HIST_DEPRN_EXPENSE HIST_DEPRN_EXPENSE, HIST_YTD HIST_YTD, HIST_ACCUM_DEPRN HIST_ACCUM_DEPRN, HIST_LIFE_IN_MONTHS HIST_LIFE_IN_MONTHS, HIST_NBV HIST_NBV, HIST_SALVAGE_VALUE HIST_SALVAGE_VALUE, GENERAL_FUND_PERIODIC GENERAL_FUND_PERIODIC, OPERATING_ACCOUNT_YTD OPERATING_ACCOUNT_YTD, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "IGI"."IGI_IMP_IAC_INTERFACE_PY_ADD"

View Text - HTML Formatted

SELECT ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CATEGORY_ID CATEGORY_ID
, PERIOD_COUNTER PERIOD_COUNTER
, NET_BOOK_VALUE NET_BOOK_VALUE
, ADJUSTED_COST ADJUSTED_COST
, OPERATING_ACCT OPERATING_ACCT
, REVAL_RESERVE REVAL_RESERVE
, DEPRN_AMOUNT DEPRN_AMOUNT
, DEPRN_RESERVE DEPRN_RESERVE
, BACKLOG_DEPRN_RESERVE BACKLOG_DEPRN_RESERVE
, GENERAL_FUND GENERAL_FUND
, LAST_REVAL_DATE LAST_REVAL_DATE
, CURRENT_REVAL_FACTOR CURRENT_REVAL_FACTOR
, CUMMULATIVE_REVAL_FACTOR CUMMULATIVE_REVAL_FACTOR
, HIST_COST HIST_COST
, HIST_DEPRN_EXPENSE HIST_DEPRN_EXPENSE
, HIST_YTD HIST_YTD
, HIST_ACCUM_DEPRN HIST_ACCUM_DEPRN
, HIST_LIFE_IN_MONTHS HIST_LIFE_IN_MONTHS
, HIST_NBV HIST_NBV
, HIST_SALVAGE_VALUE HIST_SALVAGE_VALUE
, GENERAL_FUND_PERIODIC GENERAL_FUND_PERIODIC
, OPERATING_ACCOUNT_YTD OPERATING_ACCOUNT_YTD
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "IGI"."IGI_IMP_IAC_INTERFACE_PY_ADD"