WORKFLOW NOTIFICATION COUNT

Workflow Notification Count

SQL> select count(*) from wf_notifications where mail_status='MAIL' and status='OPEN';


SQL> select component_status from apps.fnd_svc_components where component_id = (select component_id from apps.fnd_svc_components where component_name = 'Workflow

Notification Mailer');


SQL> SELECT component_name, component_status, component_status_info FROM fnd_svc_components_v WHERE component_name like 'Workflow%';