eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSDWF SQL Statements

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

Line: 36


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

Line: 38


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

Line: 64


	SELECT C0, C1, C2, C3
        into ActRetCode, ActRetText, ActRetVal, ActRetErr
	from THE (SELECT CAST (EPS.query(express_server,
	'DB0='|| CodeLoc || '/ODPCODE\'
	|| 'DBCount=1\'
	|| 'MeasureCount=4\'
	|| 'Measure0=ACTIVITY.FORMULA\'
        || 'Measure1=ACTIVITY.TEXT\'
        || 'Measure2=ACTIVITY.RETVAL\'
        || 'Measure3=ACTIVITY.ERROR\'
	|| 'E0Count=2\'
	|| 'E0Dim0Name=PLACEHOLDER\'
	|| 'E0Dim1Name=ACTIVITY.ENTRY\'
      || 'E0Dim1Script=CALL WF.SETACTIVITY('''|| ActEntry || ''', '''|| PlanID ||''',  '''|| DBName ||''', '''|| SharedLoc ||''',  '''|| DPAdmin ||''',  '''|| thisrole ||''', '''|| ItemKey ||''', '''|| Master ||''', '''|| Process ||''')\'
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL)
	 AS EPS_express_list_t)
	   from DUAL);

Line: 174


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


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

Line: 268


       SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
         WHERE INSTANCE_ID=actid;

Line: 270


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

Line: 307


	SELECT C0, C1, C2
        into ActRetCode, ActRetText, ActRetErr
	from THE (SELECT CAST (EPS.query(express_server,
	'DB0='|| CodeLoc || '/ODPCODE\'
	|| 'DBCount=1\'
	|| 'MeasureCount=3\'
	|| 'Measure0=ACTIVITY.FORMULA\'
        || 'Measure1=ACTIVITY.TEXT\'
        || 'Measure2=ACTIVITY.ERROR\'
	|| 'E0Count=2\'
	|| 'E0Dim0Name=PLACEHOLDER\'
	|| 'E0Dim1Name=ACTIVITY.ENTRY\'
      || 'E0Dim1Script=CALL WF.SETACTIVITY('''|| ActEntry || ''', '''|| PlanID ||''',  '''|| DBName ||''', '''|| SharedLoc ||''',  '''|| DPAdmin ||''',  '''|| thisrole ||''', '''|| ItemKey ||''',  '''|| Master ||''')\'
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL)
	 AS EPS_express_list_t)
	   from DUAL);

Line: 372


       SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
         WHERE INSTANCE_ID=actid;

Line: 374


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

Line: 391


	SELECT C0, C1, C2, C3
        into ActRetCode, ActRetText, ActRetVal, ActRetErr
	from THE (SELECT CAST (EPS.query(express_server,
	'DB0='|| CodeLoc || '/ODPCODE\'
	|| 'DBCount=1\'
	|| 'MeasureCount=4\'
	|| 'Measure0=ACTIVITY.FORMULA\'
      || 'Measure1=ACTIVITY.TEXT\'
      || 'Measure2=ACTIVITY.RETVAL\'
      || 'Measure3=ACTIVITY.ERROR\'
	|| 'E0Count=2\'
	|| 'E0Dim0Name=PLACEHOLDER\'
	|| 'E0Dim1Name=ACTIVITY.ENTRY\'
      || 'E0Dim1Script=CALL WF.SETACTIVITY('''|| ActEntry || ''', '''|| PlanID ||''',  '''|| DBName ||''', '''|| SharedLoc ||''',  '''|| owner ||''',  '''|| thisrole ||''',  '''|| ItemKey ||''',  '''|| Master ||''')\'
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL
	,NULL)
	 AS EPS_express_list_t)
	   from DUAL);

Line: 566


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


procedure Selector(itemtype in varchar2,
		  	 itemkey  in varchar2,
		  	 actid    in number,
		  	 command  in varchar2,
                   resultout   out varchar2)
IS

temp varchar2(100);

Line: 693


   	select user_id into msd_user_id
   	from fnd_user
   	where user_name = g_owner;

Line: 697


   /*	select r.application_id, r.responsibility_id into resp_appl_id, resp_id
     		from fnd_application a, fnd_responsibility r
     		where r.application_id = a.application_id
     		and a.application_short_name = 'MSD'
     		and r.responsibility_key = 'MSD_SYSADMIN';  */

Line: 703


      select count(*) into number_resps
       from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a
       where  r.application_id = a.application_id
       and r.application_id =  urg.responsibility_application_id
       and r.responsibility_id = urg.responsibility_id
       and urg.user_id = msd_user_id
       and a.application_short_name = 'MSD'
       and (r.responsibility_key = 'MSD_SYSADMIN' or
            r.responsibility_key = 'MSD_INTEGADMIN' or
            r.responsibility_key = 'MSD_ADMIN')
       and r.request_group_id <> 0;

Line: 721


            select  r.application_id, r.responsibility_id into resp_appl_id, resp_id
       		from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a
       		where  r.application_id = a.application_id
       		and r.application_id =  urg.responsibility_application_id
       		and r.responsibility_id = urg.responsibility_id
       		and urg.user_id = msd_user_id
       		and a.application_short_name = 'MSD'
       		and (r.responsibility_key = 'MSD_SYSADMIN' or
               	     r.responsibility_key = 'MSD_INTEGADMIN' or
               	     r.responsibility_key = 'MSD_ADMIN')
       		and r.request_group_id <> 0;

Line: 735


            select  r.application_id, r.responsibility_id into resp_appl_id, resp_id
       		from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a
       		where  r.application_id = a.application_id
       		and r.application_id =  urg.responsibility_application_id
       		and r.responsibility_id = urg.responsibility_id
       		and urg.user_id = msd_user_id
       		and a.application_short_name = 'MSD'
       		and r.responsibility_key = resp_key
       		and r.request_group_id <> 0;

Line: 773


end Selector;

Line: 862


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


SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
 INTO orgcode, instcode
 FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
 WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
 msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND  msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;