DBA Data[Home] [Help]

APPS.CSY_KPI_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 551: cs_incident_Statuses_b to_stat

547: ) * 1440 wait_on_agent
548: from cs_incidents_audit_b aud , --this is audit rec for response
549: cs_incidents_audit_b to_dttm , -- to date time
550: cs_incidents_audit_b from_dttm, -- from date time
551: cs_incident_Statuses_b to_stat
552: /* the pair of from_dttm to to_dttm will give the durating in which an agent
553: owned a serveice request.
554: cs_incidents_all_b sr -- only for incident_date */
555: where aud.incident_audit_id =

Line 653: cs_incident_statuses_b to_Stat

649: from cs_incidents_audit_b curr_resp,
650: cs_incidents_audit_b aud , --this is audit rec for prior resolutions
651: cs_incidents_audit_b to_dttm , -- to date time
652: cs_incidents_audit_b from_dttm, -- from date time
653: cs_incident_statuses_b to_Stat
654: /* the pair of from_dttm to to_dttm will give the durating in which an agent
655: owned a serveice request.
656: cs_incidents_all_b sr -- only for incident_date */
657: where aud.incident_audit_id =