How to create a P6 EPS hierarchy report in BI Publisher

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

which only displays the immediate EPS node. I need the entire tree.