VIEW: AMS.AMS_QUERY_TEMPLATE_ALL#

Source

View Text - Preformatted

select TEMPLATE_ID TEMPLATE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, VIEW_APPLICATION_ID VIEW_APPLICATION_ID, SEEDED_FLAG SEEDED_FLAG, ENABLED_FLAG ENABLED_FLAG, TEMPLATE_TYPE TEMPLATE_TYPE, IN_USE_FLAG IN_USE_FLAG, LIST_SRC_TYPE LIST_SRC_TYPE, SECURITY_GROUP_ID SECURITY_GROUP_ID, MV_NAME MV_NAME, MV_AVAILABLE_FLAG MV_AVAILABLE_FLAG, SAMPLE_PCT SAMPLE_PCT, MASTER_DS_REC_NUMBERS MASTER_DS_REC_NUMBERS, SAMPLE_PCT_RECORDS SAMPLE_PCT_RECORDS, AQE_ID AQE_ID, RECALC_TABLE_STATUS RECALC_TABLE_STATUS, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_QUERY_TEMPLATE_ALL"

View Text - HTML Formatted

SELECT TEMPLATE_ID TEMPLATE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, SEEDED_FLAG SEEDED_FLAG
, ENABLED_FLAG ENABLED_FLAG
, TEMPLATE_TYPE TEMPLATE_TYPE
, IN_USE_FLAG IN_USE_FLAG
, LIST_SRC_TYPE LIST_SRC_TYPE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, MV_NAME MV_NAME
, MV_AVAILABLE_FLAG MV_AVAILABLE_FLAG
, SAMPLE_PCT SAMPLE_PCT
, MASTER_DS_REC_NUMBERS MASTER_DS_REC_NUMBERS
, SAMPLE_PCT_RECORDS SAMPLE_PCT_RECORDS
, AQE_ID AQE_ID
, RECALC_TABLE_STATUS RECALC_TABLE_STATUS
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_QUERY_TEMPLATE_ALL"