Quality Center reports

---How to find out the Path and TestPlanFolderID by giving the TestPlanFolderName

SELECT FOLD1.AL_DESCRIPTION AS Folder_Name, FOLD1.AL_ITEM_ID AS Folder_ID,
FOLD10.AL_DESCRIPTION||'\'||FOLD9.AL_DESCRIPTION||'\'||FOLD8.AL_DESCRIPTION||'\'||FOLD7.AL_DESCRIPTION||'\'||FOLD6.AL_DESCRIPTION||'\'||FOLD5.AL_DESCRIPTION ||'\'||FOLD4.AL_DESCRIPTION ||'\'||FOLD3.AL_DESCRIPTION||'\'||FOLD2.AL_DESCRIPTION AS Path
FROM ALL_LISTS FOLD1, ALL_LISTS FOLD2, ALL_LISTS FOLD3, ALL_LISTS FOLD4, ALL_LISTS FOLD5, ALL_LISTS FOLD6, ALL_LISTS FOLD7, ALL_LISTS FOLD8, ALL_LISTS FOLD9, ALL_LISTS FOLD10
WHERE FOLD2.AL_ITEM_ID = FOLD1.AL_ITEM_ID
AND FOLD3.AL_ITEM_ID (+) = FOLD2.AL_FATHER_ID
AND FOLD4.AL_ITEM_ID (+) = FOLD3.AL_FATHER_ID
AND FOLD5.AL_ITEM_ID (+) = FOLD4.AL_FATHER_ID
AND FOLD6.AL_ITEM_ID (+) = FOLD5.AL_FATHER_ID
AND FOLD7.AL_ITEM_ID (+) = FOLD6.AL_FATHER_ID
AND FOLD8.AL_ITEM_ID (+) = FOLD7.AL_FATHER_ID
AND FOLD9.AL_ITEM_ID (+) = FOLD8.AL_FATHER_ID
AND FOLD10.AL_ITEM_ID (+) = FOLD9.AL_FATHER_ID
and (FOLD1.AL_DESCRIPTION LIKE 'ENTERFOLDERNAMEHERE%') /* TestPlan Folder Name */