VIEW: APPS.IGSFV_AV_ADV_STND_UNIT

Source

View Text - Preformatted

SELECT HGP.PARTY_NUMBER, HGP.PARTY_NAME, ASU.AS_COURSE_CD, ASU.AS_VERSION_NUMBER, CRV.TITLE, ASU.EXEMPTION_INSTITUTION_CD, HGP1.PARTY_NAME, ASU.UNIT_CD, ASU.VERSION_NUMBER, UV.TITLE, TUD.UNIT, TUD.UNIT_NAME, ADTD.TERM, ADTS.ADMISSION_TEST_TYPE, ADTS.TEST_SEGMENT_NAME, ASU.S_ADV_STND_TYPE, ASU.CAL_TYPE, ASU.CI_SEQUENCE_NUMBER, CI.DESCRIPTION, NULL, /* ASU.CREDIT_PERCENTAGE, */ ASU.ACHIEVABLE_CREDIT_POINTS, ASU.GRADING_SCHEMA_CD, ASU.GRD_SCH_VERSION_NUMBER, ASU.GRADE, '_LA:ASU.S_ADV_STND_RECOGNITION_TYPE:IGS_LOOKUP_VALUES:ADV_STND_RECOGNITION_TYPE:MEANING', '_LA:ASU.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING', ASU.APPROVED_DT, HGP2.PARTY_NUMBER, HGP2.PARTY_NAME, ASU.GRANTED_DT, ASU.EXPIRY_DT, ASU.CANCELLED_DT, ASU.REVOKED_DT, ASU.COMMENTS, ASU.CRS_GROUP_IND, ASU.AV_STND_UNIT_ID, ASU.PERSON_ID, ASU.UNIT_DETAILS_ID, ASU.TST_RSLT_DTLS_ID, ASU.DEG_AUD_DETAIL_ID, ASU.AUTHORISING_PERSON_ID, ASU.CREATED_BY, ASU.CREATION_DATE, ASU.LAST_UPDATED_BY, ASU.LAST_UPDATE_DATE FROM IGS_AV_STND_UNIT_ALL ASU, HZ_PARTIES HGP, IGS_PS_VER_ALL CRV, HZ_PARTIES HGP1, IGS_PS_UNIT_VER_ALL UV, 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, HZ_PARTIES HGP2 WHERE ASU.PERSON_ID = HGP.PARTY_ID AND ASU.AS_COURSE_CD = CRV.COURSE_CD AND ASU.AS_VERSION_NUMBER = CRV.VERSION_NUMBER AND ASU.EXEMPTION_INSTITUTION_CD = HGP1.PARTY_NUMBER AND ASU.UNIT_CD = UV.UNIT_CD AND ASU.VERSION_NUMBER = UV.VERSION_NUMBER AND ASU.UNIT_DETAILS_ID = TUD.UNIT_DETAILS_ID(+) AND TUD.TERM_DETAILS_ID = ADTD.TERM_DETAILS_ID(+) AND ASU.TST_RSLT_DTLS_ID = TRD.TST_RSLT_DTLS_ID(+) AND TRD.TEST_SEGMENT_ID = ADTS.TEST_SEGMENT_ID(+) AND ASU.CAL_TYPE = CI.CAL_TYPE(+) AND ASU.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+) AND ASU.AUTHORISING_PERSON_ID = HGP2.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HGP.PARTY_NUMBER
, HGP.PARTY_NAME
, ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, CRV.TITLE
, ASU.EXEMPTION_INSTITUTION_CD
, HGP1.PARTY_NAME
, ASU.UNIT_CD
, ASU.VERSION_NUMBER
, UV.TITLE
, TUD.UNIT
, TUD.UNIT_NAME
, ADTD.TERM
, ADTS.ADMISSION_TEST_TYPE
, ADTS.TEST_SEGMENT_NAME
, ASU.S_ADV_STND_TYPE
, ASU.CAL_TYPE
, ASU.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, NULL
, /* ASU.CREDIT_PERCENTAGE
, */ ASU.ACHIEVABLE_CREDIT_POINTS
, ASU.GRADING_SCHEMA_CD
, ASU.GRD_SCH_VERSION_NUMBER
, ASU.GRADE
, '_LA:ASU.S_ADV_STND_RECOGNITION_TYPE:IGS_LOOKUP_VALUES:ADV_STND_RECOGNITION_TYPE:MEANING'
, '_LA:ASU.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING'
, ASU.APPROVED_DT
, HGP2.PARTY_NUMBER
, HGP2.PARTY_NAME
, ASU.GRANTED_DT
, ASU.EXPIRY_DT
, ASU.CANCELLED_DT
, ASU.REVOKED_DT
, ASU.COMMENTS
, ASU.CRS_GROUP_IND
, ASU.AV_STND_UNIT_ID
, ASU.PERSON_ID
, ASU.UNIT_DETAILS_ID
, ASU.TST_RSLT_DTLS_ID
, ASU.DEG_AUD_DETAIL_ID
, ASU.AUTHORISING_PERSON_ID
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
FROM IGS_AV_STND_UNIT_ALL ASU
, HZ_PARTIES HGP
, IGS_PS_VER_ALL CRV
, HZ_PARTIES HGP1
, IGS_PS_UNIT_VER_ALL UV
, 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
, HZ_PARTIES HGP2
WHERE ASU.PERSON_ID = HGP.PARTY_ID
AND ASU.AS_COURSE_CD = CRV.COURSE_CD
AND ASU.AS_VERSION_NUMBER = CRV.VERSION_NUMBER
AND ASU.EXEMPTION_INSTITUTION_CD = HGP1.PARTY_NUMBER
AND ASU.UNIT_CD = UV.UNIT_CD
AND ASU.VERSION_NUMBER = UV.VERSION_NUMBER
AND ASU.UNIT_DETAILS_ID = TUD.UNIT_DETAILS_ID(+)
AND TUD.TERM_DETAILS_ID = ADTD.TERM_DETAILS_ID(+)
AND ASU.TST_RSLT_DTLS_ID = TRD.TST_RSLT_DTLS_ID(+)
AND TRD.TEST_SEGMENT_ID = ADTS.TEST_SEGMENT_ID(+)
AND ASU.CAL_TYPE = CI.CAL_TYPE(+)
AND ASU.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND ASU.AUTHORISING_PERSON_ID = HGP2.PARTY_ID WITH READ ONLY