VIEW: APPS.AST_PLIST_PERS_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.col250 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.PERSON_FIRST_NAME, PARTY.PERSON_LAST_NAME, PARTY.PERSON_FIRST_NAME || ' ' || PARTY.PERSON_MIDDLE_NAME || ' ' || PARTY.PERSON_LAST_NAME FULL_NAME, PARTY.PARTY_NAME CUSTOMER_NAME, party.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, PARTY.EMAIL_ADDRESS, ale.col250 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, ale.col250 customer_id, null JOB_TITLE, location.LOCATION_ID, contact_pHONES.CONTACT_POINT_ID FROM ams_list_headers_all alh, ams_list_entries ale, HZ_PARTIES PARTY, 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 PARTY.PARTY_ID = ale.col250 and CONTACT_PHONES.OWNER_TABLE_NAME (+) = 'HZ_PARTIES' AND CONTACT_PHONES.OWNER_TABLE_ID (+) = ale.col250 AND CONTACT_PHONES.PRIMARY_FLAG (+) = 'Y' AND CONTACT_PHONES.CONTACT_POINT_TYPE (+) = 'PHONE' AND PARTY.PARTY_ID = SITES.PARTY_ID (+) and LOCATION.LOCATION_ID (+) = SITES.LOCATION_ID and SITES.IDENTIFYING_ADDRESS_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.COL250 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.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_FIRST_NAME || ' ' || PARTY.PERSON_MIDDLE_NAME || ' ' || PARTY.PERSON_LAST_NAME FULL_NAME
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY.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
, PARTY.EMAIL_ADDRESS
, ALE.COL250 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
, ALE.COL250 CUSTOMER_ID
, NULL JOB_TITLE
, LOCATION.LOCATION_ID
, CONTACT_PHONES.CONTACT_POINT_ID
FROM AMS_LIST_HEADERS_ALL ALH
, AMS_LIST_ENTRIES ALE
, HZ_PARTIES PARTY
, 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 PARTY.PARTY_ID = ALE.COL250
AND CONTACT_PHONES.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
AND CONTACT_PHONES.OWNER_TABLE_ID (+) = ALE.COL250
AND CONTACT_PHONES.PRIMARY_FLAG (+) = 'Y'
AND CONTACT_PHONES.CONTACT_POINT_TYPE (+) = 'PHONE'
AND PARTY.PARTY_ID = SITES.PARTY_ID (+)
AND LOCATION.LOCATION_ID (+) = SITES.LOCATION_ID
AND SITES.IDENTIFYING_ADDRESS_FLAG (+) = 'Y'