| Hierarchies [message #146206] |
Wed, 09 November 2005 05:24  |
parabol64
Messages: 22
Registered: September 2005
|
Junior Member |
|
|
Hi all.
I'm trying to figure out how the accounting flexfield segment values hierarchies work in Oracle Financials.
What I'm aiming for, is writing a SQL statemnt that would return me for instance the company (or any other accounting flexfiled segment) hierarchy.
ie Company T is parent of companies 1,2,3.
Thanks in advance,
g.
|
|
|
|
|
|
| Re: Hierarchies [message #147369 is a reply to message #146206] |
Thu, 17 November 2005 07:16  |
dearchinmoy
Messages: 8
Registered: November 2005
Location: Kolkata
|
Junior Member |
|
|
To be precise, there are two tables where hierarchies are maintained.
1) FND_FLEX_VALUE_NORM_HIERARCHY : Multiple level hierarchies
2) FND_FLEX_VALUE_HIERARCHIES : Child value ranges for key flexfield segment values.
regards
Chinmoy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
