This View retrieves the phone numbers for a party based on the contact
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT CONTACT_POINT_ID , PHONE_COUNTRY_CODE , PHONE_AREA_CODE , PHONE_NUMBER , PHONE_EXTENSION , OWNER_TABLE_ID FROM HZ_CONTACT_POINTS WHERE STATUS = 'A' AND DO_NOT_USE_FLAG = 'N' AND OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONTACT_POINT_TYPE = 'PHONE' AND PHONE_LINE_TYPE = 'GEN'