DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on HZ_CONTACT_POINTS

Line 2464: hz_contact_points hcp

2460: hcp.phone_country_code || ' ' || hcp.phone_area_code || ' ' || hcp.phone_number PHONE_NUMBER
2461: FROM
2462: cs_incidents_all_b ci_all_b,
2463: cs_hz_sr_contact_points_v chscp,
2464: hz_contact_points hcp
2465: WHERE
2466: ci_all_b.incident_id = chscp.incident_id
2467: AND chscp.contact_point_id = hcp.contact_point_id
2468: AND chscp.primary_flag = 'Y'