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 1017: from wf_items

1013:
1014:
1015: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
1016: select item_type, item_key
1017: from wf_items
1018: where parent_item_type = l_wf_itemtype
1019: and parent_item_key = l_wf_itemkey;
1020:
1021: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is

Line 2404: from wf_items item

2400: ORDER BY sequence_num desc;
2401:
2402: cursor c1(itemtype varchar2, itemkey varchar2) is
2403: select item_key
2404: from wf_items item
2405: where item.item_type = itemtype
2406: AND item.parent_item_key = itemkey;
2407: xAmeTransactionType VARCHAR2(1000);
2408: BEGIN

Line 2467: wf_items wfi,

2463: BEGIN
2464: SELECT NVL(activity_status, 'N')
2465: INTO l_activity_status
2466: FROM wf_item_activity_statuses wfs,
2467: wf_items wfi,
2468: wf_process_activities wfa
2469: WHERE wfi.item_type = l_item_type
2470: and wfi.item_key = l_item_key
2471: and wfa.activity_name = wfi.root_activity

Line 2506: wf_items wfi,

2502: BEGIN
2503: SELECT NVL(activity_status, 'N')
2504: INTO l_activity_status
2505: FROM wf_item_activity_statuses wfs,
2506: wf_items wfi,
2507: wf_process_activities wfa
2508: WHERE wfi.item_type = l_item_type
2509: and wfi.item_key = c1_rec.item_key
2510: and wfa.activity_name = wfi.root_activity

Line 3232: wf_items item

3228:
3229: cursor c1(itemtype varchar2, itemkey varchar2) is
3230: select stat.notification_id
3231: from wf_item_activity_statuses stat,
3232: wf_items item
3233: where stat.item_type = itemtype
3234: AND item.item_type = itemtype
3235: AND item.parent_item_key = itemkey
3236: AND stat.item_key = item.item_key