can i make a heirarchy on a single table without using an alias??

[riatoan]

Hi,
Can anyone tell me how I can use Business Objects to recreate this heirarchy from the tables below? I need the flexibility to add new COLLECTION_TYPE_IDs so creating aliases of the COLLECTION_HEIRARCHY table is not an option.

Thanks in advance,
R.

COLLECTION.COLLECTION_ID = 10
COLLECTION_HEIRARCHY.PARENT_COLLECTION_ID = 11
COLLECTION_TYPE.COLLECTION_TYPE_ID = 7
|_
COLLECTION.COLLECTION_ID = 11
COLLECTION_HEIRARCHY.PARENT_COLLECTION_ID = 12
COLLECTION_TYPE.COLLECTION_TYPE_ID = 6
|_
COLLECTION.COLLECTION_ID = 12
COLLECTION_HEIRARCHY.PARENT_COLLECTION_ID = 13
COLLECTION_TYPE.COLLECTION_TYPE_ID = 5


TABLE COLLECTION_HEIRARCHY
Name Null? Type
------------------------------------- -------- ---------
COLLECTION_ID NOT NULL NUMBER(4)
PARENT_COLLECTION_ID NOT NULL NUMBER(4)
START_DT NOT NULL DATE
END_DT DATE

TABLE COLLECTION
Name Null? Type
------------------------------------ -------- --------
COLLECTION_ID NOT NULL NUMBER(4)
COLLECTION_TYPE_ID NOT NULL NUMBER(4)
COLLECTION_DESC NOT NULL VARCHAR2(30)
ADHOC_IND NOT NULL VARCHAR2(1)
RULE_ID NUMBER(4)
START_DT NOT NULL DATE
END_DT DATE

TABLE COLLECTION_TYPE
Name Null? Type
------------------------------------ -------- --------
COLLECTION_TYPE_ID NOT NULL NUMBER(4)
COLLECTION_TYPE_DESC NOT NULL VARCHAR2(20)