View: WSH_PRIMARY_CUSTOMER_PHONE_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_PRIMARY_CUSTOMER_PHONE_V

View Text

SELECT DISTINCT CAR.CUST_ACCOUNT_ID CUSTOMER_ID
, CAR.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ADDRESS_ID
, CONT_POINT.PHONE_AREA_CODE AREA_CODE
, DECODE(CONT_POINT.CONTACT_POINT_TYPE
, 'TLX'
, CONT_POINT.TELEX_NUMBER
, CONT_POINT.PHONE_NUMBER) PHONE_NUMBER
FROM HZ_CONTACT_POINTS CONT_POINT
, HZ_CUST_ACCOUNT_ROLES CAR
WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CONT_POINT.CONTACT_POINT_TYPE NOT IN ( 'EDI'
, 'EMAIL'
, 'WEB')
AND CAR.CUST_ACCOUNT_ID /* CUSTOMER_ID */ IS NOT NULL
AND CAR.CUST_ACCT_SITE_ID /* ADDRESS_ID */ IS NOT NULL
AND CAR.CUST_ACCOUNT_ROLE_ID /* CONTACT_ID */ IS NULL
AND NVL(CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.CONTACT_POINT_TYPE) = 'GEN'
AND CONT_POINT.PRIMARY_FLAG = 'Y'

Columns