[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity contains notes about institutions, organizational units or locations. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ONT.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, ONT.ORG_STRUCTURE_TYPE
, ONT.ORG_NOTE_SEQUENCE
, ONT.ORG_NOTE_TYPE
, ONT.START_DATE EFFECTIVE_START_DATE
, ONT.END_DATE EFFECTIVE_END_DATE
, ONT.NOTE_TEXT NOTES
, DECODE(ONT.ORG_STRUCTURE_TYPE
, 'LOCATION'
, LOC.DESCRIPTION
, HP.PARTY_NAME) ORG_STRUCTURE_NAME
, '_LA:ONT.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, ONY.NOTE_TYPE_DESCRIPTION ORG_NOTE_TYPE_DESC
, ONT.CREATED_BY
, ONT.CREATION_DATE
, ONT.LAST_UPDATED_BY
, ONT.LAST_UPDATE_DATE
FROM IGS_OR_ORG_NOTES ONT
, IGS_OR_ORG_NOTE_TYPE ONY
, HZ_PARTIES HP
, IGS_AD_LOCATION_ALL LOC
, IGS_PE_HZ_PARTIES IHP
WHERE ONT.ORG_STRUCTURE_ID =IHP.OSS_ORG_UNIT_CD(+)
AND IHP.PARTY_ID = HP.PARTY_ID(+)
AND ONT.ORG_STRUCTURE_ID = LOC.LOCATION_CD(+)
AND ONT.ORG_NOTE_TYPE = ONY.ORG_NOTES_TYPE WITH READ ONLY