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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_EN_VALIDITY_ACTVT_SETUPS

Object Details

Object Name:	IGSFV_EN_VALIDITY_ACTVT_SETUPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_EN_VALIDITY_ACTVT_SETUPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity gives the information about the self service user activity setup for enrollment validations

[View Source]

Columns

Name	Datatype	Length	Comments
USER_ACTIVITY_VALIDATION_ID	NUMBER	(15)	System generated number to uniquely identify the self service user activity setup for enrollment validation
PERSON_TYPE	VARCHAR2	(30)	Indicates the system-defined person type for which the user activity setup has been done
PERSON_TYPE_DESC	VARCHAR2	(240)	Gives information about the system defined person type for which the user activity setup has been done
VALIDATION	VARCHAR2	(30)	Indicates the validation code to be enforced on the person type
_LA:VALIDATION_DESCRIPTION	CHAR	(64)	Indicates the validation description to be enforced on the person type
DENY_WARN_INDICATOR	VARCHAR2	(10)	Indicates whether the step has been denied or warned
OVERRIDE_FLAG	VARCHAR2	(1)	Indicates whether the step has been overridden or not
_LA:OVERRIDE_FLAG_DESC	CHAR	(49)	Indicates the description of Override Flag
OVERRIDE_DATE	DATE		Indicates the date on which the step was overridden
STEP_OVERRIDE_LIMIT	NUMBER	(6)	Override limit, used to create variable credit approval
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_ACTIVITY_VALIDATION_ID
,      PERSON_TYPE
,      PERSON_TYPE_DESC
,      VALIDATION
,      _LA:VALIDATION_DESCRIPTION
,      DENY_WARN_INDICATOR
,      OVERRIDE_FLAG
,      _LA:OVERRIDE_FLAG_DESC
,      OVERRIDE_DATE
,      STEP_OVERRIDE_LIMIT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_EN_VALIDITY_ACTVT_SETUPS;

Dependencies

[top of page]

APPS.IGSFV_EN_VALIDITY_ACTVT_SETUPS references the following:

APPS: FND_LOOKUP_VALUES; IGS_PE_PERSON_TYPES; IGS_PE_USR_AVAL_ALL

APPS.IGSFV_EN_VALIDITY_ACTVT_SETUPS is not referenced by any database object