Script to find the Workflow and Service component status

set linesize 150

col Component format a40

set pagesize 9999

col COMPONENT_NAME format a50

col COMPONENT_STATUS format a50

col Component format a40

select SC.COMPONENT_TYPE, SC.COMPONENT_NAME, FND_SVC_COMPONENT.Get_Component_Status(SC.COMPONENT_NAME) COMPONENT_STATUS from FND_SVC_COMPONENTS SC order by 1, 2;

For Specific Component status.

     SELECT component_name as Component, component_status as Status          FROM fnd_svc_components WHERE component_type = 'WF_MAILER';