Product: | IGS - Student System |
---|---|
Description: | Links Extract Lines with Extract Fields |
Implementation/DBA Data: | APPS.IGS_HE_EX_RN_FD_LN_DTLS_V |
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