APPS.MSDWF dependencies on MSD_ORGANIZATION_DEFINITIONS

Line 867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code

863: from msd_demand_plans_v
864: where demand_plan_name=PlanName;
865:
866: -- Get organiztion code and instance
867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
868: INTO orgcode, instcode
869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

Line 869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v

865:
866: -- Get organiztion code and instance
867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
868: INTO orgcode, instcode
869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
872:
873: numDaysToCol := to_number(NumDays_to_collect);

Line 871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
868: INTO orgcode, instcode
869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
872:
873: numDaysToCol := to_number(NumDays_to_collect);
874: -- Set item key
875: org := orgcode || ':' || instcode;