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

Line 1492: from wf_notifications

1488: into ct_waiting_msg
1489: from
1490: (
1491: select mail_status
1492: from wf_notifications
1493: where mail_status = 'MAIL' ) v
1494: where rownum <= to_number(v_threshold_val) + 1;
1495: else
1496: -- Get the full count of waiting workflow mailer messages

Line 1499: from wf_notifications

1495: else
1496: -- Get the full count of waiting workflow mailer messages
1497: select count(*)
1498: into ct_waiting_msg
1499: from wf_notifications
1500: where mail_status = 'MAIL';
1501: end if;
1502: end;
1503:

Line 1660: from wf_notifications

1656: -- Get the count of processed workflow mailer messages that began within
1657: -- last 24 hours
1658: select count(*)
1659: into ct_processed_msg
1660: from wf_notifications
1661: where mail_status = 'SENT'
1662: and status = 'OPEN'
1663: and (sysdate - begin_date <= 1);
1664: