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.WF_MONITOR dependencies on WF_NOTIFICATIONS

Line 501: wf_notifications n

497: wf_item_activity_statuses s,
498: wf_lookups l1,
499: wf_lookups l2,
500: wf_lookup_types art,
501: wf_notifications n
502: where pd.item_type = x_item_type
503: and pd.name = x_proc_parent
504: and pd.begin_date <= to_date(x_begin_date, 'DD/MM/YYYY HH24:MI:SS')
505: and (pd.end_date is null or

Line 765: wf_notifications n,

761: wf_activities a,
762: wf_activities_tl a1,
763: wf_item_types_vl ait,
764: wf_item_activity_statuses s,
765: wf_notifications n,
766: wf_lookups l1,
767: wf_lookups l2,
768: wf_lookup_types art
769: where pd.item_type = x_proc_type

Line 844: from wf_notifications n,

840: 'DATE', to_char(na.date_value, nvl(ma.format,
841: 'DD-MON-YYYY HH24:MI:SS')),
842: 'LOOKUP', wf_core.activity_result(ma.format, na.text_value),
843: na.text_value) value
844: from wf_notifications n,
845: wf_notification_attributes na,
846: wf_message_attributes_vl ma
847: where n.group_id = nid
848: and n.message_type = ma.message_type

Line 2327: wf_notifications ntf

2323: and ias.end_date > sysdate - x_numdays)))
2324: and ((c_person is null) or exists
2325: (select null
2326: from wf_item_activity_statuses ias,
2327: wf_notifications ntf
2328: where wi.end_date is null
2329: and ias.item_type = wi.item_type
2330: and ias.item_key = wi.item_key
2331: and ias.activity_status||'' = 'NOTIFIED'

Line 3045: WF_NOTIFICATIONS N

3041: cursor attrs(mnid in number) is
3042: select MA.NAME
3043: from WF_NOTIFICATION_ATTRIBUTES NA,
3044: WF_MESSAGE_ATTRIBUTES_VL MA,
3045: WF_NOTIFICATIONS N
3046: where N.NOTIFICATION_ID = mnid
3047: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
3048: and MA.MESSAGE_NAME = N.MESSAGE_NAME
3049: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 3390: wf_notifications n

3386: INTO x_notification_result,
3387: x_notification_response
3388: FROM wf_notification_attributes na,
3389: wf_message_attributes_vl ma,
3390: wf_notifications n
3391: WHERE n.group_id = x_notification_id
3392: AND n.message_type = ma.message_type
3393: AND n.message_name = ma.message_name
3394: AND ma.name = na.name

Line 3426: wf_notifications n

3422: SELECT count(*)
3423: INTO x_notification_response
3424: FROM wf_notification_attributes na,
3425: wf_message_attributes_vl ma,
3426: wf_notifications n
3427: WHERE n.group_id = x_notification_id
3428: AND n.message_type = ma.message_type
3429: AND n.message_name = ma.message_name
3430: AND ma.name = na.name