We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need help on a query with Account hierarchies

Received Response
1
Views
1
Comments

Summary:

I need to retrieve GL balances based on the account hierarchies and I am not able to get it for the 2nd level child. I am able to do it for one level. In the query below, the parent value 80000 has a couple of parents in it and I need to get to the lowest level child value. Can you pelase help?

select pk1_value from GL_SEG_VAL_HIER_RF

where tree_code = 'Account SPWR US CORPORATE'

and distance = 1

and ANCESTOR_PK1_VALUE in ('80000', '85000') 

and tree_version_id = 'BEF811F07D6DC7F8E0534461500A0B3F'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!