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: MSC.MSC_CRITERIA#

Source

View Text - Preformatted


select FOLDER_OBJECT FOLDER_OBJECT, FIELD_NAME FIELD_NAME, FIELD_TYPE FIELD_TYPE, LOV_NAME LOV_NAME, SQL_STATEMENT SQL_STATEMENT, FIELD_PROMPT FIELD_PROMPT, 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, APP_SHORT_NAME APP_SHORT_NAME, FLEX_NUM FLEX_NUM, DATA_SET DATA_SET, FLEX_CODE FLEX_CODE, LOV_TYPE LOV_TYPE, LONG_LIST LONG_LIST, GROUP_BY GROUP_BY, ZD_EDITION_NAME ZD_EDITION_NAME, SQL_STATEMENT2 SQL_STATEMENT2 from "MSC"."MSC_CRITERIA"

View Text - HTML Formatted

SELECT FOLDER_OBJECT FOLDER_OBJECT
, FIELD_NAME FIELD_NAME
, FIELD_TYPE FIELD_TYPE
, LOV_NAME LOV_NAME
, SQL_STATEMENT SQL_STATEMENT
, FIELD_PROMPT FIELD_PROMPT
, 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
, APP_SHORT_NAME APP_SHORT_NAME
, FLEX_NUM FLEX_NUM
, DATA_SET DATA_SET
, FLEX_CODE FLEX_CODE
, LOV_TYPE LOV_TYPE
, LONG_LIST LONG_LIST
, GROUP_BY GROUP_BY
, ZD_EDITION_NAME ZD_EDITION_NAME
, SQL_STATEMENT2 SQL_STATEMENT2
FROM "MSC"."MSC_CRITERIA"