Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes parent and child relationships between organizational units. An organizational unit may have many parents and many children. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OUR.PARENT_ORG_UNIT_CD PARENT_ORG_UNIT_CODE
, OUR.PARENT_START_DT PARENT_START_DATE
, OUR.CHILD_ORG_UNIT_CD CHILD_ORG_UNIT_CODE
, OUR.CHILD_START_DT CHILD_START_DATE
, OUR.CREATE_DT CREATE_DATE
, OUR.LOGICAL_DELETE_DT LOGICAL_DELETE_DATE
, HP1.PARTY_NAME PARENT_ORG_UNIT_NAME
, HP2.PARTY_NAME CHILD_ORG_UNIT_NAME
, OUR.CREATED_BY
, OUR.CREATION_DATE
, OUR.LAST_UPDATED_BY
, OUR.LAST_UPDATE_DATE
FROM IGS_OR_UNIT_REL OUR
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_PE_HZ_PARTIES IHP1
, IGS_PE_HZ_PARTIES IHP2
WHERE OUR.PARENT_ORG_UNIT_CD = IHP1.OSS_ORG_UNIT_CD
AND IHP1.PARTY_ID = HP1.PARTY_ID
AND OUR.CHILD_ORG_UNIT_CD = IHP2.OSS_ORG_UNIT_CD
AND IHP2.PARTY_ID = HP2.PARTY_ID WITH READ ONLY