r12, scripts, workflow

SQL to monitor (check status) of Workflow Notification Mailer (Java)

/

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;