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 1406: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

1402: l_source_document_type_id NUMBER;
1403: l_source_document_id NUMBER;
1404: CURSOR book_eligible IS
1405: SELECT 'Y'
1406: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1407: , WF_PROCESS_ACTIVITIES WPA
1408: WHERE WIAS.item_type = 'OEOH'
1409: AND WIAS.item_key = l_itemkey
1410: AND WIAS.activity_status = 'NOTIFIED'

Line 1416: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

1412: AND WPA.instance_id = WIAS.process_activity;
1413: --For bug 3493374
1414: CURSOR booking_errored IS
1415: SELECT 'Y'
1416: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1417: , WF_PROCESS_ACTIVITIES WPA
1418: WHERE WIAS.item_type = 'OEOH'
1419: AND WIAS.item_key = l_itemkey
1420: AND WIAS.activity_status = 'ERROR'