VIEW: APPS.IGSFV_HESA_EXT_RUN_DAT_FIELDS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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