APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_ANALYZE_TABLES

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

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

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

2363: --
2364: update_dp_parameters_ds (errbuf, retcode, p_demand_plan_id);
2365:
2366: commit;
2367: MSD_ANALYZE_TABLES.analyze_table(null,7);
2368:
2369: if l_debug = C_YES_FLAG then
2370: debug_out( 'Exiting stripe_demand_plan_stream ' || to_char(sysdate, 'hh24:mi:ss'));
2371: end if;

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

3092: --
3093: update_dp_parameters_ds (errbuf, retcode, p_demand_plan_id);
3094:
3095: commit;
3096: MSD_ANALYZE_TABLES.analyze_table(null,7);
3097:
3098: END Handle_Fact_data;
3099:
3100: -- Bug 3239820. Insert Level Value Pk of 0 to optimize