145: '(' || cont_point.phone_area_code || ')' ) ||
146: decode(cont_point.contact_point_type,'TLX',
147: cont_point.telex_number, cont_point.phone_number)
148: from
149: hz_contact_points cont_point,
150: hz_cust_account_roles car
151: where
152: car.party_id = cont_point.owner_table_id
153: and cont_point.owner_table_name = 'HZ_PARTIES'
168: '(' || cont_point.phone_area_code || ')' ) ||
169: decode(cont_point.contact_point_type,'TLX',
170: cont_point.telex_number, cont_point.phone_number)
171: from
172: hz_contact_points cont_point,
173: hz_cust_account_roles car
174: where
175: car.party_id = cont_point.owner_table_id
176: and cont_point.owner_table_name = 'HZ_PARTIES'