How to pull Quality Center test cases from Test Plan Module using SQL?

SELECT ALL_LISTS.AL_ITEM_ID as Item_Id, ALL_LISTS.AL_ABSOLUTE_PATH as Absolute_Path, ALL_LISTS.AL_DESCRIPTION as Name, ALL_LISTS.AL_MEMO as Description, ALL_LISTS.AL_FATHER_ID as Father_Id,
TEST.TS_TEST_ID as Test_ID,  TEST.TS_NAME as Test_Name,  TEST.TS_SUBJECT as Subject,  TEST.TS_USER_03 as Test_Script_MWS_Document_ID,  TEST.TS_USER_04 as Test_Script_MWS_Document_Rev_#,  TEST.TS_USER_06 as Approval_Status,  TEST.TS_USER_11 as Requirement_Doc_Id,  TEST.TS_USER_12 as Requirement_Id, TEST.TS_USER_08 as GxP_Relevant, TEST.TS_USER_16 as Test_Script_Type, TEST.TS_USER_15 as Source_Test_Case_ID, TEST.TS_USER_07 as Created_From_Test_Case_ID, TEST.TS_USER_13 as Revision_Number
FROM   TEST /*Test*/, ALL_LISTS /*Test Plan Folder*/
WHERE  TEST.TS_SUBJECT /*Test.Subject*/ = ALL_LISTS.AL_ITEM_ID /*Test Plan Folder.Item Id*/
AND    SUBSTR(ALL_LISTS.AL_ABSOLUTE_PATH,1,9) IN
(
SELECT ALL_LISTS.AL_ABSOLUTE_PATH /*Test Plan Folder.Absolute Path*/
FROM   ALL_LISTS /*Test Plan Folder*/
WHERE  ALL_LISTS.AL_ITEM_ID='Test Script ID')