View: IGS_EN_CPD_EXT_V

Product:	IGS - Student System
Description:	Describes the Enrollment Category Eligibility Validation Extension
Implementation/DBA Data:	APPS.IGS_EN_CPD_EXT_V

View Text

SELECT CPDE.ROW_ID
, CPDE.IGS_EN_CPD_EXT_ID
, CPDE.ENROLMENT_CAT
, CPDE.ENR_METHOD_TYPE
, CPDE.S_STUDENT_COMM_TYPE
, CPDE.STEP_ORDER_NUM
, CPDE.S_ENROLMENT_STEP_TYPE
, LKUPS.MEANING
, LKUPS.STEP_GROUP_TYPE
, LKUPS.STEP_ORDER_APPLICABLE_IND
, CPDE.NOTIFICATION_FLAG
, CPDE.S_RULE_CALL_CD
, CPDE.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(CPDE.RUL_SEQUENCE_NUMBER)
, DECODE(LKUPS.STEP_ORDER_APPLICABLE_IND
, 'Y'
, DECODE(NVL(CPDE.RUL_SEQUENCE_NUMBER
, 0)
, 0
, 'UNDEFINED'
, 'DEFINED')
, NULL )
, CPDE.STUD_AUDIT_LIM
, CPDE.CREATED_BY
, CPDE.CREATION_DATE
, CPDE.LAST_UPDATED_BY
, CPDE.LAST_UPDATE_DATE
, CPDE.LAST_UPDATE_LOGIN
FROM IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
, IGS_EN_CPD_EXT CPDE
, IGS_LOOKUPS_VIEW LKUPS
WHERE CPDE.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD(+)
AND SRC.S_RULE_TYPE_CD(+) = 'ELGBL'
AND RUD.SEQUENCE_NUMBER(+) = SRC.RUD_SEQUENCE_NUMBER
AND LKUPS.LOOKUP_CODE = CPDE.S_ENROLMENT_STEP_TYPE
AND LKUPS.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'

Columns