APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_DIMENSIONS_V

Line 128: FROM msd_dp_dimensions_v

124: CURSOR get_dim (p_demand_plan_id NUMBER,
125: p_dp_dimension_code VARCHAR2,
126: p_dimension_code VARCHAR2) IS
127: SELECT dimension_code
128: FROM msd_dp_dimensions_v
129: WHERE demand_plan_id = p_demand_plan_id
130: AND dp_dimension_code = p_dp_dimension_code
131: AND dimension_code = p_dimension_code;
132:

Line 138: FROM msd_dp_dimensions_v

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

Line 148: FROM msd_dp_dimensions_v

144: CURSOR chk_coll_dim (p_demand_plan_id number) IS
145: SELECT COUNT(1)
146: FROM (
147: SELECT dp_dimension_code, count(1)
148: FROM msd_dp_dimensions_v
149: WHERE demand_plan_id = p_demand_plan_id
150: GROUP BY dp_dimension_code
151: HAVING COUNT(1) > 1);
152:

Line 158: FROM msd_dp_dimensions_v mddv

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

Line 174: FROM msd_dp_dimensions_v pd

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

Line 187: FROM msd_dp_dimensions_v pd

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

Line 200: FROM msd_dp_dimensions_v dd1

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

Line 204: from msd_dp_dimensions_v dd2

200: FROM msd_dp_dimensions_v dd1
201: WHERE demand_plan_id = p_demand_plan_id
202: AND NOT EXISTS
203: (select 1
204: from msd_dp_dimensions_v dd2
205: where dd2.demand_plan_id = p_demand_plan_id
206: and dd1.dp_dimension_code = dd2.dimension_code
207: and dd1.dp_dimension_code = dd2.dp_dimension_code
208: );

Line 437: msd_dp_dimensions_v mdd

433: mdp.revision
434: FROM msd_cs_defn_dim_dtls mcdd,
435: msd_dp_parameters mdp,
436: msd_cs_definitions mcd,
437: msd_dp_dimensions_v mdd
438: WHERE mdp.demand_plan_id = p_demand_plan_id
439: AND mdd.demand_plan_id = p_demand_plan_id
440: AND mdd.dimension_code = mcdd.dimension_code
441: AND mcdd.cs_definition_id = mcd.cs_definition_id