View: IGS_EN_ELGB_OVR_STEP_V

Product:	IGS - Student System
Description:	Describes the Enrollment Category Eligibility Validation Override step Details
Implementation/DBA Data:	APPS.IGS_EN_ELGB_OVR_STEP_V

View Text

SELECT EOS.ROWID ROW_ID
, EOS.ELGB_OVR_STEP_ID
, EOS.ELGB_OVERRIDE_ID
, TO_CHAR(NULL)
, /**EOS.UNIT_CD
, **/ TO_NUMBER(NULL)
, /**EOS.VERSION_NUMBER
, **/ TO_CHAR(NULL)
, /**UV1.TITLE
, **/ TO_NUMBER(NULL)
, /**EOS.UOO_ID
, **/ TO_CHAR(NULL)
, /**UOO.UNIT_CD
, **/ TO_NUMBER(NULL)
, /**UOO.VERSION_NUMBER
, **/ TO_CHAR(NULL)
, /**UV2.TITLE
, **/ TO_CHAR(NULL)
, /**UOO.CAL_TYPE
, **/ TO_NUMBER(NULL)
, /**UOO.CI_SEQUENCE_NUMBER
, **/ TO_DATE(NULL)
, /**CA.START_DT
, **/ TO_DATE(NULL)
, /**CA.END_DT
, **/ TO_CHAR(NULL)
, /**CA.ALTERNATE_CODE
, **/ TO_CHAR(NULL)
, /**UOO.LOCATION_CD
, **/ TO_CHAR(NULL)
, /**UOO.UNIT_CLASS
, **/ TO_NUMBER(NULL)
, /**UOO.CALL_NUMBER
, **/ EOS.STEP_OVERRIDE_TYPE
, LKV.MEANING
, LKV.STEP_GROUP_TYPE
, EOS.STEP_OVERRIDE_DT
, EOS.STEP_OVERRIDE_LIMIT
, EOS.CREATED_BY
, EOS.CREATION_DATE
, EOS.LAST_UPDATED_BY
, EOS.LAST_UPDATE_DATE
, EOS.LAST_UPDATE_LOGIN
FROM IGS_EN_ELGB_OVR_STEP EOS
, IGS_LOOKUPS_VIEW LKV
WHERE LKV.LOOKUP_CODE = EOS.STEP_OVERRIDE_TYPE
AND LKV.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'
AND LKV.CLOSED_IND ='N'

Columns