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_PQ_TYPES#

Source

View Text - Preformatted


select QUERY_ID QUERY_ID, SOURCE_TYPE SOURCE_TYPE, OBJECT_TYPE OBJECT_TYPE, SEQUENCE_ID SEQUENCE_ID, AND_OR_FLAG AND_OR_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUSTOMIZED_TEXT CUSTOMIZED_TEXT, SR_INSTANCE_ID SR_INSTANCE_ID, OBJECT_TYPE_TEXT OBJECT_TYPE_TEXT, ACTIVE_FLAG ACTIVE_FLAG, DETAIL_QUERY_ID DETAIL_QUERY_ID, FREQUENCY FREQUENCY, PRIORITY PRIORITY from "MSC"."MSC_PQ_TYPES"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, SOURCE_TYPE SOURCE_TYPE
, OBJECT_TYPE OBJECT_TYPE
, SEQUENCE_ID SEQUENCE_ID
, AND_OR_FLAG AND_OR_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUSTOMIZED_TEXT CUSTOMIZED_TEXT
, SR_INSTANCE_ID SR_INSTANCE_ID
, OBJECT_TYPE_TEXT OBJECT_TYPE_TEXT
, ACTIVE_FLAG ACTIVE_FLAG
, DETAIL_QUERY_ID DETAIL_QUERY_ID
, FREQUENCY FREQUENCY
, PRIORITY PRIORITY
FROM "MSC"."MSC_PQ_TYPES"