APPS.CSY_KPI_PKG dependencies on CSY_RESOLUTION_QLTY

Line 921: update csy_resolution_qlty

917: l_sr_resolved,
918: l_sr_reopen,
919: l_sr_reopen2;
920: if c_first_resolutions%notfound then exit; end if;
921: update csy_resolution_qlty
922: set total_sr_resolved_1st_time = nvl(total_sr_resolved_1st_time,0) +
923: l_sr_resolved,
924: total_sr_reopened = nvl(total_sr_reopened,0)+l_sr_reopen,
925: tot_sr_reopened_once_or_more = nvl(tot_sr_reopened_once_or_more,0)+

Line 936: insert into csy_resolution_qlty (

932: and inventory_item_id = l_inv_item_id
933: and resolution_code = l_resol_code
934: and problem_code = l_prob_code;
935: if (sql%notfound ) then
936: insert into csy_resolution_qlty (
937: SUMMARY_DATE ,
938: INCIDENT_OWNER_ID ,
939: OWNER_TYPE ,
940: INCIDENT_SEVERITY_ID ,

Line 2240: delete from csy_resolution_qlty;

2236: into l_min_date
2237: from cs_incidents_audit_b;
2238: */
2239: delete from csy_response_resolutions;
2240: delete from csy_resolution_qlty;
2241: commit;
2242: l_min_date := trunc(sysdate) - 370;
2243: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',
2244: to_char(l_min_date,'YYYYMMDD hh24:mi:ss'),

Line 2391: FROM csy_resolution_qlty resl,

2387: incident_severity_id,
2388: SUM(total_sr_resolved_1st_time) total_sr_resolved_1st_time,
2389: SUM(total_sr_reopened) total_sr_reopened,
2390: SUM(tot_sr_reopened_once_or_more) tot_sr_reopened_once_or_more
2391: FROM csy_resolution_qlty resl,
2392: csy_periods_v per
2393: WHERE resl.summary_date BETWEEN per.start_date
2394: AND per.end_date
2395: GROUP BY period_type,