eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSFV_EN_VALIDITY_ACTVT_SETUPS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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