DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on HZ_CONTACT_POINTS

Line 2474: hz_contact_points hcp

2470: hcp.phone_country_code || ' ' || hcp.phone_area_code || ' ' || hcp.phone_number PHONE_NUMBER
2471: FROM
2472: cs_incidents_all_b ci_all_b,
2473: cs_hz_sr_contact_points_v chscp,
2474: hz_contact_points hcp
2475: WHERE
2476: ci_all_b.incident_id = chscp.incident_id
2477: AND chscp.contact_point_id = hcp.contact_point_id
2478: AND chscp.primary_flag = 'Y'