Need help on a query with Account hierarchies
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'