| CHART OF ACCOUNTS HIERARCHY [message #272229] |
Thu, 04 October 2007 04:57  |
fusion007
Messages: 11
Registered: September 2007
|
Junior Member |
|
|
Hi...
I want to create a Disco report to list all parents with the child values underneath them.
For example, the top parent level might be TOTAL and underneath that we may have 4 other parents say ABCD, EFGH, IJKL, MNOP and underneath that we may well have more parents and child cost centres.
What I want to be able to do is list the top level TOTAL then underneath have ABCD under which should the other parent codes and child codes. Then the same for EFGH etc. Example:
TOTAL
- ABCD
1234
5678
- WXYZ
9999
6789
- EFGH
8756
1257
7667
- MHSA
5567
3487
etc etc. I hope you understand what I'm trying to do. Basically have a hierarchy tree.
There is one view that has the required data FND_FLEX_HIERARCHIES_VL.
I'd be grateful for any advice please. I'm using Disco version 4.1.
Thanks
|
|
|
|
| Re: CHART OF ACCOUNTS HIERARCHY [message #272370 is a reply to message #272229] |
Thu, 04 October 2007 14:13  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Hi,
You have to do this in SQL (create a view), Discoverer can't do this. You can do it using connect by prior functionality, see the SQL reference.
Regards,
Sabine
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
