SELECT DS.DEMAND_PLAN_ID , DP.DEMAND_PLAN_NAME , DS.SCENARIO_ID , DS.SCENARIO_NAME , DP.ORGANIZATION_ID , DP.SR_INSTANCE_ID FROM MSD_DP_SCENARIOS DS , MSD_DEMAND_PLANS DP WHERE DS.DEMAND_PLAN_ID = DP.DEMAND_PLAN_ID AND DS.LAST_REVISION IS NOT NULL AND /* ITEM LEVEL */ EXISTS(SELECT 1 FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL WHERE OL.DEMAND_PLAN_ID = DS.DEMAND_PLAN_ID AND OL.SCENARIO_ID = DS.SCENARIO_ID AND OL.LEVEL_ID = 1) AND /* ORGANIZATION LEVEL */ EXISTS(SELECT 1 FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL WHERE OL.DEMAND_PLAN_ID = DS.DEMAND_PLAN_ID AND OL.SCENARIO_ID = DS.SCENARIO_ID AND OL.LEVEL_ID = 7) AND /* GEOGRAPHY LEVEL */ EXISTS(SELECT 1 FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL WHERE OL.DEMAND_PLAN_ID = DS.DEMAND_PLAN_ID AND OL.SCENARIO_ID = DS.SCENARIO_ID AND OL.LEVEL_ID = 11)