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.BEN_ELIGY_CRIT_VALUES_D

Object Details

Object Name:	BEN_ELIGY_CRIT_VALUES_D
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_ELIGY_CRIT_VALUES_D
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ELIGY_CRIT_VALUES_ID	NUMBER	(15)		System Generated Primary Key Column
ELIGY_PRFL_NAME	VARCHAR2	(240)	Yes
ELIGY_CRITERIA_NAME	VARCHAR2	(240)	Yes	Name of the New Criteria.
EFFECTIVE_START_DATE	DATE			Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
ORDR_NUM	NUMBER	(15)		Order Number of Record
NUMBER_VALUE1	NUMBER			Number Criteria Value. E.g. id
NUMBER_VALUE2	NUMBER			Number Criteria Value. E.g. id
NUMBER_VALUE3	VARCHAR2	(240)
NUMBER_VALUE4	VARCHAR2	(240)
CHAR_VALUE1	DATE			Character Criteria Value. E.g. lookup Codes
CHAR_VALUE2	DATE			Character criteria Values. E.g. Lookup Codes
CHAR_VALUE3	VARCHAR2	(80)	Yes
CHAR_VALUE4	VARCHAR2	(30)
DATE_VALUE1	VARCHAR2	(240)		Date Criteria Value
DATE_VALUE2	VARCHAR2	(240)		Date Criteria Value
DATE_VALUE3	NUMBER
DATE_VALUE4	NUMBER
EXCLD_FLAG	DATE			Exclude Y or N
LEGISLATION_CODE	DATE			Foreign key to FND_TERRITORIES
CRITERIA_SCORE	NUMBER
CRITERIA_WEIGHT	NUMBER
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row
LAST_UPDATED_BY	VARCHAR2	(100)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)

Query Text

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


SELECT ELIGY_CRIT_VALUES_ID
,      ELIGY_PRFL_NAME
,      ELIGY_CRITERIA_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ORDR_NUM
,      NUMBER_VALUE1
,      NUMBER_VALUE2
,      NUMBER_VALUE3
,      NUMBER_VALUE4
,      CHAR_VALUE1
,      CHAR_VALUE2
,      CHAR_VALUE3
,      CHAR_VALUE4
,      DATE_VALUE1
,      DATE_VALUE2
,      DATE_VALUE3
,      DATE_VALUE4
,      EXCLD_FLAG
,      LEGISLATION_CODE
,      CRITERIA_SCORE
,      CRITERIA_WEIGHT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.BEN_ELIGY_CRIT_VALUES_D;

Dependencies

[top of page]

APPS.BEN_ELIGY_CRIT_VALUES_D references the following:

APPS: BEN_ELIGY_CRITERIA; BEN_ELIGY_CRIT_VALUES_F; BEN_ELIGY_PRFL_F; FND_USER; HR_API - show dependent code; HR_LOOKUPS

APPS.BEN_ELIGY_CRIT_VALUES_D is not referenced by any database object