VIEW: APPS.IGS_PE_USR_AVAL

Source

View Text - Preformatted

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) )

View Text - HTML Formatted

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) )