Product: | AMS - Marketing |
---|---|
Description: | This view stores the body of the condition or in other words, has the non-variant information (condition parts that don't change between Admin and End User) in a query condition in Audience Workbench. |
Implementation/DBA Data: | APPS.AMS_QUERY_COND_DISP_STRUCT_VL |
SELECT B.ROWID ROW_ID
, B.QUERY_COND_DISP_STRUCT_ID
, B.QUERY_TEMPLATE_ID
, B.QUERY_CONDITION_ID
, B.TOKEN_TYPE
, B.TOKEN_SEQUENCE
, B.AVAILABLE_LOV_ID
, B.VALUE_TYPE
, B.NON_VARIANT_VALUE
, B.QUERY_ALIAS_ID
, B.DATA_TYPE
, B.EXP_LOGIC_SEQ
, B.EXP_DISPLAY_SEQ
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.REQUEST_ID
, B.PROGRAM_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_UPDATE_DATE
, B.SECURITY_GROUP_ID
, T.DISPLAY_TEXT
FROM AMS_QUERY_COND_DISP_STRUCT_TL T
, AMS_QUERY_COND_DISP_STRUCT_ALL B
WHERE B.QUERY_COND_DISP_STRUCT_ID = T.QUERY_COND_DISP_STRUCT_ID
AND T.LANGUAGE = USERENV('LANG')