View: IGSFV_EN_VALIDITY_ACTVT_SETUPS

Product:	IGS - Student System
Description:	This entity gives the information about the self service user activity setup for enrollment validations
Implementation/DBA Data:	APPS.IGSFV_EN_VALIDITY_ACTVT_SETUPS

View Text

SELECT UAVV1.USR_ACT_VAL_ID
, UAVV1.PERSON_TYPE
, PTY.DESCRIPTION
, UAVV1.VALIDATION
, '_LA:VALIDATION:IGS_LOOKUP_VALUES:ENROLMENT_STEP_TYPE_EXT:MEANING'
, UAVV1.DENY_WARN
, UAVV1.OVERRIDE_IND
, '_LA:OVERRIDE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UAVV1.OVERRIDE_DT
, UAVV1.STEP_OVERRIDE_LIMIT
, UAVV1.CREATED_BY
, UAVV1.CREATION_DATE
, UAVV1.LAST_UPDATED_BY
, UAVV1.LAST_UPDATE_DATE
FROM IGS_PE_USR_AVAL_ALL UAVV1
, IGS_PE_PERSON_TYPES PTY
, FND_LOOKUP_VALUES LVAL
WHERE UAVV1.PERSON_TYPE = PTY.PERSON_TYPE_CODE
AND UAVV1.VALIDATION = LVAL.LOOKUP_CODE
AND LVAL.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'
AND LVAL.VIEW_APPLICATION_ID (+) = 8405
AND LVAL.LANGUAGE (+) = USERENV ('LANG')
AND LVAL.SECURITY_GROUP_ID (+) = 0
AND LVAL.ENABLED_FLAG = 'Y' UNION SELECT UAVV.USR_ACT_VAL_ID
, UAVV.PERSON_TYPE
, PTY.DESCRIPTION
, UAVV.VALIDATION
, '_LA:VALIDATION:IGS_LOOKUP_VALUES:ENROLMENT_OVR_STEP_TYPE:MEANING'
, UAVV.DENY_WARN
, UAVV.OVERRIDE_IND
, '_LA:OVERRIDE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UAVV.OVERRIDE_DT
, UAVV.STEP_OVERRIDE_LIMIT
, UAVV.CREATED_BY
, UAVV.CREATION_DATE
, UAVV.LAST_UPDATED_BY
, UAVV.LAST_UPDATE_DATE
FROM IGS_PE_USR_AVAL_ALL UAVV
, IGS_PE_PERSON_TYPES PTY
, FND_LOOKUP_VALUES LVAL
WHERE UAVV.PERSON_TYPE = PTY.PERSON_TYPE_CODE
AND UAVV.VALIDATION = LVAL.LOOKUP_CODE
AND LVAL.LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE'
AND LVAL.VIEW_APPLICATION_ID (+) = 8405
AND LVAL.LANGUAGE (+) = USERENV ('LANG')
AND LVAL.SECURITY_GROUP_ID (+) = 0
AND LVAL.ENABLED_FLAG = 'Y' WITH READ ONLY

Columns