eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSY_KPI_PKG dependencies on CS_INCIDENTS_ALL_B

Line 252: cs_incidents_all_b sr

248: cursor c_backlog is
249: select nvl(aud_out.incident_owner_id,-1), nvl(aud_out.group_id,-1),
250: nvl(aud_out.incident_severity_id,-1), count(*)
251: from cs_incidents_audit_b aud_out,
252: cs_incidents_all_b sr
253: where aud_out.incident_resolved_date is null
254: and aud_out.incident_id = sr.incident_id
255: and nvl(sr.incident_resolved_date,sysdate+1000) > l_dt
256: and incident_audit_id =

Line 387: cs_incidents_all_b sr

383: count(decode(sign(sr.incident_resolved_date-
384: sr.expected_resolution_date),
385: 1,1,null)) resl_sla_missed
386: from cs_incidents_audit_b aud, --this is audit rec for response
387: cs_incidents_all_b sr
388: where sr.incident_id = aud.incident_id
389: and (aud.incident_owner_id is not null or
390: aud.group_id is not null)
391: and aud.incident_audit_id =

Line 424: cs_incidents_all_b sr

420: from cs_incidents_audit_b curr_resp,
421: --this is audit rec for response in curr run dates
422: cs_incidents_audit_b prev_resp,
423: -- this is response in before curr run dates
424: cs_incidents_all_b sr
425: where sr.incident_id = prev_resp.incident_id
426: and curr_resp.incident_audit_id =
427: ( select max(incident_audit_id)
428: from cs_incidents_audit_b aud_in

Line 516: cs_incidents_all_b sr -- only for incident_date */

512: cs_incidents_audit_b from_dttm, -- from date time
513: cs_incident_Statuses_b to_stat
514: /* the pair of from_dttm to to_dttm will give the durating in which an agent
515: owned a serveice request.
516: cs_incidents_all_b sr -- only for incident_date */
517: where aud.incident_audit_id =
518: ( select max(incident_audit_id)
519: from cs_incidents_audit_b aud_in
520: where aud_in.incident_id = aud.incident_id

Line 618: cs_incidents_all_b sr -- only for incident_date */

614: cs_incidents_audit_b from_dttm, -- from date time
615: cs_incident_statuses_b to_Stat
616: /* the pair of from_dttm to to_dttm will give the durating in which an agent
617: owned a serveice request.
618: cs_incidents_all_b sr -- only for incident_date */
619: where aud.incident_audit_id =
620: ( select max(incident_audit_id)
621: from cs_incidents_audit_b aud_in
622: where aud_in.incident_id = curr_resp.incident_id

Line 683: l_owner_id cs_incidents_all_b.incident_owner_id % type;

679: aud.group_id,
680: aud.incident_severity_id,
681: trunc(aud.incident_resolved_date)
682: ;
683: l_owner_id cs_incidents_all_b.incident_owner_id % type;
684: l_sev_id cs_incidents_all_b.incident_severity_id % type;
685: l_group_id cs_incidents_all_b.owner_group_id % type;
686: l_summ_dt cs_incidents_all_b.close_date % type;
687: l_resl_time number;

Line 684: l_sev_id cs_incidents_all_b.incident_severity_id % type;

680: aud.incident_severity_id,
681: trunc(aud.incident_resolved_date)
682: ;
683: l_owner_id cs_incidents_all_b.incident_owner_id % type;
684: l_sev_id cs_incidents_all_b.incident_severity_id % type;
685: l_group_id cs_incidents_all_b.owner_group_id % type;
686: l_summ_dt cs_incidents_all_b.close_date % type;
687: l_resl_time number;
688: l_no_of_resp number;

Line 685: l_group_id cs_incidents_all_b.owner_group_id % type;

681: trunc(aud.incident_resolved_date)
682: ;
683: l_owner_id cs_incidents_all_b.incident_owner_id % type;
684: l_sev_id cs_incidents_all_b.incident_severity_id % type;
685: l_group_id cs_incidents_all_b.owner_group_id % type;
686: l_summ_dt cs_incidents_all_b.close_date % type;
687: l_resl_time number;
688: l_no_of_resp number;
689: l_wait_on_support number;

Line 686: l_summ_dt cs_incidents_all_b.close_date % type;

682: ;
683: l_owner_id cs_incidents_all_b.incident_owner_id % type;
684: l_sev_id cs_incidents_all_b.incident_severity_id % type;
685: l_group_id cs_incidents_all_b.owner_group_id % type;
686: l_summ_dt cs_incidents_all_b.close_date % type;
687: l_resl_time number;
688: l_no_of_resp number;
689: l_wait_on_support number;
690: l_wait_on_customer number;

Line 846: l_owner_id cs_incidents_all_b.incident_owner_id % type;

842: ) as
843: Type Resolution_cursor_type is ref cursor;
844: c_first_resolutions Resolution_cursor_type;
845: l_dt date ;
846: l_owner_id cs_incidents_all_b.incident_owner_id % type;
847: l_sev_id cs_incidents_all_b.incident_severity_id % type;
848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;

Line 847: l_sev_id cs_incidents_all_b.incident_severity_id % type;

843: Type Resolution_cursor_type is ref cursor;
844: c_first_resolutions Resolution_cursor_type;
845: l_dt date ;
846: l_owner_id cs_incidents_all_b.incident_owner_id % type;
847: l_sev_id cs_incidents_all_b.incident_severity_id % type;
848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;
851: l_prob_code cs_incidents_all_b.problem_code % type;

Line 848: l_resol_dt cs_incidents_all_b.incident_date % type;

844: c_first_resolutions Resolution_cursor_type;
845: l_dt date ;
846: l_owner_id cs_incidents_all_b.incident_owner_id % type;
847: l_sev_id cs_incidents_all_b.incident_severity_id % type;
848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;
851: l_prob_code cs_incidents_all_b.problem_code % type;
852: l_resol_code cs_incidents_all_b.resolution_code % type;

Line 849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;

845: l_dt date ;
846: l_owner_id cs_incidents_all_b.incident_owner_id % type;
847: l_sev_id cs_incidents_all_b.incident_severity_id % type;
848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;
851: l_prob_code cs_incidents_all_b.problem_code % type;
852: l_resol_code cs_incidents_all_b.resolution_code % type;
853: l_sr_resolved number;

Line 850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;

846: l_owner_id cs_incidents_all_b.incident_owner_id % type;
847: l_sev_id cs_incidents_all_b.incident_severity_id % type;
848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;
851: l_prob_code cs_incidents_all_b.problem_code % type;
852: l_resol_code cs_incidents_all_b.resolution_code % type;
853: l_sr_resolved number;
854: l_sr_reopen number;

Line 851: l_prob_code cs_incidents_all_b.problem_code % type;

847: l_sev_id cs_incidents_all_b.incident_severity_id % type;
848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;
851: l_prob_code cs_incidents_all_b.problem_code % type;
852: l_resol_code cs_incidents_all_b.resolution_code % type;
853: l_sr_resolved number;
854: l_sr_reopen number;
855: l_sr_reopen2 number;

Line 852: l_resol_code cs_incidents_all_b.resolution_code % type;

848: l_resol_dt cs_incidents_all_b.incident_date % type;
849: l_inv_item_id cs_incidents_all_b.inventory_item_id % type;
850: l_inv_org_id cs_incidents_all_b.inv_organization_id % type;
851: l_prob_code cs_incidents_all_b.problem_code % type;
852: l_resol_code cs_incidents_all_b.resolution_code % type;
853: l_sr_resolved number;
854: l_sr_reopen number;
855: l_sr_reopen2 number;
856: begin

Line 968: cs_incidents_all_b sr

964: count(first_rslvd.incident_id) sr_resolved ,
965: 0 sr_reopened,
966: 0 sr_reopened2
967: from cs_incidents_audit_b first_rslvd,
968: cs_incidents_all_b sr
969: where sr.incident_id = first_rslvd.incident_id
970: and first_rslvd.incident_owner_id is not null
971: -- so that only those rec are selected where resolution date is
972: -- set from null to NOT NULL

Line 1032: cs_incidents_all_b sr

1028: 1 from prev_unrsltns
1029: it will return 1 only if there are atleast 2 old close dates */
1030: from cs_incidents_audit_b last_unrslvd,
1031: cs_incidents_audit_b prev_unrsltns,
1032: cs_incidents_all_b sr
1033: where sr.incident_id = last_unrslvd.incident_id
1034: and last_unrslvd.incident_owner_id is not null
1035: and last_unrslvd.old_incident_resolved_date is not null
1036: and last_unrslvd.incident_resolved_date is null

Line 1103: cs_incidents_all_b sr

1099: cs_incidents_audit_b prev_unrsltns,
1100: /* this indicates if a sr is reworked*/
1101: cs_incidents_audit_b prev_unrsltns1,
1102: /* this table indicates if a sr is reworked more than once*/
1103: cs_incidents_all_b sr
1104: where sr.incident_id = prev_unrsltns.incident_id
1105: and curr_unrslvd.incident_owner_id is not null
1106: and curr_unrslvd.old_incident_resolved_date is not null
1107: and curr_unrslvd.incident_resolved_date is null

Line 1194: l_incident_owner_id cs_incidents_all_b.incident_owner_id % type;

1190: l_sr_in number;
1191: l_sr_out number;
1192: Type AssignmentCursorType is ref cursor;
1193: c_agent_assignment AssignmentCursorType;
1194: l_incident_owner_id cs_incidents_all_b.incident_owner_id % type;
1195: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
1196: begin
1197: if (p_load_type = 'ADD' ) then
1198: open c_agent_assignment for p_sql using

Line 1195: l_owner_group_id cs_incidents_all_b.owner_group_id % type;

1191: l_sr_out number;
1192: Type AssignmentCursorType is ref cursor;
1193: c_agent_assignment AssignmentCursorType;
1194: l_incident_owner_id cs_incidents_all_b.incident_owner_id % type;
1195: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
1196: begin
1197: if (p_load_type = 'ADD' ) then
1198: open c_agent_assignment for p_sql using
1199: p_from_date, p_to_date,

Line 1848: l_owner_id cs_incidents_all_b.incident_owner_id % type;

1844: aud.group_id,
1845: aud.incident_severity_id,
1846: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date))
1847: ;
1848: l_owner_id cs_incidents_all_b.incident_owner_id % type;
1849: l_sev_id cs_incidents_all_b.incident_severity_id % type;
1850: l_group_id cs_incidents_all_b.owner_group_id % type;
1851: l_summ_dt cs_incidents_all_b.close_date % type;
1852: l_resp_time number;

Line 1849: l_sev_id cs_incidents_all_b.incident_severity_id % type;

1845: aud.incident_severity_id,
1846: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date))
1847: ;
1848: l_owner_id cs_incidents_all_b.incident_owner_id % type;
1849: l_sev_id cs_incidents_all_b.incident_severity_id % type;
1850: l_group_id cs_incidents_all_b.owner_group_id % type;
1851: l_summ_dt cs_incidents_all_b.close_date % type;
1852: l_resp_time number;
1853: l_no_of_resp number;

Line 1850: l_group_id cs_incidents_all_b.owner_group_id % type;

1846: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date))
1847: ;
1848: l_owner_id cs_incidents_all_b.incident_owner_id % type;
1849: l_sev_id cs_incidents_all_b.incident_severity_id % type;
1850: l_group_id cs_incidents_all_b.owner_group_id % type;
1851: l_summ_dt cs_incidents_all_b.close_date % type;
1852: l_resp_time number;
1853: l_no_of_resp number;
1854: l_wait_on_me number;

Line 1851: l_summ_dt cs_incidents_all_b.close_date % type;

1847: ;
1848: l_owner_id cs_incidents_all_b.incident_owner_id % type;
1849: l_sev_id cs_incidents_all_b.incident_severity_id % type;
1850: l_group_id cs_incidents_all_b.owner_group_id % type;
1851: l_summ_dt cs_incidents_all_b.close_date % type;
1852: l_resp_time number;
1853: l_no_of_resp number;
1854: l_wait_on_me number;
1855: l_wait_on_others number;