APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_INV_DETAIL_SNAPSHOTS

Line 27: g_large_snapshots TableList := TableList('ISC_DBI_SUPPLIES_SNAPSHOTS','ISC_DBI_INV_DETAIL_SNAPSHOTS',

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
31:

Line 1912: -- Collect ISC_DBI_INV_DETAIL_SNAPSHOTS

1908: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1909: -- COMMIT;
1910:
1911: -- ------------------------------------
1912: -- Collect ISC_DBI_INV_DETAIL_SNAPSHOTS
1913: -- ------------------------------------
1914:
1915: BIS_COLLECTION_UTILITIES.put_line(' ');
1916: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_inv_detail_snapshots.');

Line 1916: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_inv_detail_snapshots.');

1912: -- Collect ISC_DBI_INV_DETAIL_SNAPSHOTS
1913: -- ------------------------------------
1914:
1915: BIS_COLLECTION_UTILITIES.put_line(' ');
1916: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_inv_detail_snapshots.');
1917: FII_UTIL.Start_Timer;
1918:
1919: -- item level only
1920:

Line 1922: INTO isc_dbi_inv_detail_snapshots f(

1918:
1919: -- item level only
1920:
1921: INSERT /*+ APPEND PARALLEL(F) */
1922: INTO isc_dbi_inv_detail_snapshots f(
1923: SNAPSHOT_ID,
1924: ORGANIZATION_ID,
1925: SR_INVENTORY_ITEM_ID,
1926: START_DATE,

Line 2034: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_inv_detail_snapshots in');

2030: AND bitand(tmp.plan_usage, 2) = 2)
2031: GROUP BY snapshot_id, organization_id, sr_inventory_item_id, start_date, period_type_id, uom_code;
2032:
2033: FII_UTIL.Stop_Timer;
2034: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_inv_detail_snapshots in');
2035: -- COMMIT;
2036:
2037: -- ----------------------------------
2038: -- Collect ISC_DBI_RES_SUM_SNAPSHOTS