Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PARTY.PARTY_NAME
, CONT_POINT.CONTACT_POINT_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_TYPE
, PARTY.COMPETITOR_FLAG
, PARTY.CUSTOMER_KEY
, PARTY.CATEGORY_CODE
, PARTY.STATUS
, PARTY.SIC_CODE
, PARTY.TAX_REFERENCE
, PARTY.CURR_FY_POTENTIAL_REVENUE CURRENT_FY_REVENUE
, PARTY.FISCAL_YEAREND_MONTH
, CONT_POINT.LAST_UPDATE_DATE
, CONT_POINT.LAST_UPDATED_BY
, CONT_POINT.CREATION_DATE
, CONT_POINT.CREATED_BY
, CONT_POINT.TELEPHONE_TYPE
, CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.LAST_UPDATE_LOGIN
, CONT_POINT.PHONE_COUNTRY_CODE
, CONT_POINT.PHONE_AREA_CODE
, CONT_POINT.PHONE_NUMBER
, CONT_POINT.PHONE_EXTENSION
, NVL(CONT_POINT.PHONE_COUNTRY_CODE
, ' ')||'-'|| NVL(CONT_POINT.PHONE_AREA_CODE
, ' ')||'-'|| CONT_POINT.PHONE_NUMBER||' '|| CONT_POINT.PHONE_EXTENSION FULL_PHONE_NUMBER
, CONT_POINT.CONTACT_POINT_TYPE
, CONT_POINT.PRIMARY_FLAG
, PARTY.EMAIL_ADDRESS
, CONT_POINT.ORIG_SYSTEM_REFERENCE
, CONT_POINT.REQUEST_ID
, CONT_POINT.PROGRAM_APPLICATION_ID
, CONT_POINT.PROGRAM_ID
, CONT_POINT.PROGRAM_UPDATE_DATE
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.PROVINCE
, PARTY.COUNTY
, PARTY.POSTAL_CODE
, PARTY.COUNTRY
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CONT_POINT
WHERE PARTY.PARTY_TYPE = 'ORGANIZATION'
AND PARTY.STATUS = 'A'
AND CONT_POINT.CONTACT_POINT_TYPE(+) = 'PHONE'
AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID