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_ITEM_ACTIVITY_STATUSES

Line 206: FROM wf_item_activity_statuses

202: -- if viewing method is through URL
203: -- fix bug 1332384
204: SELECT item_key
205: INTO l_header_id
206: FROM wf_item_activity_statuses
207: where notification_id = to_number(document_id);
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: -- if viewing method is email

Line 283: FROM wf_item_activity_statuses

279: -- if viewing method is through URL
280: -- fix bug 1332384
281: SELECT item_key
282: INTO l_line_id
283: FROM wf_item_activity_statuses
284: where notification_id = to_number(document_id);
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: -- if viewing method is email

Line 3045: -- from wf_item_activity_statuses_v

3041: BEGIN
3042:
3043: -- select ITEM_KEY, ITEM_TYPE
3044: -- into l_item_key, l_item_type
3045: -- from wf_item_activity_statuses_v
3046: -- where NOTIFICATION_ID = to_number(document_id);
3047:
3048: -- replaced with this. see bug#4930449
3049: select ITEM_KEY, ITEM_TYPE

Line 3051: from WF_ITEM_ACTIVITY_STATUSES

3047:
3048: -- replaced with this. see bug#4930449
3049: select ITEM_KEY, ITEM_TYPE
3050: into l_item_key, l_item_type
3051: from WF_ITEM_ACTIVITY_STATUSES
3052: where NOTIFICATION_ID = to_number(document_id);
3053:
3054:
3055: -- Get the Sales Document Type

Line 3832: from wf_item_activity_statuses s,

3828: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
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

Line 3852: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

3848: and act.function = l_standard_block;
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'

Line 3862: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

3858: AND WPA.instance_id = WIAS.process_activity;
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'