VIEW: APPS.IGS_AS_INS_GRD_ENTRY_V

Source

View Text - Preformatted

SELECT IG.ROWID ROW_ID, P.PERSON_NUMBER PERSON_NUMBER, IG.KEYING_WHO KEYING_WHO, IG.KEYING_TIME KEYING_TIME, IG.STUDENT_SEQUENCE STUDENT_SEQUENCE, IG.PERSON_ID PERSON_ID, IG.NAME NAME, IG.COURSE_CD COURSE_CD, IG.UNIT_CD UNIT_CD, IG.VERSION_NUMBER VERSION_NUMBER, IG.CAL_TYPE CAL_TYPE, IG.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER, IG.LOCATION_CD LOCATION_CD, IG.UNIT_CLASS UNIT_CLASS, IG.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS, IG.MARK MARK, IG.GRADING_SCHEMA_CD GRADING_SCHEMA_CD, IG.GS_VERSION_NUMBER GS_VERSION_NUMBER, IG.GRADE GRADE, IG.SPECIFIED_GRADE_IND SPECIFIED_GRADE_IND, IG.CREATED_BY CREATED_BY, IG.CREATION_DATE CREATION_DATE, IG.LAST_UPDATED_BY LAST_UPDATED_BY, IG.LAST_UPDATE_DATE LAST_UPDATE_DATE, IG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_INS_GRD_ENTRY IG, IGS_PE_PERSON P WHERE IG.PERSON_ID = P.PERSON_ID

View Text - HTML Formatted

SELECT IG.ROWID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, IG.KEYING_WHO KEYING_WHO
, IG.KEYING_TIME KEYING_TIME
, IG.STUDENT_SEQUENCE STUDENT_SEQUENCE
, IG.PERSON_ID PERSON_ID
, IG.NAME NAME
, IG.COURSE_CD COURSE_CD
, IG.UNIT_CD UNIT_CD
, IG.VERSION_NUMBER VERSION_NUMBER
, IG.CAL_TYPE CAL_TYPE
, IG.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, IG.LOCATION_CD LOCATION_CD
, IG.UNIT_CLASS UNIT_CLASS
, IG.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS
, IG.MARK MARK
, IG.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, IG.GS_VERSION_NUMBER GS_VERSION_NUMBER
, IG.GRADE GRADE
, IG.SPECIFIED_GRADE_IND SPECIFIED_GRADE_IND
, IG.CREATED_BY CREATED_BY
, IG.CREATION_DATE CREATION_DATE
, IG.LAST_UPDATED_BY LAST_UPDATED_BY
, IG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_INS_GRD_ENTRY IG
, IGS_PE_PERSON P
WHERE IG.PERSON_ID = P.PERSON_ID