APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_RES_SUMMARY_F

Line 22: g_large_bases TableList := TableList('ISC_DBI_SUPPLIES_F','ISC_DBI_INV_DETAIL_F','ISC_DBI_RES_SUMMARY_F',

18: g_rebuild_snapshot_index VARCHAR2(1) := 'N';
19:
20: TYPE TableList IS TABLE OF VARCHAR2(80);
21: g_small_bases TableList := TableList('ISC_DBI_PLAN_ORGANIZATIONS', 'ISC_DBI_PLAN_BUCKETS', 'ISC_DBI_PLANS');
22: g_large_bases TableList := TableList('ISC_DBI_SUPPLIES_F','ISC_DBI_INV_DETAIL_F','ISC_DBI_RES_SUMMARY_F',
23: 'ISC_DBI_EXCEPTION_DETAILS_F','ISC_DBI_DEMANDS_F',
24: 'ISC_DBI_FULL_PEGGING_F');
25:
26: g_small_snapshots TableList := TableList('ISC_DBI_PLAN_ORG_SNAPSHOTS', 'ISC_DBI_PLAN_SNAPSHOTS');

Line 468: 'INTO isc_dbi_res_summary_f ( '||

464: 'VALUES(plan_id,organization_id,sr_inventory_item_id,time_detail_date_id,carrying_cost,detail_date,'||
465: 'inventory_cost,mds_cost,mds_price,mds_quantity,production_cost,purchasing_cost,'||
466: 'uom_code,created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
467: 'WHEN union_flag = 6 THEN '||
468: 'INTO isc_dbi_res_summary_f ( '||
469: 'PLAN_ID,ORGANIZATION_ID,DEPARTMENT_ID,RESOURCE_ID,TIME_RESOURCE_DATE_ID,'||
470: 'AVAILABLE_HOURS,ORGANIZATION_TYPE,REQUIRED_HOURS,RESOURCE_DATE,UTILIZATION,'||
471: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
472: 'VALUES(plan_id,organization_id,department_id,resource_id,time_resource_date_id,'||

Line 2068: isc_dbi_res_summary_f ires,

2064: ires.resource_id,
2065: sum(nvl(required_hours,0)/(per.end_date-per.start_date+1)) REQUIRED_HOURS,
2066: sum(nvl(available_hours,0)/(per.end_date-per.start_date+1)) AVAILABLE_HOURS
2067: FROM isc_dbi_tmp_plans tmp,
2068: isc_dbi_res_summary_f ires,
2069: isc_dbi_periods per,
2070: fii_time_day time
2071: WHERE tmp.plan_id = ires.plan_id
2072: AND bitand(tmp.plan_usage, 2) = 2