APPS.CSF_ALERTS_PUB dependencies on CS_HZ_SR_CONTACT_POINTS_V

Line 2463: cs_hz_sr_contact_points_v chscp,

2459: SELECT
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

Line 2571: cs_hz_sr_contact_points_v chscp

2567: hz_party_sites hps,
2568: hz_parties hp,
2569: mtl_system_items_vl msi_b,
2570: cs_customer_products_all ccp_all,
2571: cs_hz_sr_contact_points_v chscp
2572: WHERE
2573: jta.task_assignment_id = v_task_assgn_id
2574: and jta.task_id = jtb.task_id
2575: and j_vl.task_id = jta.task_id

Line 2616: cs_hz_sr_contact_points_v chscp

2612: hz_party_sites hps,
2613: hz_parties hp,
2614: mtl_system_items_vl msi_b,
2615: cs_customer_products_all ccp_all,
2616: cs_hz_sr_contact_points_v chscp
2617: WHERE
2618: jtb.task_id = v_task_id
2619: and j_vl.task_id = jtb.task_id
2620: and jp_vl.task_priority_id (+) = j_vl.task_priority_id

Line 2662: cs_hz_sr_contact_points_v chscp

2658: hz_party_sites hps,
2659: hz_parties hp,
2660: mtl_system_items_vl msi_b,
2661: cs_customer_products_all ccp_all,
2662: cs_hz_sr_contact_points_v chscp
2663: WHERE
2664: jtb.task_id = v_task_id
2665: and jtab.task_audit_id = v_task_audit_id
2666: and jtab.task_id = jtb.task_id