VIEW: APPS.IGS_HE_EX_RN_FD_LN_DTLS_V

Source

View Text - Preformatted

SELECT a.rowid ,a.rn_dat_fd_id ,a.extract_run_id ,a.field_number ,a.line_number ,b.person_id ,b.student_inst_number ,b.course_cd ,b.crv_version_number ,b.unit_cd ,b.uv_version_number ,a.value ,a.override_value ,b.manually_inserted ,b.exclude_from_file ,b.recalculate_flag FROM igs_he_ex_rn_dat_fd a, igs_he_ex_rn_dat_ln b WHERE a.extract_run_id = b.extract_run_id AND a.line_number = b.line_number

View Text - HTML Formatted

SELECT A.ROWID
, A.RN_DAT_FD_ID
, A.EXTRACT_RUN_ID
, A.FIELD_NUMBER
, A.LINE_NUMBER
, B.PERSON_ID
, B.STUDENT_INST_NUMBER
, B.COURSE_CD
, B.CRV_VERSION_NUMBER
, B.UNIT_CD
, B.UV_VERSION_NUMBER
, A.VALUE
, A.OVERRIDE_VALUE
, B.MANUALLY_INSERTED
, B.EXCLUDE_FROM_FILE
, B.RECALCULATE_FLAG
FROM IGS_HE_EX_RN_DAT_FD A
, IGS_HE_EX_RN_DAT_LN B
WHERE A.EXTRACT_RUN_ID = B.EXTRACT_RUN_ID
AND A.LINE_NUMBER = B.LINE_NUMBER