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: CSM.CSM_CUSTOMIZATION_VIEWS#

Source

View Text - Preformatted


select CUST_VIEW_ID CUST_VIEW_ID, PAGE_NAME PAGE_NAME, REGION_NAME REGION_NAME, CUST_VIEW_KEY CUST_VIEW_KEY, LEVEL_ID LEVEL_ID, LEVEL_VALUE LEVEL_VALUE, MESSAGE_NAME MESSAGE_NAME, SELECT_STATEMENT SELECT_STATEMENT, WHERE_CONDITION WHERE_CONDITION, WHERE_CLAUSE WHERE_CLAUSE, ORDERBY_CLAUSE ORDERBY_CLAUSE, IS_DEFAULT IS_DEFAULT, DISPLAY_ROWS DISPLAY_ROWS, DISPLAY_VIEW DISPLAY_VIEW, BASE_VO_NAME BASE_VO_NAME, UPDATABLE UPDATABLE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ZD_EDITION_NAME ZD_EDITION_NAME from "CSM"."CSM_CUSTOMIZATION_VIEWS"

View Text - HTML Formatted

SELECT CUST_VIEW_ID CUST_VIEW_ID
, PAGE_NAME PAGE_NAME
, REGION_NAME REGION_NAME
, CUST_VIEW_KEY CUST_VIEW_KEY
, LEVEL_ID LEVEL_ID
, LEVEL_VALUE LEVEL_VALUE
, MESSAGE_NAME MESSAGE_NAME
, SELECT_STATEMENT SELECT_STATEMENT
, WHERE_CONDITION WHERE_CONDITION
, WHERE_CLAUSE WHERE_CLAUSE
, ORDERBY_CLAUSE ORDERBY_CLAUSE
, IS_DEFAULT IS_DEFAULT
, DISPLAY_ROWS DISPLAY_ROWS
, DISPLAY_VIEW DISPLAY_VIEW
, BASE_VO_NAME BASE_VO_NAME
, UPDATABLE UPDATABLE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CSM"."CSM_CUSTOMIZATION_VIEWS"