APPS.MSD_ASCP_FLOW dependencies on MSD_ANALYZE_TABLES

Line 83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);

79: /* Bug# 5248221 Analyze tables MSD_DP_SCENARIO_ENTRIES, MSD_DP_SCENARIO_REVISIONS and
80: MSD_DP_PLANNING_PERCENTAGES before populating the denorm tables
81: */
82: commit;
83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);
84: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',null);
85: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PERCENTAGES',null);
86:
87: /* Populate denormalized msd_planning_percentage table and

Line 84: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',null);

80: MSD_DP_PLANNING_PERCENTAGES before populating the denorm tables
81: */
82: commit;
83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);
84: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',null);
85: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PERCENTAGES',null);
86:
87: /* Populate denormalized msd_planning_percentage table and
88: msd_dp_ascp_scn_entries tables */

Line 85: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PERCENTAGES',null);

81: */
82: commit;
83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);
84: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',null);
85: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PERCENTAGES',null);
86:
87: /* Populate denormalized msd_planning_percentage table and
88: msd_dp_ascp_scn_entries tables */
89:

Line 368: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);

364: /* Bug# 10160412 - Commit if number of records deleted are > 1M */
365: IF (sql%rowcount > 1000000)
366: THEN
367: commit;
368: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);
369: END IF;
370:
371:
372: /* Bug# 5181742

Line 511: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);

507: /*Bug# 10160412 - Commit if number of records deleted are > 1M */
508: IF (sql%rowcount > 1000000)
509: THEN
510: commit;
511: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);
512: END IF;
513:
514: x_sql_stmt := 'INSERT INTO msd_dp_planning_pct_denorm( ' ||
515: 'demand_plan_id , ' ||

Line 561: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);

557: MSD_DP_PLANNING_PCT_DENORM after populating them to update statistics
558: */
559: commit;
560:
561: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);
562: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);
563:
564:
565: EXCEPTION

Line 562: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);

558: */
559: commit;
560:
561: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);
562: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);
563:
564:
565: EXCEPTION
566: WHEN OTHERS THEN