VIEW: AMS.AMS_QUERY_CONDITION#

Source

View Text - Preformatted

select QUERY_CONDITION_ID QUERY_CONDITION_ID, TEMPLATE_ID TEMPLATE_ID, JOIN_CONDITION JOIN_CONDITION, OPERAND_DATA_TYPE OPERAND_DATA_TYPE, MANDATORY_FLAG MANDATORY_FLAG, DEFAULT_FLAG DEFAULT_FLAG, CONDITION_IN_USE_FLAG CONDITION_IN_USE_FLAG, LEFT_OPERAND_TYPE LEFT_OPERAND_TYPE, VALUE1_TYPE VALUE1_TYPE, VALUE2_TYPE VALUE2_TYPE, DISPLAY_COL_NUMBER DISPLAY_COL_NUMBER, MAX_TOKEN_COUNT MAX_TOKEN_COUNT, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, COND_KEYWORD COND_KEYWORD, PARAMETER_KEY PARAMETER_KEY, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_QUERY_CONDITION"

View Text - HTML Formatted

SELECT QUERY_CONDITION_ID QUERY_CONDITION_ID
, TEMPLATE_ID TEMPLATE_ID
, JOIN_CONDITION JOIN_CONDITION
, OPERAND_DATA_TYPE OPERAND_DATA_TYPE
, MANDATORY_FLAG MANDATORY_FLAG
, DEFAULT_FLAG DEFAULT_FLAG
, CONDITION_IN_USE_FLAG CONDITION_IN_USE_FLAG
, LEFT_OPERAND_TYPE LEFT_OPERAND_TYPE
, VALUE1_TYPE VALUE1_TYPE
, VALUE2_TYPE VALUE2_TYPE
, DISPLAY_COL_NUMBER DISPLAY_COL_NUMBER
, MAX_TOKEN_COUNT MAX_TOKEN_COUNT
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, COND_KEYWORD COND_KEYWORD
, PARAMETER_KEY PARAMETER_KEY
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_QUERY_CONDITION"