VIEW: APPS.IGSBV_AV_ADV_STND_UNIT_LEVEL

Source

View Text - Preformatted

SELECT ASUL.AS_COURSE_CD, ASUL.AS_VERSION_NUMBER, ASUL.S_ADV_STND_TYPE, ASUL.UNIT_LEVEL, ASUL.EXEMPTION_INSTITUTION_CD, ASUL.CAL_TYPE, ASUL.CI_SEQUENCE_NUMBER, ASUL.CREDIT_POINTS, '_LA:ASUL.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING', ASUL.APPROVED_DT, 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 WITH READ ONLY

View Text - HTML Formatted

SELECT ASUL.AS_COURSE_CD
, ASUL.AS_VERSION_NUMBER
, ASUL.S_ADV_STND_TYPE
, ASUL.UNIT_LEVEL
, ASUL.EXEMPTION_INSTITUTION_CD
, ASUL.CAL_TYPE
, ASUL.CI_SEQUENCE_NUMBER
, ASUL.CREDIT_POINTS
, '_LA:ASUL.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING'
, ASUL.APPROVED_DT
, 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 WITH READ ONLY