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: commit;
83: MSD_ANALYZE_TABLES.analyze_table('MSD_DP_SCENARIO_ENTRIES',null);

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

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

Line 471: 'msd_dp_scenario_entries mdse ' ||

467: 'mdse.demand_class), ' ||
468: 'mdse.demand_class), ' ||
469: '''-100'') DEMAND_CLASS ' ||
470: 'from msd_dp_scenarios mds, ' ||
471: 'msd_dp_scenario_entries mdse ' ||
472: 'WHERE mds.demand_plan_id = ' || p_demand_plan_id || ' ' ||
473: 'AND mds.scenario_id ' || x_dmd_pri_scenario_id_list ||
474: 'AND mds.demand_plan_id = mdse.demand_plan_id ' ||
475: 'AND mds.scenario_id = mdse.scenario_id ' ||