APPS.MSD_ASCP_FLOW dependencies on MSD_ANALYZE_TABLES

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

78:
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: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);
83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',null);
84: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PERCENTAGES',null);
85:
86: /* Populate denormalized msd_planning_percentage table and

Line 83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',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: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);
83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_REVISIONS',null);
84: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PERCENTAGES',null);
85:
86: /* Populate denormalized msd_planning_percentage table and
87: msd_dp_ascp_scn_entries tables */

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

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

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

537: MSD_DP_PLANNING_PCT_DENORM after populating them to update statistics
538: */
539: commit;
540:
541: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);
542: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);
543:
544:
545: EXCEPTION

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

538: */
539: commit;
540:
541: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCN_ENTRIES_DENORM',null);
542: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_PLANNING_PCT_DENORM',null);
543:
544:
545: EXCEPTION
546: WHEN OTHERS THEN