we have 4 normalized tables. user need to see the data hierarchically in a view. so iam considering to use Connect by prior function. any inputs please.

Code:
product 
--------

prd_id prod_name
10       Savings


customer
----------

prd_id cust_id cust_name
10        1          Louis

Account
---------

prd_id cust_id acc_id balance
10       1         2         $1000
10       1         3         $5000

Txn
----

prd_id cust_id acc_id txn_id xfr_amt

10       1         2        4         $500
10       1         3        5         $5000

Need to join all the 4 tables and show the data hierarchically. appreciate your help. Thanks