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.POR_UTIL_PKG dependencies on WF_ITEMS

Line 990: from wf_items

986:
987:
988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key
990: from wf_items
991: where parent_item_type = l_wf_itemtype
992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is

Line 2072: from wf_items item

2068: ORDER BY sequence_num desc;
2069:
2070: cursor c1(itemtype varchar2, itemkey varchar2) is
2071: select item_key
2072: from wf_items item
2073: where item.item_type = itemtype
2074: AND item.parent_item_key = itemkey;
2075:
2076: BEGIN

Line 2117: wf_items wfi,

2113: BEGIN
2114: SELECT NVL(activity_status, 'N')
2115: INTO l_activity_status
2116: FROM wf_item_activity_statuses wfs,
2117: wf_items wfi,
2118: wf_process_activities wfa
2119: WHERE wfi.item_type = l_item_type
2120: and wfi.item_key = l_item_key
2121: and wfa.activity_name = wfi.root_activity

Line 2156: wf_items wfi,

2152: BEGIN
2153: SELECT NVL(activity_status, 'N')
2154: INTO l_activity_status
2155: FROM wf_item_activity_statuses wfs,
2156: wf_items wfi,
2157: wf_process_activities wfa
2158: WHERE wfi.item_type = l_item_type
2159: and wfi.item_key = c1_rec.item_key
2160: and wfa.activity_name = wfi.root_activity

Line 2863: wf_items item

2859:
2860: cursor c1(itemtype varchar2, itemkey varchar2) is
2861: select stat.notification_id
2862: from wf_item_activity_statuses stat,
2863: wf_items item
2864: where stat.item_type = itemtype
2865: AND item.item_type = itemtype
2866: AND item.parent_item_key = itemkey
2867: AND stat.item_key = item.item_key