APPS.CSF_ALERTS_PUB dependencies on CS_HZ_SR_CONTACT_POINTS_V

Line 2473: cs_hz_sr_contact_points_v chscp,

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

Line 2581: cs_hz_sr_contact_points_v chscp

2577: hz_party_sites hps,
2578: hz_parties hp,
2579: mtl_system_items_vl msi_b,
2580: cs_customer_products_all ccp_all,
2581: cs_hz_sr_contact_points_v chscp
2582: WHERE
2583: jta.task_assignment_id = v_task_assgn_id
2584: and jta.task_id = jtb.task_id
2585: and j_vl.task_id = jta.task_id

Line 2626: cs_hz_sr_contact_points_v chscp

2622: hz_party_sites hps,
2623: hz_parties hp,
2624: mtl_system_items_vl msi_b,
2625: cs_customer_products_all ccp_all,
2626: cs_hz_sr_contact_points_v chscp
2627: WHERE
2628: jtb.task_id = v_task_id
2629: and j_vl.task_id = jtb.task_id
2630: and jp_vl.task_priority_id (+) = j_vl.task_priority_id

Line 2672: cs_hz_sr_contact_points_v chscp

2668: hz_party_sites hps,
2669: hz_parties hp,
2670: mtl_system_items_vl msi_b,
2671: cs_customer_products_all ccp_all,
2672: cs_hz_sr_contact_points_v chscp
2673: WHERE
2674: jtb.task_id = v_task_id
2675: and jtab.task_audit_id = v_task_audit_id
2676: and jtab.task_id = jtb.task_id