VIEW: APPS.AST_MLIST_SECURE_UWQ_V

Source

View Text - Preformatted

SELECT DISTINCT 'AST_RC_ALL' ieu_object_function, 'PARTY_ID=345 ' ieu_object_parameters, '' ieu_media_type_uuid, 'PARTY' IEU_ACTION_OBJECT_CODE, 'PARTY_ID' ieu_param_pk_col, ale.party_id ieu_param_pk_value, 'RS_INDIVIDUAL' resource_type, csch.schedule_id, csch.schedule_name, csch.status_code status_code, csch.source_code, alh.list_name, alh.list_header_id, alh.list_source_type, alh.list_type, ale.list_entry_id, ale.suffix, ale.first_name, ale.last_name, decode(alh.list_source_type, 'PERSON_LIST', ' ', ale.first_name || ' ' || ale.last_name) FULL_NAME, ale.customer_name, ale.title, ale.city, ale.state, ale.zipcode, ale.country, ale.address_line1 || ' ' || ale.address_line2 || ' ' || ale.city || ' ' || ale.state || ' ' || ale.zipcode || ' ' || ale.country, ale.col5, ale.col6, ale.phone, ale.email_address, ale.party_id, ale.creation_date, ale.last_update_date, ale.marked_as_duplicate_flag, ale.part_of_control_group_flag, asou.SOURCE_CODE_ID, ale.col147, ale.col144, ale.LOCATION_ID, ale.CONTACT_POINT_ID FROM ams_campaign_schedules_vl csch, ams_list_headers_all alh, ams_list_entries ale, ams_act_lists acts, ams_source_codes ASOU WHERE csch.schedule_id = acts.list_used_by_id AND acts.list_used_by = 'CSCH' AND acts.list_act_type = 'TARGET' AND acts.list_header_id = alh.list_header_id AND alh.list_header_id = ale.list_header_id AND asou.source_code = ale.source_code AND ale.outcome_id is null AND ale.enabled_flag = 'Y'

View Text - HTML Formatted

SELECT DISTINCT 'AST_RC_ALL' IEU_OBJECT_FUNCTION
, 'PARTY_ID=345 ' IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'PARTY' IEU_ACTION_OBJECT_CODE
, 'PARTY_ID' IEU_PARAM_PK_COL
, ALE.PARTY_ID IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, CSCH.SCHEDULE_ID
, CSCH.SCHEDULE_NAME
, CSCH.STATUS_CODE STATUS_CODE
, CSCH.SOURCE_CODE
, ALH.LIST_NAME
, ALH.LIST_HEADER_ID
, ALH.LIST_SOURCE_TYPE
, ALH.LIST_TYPE
, ALE.LIST_ENTRY_ID
, ALE.SUFFIX
, ALE.FIRST_NAME
, ALE.LAST_NAME
, DECODE(ALH.LIST_SOURCE_TYPE
, 'PERSON_LIST'
, ' '
, ALE.FIRST_NAME || ' ' || ALE.LAST_NAME) FULL_NAME
, ALE.CUSTOMER_NAME
, ALE.TITLE
, ALE.CITY
, ALE.STATE
, ALE.ZIPCODE
, ALE.COUNTRY
, ALE.ADDRESS_LINE1 || ' ' || ALE.ADDRESS_LINE2 || ' ' || ALE.CITY || ' ' || ALE.STATE || ' ' || ALE.ZIPCODE || ' ' || ALE.COUNTRY
, ALE.COL5
, ALE.COL6
, ALE.PHONE
, ALE.EMAIL_ADDRESS
, ALE.PARTY_ID
, ALE.CREATION_DATE
, ALE.LAST_UPDATE_DATE
, ALE.MARKED_AS_DUPLICATE_FLAG
, ALE.PART_OF_CONTROL_GROUP_FLAG
, ASOU.SOURCE_CODE_ID
, ALE.COL147
, ALE.COL144
, ALE.LOCATION_ID
, ALE.CONTACT_POINT_ID
FROM AMS_CAMPAIGN_SCHEDULES_VL CSCH
, AMS_LIST_HEADERS_ALL ALH
, AMS_LIST_ENTRIES ALE
, AMS_ACT_LISTS ACTS
, AMS_SOURCE_CODES ASOU
WHERE CSCH.SCHEDULE_ID = ACTS.LIST_USED_BY_ID
AND ACTS.LIST_USED_BY = 'CSCH'
AND ACTS.LIST_ACT_TYPE = 'TARGET'
AND ACTS.LIST_HEADER_ID = ALH.LIST_HEADER_ID
AND ALH.LIST_HEADER_ID = ALE.LIST_HEADER_ID
AND ASOU.SOURCE_CODE = ALE.SOURCE_CODE
AND ALE.OUTCOME_ID IS NULL
AND ALE.ENABLED_FLAG = 'Y'