APPS.MSD_ASCP_FLOW dependencies on MSD_DP_SCENARIO_ENTRIES

Line 79: /* Bug# 5248221 Analyze tables MSD_DP_SCENARIO_ENTRIES, MSD_DP_SCENARIO_REVISIONS and

75: aname => 'ODPPLAN');
76:
77: l_dp_plan_id := to_number(PlanID);
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);

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 245: from msd_dp_scenario_entries

241:
242: begin
243:
244: select quantity into l_priority
245: from msd_dp_scenario_entries
246: where demand_plan_id = p_demand_plan_id
247: and scenario_id = l_dmd_prty_scen_id
248: and decode(time_lvl_id, 9, 1, 1, 2, 3) = p_bucket_type
249: and time_lvl_val_from = p_start_time

Line 461: 'msd_dp_scenario_entries mdse ' ||

457: 'mdse.demand_class), ' ||
458: 'mdse.demand_class), ' ||
459: '''-100'') DEMAND_CLASS ' ||
460: 'from msd_dp_scenarios mds, ' ||
461: 'msd_dp_scenario_entries mdse ' ||
462: 'WHERE mds.demand_plan_id = ' || p_demand_plan_id || ' ' ||
463: 'AND mds.scenario_id ' || x_dmd_pri_scenario_id_list ||
464: 'AND mds.demand_plan_id = mdse.demand_plan_id ' ||
465: 'AND mds.scenario_id = mdse.scenario_id ' ||