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_WF_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 3833: wf_process_activities pa, wf_lookups l,

3829:
3830: CURSOR c_eligible_activity IS
3831: select pa.activity_name
3832: from wf_item_activity_statuses s,
3833: wf_process_activities pa, wf_lookups l,
3834: wf_activities_vl act
3835: where s.activity_status = l.lookup_code
3836: and l.lookup_type = l_wfeng_status
3837: and s.process_activity = pa.instance_id

Line 3853: , WF_PROCESS_ACTIVITIES WPA

3849:
3850: CURSOR book_eligible IS
3851: SELECT 'Y'
3852: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
3853: , WF_PROCESS_ACTIVITIES WPA
3854: WHERE WIAS.item_type = 'OEOH'
3855: AND WIAS.item_key = p_header_id
3856: AND WIAS.activity_status = 'NOTIFIED'
3857: AND WPA.activity_name = 'BOOK_ELIGIBLE'

Line 3863: , WF_PROCESS_ACTIVITIES WPA

3859:
3860: CURSOR book_deferred IS
3861: SELECT 'Y'
3862: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
3863: , WF_PROCESS_ACTIVITIES WPA
3864: WHERE WIAS.item_type = 'OEOH'
3865: AND WIAS.item_key = p_header_id
3866: AND WIAS.activity_status = 'DEFERRED'
3867: AND WPA.activity_name = 'BOOK_DEFER'