You might look at R0909P? It has a pre-process(R0909R) that has to be run to populate its F0909 table - but, it should give you want you want.
When you look at it - pay VERY GOOD ATTENTION to the Levels of Detail Sequencing. You really don't want to have any skips!
You will want to review the bOrgacle Document:
E1: 09: FAQ - Frequently Asked Questions Regarding Chart of Accounts [ID 664720.1]
If you need more reading:
JD Edwards EnterpriseOne Financial Management Reports Guide 9.0 [ID 1234465.1]
(db)