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.WF_OAM_METRICS SQL Statements

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

Line: 41


   SELECT count(item_key) into activeCount FROM
               (select /*+ PARALLEL(wf_item_activity_statuses) */
                distinct item_type, item_key from wf_item_activity_statuses
                WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));

Line: 46


   SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';

Line: 48


   SELECT count(item_key) into erroredCount FROM
               (select /*+ PARALLEL(wf_item_activity_statuses) */
                distinct item_type, item_key from wf_item_activity_statuses
                WHERE activity_status = 'ERROR');

Line: 53


   SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';

Line: 55


   update FND_USER_PREFERENCES set preference_value = to_char(activeCount) where preference_name = 'NUM_ACTIVE' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

Line: 57


   update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

Line: 59


   update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

Line: 61


   update FND_USER_PREFERENCES set preference_value = to_char(suspendedCount) where preference_name = 'NUM_SUSPEND' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

Line: 64


  update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerWFItemsGraph' and
              user_name = '-WF_DEFAULT-';

Line: 86


             SELECT /*+ PARALLEL(wf_item_activity_statuses) */
             item_type, count(distinct(item_key)) cnt
             FROM wf_item_activity_statuses
             WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING')
             GROUP BY item_type ORDER BY item_type;

Line: 93


  update wf_item_types set NUM_ACTIVE = 0;

Line: 101


    	update wf_item_types set NUM_ACTIVE = l_cnt(i)
	 where name = l_item_type(i);

Line: 109


  update fnd_user_preferences
	set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
	where preference_name = 'LAST_UPDATE_TIME' and
	      module_name = 'WFManagerActiveWFItems' and
	      user_name = '-WF_DEFAULT-';

Line: 133


		SELECT item_type, count(distinct(item_key)) cnt
		FROM wf_item_activity_statuses
		WHERE activity_status = 'ERROR'
		GROUP BY item_type ORDER BY item_type;

Line: 139


  update wf_item_types set NUM_ERROR = 0;

Line: 148


        update wf_item_types set NUM_ERROR = l_cnt(i)
         where name = l_item_type(i);

Line: 156


  update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerErrorWFItems' and
              user_name = '-WF_DEFAULT-';

Line: 180


                SELECT item_type, count(distinct(item_key)) cnt
                FROM wf_item_activity_statuses
                WHERE activity_status = 'DEFERRED'
                GROUP BY item_type ORDER BY item_type;

Line: 186


  update wf_item_types set NUM_DEFER = 0;

Line: 195


        update wf_item_types set NUM_DEFER = l_cnt(i)
         where name = l_item_type(i);

Line: 203


  update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerDeferWFItems' and
              user_name = '-WF_DEFAULT-';

Line: 227


                SELECT item_type, count(distinct(item_key)) cnt
                FROM wf_item_activity_statuses
                WHERE activity_status = 'SUSPEND'
                GROUP BY item_type ORDER BY item_type;

Line: 233


  update wf_item_types set NUM_SUSPEND = 0;

Line: 242


        update wf_item_types set NUM_SUSPEND = l_cnt(i)
         where name = l_item_type(i);

Line: 250


  update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerSuspendWFItems' and
              user_name = '-WF_DEFAULT-';

Line: 275


        SELECT /*+ PARALLEL(wi) */ wi.item_type, count(wi.item_key) cnt
         FROM wf_items wi
        WHERE wi.end_date IS NOT NULL
        GROUP BY wi.item_type
        order by wi.item_type;

Line: 282


  update wf_item_types set NUM_COMPLETE = 0, NUM_PURGEABLE = 0;

Line: 293


           update wf_item_types set NUM_COMPLETE = l_cnt(i),
			 NUM_PURGEABLE = l_purgeCnt(i)
           where  name = l_item_type(i);

Line: 302


  update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerCompleteWFItems' and
              user_name = '-WF_DEFAULT-';

Line: 358


        update FND_USER_PREFERENCES set preference_value = to_char(readyCount) where preference_name = 'NUM_READY' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line: 360


        update FND_USER_PREFERENCES set preference_value = to_char(waitingCount) where preference_name = 'NUM_WAITING' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line: 362


        update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line: 364


        update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line: 366


        update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line: 368


        update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line: 370


  update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerWFAgentsGraph' and
              user_name = '-WF_DEFAULT-';

Line: 397


		 SELECT distinct(queue_name) as queue_name  FROM wf_agents
		 WHERE queue_name is not null
		 AND queue_name not like '%WF_SMTP_O_1_QUEUE'
	 	 AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

Line: 405


   UPDATE wf_agents
	SET NUM_READY = 0, NUM_WAITING = 0,  NUM_EXPIRED = 0, NUM_UNDELIV = 0,
	    NUM_ERROR = 0, NUM_PROCESS = 0;

Line: 424


	update wf_agents
	      SET  NUM_READY = readyCount, NUM_WAITING = waitingCount,
	           NUM_EXPIRED = expiredCount, NUM_UNDELIV = undeliverableCount,
		   NUM_ERROR = erroredCount, NUM_PROCESS = processedCount
	      WHERE queue_name = agent_row.queue_name and
		    system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

Line: 433


   update fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerWFAgents' and
              user_name = '-WF_DEFAULT-';

Line: 504


        SELECT count(*) into processedCount FROM wf_notifications
        WHERE mail_status = 'SENT' AND status = 'OPEN';

Line: 507


        SELECT count(*) into waitingCount FROM wf_notifications
        WHERE mail_status = 'MAIL';

Line: 510


        UPDATE FND_USER_PREFERENCES
                SET preference_value = to_char(processedCount)
                WHERE preference_name = 'NUM_PROCESSED' and
                user_name='-WF_DEFAULT-' and module_name='WFManagerWFNtfsGraph';

Line: 515


        UPDATE FND_USER_PREFERENCES SET preference_value = to_char(waitingCount)        WHERE preference_name = 'NUM_WAITING' and
         user_name='-WF_DEFAULT-' and module_name='WFManagerWFNtfsGraph';

Line: 519


        UPDATE fnd_user_preferences
        set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
        where preference_name = 'LAST_UPDATE_TIME' and
              module_name = 'WFManagerWFNtfsGraph' and
              user_name = '-WF_DEFAULT-';