APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_ANALYZE_TABLES

Line 1895: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);

1891: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics
1892: are upto date when insert into msd_cs_data_ds is done.
1893: */
1894: commit;
1895: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);
1896:
1897: if l_debug = C_YES_FLAG then
1898: debug_out( 'Exiting copy_level_val_stripe ' || to_char(sysdate, 'hh24:mi:ss'));
1899: end if;

Line 2373: MSD_ANALYZE_TABLES.analyze_table(null,7);

2369: --
2370: update_dp_parameters_ds (errbuf, retcode, p_demand_plan_id);
2371:
2372: commit;
2373: MSD_ANALYZE_TABLES.analyze_table(null,7);
2374:
2375: if l_debug = C_YES_FLAG then
2376: debug_out( 'Exiting stripe_demand_plan_stream ' || to_char(sysdate, 'hh24:mi:ss'));
2377: end if;

Line 3102: MSD_ANALYZE_TABLES.analyze_table(null,7);

3098: --
3099: update_dp_parameters_ds (errbuf, retcode, p_demand_plan_id);
3100:
3101: commit;
3102: MSD_ANALYZE_TABLES.analyze_table(null,7);
3103:
3104: END Handle_Fact_data;
3105:
3106: -- Bug 3239820. Insert Level Value Pk of 0 to optimize