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

Line 11: , WF_PROCESS_ACTIVITIES WPA

7: BEGIN
8:
9: SELECT WPA.activity_name INTO l_activity
10: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
11: , WF_PROCESS_ACTIVITIES WPA
12: WHERE WIAS.item_type = p_item_type
13: AND WIAS.item_key = p_item_key
14: AND WIAS.activity_status = 'NOTIFIED'
15: AND WPA.instance_id = WIAS.process_activity;

Line 480: , WF_PROCESS_ACTIVITIES WPA

476:
477: CURSOR Compliance_eligible IS
478: SELECT 'Y'
479: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
480: , WF_PROCESS_ACTIVITIES WPA
481: WHERE WIAS.item_type = p_item_type
482: AND WIAS.item_key = l_itemkey
483: AND WIAS.activity_status = 'NOTIFIED'
484: AND WPA.activity_name = 'PRICING_APPROVAL_ELIGIBLE'

Line 490: , WF_PROCESS_ACTIVITIES WPA

486:
487: CURSOR Compliance_errored IS
488: SELECT 'Y'
489: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
490: , WF_PROCESS_ACTIVITIES WPA
491: WHERE WIAS.item_type = p_item_type
492: AND WIAS.item_key = l_itemkey
493: AND WIAS.activity_status = 'ERROR'
494: AND WPA.activity_name = 'PRICING_APPROVAL_ELIGIBLE'

Line 1251: , WF_PROCESS_ACTIVITIES WPA

1247: --and submit-approve - progress only submit WF activity
1248: BEGIN
1249: select WPA.activity_name INTO l_wf_activity
1250: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1251: , WF_PROCESS_ACTIVITIES WPA
1252: WHERE WIAS.item_type = p_item_type
1253: AND WIAS.item_key = to_char(p_header_id)
1254: AND WIAS.activity_status = 'NOTIFIED'
1255: AND WPA.activity_name in ( 'SUBMITTED_DEAL_WB', 'PRICING_APPROVAL_ELIGIBLE')