APPS.BIV_DBI_COLLECTION_AGE dependencies on BIV_BAC_AGE_SUM_F

Line 37: if not bis_collection_utilities.setup( 'BIV_BAC_AGE_SUM_F' ) then

33: l_error_tbl bis_utilities_pub.error_tbl_type;
34:
35: begin
36:
37: if not bis_collection_utilities.setup( 'BIV_BAC_AGE_SUM_F' ) then
38: raise g_bis_setup_exception;
39: end if;
40:
41: biv_dbi_collection_util.get_last_log( l_log_rowid

Line 306: , 'BIV_BAC_AGE_SUM_F'

302: bis_collection_utilities.log('truncating Backlog Aging table',1);
303:
304: if biv_dbi_collection_util.truncate_table
305: ( l_biv_schema
306: , 'BIV_BAC_AGE_SUM_F'
307: , l_error_message ) <> 0 then
308: raise l_exception;
309: end if;
310:

Line 314: into biv_bac_age_sum_f f

310:
311: bis_collection_utilities.log('inserting Backlog Aging rows',1);
312:
313: insert /*+ APPEND parallel(f) */
314: into biv_bac_age_sum_f f
315: ( report_date
316: , grp_id
317: , incident_type_id
318: , incident_severity_id

Line 635: , 'BIV_BAC_AGE_SUM_F'

631: --
632: bis_collection_utilities.log('gathering stats on Backlog Aging table',2);
633: if biv_dbi_collection_util.gather_statistics
634: ( l_biv_schema
635: , 'BIV_BAC_AGE_SUM_F'
636: , l_error_message ) <> 0 then
637: raise l_exception;
638: end if;
639: --

Line 644: into biv_bac_age_sum_f f

640:
641: bis_collection_utilities.log('inserting group set rows into Backlog Aging table',2);
642:
643: insert /*+ APPEND parallel(f) */
644: into biv_bac_age_sum_f f
645: ( report_date
646: , grp_id
647: , incident_type_id
648: , incident_severity_id

Line 763: biv_bac_age_sum_f f

759: , incident_urgency_id
760: , incident_owner_id
761: , escalated_flag
762: from
763: biv_bac_age_sum_f f
764: group by
765: report_date
766: , incident_type_id
767: , incident_severity_id