Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OAD.ROWID ROW_ID
, OAD.ORG_STRUCTURE_ID
, OAD.ORG_STRUCTURE_TYPE
, OAD.ORG_AGENCY_ID
, I.PARTY_NAME
, OAD.ORG_ACCR_STATUS
, OAS.MEANING
, OAD.START_DATE
, OAD.END_DATE
, OAD.CREATION_DATE
, OAD.CREATED_BY
, OAD.LAST_UPDATE_DATE
, OAD.LAST_UPDATED_BY
, OAD.LAST_UPDATE_LOGIN
FROM IGS_OR_ORG_ACCR_DTLS OAD
, IGS_OR_INST_ORG_BASE_V I
, IGS_LOOKUP_VALUES OAS
WHERE OAD.ORG_AGENCY_ID = I.PARTY_NUMBER
AND OAD.ORG_ACCR_STATUS = OAS.LOOKUP_CODE
AND OAS.LOOKUP_TYPE = 'OR_ACCR_STATUS'
AND I.INST_ORG_IND = 'I'