Could you please find your mysterious email in KNTA_NOTIF_TXN_PARENTS table. This table stores a list of all the packages, Issues, or Report Submissions that have notifications to be sent.
Then find PARENT_KEY_ID field. This field contain foreign Key to the KDLV_PACKAGES, KCRT_REQUESTS, or KTNA_REPORT_SUBMISSIONS tables.
After then find NOTIFICATION_ID and find this number in KNTA_NOTIFICATIONS_NLS table. This table stores the definition of each notification created by the user. These notifications are used as a template to create the actual email notifications that are triggered by events in PPM Center. For example, the Workflow Step Notification is triggered to create an email by a change in the workflow step and status for a package line. For DM and DepM notification types, the CONDITION_VALUE maps to the workflow_step and the EVENT_VALUE maps to the status.
With following above way you can find request type and/or workflow step.
PS: Please keep alive our forum via kudos the professionals
IT Governance Professional & PPM Solution Architect
1. If you have configured notification on step just make control on Event parameter in notification. Like Specific result or Eligible... can you provide screen shots of your step parameters and notification parameters? It will be more clear for all.
2. If you developed a DB trigger thats sends notification on request changes just make control the condition in this trigger..