SELECT DISTINCT CAR.CUST_ACCOUNT_ROLE_ID CONTACT_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_ROLE_ID IS NOT NULL AND NVL(CONT_POINT.PHONE_LINE_TYPE , CONT_POINT.CONTACT_POINT_TYPE) = 'GEN' AND CONT_POINT.PRIMARY_FLAG = 'Y'