VIEW: CSM.CSM_QUERY_B#

Source

View Text - Preformatted

select QUERY_ID QUERY_ID, QUERY_NAME QUERY_NAME, QUERY_TYPE QUERY_TYPE, QUERY_TEXT1 QUERY_TEXT1, QUERY_TEXT2 QUERY_TEXT2, LEVEL_ID LEVEL_ID, LEVEL_VALUE LEVEL_VALUE, PARENT_QUERY_ID PARENT_QUERY_ID, SAVED_QUERY SAVED_QUERY, QUERY_OUTPUT_FORMAT QUERY_OUTPUT_FORMAT, MIME_TYPE MIME_TYPE, WORK_FLOW WORK_FLOW, RETENTION_POLICY RETENTION_POLICY, RETENTION_DAYS RETENTION_DAYS, DELETE_FLAG DELETE_FLAG, TEMPLATE TEMPLATE, TEMPLATE_FILE TEMPLATE_FILE, SEEDED SEEDED, EXECUTION_MODE EXECUTION_MODE, EMAIL_ENABLED EMAIL_ENABLED, RESTRICTED_FLAG RESTRICTED_FLAG, DISABLED_FLAG DISABLED_FLAG, PROCEDURE_NAME PROCEDURE_NAME, 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 from "CSM"."CSM_QUERY_B"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, QUERY_NAME QUERY_NAME
, QUERY_TYPE QUERY_TYPE
, QUERY_TEXT1 QUERY_TEXT1
, QUERY_TEXT2 QUERY_TEXT2
, LEVEL_ID LEVEL_ID
, LEVEL_VALUE LEVEL_VALUE
, PARENT_QUERY_ID PARENT_QUERY_ID
, SAVED_QUERY SAVED_QUERY
, QUERY_OUTPUT_FORMAT QUERY_OUTPUT_FORMAT
, MIME_TYPE MIME_TYPE
, WORK_FLOW WORK_FLOW
, RETENTION_POLICY RETENTION_POLICY
, RETENTION_DAYS RETENTION_DAYS
, DELETE_FLAG DELETE_FLAG
, TEMPLATE TEMPLATE
, TEMPLATE_FILE TEMPLATE_FILE
, SEEDED SEEDED
, EXECUTION_MODE EXECUTION_MODE
, EMAIL_ENABLED EMAIL_ENABLED
, RESTRICTED_FLAG RESTRICTED_FLAG
, DISABLED_FLAG DISABLED_FLAG
, PROCEDURE_NAME PROCEDURE_NAME
, 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
FROM "CSM"."CSM_QUERY_B"