[Home] [Help]
455: , -2) incident_owner_id
456: , case when e.escalated_date <= a.creation_date then 'Y' else 'N' end escalated_flag
457: from
458: cs_incidents_audit_b a
459: , cs_incidents_all_b i
460: , biv_dbi_escalations_stg e
461: where
462: a.incident_id = i.incident_id
463: and a.creation_date >= l_collect_from_date
731: -- After the SR is closed changes made to the SR will not get picked up in the fact until its reopened and re-closed.
732: and (ciab.old_status_flag ='O' or ciab.old_status_flag is null) /* using status_flag instead of old_closed_date as a workaround for bad data */
733: group by ciab.incident_id
734: ) a,
735: cs_incidents_all_b i
736: where i.incident_id = a.a_incident_id
737: and i.status_flag = 'C'
738: ) r
739: , biv_dbi_escalations_stg e
1245: , i.incident_urgency_id
1246: , decode(i.resource_type, 'RS_EMPLOYEE', nvl(i.incident_owner_id, -2)
1247: , -2) incident_owner_id
1248: from
1249: cs_incidents_all_b i
1250: where
1251: i.incident_date < l_collect_from_date
1252: -- modified - this is not logical, unless it's 'O' it will be ingored anyway!
1253: and i.status_flag = 'O'
1256: where
1257: first_for_incident = 'Y'
1258: and status_flag = 'O'
1259: ) a
1260: , cs_incidents_all_b i
1261: , ( select /*+ parallel(stg) */ * from biv_dbi_escalations_stg stg
1262: where de_escalated_same_day = 'N'
1263: ) e
1264: where
1572: removed the where clause in 8.0 so that the latest attibutes are picked into the Resolution fact until the SR is closed.
1573: After the SR is closed changes made to the SR will not get picked up in the fact until its reopened and re-resolved.*/
1574: group by ciab.incident_id
1575: ) a,
1576: cs_incidents_all_b i
1577: where i.incident_id = a.a_incident_id (+)
1578: ) r
1579: , biv_dbi_escalations_stg e
1580: where