FND Design Data [Home] [Help]

View: IGS_EN_ELGB_OVR_SYS_STEP_V

Product: IGS - Student System (Obsolete)
Description: This view is used to capture the Enrollment Eligibility Override of system steps.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT EOS.ROWID ROW_ID
, EOS.ELGB_OVR_STEP_ID
, EOS.ELGB_OVERRIDE_ID
, 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_OVR_STEP_TYPE'
AND LKV.CLOSED_IND ='N'

Columns

Name
ROW_ID
ELGB_OVR_STEP_ID
ELGB_OVERRIDE_ID
STEP_OVERRIDE_TYPE
STEP_OVR_TYPE_MEANING
STEP_GROUP_TYPE
STEP_OVERRIDE_DT
STEP_OVERRIDE_LIMIT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN