Creating a P6 report in BI that shows all levels children levels of the EPS

I'm trying to create a report that imitates the EPS layout in P6 with all of the EPS levels listed along with any projects. The only reference I could find in the knowledgebase  groups to level 1 - see code below

select    DISTINCT "P6EPSHIERARCHY"."CHILDID" as "EPS_ID",

     "P6EPSHIERARCHY"."CHILDNAME" as "EPS_NAME",

     "P6EPSHIERARCHY"."FULLPATHNAME" as "EPS_PATH",

     "P6PROJECT"."ID" as "PROJ_ID",

     "P6PROJECT"."NAME" as "PROJ_NAME"

from    "PXRPTUSER"."P6PROJECT" "P6PROJECT",

    "PXRPTUSER"."P6EPSHIERARCHY" "P6EPSHIERARCHY"

where   "P6PROJECT"."PARENTEPSOBJECTID"(+) ="P6EPSHIERARCHY"."CHILDOBJECTID"

order by "P6EPSHIERARCHY"."FULLPATHNAME" ASC