APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_DIMENSIONS_V

Line 132: FROM msd_dp_dimensions_v

128: CURSOR get_dim (p_demand_plan_id NUMBER,
129: p_dp_dimension_code VARCHAR2,
130: p_dimension_code VARCHAR2) IS
131: SELECT dimension_code
132: FROM msd_dp_dimensions_v
133: WHERE demand_plan_id = p_demand_plan_id
134: AND dp_dimension_code = p_dp_dimension_code
135: AND dimension_code = p_dimension_code;
136:

Line 142: FROM msd_dp_dimensions_v

138: -- check there are at least three user dimensions and not more than four.
139: --
140: CURSOR chk_user_dim (p_demand_plan_id number) IS
141: SELECT COUNT(DISTINCT dp_dimension_code)
142: FROM msd_dp_dimensions_v
143: WHERE demand_plan_id = p_demand_plan_id;
144:
145: --
146: -- check there is only one collapsed dimension.

Line 152: FROM msd_dp_dimensions_v

148: CURSOR chk_coll_dim (p_demand_plan_id number) IS
149: SELECT COUNT(1)
150: FROM (
151: SELECT dp_dimension_code, count(1)
152: FROM msd_dp_dimensions_v
153: WHERE demand_plan_id = p_demand_plan_id
154: GROUP BY dp_dimension_code
155: HAVING COUNT(1) > 1);
156:

Line 162: FROM msd_dp_dimensions_v mddv

158: -- check all dimensions are used in the demand plan.
159: --
160: CURSOR chk_used_dim (p_demand_plan_id number) IS
161: SELECT DISTINCT dp_dimension_code
162: FROM msd_dp_dimensions_v mddv
163: WHERE demand_plan_id = p_demand_plan_id
164: and not exists (
165: select 1
166: from msd_cs_definitions mcd, msd_cs_defn_dim_dtls mcdd, msd_dp_parameters mdp

Line 178: FROM msd_dp_dimensions_v pd

174: -- find user dimensions that don't have hierarchies or have invald hierarchies
175: --
176: CURSOR get_usr_dim_with_no_hier (p_demand_plan_id in number) IS
177: SELECT DISTINCT dp_dimension dp_dimension
178: FROM msd_dp_dimensions_v pd
179: WHERE demand_plan_id = p_demand_plan_id
180: AND dp_dimension_code <> 'TIM'
181: AND NOT EXISTS
182: (SELECT hierarchy_id

Line 191: FROM msd_dp_dimensions_v pd

187: -- find dimensions that don't have hierarchies or have invalid hierarchies
188: --
189: CURSOR get_dim_with_no_hier (p_demand_plan_id IN NUMBER) IS
190: SELECT DISTINCT dimension dimension_code
191: FROM msd_dp_dimensions_v pd
192: WHERE demand_plan_id = p_demand_plan_id
193: AND dp_dimension_code <> 'TIM'
194: AND NOT EXISTS
195: (select hierarchy_id

Line 204: FROM msd_dp_dimensions_v dd1

200:
201: -- Find dimension that exist as dp_dimension code but not as dimension.
202: CURSOR get_hier_collaps (p_demand_plan_id NUMBER) IS
203: SELECT DISTINCT dp_dimension
204: FROM msd_dp_dimensions_v dd1
205: WHERE demand_plan_id = p_demand_plan_id
206: AND NOT EXISTS
207: (select 1
208: from msd_dp_dimensions_v dd2

Line 208: from msd_dp_dimensions_v dd2

204: FROM msd_dp_dimensions_v dd1
205: WHERE demand_plan_id = p_demand_plan_id
206: AND NOT EXISTS
207: (select 1
208: from msd_dp_dimensions_v dd2
209: where dd2.demand_plan_id = p_demand_plan_id
210: and dd1.dp_dimension_code = dd2.dimension_code
211: and dd1.dp_dimension_code = dd2.dp_dimension_code
212: );

Line 441: msd_dp_dimensions_v mdd

437: mdp.revision
438: FROM msd_cs_defn_dim_dtls mcdd,
439: msd_dp_parameters mdp,
440: msd_cs_definitions mcd,
441: msd_dp_dimensions_v mdd
442: WHERE mdp.demand_plan_id = p_demand_plan_id
443: AND mdd.demand_plan_id = p_demand_plan_id
444: AND mdd.dimension_code = mcdd.dimension_code
445: AND mcdd.cs_definition_id = mcd.cs_definition_id