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.BIV_DBI_COLLECTION_INC dependencies on CS_INCIDENTS_ALL_B

Line 432: biv_dbi_backlog_sum_f f, cs_incidents_all_b i

428: , nvl(i.customer_id,-1) /* functionally should not be possible */
429: , nvl(i.sr_creation_channel,'-1') /* functionally should not be possible */
430: , nvl(i.resolution_code,'-1') /* valid, resolution code not specified*/
431: from
432: biv_dbi_backlog_sum_f f, cs_incidents_all_b i
433: where
434: backlog_date_to = l_max_date
435: and i.incident_id = f.incident_id
436:

Line 554: cs_incidents_audit_b a , cs_incidents_all_b i

550: , nvl(i.customer_id,-1) /* functionally should not be possible */
551: , nvl(i.sr_creation_channel,'-1') /* functionally should not be possible */
552: , nvl(i.resolution_code,'-1') /* valid, resolution code not specified*/
553: from
554: cs_incidents_audit_b a , cs_incidents_all_b i
555: where
556: a.creation_date between p_collect_from_date and p_collect_to_date
557: and i.incident_id = a.incident_id
558: and nvl(a.updated_entity_code, 'SR_HEADER') IN ('SR_HEADER','SR_ESCALATION')

Line 1483: ) a, cs_incidents_all_b i,

1479: /* workaround for bad data where old_status_flag can be null.*/
1480: or 'Y' in (reopened_flag))
1481: /* to update those SR's that have been reopened so that they are not displayed in the report. */
1482: group by incident_id
1483: ) a, cs_incidents_all_b i,
1484: (
1485: select trf.object_id, tsk.task_id, trunc(tsk.actual_start_date) escalated_date_from
1486: , trunc(nvl(tsk.actual_end_date,to_date('01-12-4712','DD-MM-YYYY'))) escalated_date_to
1487: , tsk.actual_start_date escalated_date