View: IGS_PE_USR_AVAL

Product:	IGS - Student System
Description:	Describes all the columns related to self service user activity setup for enrollment validations
Implementation/DBA Data:	APPS.IGS_PE_USR_AVAL

View Text

SELECT UAV.ROWID ROW_ID
, UAV.USR_ACT_VAL_ID USR_ACT_VAL_ID
, UAV.PERSON_TYPE PERSON_TYPE
, UAV.VALIDATION VALIDATION
, LKV.MEANING VAL_MEANING
, UAV.DENY_WARN
, UAV.OVERRIDE_IND
, UAV.OVERRIDE_DT
, UAV.ORG_ID
, UAV.STEP_OVERRIDE_LIMIT
, UAV.CREATED_BY CREATED_BY
, UAV.CREATION_DATE CREATION_DATE
, UAV.LAST_UPDATED_BY LAST_UPDATED_BY
, UAV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UAV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PE_USR_AVAL_ALL UAV
, IGS_LOOKUP_VALUES LKV
WHERE LKV.LOOKUP_CODE = UAV.VALIDATION
AND ( LKV.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT' OR LKV.LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE')
AND LKV.CLOSED_IND <> 'Y'
AND (NVL (UAV.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) )

Columns