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

Line 837: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,

833: -- check begin date as well
834: -- move the BEGIN_DATE, SYSDATE comparion to a separate clause
835: SELECT CWA.COST, CWIAS.BEGIN_DATE
836: into cost, l_begdate
837: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,
838: WF_PROCESS_ACTIVITIES CWPA,
839: WF_ITEMS WI,
840: WF_ACTIVITIES CWA
841: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'

Line 942: from wf_item_activity_statuses_h

938: (g_ActivityHistoryCount(g_Key).ACTID <> enqueue_event.actid)) then
939:
940: select count(process_activity)
941: into l_background_occurrence
942: from wf_item_activity_statuses_h
943: where item_type = enqueue_event.itemtype
944: and item_key = enqueue_event.itemkey
945: and process_activity = enqueue_event.actid
946: and begin_date >= g_background_begin_date;