List of Executions with info Release, Cycle, Folder TestLab, Strategy, Test Name and State of Implementation

List of Executions with info Release, Cycle, Folder Test Lab, Strategy, Test Name and State of Implementation

SELECT A.REL_NAME AS RELEASE,
              B.RCYC_NAME AS CICLO,
              C.CF_ITEM_NAME AS FOLDER,
              D.CY_CYCLE AS TESTSET,
              E.TS_NAME AS TEST,
              F.TC_STATUS AS STATO
FROM CYCL_FOLD C
           JOIN (SELECT CY_CYCLE_ID,
                                     CY_CYCLE,
                                     CY_FOLDER_ID,
                                     CY_ASSIGN_RCYC FROM CYCLE) AS D
                       ON D.CY_FOLDER_ID = C.CF_ITEM_ID
           JOIN (SELECT RCYC_ID,
                                     RCYC_NAME,
                                     RCYC_PARENT_ID FROM RELEASE_CYCLES) AS B
                       ON B.RCYC_ID = D.CY_ASSIGN_RCYC
           JOIN (SELECT TC_TESTCYCL_ID,
                                     TC_CYCLE_ID,
                                     TC_TEST_ID,
                                     TC_STATUS FROM TESTCYCL) AS F
                       ON F.TC_CYCLE_ID = D.CY_CYCLE_ID
           JOIN (SELECT TS_TEST_ID,
                                    TS_NAME FROM TEST) AS E
                       ON E.TS_TEST_ID = F.TC_TEST_ID
           JOIN (SELECT REL_NAME,
                                    REL_ID FROM RELEASES) AS A
                       ON A.REL_ID = B.RCYC_PARENT_ID
WHERE C.CF_ITEM_ID = 196