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: QRM.QRM_ANALYSIS_SETTINGS#

Source

View Text - Preformatted


select ANALYSIS_NAME ANALYSIS_NAME, HISTORY_FLAG HISTORY_FLAG, ANALYSIS_TYPE ANALYSIS_TYPE, STYLE STYLE, DATE_TYPE DATE_TYPE, CURRENCY_SOURCE CURRENCY_SOURCE, UNITS UNITS, STATUS STATUS, DIRTY DIRTY, BUSINESS_WEEK BUSINESS_WEEK, DESCRIPTION DESCRIPTION, FILTER_NAME FILTER_NAME, MD_SET_CODE MD_SET_CODE, THRESHOLD_NUM THRESHOLD_NUM, THRESHOLD_TYPE THRESHOLD_TYPE, TB_LABEL TB_LABEL, TB_NAME TB_NAME, START_DATE START_DATE, END_DATE END_DATE, START_DATE_REF START_DATE_REF, END_DATE_REF END_DATE_REF, START_DATE_OFFSET START_DATE_OFFSET, END_DATE_OFFSET END_DATE_OFFSET, START_OFFSET_TYPE START_OFFSET_TYPE, END_OFFSET_TYPE END_OFFSET_TYPE, SHOW_TOTALS SHOW_TOTALS, CURR_REPORTING CURR_REPORTING, CURRENCY_USED CURRENCY_USED, DEC_PLACES DEC_PLACES, PROCESS_ID PROCESS_ID, LAST_RUN_DATE LAST_RUN_DATE, GL_CALENDAR_ID GL_CALENDAR_ID, 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, ZD_EDITION_NAME ZD_EDITION_NAME from "QRM"."QRM_ANALYSIS_SETTINGS"

View Text - HTML Formatted

SELECT ANALYSIS_NAME ANALYSIS_NAME
, HISTORY_FLAG HISTORY_FLAG
, ANALYSIS_TYPE ANALYSIS_TYPE
, STYLE STYLE
, DATE_TYPE DATE_TYPE
, CURRENCY_SOURCE CURRENCY_SOURCE
, UNITS UNITS
, STATUS STATUS
, DIRTY DIRTY
, BUSINESS_WEEK BUSINESS_WEEK
, DESCRIPTION DESCRIPTION
, FILTER_NAME FILTER_NAME
, MD_SET_CODE MD_SET_CODE
, THRESHOLD_NUM THRESHOLD_NUM
, THRESHOLD_TYPE THRESHOLD_TYPE
, TB_LABEL TB_LABEL
, TB_NAME TB_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, START_DATE_REF START_DATE_REF
, END_DATE_REF END_DATE_REF
, START_DATE_OFFSET START_DATE_OFFSET
, END_DATE_OFFSET END_DATE_OFFSET
, START_OFFSET_TYPE START_OFFSET_TYPE
, END_OFFSET_TYPE END_OFFSET_TYPE
, SHOW_TOTALS SHOW_TOTALS
, CURR_REPORTING CURR_REPORTING
, CURRENCY_USED CURRENCY_USED
, DEC_PLACES DEC_PLACES
, PROCESS_ID PROCESS_ID
, LAST_RUN_DATE LAST_RUN_DATE
, GL_CALENDAR_ID GL_CALENDAR_ID
, 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
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "QRM"."QRM_ANALYSIS_SETTINGS"