GoDawgs,
Here is the SQL Query you need:
SELECT
T.TS_TEST_ID, /*T.Test ID* /
T.TS_NAME, /*T.Test Name* /
T.TS_DESCRIPTION, /*T.Test Description * /
D.DS_STEP_NAME, /*Design Step.Step Name* /
D.DS_DESCRIPTION, /*Design Step.Step Description* /
D.DS_EXPECTED, /*Design Step.Expected Result*/
T.TS_TYPE, /*T.Type* /
A.AL_ABSOLUTE_PATH,
A.AL_DESCRIPTION /*Test Plan Folder.Name*/
FROM
ALL_LISTS A,
Test T
LEFT OUTER JOIN DESSTEPS D on TS_TEST_ID = D.TS_TEST_ID
WHERE
A.AL_ITEM_ID = T.TS_SUBJECT AND A.AL_DESCRIPTION LIKE'End2End%'