APPS.WF_OAM_METRICS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 42: (select /*+ PARALLEL(wf_item_activity_statuses) */

38:
39: Begin
40:
41: SELECT count(item_key) into activeCount FROM
42: (select /*+ PARALLEL(wf_item_activity_statuses) */
43: distinct item_type, item_key from wf_item_activity_statuses
44: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';

Line 43: distinct item_type, item_key from wf_item_activity_statuses

39: Begin
40:
41: SELECT count(item_key) into activeCount FROM
42: (select /*+ PARALLEL(wf_item_activity_statuses) */
43: distinct item_type, item_key from wf_item_activity_statuses
44: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:

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

42: (select /*+ PARALLEL(wf_item_activity_statuses) */
43: distinct item_type, item_key from wf_item_activity_statuses
44: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
48: SELECT count(item_key) into erroredCount FROM
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses

Line 49: (select /*+ PARALLEL(wf_item_activity_statuses) */

45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
48: SELECT count(item_key) into erroredCount FROM
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';

Line 50: distinct item_type, item_key from wf_item_activity_statuses

46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
48: SELECT count(item_key) into erroredCount FROM
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
54:

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

49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
54:
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';
56:
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 86: SELECT /*+ PARALLEL(wf_item_activity_statuses) */

82: l_item_type dbms_sql.VARCHAR2_table;
83: l_cnt dbms_sql.NUMBER_table;
84:
85: cursor wf_items_cursor is
86: SELECT /*+ PARALLEL(wf_item_activity_statuses) */
87: item_type, count(distinct(item_key)) cnt
88: FROM wf_item_activity_statuses
89: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING')
90: GROUP BY item_type ORDER BY item_type;

Line 88: FROM wf_item_activity_statuses

84:
85: cursor wf_items_cursor is
86: SELECT /*+ PARALLEL(wf_item_activity_statuses) */
87: item_type, count(distinct(item_key)) cnt
88: FROM wf_item_activity_statuses
89: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING')
90: GROUP BY item_type ORDER BY item_type;
91: begin
92:

Line 134: FROM wf_item_activity_statuses

130: l_cnt dbms_sql.NUMBER_table;
131:
132: cursor wf_items_cursor is
133: SELECT item_type, count(distinct(item_key)) cnt
134: FROM wf_item_activity_statuses
135: WHERE activity_status = 'ERROR'
136: GROUP BY item_type ORDER BY item_type;
137: begin
138:

Line 181: FROM wf_item_activity_statuses

177: l_cnt dbms_sql.NUMBER_table;
178:
179: cursor wf_items_cursor is
180: SELECT item_type, count(distinct(item_key)) cnt
181: FROM wf_item_activity_statuses
182: WHERE activity_status = 'DEFERRED'
183: GROUP BY item_type ORDER BY item_type;
184: begin
185:

Line 228: FROM wf_item_activity_statuses

224: l_cnt dbms_sql.NUMBER_table;
225:
226: cursor wf_items_cursor is
227: SELECT item_type, count(distinct(item_key)) cnt
228: FROM wf_item_activity_statuses
229: WHERE activity_status = 'SUSPEND'
230: GROUP BY item_type ORDER BY item_type;
231: begin
232: