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

Line 24: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

20: IS
21: l_book_deferred VARCHAR2(1);
22: CURSOR book_deferred IS
23: SELECT 'Y'
24: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
25: , WF_PROCESS_ACTIVITIES WPA
26: WHERE WIAS.item_type = 'OEOH'
27: AND WIAS.item_key = p_itemkey
28: AND WIAS.activity_status = 'DEFERRED'

Line 1492: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

1488: l_count NUMBER; -- added for 13536089
1489: l_flow_status_code VARCHAR2(100); --added for 13536089. modified for 14352532
1490: CURSOR book_eligible IS
1491: SELECT 'Y'
1492: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1493: , WF_PROCESS_ACTIVITIES WPA
1494: WHERE WIAS.item_type = 'OEOH'
1495: AND WIAS.item_key = l_itemkey
1496: AND WIAS.activity_status = 'NOTIFIED'

Line 1502: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

1498: AND WPA.instance_id = WIAS.process_activity;
1499: --For bug 3493374
1500: CURSOR booking_errored IS
1501: SELECT 'Y'
1502: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1503: , WF_PROCESS_ACTIVITIES WPA
1504: WHERE WIAS.item_type = 'OEOH'
1505: AND WIAS.item_key = l_itemkey
1506: AND WIAS.activity_status = 'ERROR'