VIEW: APPS.IGS_AV_STND_UNIT_DTL_V

Source

View Text - Preformatted

SELECT asu.rowid row_id, asu.person_id person_id, asu.as_course_cd as_course_cd, asu.as_version_number as_version_number, asu.s_adv_stnd_type s_adv_stnd_type, asu.unit_cd unit_cd, asu.version_number version_number, asu.s_adv_stnd_granting_status s_adv_stnd_granting_status, asu.approved_dt approved_dt, asu.authorising_person_id authorising_person_id, ppv.person_number authorising_person_number, ppv.full_name preferred_name, asu.crs_group_ind crs_group_ind, asu.exemption_institution_cd exemption_institution_cd, asu.granted_dt granted_dt, asu.expiry_dt expiry_dt, asu.cancelled_dt cancelled_dt, asu.revoked_dt revoked_dt, asu.comments comments, NULL, /* asu.credit_percentage credit_percentage, */ asu.s_adv_stnd_recognition_type s_adv_stnd_recognition_type, asu.created_by created_by, asu.creation_date creation_date, asu.last_updated_by last_updated_by, asu.last_update_date last_update_date, asu.last_update_login last_update_login, asu.request_id request_id, asu.program_application_id program_application_id, asu.program_id program_id, asu.program_update_date 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, igs_pe_person_base_v ppv WHERE asu.authorising_person_id = ppv.person_id

View Text - HTML Formatted

SELECT ASU.ROWID ROW_ID
, ASU.PERSON_ID PERSON_ID
, ASU.AS_COURSE_CD AS_COURSE_CD
, ASU.AS_VERSION_NUMBER AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE S_ADV_STND_TYPE
, ASU.UNIT_CD UNIT_CD
, ASU.VERSION_NUMBER VERSION_NUMBER
, ASU.S_ADV_STND_GRANTING_STATUS S_ADV_STND_GRANTING_STATUS
, ASU.APPROVED_DT APPROVED_DT
, ASU.AUTHORISING_PERSON_ID AUTHORISING_PERSON_ID
, PPV.PERSON_NUMBER AUTHORISING_PERSON_NUMBER
, PPV.FULL_NAME PREFERRED_NAME
, ASU.CRS_GROUP_IND CRS_GROUP_IND
, ASU.EXEMPTION_INSTITUTION_CD EXEMPTION_INSTITUTION_CD
, ASU.GRANTED_DT GRANTED_DT
, ASU.EXPIRY_DT EXPIRY_DT
, ASU.CANCELLED_DT CANCELLED_DT
, ASU.REVOKED_DT REVOKED_DT
, ASU.COMMENTS COMMENTS
, NULL
, /* ASU.CREDIT_PERCENTAGE CREDIT_PERCENTAGE
, */ ASU.S_ADV_STND_RECOGNITION_TYPE S_ADV_STND_RECOGNITION_TYPE
, ASU.CREATED_BY CREATED_BY
, ASU.CREATION_DATE CREATION_DATE
, ASU.LAST_UPDATED_BY LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASU.REQUEST_ID REQUEST_ID
, ASU.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ASU.PROGRAM_ID PROGRAM_ID
, ASU.PROGRAM_UPDATE_DATE 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
, IGS_PE_PERSON_BASE_V PPV
WHERE ASU.AUTHORISING_PERSON_ID = PPV.PERSON_ID