eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: IGI.IGI_IAC_PROJ_REP_ITF#

Source

View Text - Preformatted


select PROJECTION_ID PROJECTION_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, START_PERIOD START_PERIOD, END_PERIOD END_PERIOD, PROJ_PERIOD PROJ_PERIOD, FISCAL_YEAR FISCAL_YEAR, PERIODIC_INDEX PERIODIC_INDEX, REVAL_INDEX REVAL_INDEX, REVAL_PERIOD_NAME REVAL_PERIOD_NAME, COMPANY COMPANY, COST_CENTER COST_CENTER, CATEGORY_ID CATEGORY_ID, MAJOR_CATEGORY MAJOR_CATEGORY, MINOR_CATEGORY MINOR_CATEGORY, CATEGORY_DESC CATEGORY_DESC, ASSET_NUMBER ASSET_NUMBER, ASSET_DESC ASSET_DESC, DEPRN_PERIOD DEPRN_PERIOD, DEPRN_YTD DEPRN_YTD, LATEST_REVAL_COST LATEST_REVAL_COST, EXCEPTION_CODE EXCEPTION_CODE, EXCEPTION_DESC EXCEPTION_DESC, REQUEST_ID REQUEST_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, 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, CATEGORY CATEGORY, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME, PERIOD_COUNTER PERIOD_COUNTER from "IGI"."IGI_IAC_PROJ_REP_ITF"

View Text - HTML Formatted

SELECT PROJECTION_ID PROJECTION_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, START_PERIOD START_PERIOD
, END_PERIOD END_PERIOD
, PROJ_PERIOD PROJ_PERIOD
, FISCAL_YEAR FISCAL_YEAR
, PERIODIC_INDEX PERIODIC_INDEX
, REVAL_INDEX REVAL_INDEX
, REVAL_PERIOD_NAME REVAL_PERIOD_NAME
, COMPANY COMPANY
, COST_CENTER COST_CENTER
, CATEGORY_ID CATEGORY_ID
, MAJOR_CATEGORY MAJOR_CATEGORY
, MINOR_CATEGORY MINOR_CATEGORY
, CATEGORY_DESC CATEGORY_DESC
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESC ASSET_DESC
, DEPRN_PERIOD DEPRN_PERIOD
, DEPRN_YTD DEPRN_YTD
, LATEST_REVAL_COST LATEST_REVAL_COST
, EXCEPTION_CODE EXCEPTION_CODE
, EXCEPTION_DESC EXCEPTION_DESC
, REQUEST_ID REQUEST_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, 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
, CATEGORY CATEGORY
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
, PERIOD_COUNTER PERIOD_COUNTER
FROM "IGI"."IGI_IAC_PROJ_REP_ITF"