APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_LEVEL_VALUES

Line 235: from msd_level_values lv);

231: AND dp_dimension_code <> 'TIM'
232: AND dh.hierarchy_id = hl.hierarchy_id
233: AND level_id NOT IN
234: (select distinct level_id
235: from msd_level_values lv);
236:
237: --
238: -- Validate Time dimensions has values
239: --

Line 3090: from msd_level_values_ds

3086: select to_char(instance_id), to_char(validation_org_id) sr_level_pk
3087: from msc_apps_instances
3088: minus
3089: select instance, sr_level_pk
3090: from msd_level_values_ds
3091: where demand_plan_id = p_demand_plan_id
3092: and level_id = 7;
3093:
3094:

Line 3142: -- msd_level_values_ds geo,

3138: cursor invalid_internal_orgs (p_demand_plan_id number)
3139: is
3140: select mdio.sr_organization_id, mlv.level_value
3141: from msd_dp_iso_organizations mdio,
3142: -- msd_level_values_ds geo,
3143: msd_level_values_ds org,
3144: msd_level_values mlv
3145: where mdio.demand_plan_id = p_demand_plan_id
3146: and mdio.demand_plan_id = org.demand_plan_id

Line 3143: msd_level_values_ds org,

3139: is
3140: select mdio.sr_organization_id, mlv.level_value
3141: from msd_dp_iso_organizations mdio,
3142: -- msd_level_values_ds geo,
3143: msd_level_values_ds org,
3144: msd_level_values mlv
3145: where mdio.demand_plan_id = p_demand_plan_id
3146: and mdio.demand_plan_id = org.demand_plan_id
3147: and mdio.sr_instance_id = org.instance

Line 3144: msd_level_values mlv

3140: select mdio.sr_organization_id, mlv.level_value
3141: from msd_dp_iso_organizations mdio,
3142: -- msd_level_values_ds geo,
3143: msd_level_values_ds org,
3144: msd_level_values mlv
3145: where mdio.demand_plan_id = p_demand_plan_id
3146: and mdio.demand_plan_id = org.demand_plan_id
3147: and mdio.sr_instance_id = org.instance
3148: --and geo.level_id = 15