View: AST_PLIST_REL_UWQ_V

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

View Text

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
, TO_CHAR(REL.PARTY_ID) IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, NULL SCHEDULE_ID
, NULL SCHEDULE_NAME
, NULL STATUS_CODE
, NULL SOURCE_CODE
, ALH.OWNER_USER_ID RESOURCE_ID
, ALH.LIST_NAME
, ALH.LIST_HEADER_ID
, ALH.LIST_SOURCE_TYPE
, ALH.LIST_SOURCE
, ALH.ENABLED_FLAG
, ALH.LIST_TYPE
, ALE.LIST_ENTRY_ID
, NULL SUFFIX
, PARTY_CONTACTS.PERSON_FIRST_NAME
, PARTY_CONTACTS.PERSON_LAST_NAME
, PARTY_CONTACTS.PERSON_FIRST_NAME || ' ' || PARTY_CONTACTS.PERSON_MIDDLE_NAME || ' ' || PARTY_CONTACTS.PERSON_LAST_NAME FULL_NAME
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY_CONTACTS.PERSON_TITLE TITLE
, LOCATION.CITY
, LOCATION.STATE
, LOCATION.POSTAL_CODE ZIPCODE
, LOCATION.COUNTRY
, LOCATION.ADDRESS1 || ' ' || LOCATION.ADDRESS2 || ' ' || LOCATION.CITY || ' ' || LOCATION.STATE || ' ' || LOCATION.POSTAL_CODE || ' ' || LOCATION.COUNTRY LOCATION
, CONTACT_PHONES.PHONE_COUNTRY_CODE || DECODE(CONTACT_PHONES.PHONE_COUNTRY_CODE
, NULL
, ''
, ' ')|| CONTACT_PHONES.PHONE_AREA_CODE || DECODE(CONTACT_PHONES.PHONE_AREA_CODE
, NULL
, ''
, ' ') || CONTACT_PHONES.PHONE_NUMBER || DECODE(CONTACT_PHONES.PHONE_NUMBER
, NULL
, ''
, ' ')|| CONTACT_PHONES.PHONE_EXTENSION PHONE
, REL_PARTY.EMAIL_ADDRESS
, ALE.COL248 PARTY_ID
, ALE.CREATION_DATE
, ALE.LAST_UPDATE_DATE
, ALE.MARKED_AS_DUPLICATE_FLAG
, ALE.PART_OF_CONTROL_GROUP_FLAG
, NULL SOURCE_CODE_FOR_ID
, REL.OBJECT_ID CUSTOMER_ID
, ORG_CONT.JOB_TITLE
, LOCATION.LOCATION_ID
, CONTACT_PHONES.CONTACT_POINT_ID
FROM AMS_LIST_HEADERS_ALL ALH
, AMS_LIST_ENTRIES ALE
, HZ_PARTIES PARTY_CONTACTS
, HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTY
, HZ_PARTIES REL_PARTY
, HZ_ORG_CONTACTS ORG_CONT
, HZ_CONTACT_POINTS CONTACT_PHONES
, HZ_LOCATIONS LOCATION
, HZ_PARTY_SITES SITES
WHERE ALH.LIST_HEADER_ID = ALE.LIST_HEADER_ID
AND ALH.LIST_HEADER_ID +0 = ALE.LIST_HEADER_ID
AND ALE.OUTCOME_ID IS NULL
AND REL.PARTY_ID = ALE.COL248
AND PARTY_CONTACTS.PARTY_ID = REL.SUBJECT_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_TYPE='PERSON'
AND PARTY.PARTY_ID = REL.OBJECT_ID
AND REL.OBJECT_ID = ALE.COL250
AND CONTACT_PHONES.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
AND CONTACT_PHONES.OWNER_TABLE_ID (+) = ALE.COL248
AND CONTACT_PHONES.PRIMARY_FLAG (+) = 'Y'
AND CONTACT_PHONES.CONTACT_POINT_TYPE (+) = 'PHONE'
AND REL_PARTY.PARTY_ID = ALE.COL248
AND ORG_CONT.PARTY_RELATIONSHIP_ID (+) = REL.RELATIONSHIP_ID
AND PARTY.PARTY_ID = SITES.PARTY_ID (+)
AND LOCATION.LOCATION_ID (+) = SITES.LOCATION_ID
AND SITES.IDENTIFYING_ADDRESS_FLAG (+) = 'Y'

Columns