[Home] [Help]
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
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;
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;
2562: jtf_task_assignments jta,
2563: jtf_tasks_vl j_vl,
2564: jtf_task_priorities_vl jp_vl,
2565: jtf_task_statuses_vl js_vl,
2566: cs_incidents_all c_b,
2567: hz_party_sites hps,
2568: hz_parties hp,
2569: mtl_system_items_vl msi_b,
2570: cs_customer_products_all ccp_all,
2607: FROM
2608: jtf_tasks_b jtb,
2609: jtf_tasks_vl j_vl,
2610: jtf_task_priorities_vl jp_vl,
2611: cs_incidents_all c_b,
2612: hz_party_sites hps,
2613: hz_parties hp,
2614: mtl_system_items_vl msi_b,
2615: cs_customer_products_all ccp_all,
2653: jtf_tasks_b jtb,
2654: jtf_task_audits_b jtab,
2655: jtf_tasks_vl j_vl,
2656: jtf_task_priorities_vl jp_vl,
2657: cs_incidents_all c_b,
2658: hz_party_sites hps,
2659: hz_parties hp,
2660: mtl_system_items_vl msi_b,
2661: cs_customer_products_all ccp_all,