Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CST.PARTY_NAME
, CST.PARTY_ID
, CPT.CONTACT_POINT_ID
, NULL PARTY_SITE_ID
, NULL PARTY_SITE_NUMBER
, CST.PARTY_NUMBER
, CST.PARTY_TYPE
, CST.COMPETITOR_FLAG
, CST.CUSTOMER_KEY
, CST.CATEGORY_CODE
, CST.STATUS
, CST.EMAIL_ADDRESS
, CST.PERSON_FIRST_NAME
, CST.PERSON_LAST_NAME
, CST.PERSON_FIRST_NAME || ' ' || CST.PERSON_LAST_NAME FULL_NAME
, NULL ADDRESS_KEY
, NULL LOCATION_ID
, CST.ADDRESS1
, CST.ADDRESS2
, CST.ADDRESS3
, CST.ADDRESS4
, CST.CITY
, CST.STATE
, CST.PROVINCE
, CST.COUNTY
, CST.POSTAL_CODE
, CST.COUNTRY
, CPT.CONTACT_POINT_TYPE
, CPT.TELEPHONE_TYPE
, CPT.PHONE_LINE_TYPE
, CPT.PHONE_COUNTRY_CODE
, CPT.PHONE_AREA_CODE
, CPT.PHONE_NUMBER
, CPT.PHONE_EXTENSION
, NVL(CPT.PHONE_COUNTRY_CODE
, ' ') ||'-'|| NVL(CPT.PHONE_AREA_CODE
, ' ') ||'-'|| CPT.PHONE_NUMBER||' '|| CPT.PHONE_EXTENSION FULL_PHONE_NUMBER
FROM HZ_PARTIES CST
, HZ_CONTACT_POINTS CPT
WHERE CST.PARTY_TYPE = 'PERSON'
AND CST.STATUS = 'A'
AND CPT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CPT.OWNER_TABLE_ID(+) = CST.PARTY_ID
AND CPT.CONTACT_POINT_TYPE(+) = 'PHONE'
AND CPT.STATUS(+) = 'A'