VIEW: APPS.IGS_PE_USR_AVAL_V

Source

View Text - Preformatted

SELECT UAV.ROW_ID ROW_ID, UAV.USR_ACT_VAL_ID USR_ACT_VAL_ID, UAV.PERSON_TYPE PERSON_TYPE, UAV.VALIDATION VALIDATION, LKV.MEANING VAL_MEANING, LKV.STEP_GROUP_TYPE STEP_GROUP_TYPE, UAV.DENY_WARN DENY_WARN, UAV.OVERRIDE_IND OVERRIDE_IND, UAV.OVERRIDE_DT OVERRIDE_DT, UAV.STEP_OVERRIDE_LIMIT 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 UAV, IGS_LOOKUPS_VIEW LKV WHERE LKV.LOOKUP_CODE = UAV.VALIDATION AND LKV.CLOSED_IND <> 'Y' AND ( LKV.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT' OR LKV.LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE')

View Text - HTML Formatted

SELECT UAV.ROW_ID ROW_ID
, UAV.USR_ACT_VAL_ID USR_ACT_VAL_ID
, UAV.PERSON_TYPE PERSON_TYPE
, UAV.VALIDATION VALIDATION
, LKV.MEANING VAL_MEANING
, LKV.STEP_GROUP_TYPE STEP_GROUP_TYPE
, UAV.DENY_WARN DENY_WARN
, UAV.OVERRIDE_IND OVERRIDE_IND
, UAV.OVERRIDE_DT OVERRIDE_DT
, UAV.STEP_OVERRIDE_LIMIT 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 UAV
, IGS_LOOKUPS_VIEW LKV
WHERE LKV.LOOKUP_CODE = UAV.VALIDATION
AND LKV.CLOSED_IND <> 'Y'
AND ( LKV.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT' OR LKV.LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE')