How to know what test scripts are assigned to Tester for execution.

Below is the query to pull the test scripts which are assigned to Testers for execution:

SELECT FOLD1.CF_ITEM_NAME AS Folder_Name, Substr(FOLD10.CF_ITEM_NAME||'\'||FOLD9.CF_ITEM_NAME||'\'||FOLD8.CF_ITEM_NAME||'\'||FOLD7.CF_ITEM_NAME||'\'||FOLD6.CF_ITEM_NAME||'\'||FOLD5.CF_ITEM_NAME ||'\'||FOLD4.CF_ITEM_NAME
||'\'||FOLD3.CF_ITEM_NAME||'\'||FOLD2.CF_ITEM_NAME,12-length(fold1.cf_item_path)/3)||'\'||FOLD1.CF_ITEM_NAME AS FolderPath,
CYCLE.CY_CYCLE TestSet_Name,
TEST.TS_NAME TestScript_Name,
TESTCYCL.TC_STATUS LastExec_Status, TESTCYCL.TC_TESTER_NAME ResposibleTester
FROM   CYCL_FOLD FOLD1, CYCL_FOLD FOLD2, CYCL_FOLD FOLD3, CYCL_FOLD FOLD4, CYCL_FOLD FOLD5, CYCL_FOLD FOLD6, CYCL_FOLD FOLD7, CYCL_FOLD FOLD8,  CYCL_FOLD FOLD9, CYCL_FOLD FOLD10,CYCLE,TEST,TESTCYCL
WHERE  FOLD2.CF_ITEM_ID = FOLD1.CF_FATHER_ID
AND FOLD3.CF_ITEM_ID (+) = FOLD2.CF_FATHER_ID
AND FOLD4.CF_ITEM_ID (+) = FOLD3.CF_FATHER_ID
AND FOLD5.CF_ITEM_ID (+) = FOLD4.CF_FATHER_ID
AND FOLD6.CF_ITEM_ID (+) = FOLD5.CF_FATHER_ID
AND FOLD7.CF_ITEM_ID (+) = FOLD6.CF_FATHER_ID
AND FOLD8.CF_ITEM_ID (+) = FOLD7.CF_FATHER_ID
AND FOLD9.CF_ITEM_ID (+) = FOLD8.CF_FATHER_ID
AND FOLD10.CF_ITEM_ID (+) = FOLD9.CF_FATHER_ID
AND CYCLE.CY_FOLDER_ID   = FOLD1.CF_ITEM_ID
AND TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID
AND TEST.TS_TEST_ID      = TESTCYCL.TC_TEST_ID
AND (CYCLE.CY_FOLDER_ID in (SELECT B.CF_ITEM_ID FROM CYCL_FOLD A, CYCL_FOLD B Where A.CF_ITEM_ID in (folder id) and Instr(B.CF_ITEM_PATH, A.CF_ITEM_PATH)=1))     /* Enter value for Labfolderid CF_ITEM_ID*/