VIEW: APPS.AST_MLIST_UWQ_V

Source

View Text - Preformatted

SELECT 'AST_RC_ALL' IEU_OBJECT_FUNCTION, 'PARTY_ID=&ID ' 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, 1 RESOURCE_ID, 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 'AST_RC_ALL' IEU_OBJECT_FUNCTION
, 'PARTY_ID=&ID ' 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
, 1 RESOURCE_ID
, 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'