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.EDR_STANDARD dependencies on WF_EVENTS

Line 80: wf_events a, wf_event_subscriptions b

76: l_eRecord_required varchar2(1);
77: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
78: select b.guid,A.status,b.status
79: from
80: wf_events a, wf_event_subscriptions b
81: where a.GUID = b.EVENT_FILTER_GUID
82: and a.name = p_event
83: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
84: and b.STATUS = 'ENABLED'

Line 112: wf_events a, wf_event_subscriptions b

108: -- Verify is more than one active ERES subscriptions are present
109: --
110: select count(*) INTO l_no_enabled_eres_sub
111: from
112: wf_events a, wf_event_subscriptions b
113: where a.GUID = b.EVENT_FILTER_GUID
114: and a.name = p_event
115: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
116: and b.STATUS = 'ENABLED'

Line 158: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS

154: is OWNER_TAG will always be set to application Short Name*/
155:
156: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
157: FROM FND_APPLICATION
158: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
159: WHERE NAME=evt.getEventName( ));
160:
161: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */
162:

Line 321: wf_events a, wf_event_subscriptions b

317:
318: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
319: select b.guid,A.status,b.status
320: from
321: wf_events a, wf_event_subscriptions b
322: where a.GUID = b.EVENT_FILTER_GUID
323: and a.name = p_event
324: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
325: and b.STATUS = 'ENABLED'

Line 354: wf_events a, wf_event_subscriptions b

350: -- Verify is more than one active ERES subscriptions are present
351: --
352: select count(*) into l_no_enabled_eres_sub
353: from
354: wf_events a, wf_event_subscriptions b
355: where a.GUID = b.EVENT_FILTER_GUID
356: and a.name = p_event
357: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
358: and b.STATUS = 'ENABLED'

Line 400: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS

396: is OWNER_TAG will always be set to application Short Name*/
397:
398: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
399: FROM FND_APPLICATION
400: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
401: WHERE NAME=evt.getEventName( ));
402:
403: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */
404: