APPS.MSD_SOP dependencies on MSD_DEMAND_PLANS_V

Line 26: -- PlanName - A valid plan name from msd_demand_plans_v

22: --
23: -- This program creates process named by ProcessName and
24: -- sets basic attributes for it.
25: -- IN
26: -- PlanName - A valid plan name from msd_demand_plans_v
27: -- NumDays_to_delayDist - Number of days to delay the distribution process
28: -- NumDays_to_collect - Number of days for running collection
29: -- NumDays_to_delayUpld - Number of days to delay the upload process
30: -- OUT

Line 72: from msd_demand_plans_v

68: errbuf := ' ';
69:
70: -- Get needed plan information
71: SELECT demand_plan_id, code_location, shared_db_prefix, shared_db_location, express_connect_string INTO PlanID, CodeLoc, DBName, SharedLoc, express_server
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

Line 78: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v

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

Line 79: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND

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
83: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

Line 80: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id

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:

Line 81: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id

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

Line 83: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

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;
87:

Line 199: -- PlanName - A valid plan name from msd_demand_plans_v

195: -- to run the S&OP Master Process (SOPAUTOMATE)
196: --
197: --
198: -- IN
199: -- PlanName - A valid plan name from msd_demand_plans_v
200: -- NumDays_to_delayDist - Number of days to delay the distribution process
201: -- NumDays_to_collect - Number of days for running collection
202: -- NumDays_to_delayUpld - Number of days to delay the upload process
203: -- OUT