In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query.
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%');
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%');