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_EFF_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 625: FROM wf_item_activity_statuses -- Changed to base table for bug fix 3263333

621: FROM wf_notifications
622: WHERE notification_id =
623: --(SELECT MAX(notification_id) Commented for bug fix 3263333
624: (SELECT notification_id -- Introduced for bug fix 3263333
625: FROM wf_item_activity_statuses -- Changed to base table for bug fix 3263333
626: WHERE item_type = 'PSPEFFWF' AND
627: item_key = itemkey AND
628: process_activity = actid); -- Introduced for bug fix 3263333
629: --activity_name = 'NOTIFY_APPROVER'); Commented for bug fix 3263333

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

667: FROM wf_notifications
668: WHERE notification_id =
669: --(SELECT MAX(notification_id) Commented for bug fix 3263333
670: (SELECT notification_id -- Introduced for bug fix 3263333
671: FROM wf_item_activity_statuses -- changed to base table for bug fix 3263333
672: WHERE item_type = 'PSPEFFWF' AND
673: item_key = itemkey AND
674: process_activity = actid); -- Introduced for bug fix 3263333
675: --activity_name = 'NOTIFY_CERTIFIER'); Commented for bug fix 3263333