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.

VIEW: GL.GL_OASIS_SUMMARY_DATA#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FIN_ITEM_ID FIN_ITEM_ID, DRILLDOWN_SEGNUM1 DRILLDOWN_SEGNUM1, DRILLDOWN_SEGNUM2 DRILLDOWN_SEGNUM2, ACTUAL_FLAG ACTUAL_FLAG, DRILLDOWN_SEGVAL1 DRILLDOWN_SEGVAL1, DRILLDOWN_SEGVAL2 DRILLDOWN_SEGVAL2, RELATIVE_PERIOD_POS RELATIVE_PERIOD_POS, PERIOD_NAME PERIOD_NAME, PERIOD_NUM PERIOD_NUM, PERIOD_YEAR PERIOD_YEAR, QUARTER_NUM QUARTER_NUM, DRILLDOWN_SEGDESC1 DRILLDOWN_SEGDESC1, DRILLDOWN_SEGDESC2 DRILLDOWN_SEGDESC2, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PERIOD_TO_DATE PERIOD_TO_DATE, QUARTER_TO_DATE QUARTER_TO_DATE, YEAR_TO_DATE YEAR_TO_DATE from "GL"."GL_OASIS_SUMMARY_DATA"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FIN_ITEM_ID FIN_ITEM_ID
, DRILLDOWN_SEGNUM1 DRILLDOWN_SEGNUM1
, DRILLDOWN_SEGNUM2 DRILLDOWN_SEGNUM2
, ACTUAL_FLAG ACTUAL_FLAG
, DRILLDOWN_SEGVAL1 DRILLDOWN_SEGVAL1
, DRILLDOWN_SEGVAL2 DRILLDOWN_SEGVAL2
, RELATIVE_PERIOD_POS RELATIVE_PERIOD_POS
, PERIOD_NAME PERIOD_NAME
, PERIOD_NUM PERIOD_NUM
, PERIOD_YEAR PERIOD_YEAR
, QUARTER_NUM QUARTER_NUM
, DRILLDOWN_SEGDESC1 DRILLDOWN_SEGDESC1
, DRILLDOWN_SEGDESC2 DRILLDOWN_SEGDESC2
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PERIOD_TO_DATE PERIOD_TO_DATE
, QUARTER_TO_DATE QUARTER_TO_DATE
, YEAR_TO_DATE YEAR_TO_DATE
FROM "GL"."GL_OASIS_SUMMARY_DATA"