APPS.CSF_ALERTS_PUB dependencies on CS_INCIDENTS_ALL_B

Line 2462: cs_incidents_all_b ci_all_b,

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

Line 2526: l_sr_number cs_incidents_all_b.incident_number%type;

2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2523: l_planned_effort varchar2(100);
2524: l_priority jtf_task_priorities_vl.name%type;
2525: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2526: l_sr_number cs_incidents_all_b.incident_number%type;
2527: l_sr_summary cs_incidents_all_b.summary%type;
2528: l_product_nr mtl_system_items_vl.concatenated_segments%type;
2529: l_item_serial cs_customer_products_all.current_serial_number%type;
2530: l_item_description mtl_system_items_vl.description%type;

Line 2527: l_sr_summary cs_incidents_all_b.summary%type;

2523: l_planned_effort varchar2(100);
2524: l_priority jtf_task_priorities_vl.name%type;
2525: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2526: l_sr_number cs_incidents_all_b.incident_number%type;
2527: l_sr_summary cs_incidents_all_b.summary%type;
2528: l_product_nr mtl_system_items_vl.concatenated_segments%type;
2529: l_item_serial cs_customer_products_all.current_serial_number%type;
2530: l_item_description mtl_system_items_vl.description%type;
2531: l_cust_name hz_parties.party_name%type;