Quality-Centre-Query

SELECT
CY.CY_CYCLE AS "CSR/RCQ Name",
TS.TS_NAME AS "Test Case Name",
TS.TS_DESCRIPTION AS "Test Case Description",
TS.TS_EXEC_STATUS AS "Status",
TC.TC_EXEC_DATE AS "Execution Date",
TS.TS_USER_03 AS "Priority",
CASE WHEN TS.TS_EXEC_STATUS = 'Failed' THEN
LISTAGG(LN.LN_BUG_ID,', ') WITHIN GROUP(ORDER BY LN.LN_BUG_ID)
END AS DEFECT_ID
FROM TEST TS,CYCLE CY,TESTCYCL TC
LEFT JOIN LINK LN ON
LN.LN_ENTITY_ID=TC.TC_TESTCYCL_ID
WHERE CY.CY_CYCLE_ID IN
(465)
AND CY.CY_CYCLE_ID = TC.TC_CYCLE_ID
AND TS.TS_TEST_ID  = TC.TC_TEST_ID
GROUP BY
CY.CY_CYCLE,
TS.TS_NAME,
TS.TS_DESCRIPTION,
TS.TS_EXEC_STATUS,
TC.TC_EXEC_DATE,
TS.TS_USER_03