Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes accreditation details. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OAD.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, OAD.ORG_STRUCTURE_TYPE
, OAD.ORG_AGENCY_ID ORG_AGENCY_IDENTIFIER
, '_LA:OAD.ORG_ACCR_STATUS:IGS_LOOKUP_VALUES:ORG_ACCR_STATUS:MEANING'
, OAD.START_DATE EFFECTIVE_START_DATE
, OAD.END_DATE EFFECTIVE_END_DATE
, HP1.PARTY_NAME ORG_STRUCTURE_NAME
, HP2.PARTY_NAME ORG_AGENCY_NAME
, '_LA:OAD.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, OAD.CREATED_BY
, OAD.CREATION_DATE
, OAD.LAST_UPDATED_BY
, OAD.LAST_UPDATE_DATE
FROM IGS_OR_ORG_ACCR_DTLS OAD
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_PE_HZ_PARTIES IHP1
, IGS_PE_HZ_PARTIES IHP2
WHERE OAD.ORG_STRUCTURE_ID = IHP1.OSS_ORG_UNIT_CD
AND IHP1.PARTY_ID = HP1.PARTY_ID
AND OAD.ORG_AGENCY_ID = IHP2.OSS_ORG_UNIT_CD
AND IHP2.PARTY_ID = HP2.PARTY_ID WITH READ ONLY