ODI METADATA QUERY TO FIND EXECUTION TIME TAKEN BY EACH LOAD STEP

The below query should be executed in ODI metadata schema(ODI_REPO)

SELECT A.LP_STEP_NAME, B.START_DATE,B.END_DATE,(B.END_DATE-B.START_DATE)*24*60 DURATION_IN_MIN
FROM SNP_LPI_STEP A , SNP_LPI_STEP_LOG B,SNP_LP_INST C
WHERE A.I_LP_STEP=B.I_LP_STEP
AND C.LOAD_PLAN_NAME='%'
AND  A.I_LP_INST =C. I_LP_INST
AND LP_STEP_NAME LIKE '%'
AND B.START_DATE > TO_DATE('10/22/2018 5:00:00', 'MM/DD/YYYY HH24:MI:SS')
AND B.END_DATE < TO_DATE('10/22/2018 12:00:00', 'MM/DD/YYYY HH24:MI:SS');