View: IGS_EN_CAT_PRC_STEP_LKUP_V

Product:	IGS - Student System
Description:	This view performs a look up for the category procedure based on a specific enrolment step type.
Implementation/DBA Data:	APPS.IGS_EN_CAT_PRC_STEP_LKUP_V

View Text

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'

Columns