VIEW: APPS.IGS_EN_CAT_PRC_STEP_LKUP_V

Source

View Text - Preformatted

SELECT ecps.row_id ROW_ID, ecps.ENROLMENT_CAT ENROLMENT_CAT, ecps.s_student_comm_type s_student_comm_type, ecps.ENR_METHOD_TYPE ENR_METHOD_TYPE, ecps.s_enrolment_step_type s_enrolment_step_type, ecps.step_order_num step_order_num, ecps.mandatory_step_ind mandatory_step_ind, lkups.MEANING MEANING, lkups.CLOSED_IND CLOSED_ind, lkups.step_group_type STEP_GROUP_TYPE, ecps.CREATED_BY CREATED_BY, ecps.CREATION_DATE CREATION_DATE, ecps.LAST_UPDATED_BY LAST_UPDATED_BY, ecps.LAST_UPDATE_DATE LAST_UPDATE_DATE, ecps.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_EN_CAT_PRC_STEP ecps, IGS_LOOKUPS_VIEW lkups WHERE lkups.LOOKUP_CODE = ecps.s_enrolment_step_type and lkups.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE'

View Text - HTML Formatted

SELECT ECPS.ROW_ID ROW_ID
, ECPS.ENROLMENT_CAT ENROLMENT_CAT
, ECPS.S_STUDENT_COMM_TYPE S_STUDENT_COMM_TYPE
, ECPS.ENR_METHOD_TYPE ENR_METHOD_TYPE
, ECPS.S_ENROLMENT_STEP_TYPE S_ENROLMENT_STEP_TYPE
, ECPS.STEP_ORDER_NUM STEP_ORDER_NUM
, ECPS.MANDATORY_STEP_IND MANDATORY_STEP_IND
, LKUPS.MEANING MEANING
, LKUPS.CLOSED_IND CLOSED_IND
, LKUPS.STEP_GROUP_TYPE STEP_GROUP_TYPE
, ECPS.CREATED_BY CREATED_BY
, ECPS.CREATION_DATE CREATION_DATE
, ECPS.LAST_UPDATED_BY LAST_UPDATED_BY
, ECPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ECPS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_CAT_PRC_STEP ECPS
, IGS_LOOKUPS_VIEW LKUPS
WHERE LKUPS.LOOKUP_CODE = ECPS.S_ENROLMENT_STEP_TYPE
AND LKUPS.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE'