72: from msd_demand_plans_v
73: where demand_plan_name=PlanName;
74:
75: -- Get organiztion code and instance
76: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
77: INTO org, instcode
78: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
79: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
80: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
74:
75: -- Get organiztion code and instance
76: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
77: INTO org, instcode
78: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
79: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
80: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
81: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
82: and msc_trading_partners.partner_type = 3
76: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
77: INTO org, instcode
78: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
79: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
80: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
81: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
82: and msc_trading_partners.partner_type = 3
83: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
84:
77: INTO org, instcode
78: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
79: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
80: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
81: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
82: and msc_trading_partners.partner_type = 3
83: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
84:
85: --get MSD code database name
78: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
79: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
80: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
81: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
82: and msc_trading_partners.partner_type = 3
83: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
84:
85: --get MSD code database name
86: select fnd_profile.value('MSD_CODE_AW') into codeDBName from dual;