SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query.

select SCEN_NAME,TASK_NAME3,DEF_TXT from snp_scen_task snp_scen_task,

snp_scen

where

snp_scen_task.SCEN_NO=snp_scen.SCEN_NO

AND DEF_TXT like '%OdiSendMail%';

Run the below SQL query to get the load plan name and load plan step name with the corresponding scenario name.

SELECT SNP_LOAD_PLAN.LOAD_PLAN_NAME,SNP_LP_STEP.LP_STEP_NAME,SCEN_NAME

FROM SNP_LP_STEP,SNP_LOAD_PLAN

WHERE SNP_LOAD_PLAN.I_LOAD_PLAN=SNP_LP_STEP.I_LOAD_PLAN

AND SCEN_NAME IN (SELECT SCEN_NAME--,TASK_NAME3,DEF_TXT

FROM SNP_SCEN_TASK SNP_SCEN_TASK,SNP_SCEN

WHERE 1=1

AND SNP_SCEN_TASK.SCEN_NO=SNP_SCEN.SCEN_NO

AND DEF_TXT LIKE '%OdiSendMail%');