View: IGSFV_HESA_EXT_RUN_DAT_FIELDS

View Text

SELECT FD.RN_DAT_FD_ID HESA_RETURN_FIELD_ID
, FD.EXTRACT_RUN_ID EXTRACT_RUN_ID
, FD.LINE_NUMBER LINE_NUMBER
, FD.FIELD_NUMBER FIELD_NUMBER
, ( SELECT DISTINCT SYS.FIELD_NAME
FROM IGS_HE_EXT_RUN_DTLS EXRN
, IGS_HE_USR_RTN_CLAS CLS
, IGS_HE_SYS_RT_CL_FLD SYS
WHERE FD.EXTRACT_RUN_ID = EXRN.EXTRACT_RUN_ID
AND CLS.USER_RETURN_SUBCLASS = EXRN.USER_RETURN_SUBCLASS
AND CLS.SYSTEM_RETURN_CLASS_TYPE= SYS.SYSTEM_RETURN_CLASS_TYPE
AND FD.FIELD_NUMBER = SYS.FIELD_NUMBER ) FIELD_NAME
, FD.VALUE VALUE
, FD.OVERRIDE_VALUE OVERRIDE_VALUE
, FD.CREATED_BY CREATED_BY
, FD.CREATION_DATE CREATION_DATE
, FD.LAST_UPDATED_BY LAST_UPDATED_BY
, FD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_EX_RN_DAT_FD FD WITH READ ONLY

Columns