VIEW: APPS.IGS_EN_CPD_EXT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'