VIEW: APPS.IGS_AD_APPL_EVAL_V

Source

View Text - Preformatted

SELECT AE.ROWID ROW_ID, AE.APPL_EVAL_ID APPL_EVAL_ID, AE.PERSON_ID PERSON_ID, P.PERSON_NUMBER PERSON_NUMBER, AE.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER, AE.NOMINATED_COURSE_CD NOMINATED_COURSE_CD, AE.SEQUENCE_NUMBER SEQUENCE_NUMBER, AE.EVALUATOR_ID EVALUATOR_ID, P.FULL_NAME FULL_NAME, AE.ASSIGN_TYPE ASSIGN_TYPE, AE.ASSIGN_DATE ASSIGN_DATE, AE.EVALUATION_DATE EVALUATION_DATE, AE.RATING_VALUES_ID RATING_VALUES_ID, RV.RATING_VALUE RATING, AE.RATING_TYPE_ID RATING_TYPE_ID, CC.NAME RATING_TYPE, AE.RATING_NOTES RATING_NOTES, AE.CREATED_BY CREATED_BY, AE.CREATION_DATE CREATION_DATE, AE.LAST_UPDATED_BY LAST_UPDATED_BY, AE.LAST_UPDATE_DATE LAST_UPDATE_DATE, AE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AE.REQUEST_ID REQUEST_ID, AE.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, AE.PROGRAM_ID PROGRAM_ID, AE.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE ,AE.EVALUATION_SEQUENCE EVALUATION_SEQUENCE ,RS.RATING_SCALE_ID RATING_SCALE_ID ,RATING_SCALE_NAME RATING_SCALE_NAME ,AE.CLOSED_IND CLOSED_IND FROM IGS_AD_APPL_EVAL AE, IGS_AD_RS_VALUES RV, IGS_AD_CODE_CLASSES CC, IGS_PE_PERSON_BASE_V P ,IGS_AD_RATING_SCALES_V RS WHERE AE.RATING_VALUES_ID = RV.RATING_VALUES_ID (+) AND AE.RATING_TYPE_ID = CC.CODE_ID (+) AND AE.RATING_SCALE_ID = RS.RATING_SCALE_ID(+) AND AE.EVALUATOR_ID = P.PERSON_ID

View Text - HTML Formatted

SELECT AE.ROWID ROW_ID
, AE.APPL_EVAL_ID APPL_EVAL_ID
, AE.PERSON_ID PERSON_ID
, P.PERSON_NUMBER PERSON_NUMBER
, AE.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AE.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AE.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AE.EVALUATOR_ID EVALUATOR_ID
, P.FULL_NAME FULL_NAME
, AE.ASSIGN_TYPE ASSIGN_TYPE
, AE.ASSIGN_DATE ASSIGN_DATE
, AE.EVALUATION_DATE EVALUATION_DATE
, AE.RATING_VALUES_ID RATING_VALUES_ID
, RV.RATING_VALUE RATING
, AE.RATING_TYPE_ID RATING_TYPE_ID
, CC.NAME RATING_TYPE
, AE.RATING_NOTES RATING_NOTES
, AE.CREATED_BY CREATED_BY
, AE.CREATION_DATE CREATION_DATE
, AE.LAST_UPDATED_BY LAST_UPDATED_BY
, AE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AE.REQUEST_ID REQUEST_ID
, AE.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AE.PROGRAM_ID PROGRAM_ID
, AE.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AE.EVALUATION_SEQUENCE EVALUATION_SEQUENCE
, RS.RATING_SCALE_ID RATING_SCALE_ID
, RATING_SCALE_NAME RATING_SCALE_NAME
, AE.CLOSED_IND CLOSED_IND
FROM IGS_AD_APPL_EVAL AE
, IGS_AD_RS_VALUES RV
, IGS_AD_CODE_CLASSES CC
, IGS_PE_PERSON_BASE_V P
, IGS_AD_RATING_SCALES_V RS
WHERE AE.RATING_VALUES_ID = RV.RATING_VALUES_ID (+)
AND AE.RATING_TYPE_ID = CC.CODE_ID (+)
AND AE.RATING_SCALE_ID = RS.RATING_SCALE_ID(+)
AND AE.EVALUATOR_ID = P.PERSON_ID