APPS.CSF_ALERTS_PUB dependencies on CS_INCIDENTS_ALL

Line 2472: cs_incidents_all_b ci_all_b,

2468: cursor c_rel_person_phone(v_incident_id number) is
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

Line 2536: l_sr_number cs_incidents_all_b.incident_number%type;

2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2533: l_planned_effort varchar2(100);
2534: l_priority jtf_task_priorities_vl.name%type;
2535: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2536: l_sr_number cs_incidents_all_b.incident_number%type;
2537: l_sr_summary cs_incidents_all_tl.summary%type;
2538: l_product_nr mtl_system_items_vl.concatenated_segments%type;
2539: l_item_serial cs_customer_products_all.current_serial_number%type;
2540: l_item_description mtl_system_items_vl.description%type;

Line 2537: l_sr_summary cs_incidents_all_tl.summary%type;

2533: l_planned_effort varchar2(100);
2534: l_priority jtf_task_priorities_vl.name%type;
2535: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2536: l_sr_number cs_incidents_all_b.incident_number%type;
2537: l_sr_summary cs_incidents_all_tl.summary%type;
2538: l_product_nr mtl_system_items_vl.concatenated_segments%type;
2539: l_item_serial cs_customer_products_all.current_serial_number%type;
2540: l_item_description mtl_system_items_vl.description%type;
2541: l_cust_name hz_parties.party_name%type;

Line 2576: cs_incidents_all c_b,

2572: jtf_task_assignments jta,
2573: jtf_tasks_vl j_vl,
2574: jtf_task_priorities_vl jp_vl,
2575: jtf_task_statuses_vl js_vl,
2576: cs_incidents_all c_b,
2577: hz_party_sites hps,
2578: hz_parties hp,
2579: mtl_system_items_vl msi_b,
2580: cs_customer_products_all ccp_all,

Line 2621: cs_incidents_all c_b,

2617: FROM
2618: jtf_tasks_b jtb,
2619: jtf_tasks_vl j_vl,
2620: jtf_task_priorities_vl jp_vl,
2621: cs_incidents_all c_b,
2622: hz_party_sites hps,
2623: hz_parties hp,
2624: mtl_system_items_vl msi_b,
2625: cs_customer_products_all ccp_all,

Line 2667: cs_incidents_all c_b,

2663: jtf_tasks_b jtb,
2664: jtf_task_audits_b jtab,
2665: jtf_tasks_vl j_vl,
2666: jtf_task_priorities_vl jp_vl,
2667: cs_incidents_all c_b,
2668: hz_party_sites hps,
2669: hz_parties hp,
2670: mtl_system_items_vl msi_b,
2671: cs_customer_products_all ccp_all,