View: AST_MLIST_UWQ_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_MLIST_UWQ_V

View Text

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 ASOU.SOURCE_CODE_FOR_ID = ALE.SOURCE_CODE_FOR_ID
AND ALE.OUTCOME_ID IS NULL
AND ALE.ENABLED_FLAG = 'Y'

Columns