[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ASUL.ROWID
, ASUL.PERSON_ID
, PBV.PERSON_NUMBER
, ASUL.AS_COURSE_CD
, ASUL.AS_VERSION_NUMBER
, ASUL.S_ADV_STND_TYPE
, ASUL.UNIT_LEVEL
, ASUL.CRS_GROUP_IND
, ASUL.EXEMPTION_INSTITUTION_CD
, ASUL.S_ADV_STND_GRANTING_STATUS
, ASUL.CREDIT_POINTS
, ASUL.APPROVED_DT
, ASUL.AUTHORISING_PERSON_ID
, P.PARTY_NUMBER AUTHORISING_PERSON_NUMBER
, NVL(P.KNOWN_AS
, SUBSTR(P.PERSON_FIRST_NAME
, 1
, DECODE( INSTR(P.PERSON_FIRST_NAME
, ' ')
, 0
, LENGTH(P.PERSON_FIRST_NAME)
, (INSTR(P.PERSON_FIRST_NAME
, ' ')-1) ) ) ) || ' ' || P.PERSON_LAST_NAME PREFERRED_NAME
, ASUL.GRANTED_DT
, ASUL.EXPIRY_DT
, ASUL.CANCELLED_DT
, ASUL.REVOKED_DT
, ASUL.COMMENTS
, ASUL.CREATED_BY
, ASUL.CREATION_DATE
, ASUL.LAST_UPDATED_BY
, ASUL.LAST_UPDATE_DATE
, ASUL.LAST_UPDATE_LOGIN
, ASUL.REQUEST_ID
, ASUL.PROGRAM_APPLICATION_ID
, ASUL.PROGRAM_ID
, ASUL.PROGRAM_UPDATE_DATE
, ASUL.AV_STND_UNIT_LVL_ID
, ASUL.CAL_TYPE
, ASUL.CI_SEQUENCE_NUMBER
, ASUL.INSTITUTION_CD
, ASUL.UNIT_DETAILS_ID
, ASUL.TST_RSLT_DTLS_ID
, ASUL.DEG_AUD_DETAIL_ID
, ASUL.QUAL_DETS_ID QUAL_DETS_ID
, ASUL.UNIT_LEVEL_MARK FROM IGS_AV_STND_UNIT_LVL ASUL
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PE_PERSON_BASE_V PBV
WHERE ASUL.AUTHORISING_PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND ASUL.PERSON_ID = PBV.PERSON_ID