DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_HIERARCHY_LEVELS_V

Line 233: msd_hierarchy_levels_v hl

229: SELECT DISTINCT dp_dimension_code,
230: hl. hierarchy_name,
231: level_name
232: FROM msd_dp_hierarchies_v dh,
233: msd_hierarchy_levels_v hl
234: WHERE demand_plan_id = p_demand_plan_id
235: AND dp_dimension_code <> 'TIM'
236: AND dh.hierarchy_id = hl.hierarchy_id
237: AND level_id NOT IN