View: IGS_AV_STND_UNIT_V

View Text

SELECT ASU.ROWID
, ASU.PERSON_ID
, ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE
, ASU.UNIT_CD
, ASU.VERSION_NUMBER
, UV.START_DT
, UV.UNIT_STATUS
, UV.TITLE
, UV.ACHIEVABLE_CREDIT_POINTS
, ASU.S_ADV_STND_GRANTING_STATUS
, ASU.APPROVED_DT
, ASU.AUTHORISING_PERSON_ID
, P.PARTY_NUMBER 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
, ASU.CRS_GROUP_IND
, ASU.EXEMPTION_INSTITUTION_CD
, HP.PARTY_NAME NAME
, IHP.OI_INSTITUTION_STATUS INSTITUTION_STATUS
, ASU.GRANTED_DT
, ASU.EXPIRY_DT
, ASU.CANCELLED_DT
, ASU.REVOKED_DT
, ASU.COMMENTS
, NULL
, /* ASU.CREDIT_PERCENTAGE
, */ ASU.S_ADV_STND_RECOGNITION_TYPE
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN
, ASU.REQUEST_ID
, ASU.PROGRAM_APPLICATION_ID
, ASU.PROGRAM_ID
, ASU.PROGRAM_UPDATE_DATE
, ASU.AV_STND_UNIT_ID
, ASU.CAL_TYPE
, ASU.CI_SEQUENCE_NUMBER
, ASU.INSTITUTION_CD
, ASU.UNIT_DETAILS_ID
, ASU.TST_RSLT_DTLS_ID
, ASU.GRADING_SCHEMA_CD
, ASU.GRD_SCH_VERSION_NUMBER
, ASU.GRADE
, ASU.ACHIEVABLE_CREDIT_POINTS
, ASU.DEG_AUD_DETAIL_ID
FROM IGS_AV_STND_UNIT ASU
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGS_PS_UNIT_VER UV
WHERE ASU.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 ASU.EXEMPTION_INSTITUTION_CD = HP.PARTY_NUMBER
AND HP.PARTY_ID = IHP.PARTY_ID
AND IHP.INST_ORG_IND = 'I'
AND ASU.UNIT_CD = UV.UNIT_CD
AND ASU.VERSION_NUMBER = UV.VERSION_NUMBER

Columns