CBS Hierarchy by Data view

Hello,

We are trying to get the hierarchy of a CBS in order to use it for a webservice. We have to use a data view which should show the hierarchy for each CBS of a project.

We have tested for an specific project and works fine. You can see the sql sentence below:

select bitemid, code, item, sys_connect_by_path( code, '/' ) path

from (select * from unifier_budgetitem where budgetid = 46)

start with parentid = 0

connect by prior bitemid = parentid

But when we define the sql sentence for every project (remove the 'where' clause), the system only shows the processing pop-up.