DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_HIERARCHY_LEVELS_V

Line 229: msd_hierarchy_levels_v hl

225: SELECT DISTINCT dp_dimension_code,
226: hl. hierarchy_name,
227: level_name
228: FROM msd_dp_hierarchies_v dh,
229: msd_hierarchy_levels_v hl
230: WHERE demand_plan_id = p_demand_plan_id
231: AND dp_dimension_code <> 'TIM'
232: AND dh.hierarchy_id = hl.hierarchy_id
233: AND level_id NOT IN