You're working on Oracle, right?
I'm not sure if Oracle needed the tree_sortkey code. What does 'describe acs_objects' say about the acs_objects table?
The CR does have very good support for hierarchical queries. I'm not sure if you'd use tree_sortkey, or use CONNECT BY. I just don't know enough details about how it is implemented.