APPS.MSD_SOP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 71

SELECT demand_plan_id, code_location, shared_db_prefix, shared_db_location, express_connect_string      INTO PlanID, CodeLoc, DBName, SharedLoc, express_server
from msd_demand_plans_v
where demand_plan_name=PlanName;

Line: 76

SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
 INTO org, instcode
 FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
 WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
 msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
 and msd_demand_plans_v.sr_instance_id  = msc_trading_partners.sr_instance_id
 and msc_trading_partners.partner_type = 3
 AND  msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

Line: 86

select fnd_profile.value('MSD_CODE_AW') into codeDBName from dual;

Line: 351

  select SUPPLY_PLAN_ID,SUPPLY_PLAN_NAME
  from msd_dp_scenarios
  where demand_plan_id = dp_id
  and supply_plan_id is not null;