APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PLAN_ORG_SNAPSHOTS

Line 26: g_small_snapshots TableList := TableList('ISC_DBI_PLAN_ORG_SNAPSHOTS', 'ISC_DBI_PLAN_SNAPSHOTS');

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');
27: g_large_snapshots TableList := TableList('ISC_DBI_SUPPLIES_SNAPSHOTS','ISC_DBI_INV_DETAIL_SNAPSHOTS',
28: 'ISC_DBI_RES_SUM_SNAPSHOTS', 'ISC_DBI_SHORTFALL_SNAPSHOTS');
29:
30: FUNCTION DROP_PLANS(p_plan_id NUMBER) RETURN NUMBER IS

Line 1603: -- Collect ISC_DBI_PLAN_ORG_SNAPSHOTS

1599: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_snapshots in');
1600: -- COMMIT;
1601:
1602: -- ----------------------------------
1603: -- Collect ISC_DBI_PLAN_ORG_SNAPSHOTS
1604: -- ----------------------------------
1605:
1606: BIS_COLLECTION_UTILITIES.put_line(' ');
1607: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_plan_org_snapshots.');

Line 1607: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_plan_org_snapshots.');

1603: -- Collect ISC_DBI_PLAN_ORG_SNAPSHOTS
1604: -- ----------------------------------
1605:
1606: BIS_COLLECTION_UTILITIES.put_line(' ');
1607: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_plan_org_snapshots.');
1608: FII_UTIL.Start_Timer;
1609:
1610: INSERT
1611: INTO isc_dbi_plan_org_snapshots(

Line 1611: INTO isc_dbi_plan_org_snapshots(

1607: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_plan_org_snapshots.');
1608: FII_UTIL.Start_Timer;
1609:
1610: INSERT
1611: INTO isc_dbi_plan_org_snapshots(
1612: SNAPSHOT_ID,
1613: ORGANIZATION_ID)
1614: SELECT tmp.snapshot_id, ipo.organization_id
1615: FROM isc_dbi_tmp_plans tmp,