VIEW: AMS.AMS_LIST_QUERIES_ALL#

Source

View Text - Preformatted

select LIST_QUERY_ID LIST_QUERY_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, NAME NAME, TYPE TYPE, ENABLED_FLAG ENABLED_FLAG, PRIMARY_KEY PRIMARY_KEY, PUBLIC_FLAG PUBLIC_FLAG, ORG_ID ORG_ID, COMMENTS COMMENTS, SECURITY_GROUP_ID SECURITY_GROUP_ID, ACT_LIST_QUERY_USED_BY_ID ACT_LIST_QUERY_USED_BY_ID, ARC_ACT_LIST_QUERY_USED_BY ARC_ACT_LIST_QUERY_USED_BY, SEED_FLAG SEED_FLAG, SQL_STRING SQL_STRING, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME, PARENT_LIST_QUERY_ID PARENT_LIST_QUERY_ID, SEQUENCE_ORDER SEQUENCE_ORDER, PARAMETERIZED_FLAG PARAMETERIZED_FLAG, QUERY QUERY, ADMIN_FLAG ADMIN_FLAG, QUERY_TEMPLATE_ID QUERY_TEMPLATE_ID, OWNER_USER_ID OWNER_USER_ID, QUERY_TYPE QUERY_TYPE, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_LIST_QUERIES_ALL"

View Text - HTML Formatted

SELECT LIST_QUERY_ID LIST_QUERY_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
, NAME NAME
, TYPE TYPE
, ENABLED_FLAG ENABLED_FLAG
, PRIMARY_KEY PRIMARY_KEY
, PUBLIC_FLAG PUBLIC_FLAG
, ORG_ID ORG_ID
, COMMENTS COMMENTS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ACT_LIST_QUERY_USED_BY_ID ACT_LIST_QUERY_USED_BY_ID
, ARC_ACT_LIST_QUERY_USED_BY ARC_ACT_LIST_QUERY_USED_BY
, SEED_FLAG SEED_FLAG
, SQL_STRING SQL_STRING
, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, PARENT_LIST_QUERY_ID PARENT_LIST_QUERY_ID
, SEQUENCE_ORDER SEQUENCE_ORDER
, PARAMETERIZED_FLAG PARAMETERIZED_FLAG
, QUERY QUERY
, ADMIN_FLAG ADMIN_FLAG
, QUERY_TEMPLATE_ID QUERY_TEMPLATE_ID
, OWNER_USER_ID OWNER_USER_ID
, QUERY_TYPE QUERY_TYPE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_LIST_QUERIES_ALL"