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.MSC_EXP_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2204: from wf_item_activity_statuses

2200: wf_notifications
2201: set end_date = sysdate
2202: where group_id in
2203: (select notification_id
2204: from wf_item_activity_statuses
2205: where item_type = l_item_type
2206: and item_key = l_item_key
2207: union
2208: select notification_id

Line 2209: from wf_item_activity_statuses_h

2205: where item_type = l_item_type
2206: and item_key = l_item_key
2207: union
2208: select notification_id
2209: from wf_item_activity_statuses_h
2210: where item_type = l_item_type
2211: and item_key = l_item_key);
2212:
2213: update wf_items

Line 2218: update wf_item_activity_statuses

2214: set end_date = sysdate
2215: where item_type = l_item_type
2216: and item_key = l_item_key;
2217:
2218: update wf_item_activity_statuses
2219: set end_date = sysdate
2220: where item_type = l_item_type
2221: and item_key = l_item_key;
2222:

Line 2223: update wf_item_activity_statuses_h

2219: set end_date = sysdate
2220: where item_type = l_item_type
2221: and item_key = l_item_key;
2222:
2223: update wf_item_activity_statuses_h
2224: set end_date = sysdate
2225: where item_type = l_item_type
2226: and item_key = l_item_key;
2227:

Line 3614: from wf_item_activity_statuses

3610: p_item_type varchar2,
3611: p_item_key varchar2) IS
3612: CURSOR status_cur IS
3613: select 1
3614: from wf_item_activity_statuses
3615: where item_type = p_item_type
3616: and item_key = p_item_key
3617: and activity_status = 'DEFERRED';
3618: v_dummy number;