VIEW: APPS.IGS_EN_ELGB_OVR_STEP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'