APPS.MSD_WF SQL Statements

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

Line: 46

       SELECT ACTIVITY_NAME, PROCESS_NAME INTO ActEntry, Process FROM WF_PROCESS_ACTIVITIES
         WHERE INSTANCE_ID=actid;

Line: 48

       SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
          WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';

Line: 161

	   update msd_demand_plans
		    set DP_BUILD_ERROR_FLAG = 'YES'
		    where demand_plan_id = to_number(PlanID);

Line: 204

   SELECT demand_plan_name, code_location, shared_db_prefix,
    shared_db_location, express_connect_string INTO PlName,
    CodeLoc, DBName, SharedLoc, express_server
    from msd_demand_plans_v
    where demand_plan_id=to_number(inPlan);

Line: 283

          select count(value) into FixedDate from v$parameter
              where name like '%fixed_date%' AND length(VALUE) > 0;

Line: 323

       SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
         WHERE INSTANCE_ID=actid;

Line: 325

       SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
          WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';

Line: 400

	   update msd_demand_plans
		    set DP_BUILD_ERROR_FLAG = 'YES'
		    where demand_plan_id = to_number(PlanID);

Line: 435

       SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
         WHERE INSTANCE_ID=actid;

Line: 437

       SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
          WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';

Line: 496

	   update msd_demand_plans
		    set DP_BUILD_ERROR_FLAG = 'YES'
		    where demand_plan_id = to_number(planID);

Line: 581

  select ROOT_ACTIVITY into RootAct
  from WF_ITEMS_V
  where item_type = 'ODPCYCLE' and item_key = itemkey;

Line: 621

    	  select distinct ACTIVITY_STATUS_CODE into status_code
        from wf_item_activity_statuses_v
 	  where  item_type = itemtype
  	  and    item_key  = itemkey
  	  and    ACTIVITY_STATUS_CODE = 'DEFERRED';

Line: 888

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: 893

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: 903

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

Line: 1185

       SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
           WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';