VIEW: APPS.IGSFV_AV_ADV_STND_UNIT_LEVEL

Source

View Text - Preformatted

SELECT HGP.PARTY_NUMBER, HGP.PARTY_NAME, ASUL.AS_COURSE_CD, ASUL.AS_VERSION_NUMBER, CRV.TITLE, ASUL.EXEMPTION_INSTITUTION_CD, HGP1.PARTY_NAME, ASUL.UNIT_LEVEL, ULE.DESCRIPTION, TUD.UNIT, TUD.UNIT_NAME, ADTD.TERM, ADTS.ADMISSION_TEST_TYPE, ADTS.TEST_SEGMENT_NAME, AW.AWARD_TITLE, ASUL.S_ADV_STND_TYPE, ASUL.CAL_TYPE, ASUL.CI_SEQUENCE_NUMBER, CI.DESCRIPTION, ASUL. CREDIT_POINTS, '_LA:ASUL.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING', ASUL.APPROVED_DT, HGP2.PARTY_NUMBER, HGP2.PARTY_NAME, ASUL.GRANTED_DT, ASUL.EXPIRY_DT, ASUL.CANCELLED_DT, ASUL.REVOKED_DT, ASUL.COMMENTS, ASUL.CRS_GROUP_IND, ASUL.AV_STND_UNIT_LVL_ID, ASUL.PERSON_ID, ASUL.UNIT_DETAILS_ID, ASUL.TST_RSLT_DTLS_ID, ASUL.QUAL_DETS_ID, ASUL.DEG_AUD_DETAIL_ID, ASUL.AUTHORISING_PERSON_ID, ASUL.CREATED_BY, ASUL.CREATION_DATE, ASUL.LAST_UPDATED_BY, ASUL.LAST_UPDATE_DATE, asul.unit_level_mark FROM IGS_AV_STND_UNIT_LVL_ALL ASUL, HZ_PARTIES HGP, IGS_PS_VER_ALL CRV, HZ_PARTIES HGP1, IGS_PS_UNIT_LEVEL_ALL ULE, IGS_AD_TERM_UNITDTLS TUD, IGS_AD_TST_RSLT_DTLS TRD, IGS_AD_TERM_DETAILS ADTD, IGS_AD_TEST_SEGMENTS ADTS, IGS_CA_INST_ALL CI, IGS_UC_QUAL_DETS UCQD, IGS_PS_AWD AW, HZ_PARTIES HGP2, igs_pe_hz_parties ipz WHERE ASUL.PERSON_ID = HGP.PARTY_ID AND ASUL.AS_COURSE_CD = CRV.COURSE_CD AND ASUL.AS_VERSION_NUMBER = CRV.VERSION_NUMBER AND ASUL.EXEMPTION_INSTITUTION_CD = ipz.oss_org_unit_cd AND ASUL.UNIT_LEVEL = ULE.UNIT_LEVEL AND ASUL.UNIT_DETAILS_ID = TUD.UNIT_DETAILS_ID (+) AND TUD.TERM_DETAILS_ID = ADTD.TERM_DETAILS_ID (+) AND ASUL.TST_RSLT_DTLS_ID = TRD.TST_RSLT_DTLS_ID(+) AND TRD.TEST_SEGMENT_ID = ADTS.TEST_SEGMENT_ID (+) AND ASUL.CAL_TYPE = CI.CAL_TYPE(+) AND hgp1.party_id = ipz.party_id AND ASUL.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+) AND ASUL.QUAL_DETS_ID = UCQD.QUAL_DETS_ID(+) AND UCQD.EXAM_LEVEL = AW.AWARD_CD (+) AND ASUL.AUTHORISING_PERSON_ID = HGP2.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HGP.PARTY_NUMBER
, HGP.PARTY_NAME
, ASUL.AS_COURSE_CD
, ASUL.AS_VERSION_NUMBER
, CRV.TITLE
, ASUL.EXEMPTION_INSTITUTION_CD
, HGP1.PARTY_NAME
, ASUL.UNIT_LEVEL
, ULE.DESCRIPTION
, TUD.UNIT
, TUD.UNIT_NAME
, ADTD.TERM
, ADTS.ADMISSION_TEST_TYPE
, ADTS.TEST_SEGMENT_NAME
, AW.AWARD_TITLE
, ASUL.S_ADV_STND_TYPE
, ASUL.CAL_TYPE
, ASUL.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, ASUL. CREDIT_POINTS
, '_LA:ASUL.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING'
, ASUL.APPROVED_DT
, HGP2.PARTY_NUMBER
, HGP2.PARTY_NAME
, ASUL.GRANTED_DT
, ASUL.EXPIRY_DT
, ASUL.CANCELLED_DT
, ASUL.REVOKED_DT
, ASUL.COMMENTS
, ASUL.CRS_GROUP_IND
, ASUL.AV_STND_UNIT_LVL_ID
, ASUL.PERSON_ID
, ASUL.UNIT_DETAILS_ID
, ASUL.TST_RSLT_DTLS_ID
, ASUL.QUAL_DETS_ID
, ASUL.DEG_AUD_DETAIL_ID
, ASUL.AUTHORISING_PERSON_ID
, ASUL.CREATED_BY
, ASUL.CREATION_DATE
, ASUL.LAST_UPDATED_BY
, ASUL.LAST_UPDATE_DATE
, ASUL.UNIT_LEVEL_MARK
FROM IGS_AV_STND_UNIT_LVL_ALL ASUL
, HZ_PARTIES HGP
, IGS_PS_VER_ALL CRV
, HZ_PARTIES HGP1
, IGS_PS_UNIT_LEVEL_ALL ULE
, IGS_AD_TERM_UNITDTLS TUD
, IGS_AD_TST_RSLT_DTLS TRD
, IGS_AD_TERM_DETAILS ADTD
, IGS_AD_TEST_SEGMENTS ADTS
, IGS_CA_INST_ALL CI
, IGS_UC_QUAL_DETS UCQD
, IGS_PS_AWD AW
, HZ_PARTIES HGP2
, IGS_PE_HZ_PARTIES IPZ
WHERE ASUL.PERSON_ID = HGP.PARTY_ID
AND ASUL.AS_COURSE_CD = CRV.COURSE_CD
AND ASUL.AS_VERSION_NUMBER = CRV.VERSION_NUMBER
AND ASUL.EXEMPTION_INSTITUTION_CD = IPZ.OSS_ORG_UNIT_CD
AND ASUL.UNIT_LEVEL = ULE.UNIT_LEVEL
AND ASUL.UNIT_DETAILS_ID = TUD.UNIT_DETAILS_ID (+)
AND TUD.TERM_DETAILS_ID = ADTD.TERM_DETAILS_ID (+)
AND ASUL.TST_RSLT_DTLS_ID = TRD.TST_RSLT_DTLS_ID(+)
AND TRD.TEST_SEGMENT_ID = ADTS.TEST_SEGMENT_ID (+)
AND ASUL.CAL_TYPE = CI.CAL_TYPE(+)
AND HGP1.PARTY_ID = IPZ.PARTY_ID
AND ASUL.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND ASUL.QUAL_DETS_ID = UCQD.QUAL_DETS_ID(+)
AND UCQD.EXAM_LEVEL = AW.AWARD_CD (+)
AND ASUL.AUTHORISING_PERSON_ID = HGP2.PARTY_ID WITH READ ONLY