APPS.BIV_DBI_COLLECTION_INIT dependencies on BIV_DBI_ESCALATIONS_STG

Line 191: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ESCALATIONS_STG');

187: THEN
188:
189: bis_collection_utilities.log('Starting Escalations Staging table population ');
190:
191: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ESCALATIONS_STG');
192:
193: if biv_dbi_collection_util.truncate_table
194: (l_biv_schema, 'BIV_DBI_ESCALATIONS_STG', l_error_message) <> 0 then
195: raise l_exception;

Line 194: (l_biv_schema, 'BIV_DBI_ESCALATIONS_STG', l_error_message) <> 0 then

190:
191: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ESCALATIONS_STG');
192:
193: if biv_dbi_collection_util.truncate_table
194: (l_biv_schema, 'BIV_DBI_ESCALATIONS_STG', l_error_message) <> 0 then
195: raise l_exception;
196: end if;
197:
198: bis_collection_utilities.log('Inserting rows into BIV_DBI_ESCALATIONS_STG');

Line 198: bis_collection_utilities.log('Inserting rows into BIV_DBI_ESCALATIONS_STG');

194: (l_biv_schema, 'BIV_DBI_ESCALATIONS_STG', l_error_message) <> 0 then
195: raise l_exception;
196: end if;
197:
198: bis_collection_utilities.log('Inserting rows into BIV_DBI_ESCALATIONS_STG');
199:
200: insert into biv_dbi_escalations_stg
201: (
202: incident_id,

Line 200: insert into biv_dbi_escalations_stg

196: end if;
197:
198: bis_collection_utilities.log('Inserting rows into BIV_DBI_ESCALATIONS_STG');
199:
200: insert into biv_dbi_escalations_stg
201: (
202: incident_id,
203: escalated_date_from,
204: escalated_date_to,

Line 241: ,tabname => 'BIV_DBI_ESCALATIONS_STG', percent => 10);

237:
238: BEGIN
239:
240: fnd_stats.gather_table_stats(ownname => 'BIV'
241: ,tabname => 'BIV_DBI_ESCALATIONS_STG', percent => 10);
242: END;
243:
244:
245: END IF;

Line 460: , biv_dbi_escalations_stg e

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
464: and a.creation_date+0 <= l_collect_to_date /* change here as workaround to db bug killing parallelism */

Line 739: , biv_dbi_escalations_stg e

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
740: where
741: e.incident_id (+) = r.incident_id
742: and case
743: when r.close_date is null or r.close_date < r.incident_date then

Line 1261: , ( select /*+ parallel(stg) */ * from biv_dbi_escalations_stg stg

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
1265: a.incident_id = i.incident_id

Line 1579: , biv_dbi_escalations_stg e

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
1581: e.incident_id (+) = r.incident_id
1582: and ( incident_resolved_date IS NOT NULL
1583: AND