Query To Check All Workflow Mailer Component Status

Download(allwfstat.sql)

REM +======================================================================+
REM                    
REM File Name: allwfstat.sql
REM 
REM Description:
REM   Query To Check All Workflow Mailer Component Status
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @allwfstat.sql 
REM   
REM +======================================================================+

Clear columns
SET lines 180
SET pages 100
COL STARTUP_MODE for a15
COL COMPONENT_NAME for a50
COL COMPONENT_STATUS for a20
SELECT   component_id, component_name, component_type, startup_mode, component_status
 FROM applsys.fnd_svc_components
 --WHERE component_status <> 'RUNNING'
ORDER BY component_status;