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 242: FROM wf_item_activity_statuses

238: -- if viewing method is through URL
239: -- fix bug 1332384
240: SELECT item_key, item_type
241: INTO l_item_key, l_item_type --l_header_id ame er 16084377
242: FROM wf_item_activity_statuses
243: WHERE notification_id = TO_NUMBER (document_id);
244: EXCEPTION
245: WHEN NO_DATA_FOUND
246: THEN

Line 251: FROM wf_item_activity_statuses_h

247: -- Begin Changes for bug 8570400
248: BEGIN
249: SELECT item_key, item_type
250: INTO l_item_key, l_item_type --l_header_id ame er 16084377
251: FROM wf_item_activity_statuses_h
252: WHERE notification_id = TO_NUMBER (document_id);
253: EXCEPTION
254: WHEN TOO_MANY_ROWS
255: THEN

Line 376: FROM wf_item_activity_statuses

372: -- if viewing method is through URL
373: -- fix bug 1332384
374: SELECT item_key
375: INTO l_line_id
376: FROM wf_item_activity_statuses
377: WHERE notification_id = TO_NUMBER (document_id);
378: EXCEPTION
379: WHEN NO_DATA_FOUND
380: THEN

Line 385: FROM wf_item_activity_statuses_h

381: -- Begin Changes for bug 8570400
382: BEGIN
383: SELECT item_key
384: INTO l_line_id
385: FROM wf_item_activity_statuses_h
386: WHERE notification_id = TO_NUMBER (document_id);
387: EXCEPTION
388: WHEN TOO_MANY_ROWS
389: THEN

Line 3812: -- from wf_item_activity_statuses_v

3808: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3809: BEGIN
3810: -- select ITEM_KEY, ITEM_TYPE
3811: -- into l_item_key, l_item_type
3812: -- from wf_item_activity_statuses_v
3813: -- where NOTIFICATION_ID = to_number(document_id);
3814:
3815: -- replaced with this. see bug#4930449
3816: BEGIN

Line 3819: FROM wf_item_activity_statuses

3815: -- replaced with this. see bug#4930449
3816: BEGIN
3817: SELECT item_key, item_type
3818: INTO l_item_key, l_item_type
3819: FROM wf_item_activity_statuses
3820: WHERE notification_id = TO_NUMBER (document_id);
3821: EXCEPTION
3822: WHEN NO_DATA_FOUND
3823: THEN

Line 3826: FROM wf_item_activity_statuses_h

3822: WHEN NO_DATA_FOUND
3823: THEN
3824: SELECT item_key, item_type
3825: INTO l_item_key, l_item_type
3826: FROM wf_item_activity_statuses_h
3827: WHERE notification_id = TO_NUMBER (document_id);
3828: END;
3829:
3830: /* 9047023: End */

Line 4983: FROM wf_item_activity_statuses s,

4979:
4980: CURSOR c_eligible_activity
4981: IS
4982: SELECT pa.activity_name
4983: FROM wf_item_activity_statuses s,
4984: wf_process_activities pa,
4985: wf_lookups l,
4986: wf_activities_vl act
4987: WHERE s.activity_status = l.lookup_code

Line 5006: FROM wf_item_activity_statuses wias, wf_process_activities wpa

5002:
5003: CURSOR book_eligible
5004: IS
5005: SELECT 'Y'
5006: FROM wf_item_activity_statuses wias, wf_process_activities wpa
5007: WHERE wias.item_type = 'OEOH'
5008: AND wias.item_key = p_header_id
5009: AND wias.activity_status = 'NOTIFIED'
5010: AND wpa.activity_name = 'BOOK_ELIGIBLE'

Line 5016: FROM wf_item_activity_statuses wias, wf_process_activities wpa

5012:
5013: CURSOR book_deferred
5014: IS
5015: SELECT 'Y'
5016: FROM wf_item_activity_statuses wias, wf_process_activities wpa
5017: WHERE wias.item_type = 'OEOH'
5018: AND wias.item_key = p_header_id
5019: AND wias.activity_status = 'DEFERRED'
5020: AND wpa.activity_name = 'BOOK_DEFER'