VIEW: APPS.IGS_AV_STND_UNIT_LVL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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