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

Line 418: wf_item_activity_statuses ias

414: wf_activities_vl a,
415: wf_process_activities pa,
416: wf_item_types_vl it,
417: wf_items i,
418: wf_item_activity_statuses ias
419: WHERE ias.item_type = itemtype
420: AND ias.item_key = itemkey
421: AND i.item_type = itemtype
422: AND i.item_key = itemkey

Line 436: FROM wf_item_activity_statuses -- changed to base table for bug fix 3263333

432: AND a.name = 'NOT_APPROVAL_REQUIRED');
433: /***** Commented the following for bug fix 3263333
434: --(SELECT MAX(notification_id) Commented for bug fix 3263333
435: (SELECT notification_id -- Introduced for bug fix 3263333
436: FROM wf_item_activity_statuses -- changed to base table for bug fix 3263333
437: WHERE item_type = 'PSPADJWF' AND
438: item_key = itemkey AND
439: process_activity = actid); -- Introduced for bug fix 3263333
440: --activity_name = 'NOT_APPROVAL_REQUIRED'); Commented for bug fox 3263333