This view gives hierarchy for a given item instance.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT LEVEL HIERARCHY_LEVEL , OBJECT_ID PARENT_ID , SUBJECT_ID CHILD_ID FROM CSI_II_RELATIONSHIPS WHERE RELATIONSHIP_TYPE_CODE='COMPONENT-OF' START WITH SUBJECT_ID IN (SELECT INSTANCE_ID FROM XNC_PARTY_ACCT_INSTANCE WHERE SYSTEM_ID IN(SELECT DISTINCT SYSTEM_ID FROM XNC_PARTY_ACCT_INSTANCE)) CONNECT BY SUBJECT_ID = PRIOR OBJECT_ID
[Home] [Help]