VIEW: AMS.AMS_QUERY_COND_DISP_STRUCT_AL#

Source

View Text - Preformatted

select QUERY_COND_DISP_STRUCT_ID QUERY_COND_DISP_STRUCT_ID, QUERY_TEMPLATE_ID QUERY_TEMPLATE_ID, QUERY_CONDITION_ID QUERY_CONDITION_ID, TOKEN_TYPE TOKEN_TYPE, TOKEN_SEQUENCE TOKEN_SEQUENCE, AVAILABLE_LOV_ID AVAILABLE_LOV_ID, VALUE_TYPE VALUE_TYPE, NON_VARIANT_VALUE NON_VARIANT_VALUE, QUERY_ALIAS_ID QUERY_ALIAS_ID, DATA_TYPE DATA_TYPE, EXP_LOGIC_SEQ EXP_LOGIC_SEQ, EXP_DISPLAY_SEQ EXP_DISPLAY_SEQ, 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, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_QUERY_COND_DISP_STRUCT_ALL"

View Text - HTML Formatted

SELECT QUERY_COND_DISP_STRUCT_ID QUERY_COND_DISP_STRUCT_ID
, QUERY_TEMPLATE_ID QUERY_TEMPLATE_ID
, QUERY_CONDITION_ID QUERY_CONDITION_ID
, TOKEN_TYPE TOKEN_TYPE
, TOKEN_SEQUENCE TOKEN_SEQUENCE
, AVAILABLE_LOV_ID AVAILABLE_LOV_ID
, VALUE_TYPE VALUE_TYPE
, NON_VARIANT_VALUE NON_VARIANT_VALUE
, QUERY_ALIAS_ID QUERY_ALIAS_ID
, DATA_TYPE DATA_TYPE
, EXP_LOGIC_SEQ EXP_LOGIC_SEQ
, EXP_DISPLAY_SEQ EXP_DISPLAY_SEQ
, 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
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_QUERY_COND_DISP_STRUCT_ALL"