VIEW: APPS.IGS_EN_NON_ENR_STDNT_OU_ASS_V

Source

View Text - Preformatted

SELECT NESO.ROWID, PEV.PARTY_NUMBER, neso.person_id, neso.unit_cd, neso.version_number, neso.CAL_TYPE, neso.ci_sequence_number, SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(neso.CAL_TYPE,neso.ci_sequence_number),1,10), SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(neso.CAL_TYPE,neso.ci_sequence_number),1,10), neso.course_cd, neso.location_cd, neso.UNIT_MODE, neso.UNIT_CLASS, neso.s_grade_creation_method_type, neso.grading_schema_cd, neso.gs_version_number, neso.grade, neso.mark, neso.resolved_ind, neso.comments, neso.created_by, neso.creation_date, neso.last_updated_by, neso.last_update_date, neso.last_update_login, ci.description FROM hz_parties PEV, IGS_AS_NON_ENR_STDOT neso, igs_ca_inst_all ci WHERE PEV.PARTY_ID = NESO.PERSON_ID AND NESO.CAL_TYPE =CI.CAL_TYPE AND NESO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT NESO.ROWID
, PEV.PARTY_NUMBER
, NESO.PERSON_ID
, NESO.UNIT_CD
, NESO.VERSION_NUMBER
, NESO.CAL_TYPE
, NESO.CI_SEQUENCE_NUMBER
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(NESO.CAL_TYPE
, NESO.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(NESO.CAL_TYPE
, NESO.CI_SEQUENCE_NUMBER)
, 1
, 10)
, NESO.COURSE_CD
, NESO.LOCATION_CD
, NESO.UNIT_MODE
, NESO.UNIT_CLASS
, NESO.S_GRADE_CREATION_METHOD_TYPE
, NESO.GRADING_SCHEMA_CD
, NESO.GS_VERSION_NUMBER
, NESO.GRADE
, NESO.MARK
, NESO.RESOLVED_IND
, NESO.COMMENTS
, NESO.CREATED_BY
, NESO.CREATION_DATE
, NESO.LAST_UPDATED_BY
, NESO.LAST_UPDATE_DATE
, NESO.LAST_UPDATE_LOGIN
, CI.DESCRIPTION
FROM HZ_PARTIES PEV
, IGS_AS_NON_ENR_STDOT NESO
, IGS_CA_INST_ALL CI
WHERE PEV.PARTY_ID = NESO.PERSON_ID
AND NESO.CAL_TYPE =CI.CAL_TYPE
AND NESO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER