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]

TABLE: HR.FF_USER_ENTITIES

Object Details

Object Name:	FF_USER_ENTITIES
Object Type:	TABLE
Owner:	HR
FND Design Data:	FF.FF_USER_ENTITIES
Subobject Name:
Status:	VALID

FF_USER_ENTITIES holds the specific table and selection criteria
combination that are used in the definition of a database item.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: FF_USER_ENTITIES_PK

USER_ENTITY_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
FF_USER_ENTITIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ENTITY_ID
FF_USER_ENTITIES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTE_ID
FF_USER_ENTITIES_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_ENTITY_NAME
FF_USER_ENTITIES_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATOR_ID CREATOR_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
FF_USER_ENTITIES	FF_ROUTES	FF_USER_ENTITIES ROUTE_ID
FF_DATABASE_ITEMS	FF_USER_ENTITIES	FF_DATABASE_ITEMS USER_ENTITY_ID
FF_ROUTE_PARAMETER_VALUES	FF_USER_ENTITIES	FF_ROUTE_PARAMETER_VALUES USER_ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ENTITY_ID	NUMBER	(9)	Yes	Unique identifier for the user entity.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	VARCHAR2	(30)		Foreign key to FND_TERRITORIES.
ROUTE_ID	NUMBER	(9)	Yes	Foreign key to FF_ROUTES.
NOTFOUND_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Indicates whether no rows found is acceptable for the sql for the user entity.
USER_ENTITY_NAME	VARCHAR2	(240)	Yes	Name of the user entity.
CREATOR_ID	NUMBER	(9)		Foreign key to table identified by creator type
CREATOR_TYPE	VARCHAR2	(30)		An indication of what created the user entity.
ENTITY_DESCRIPTION	VARCHAR2	(240)		Description of the user entity.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

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


SELECT USER_ENTITY_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ROUTE_ID
,      NOTFOUND_ALLOWED_FLAG
,      USER_ENTITY_NAME
,      CREATOR_ID
,      CREATOR_TYPE
,      ENTITY_DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.FF_USER_ENTITIES;

Dependencies

[top of page]

HR.FF_USER_ENTITIES does not reference any database object

HR.FF_USER_ENTITIES is referenced by following:

APPS: FF_USER_ENTITIES; FF_USER_ENTITIES_ARD; FF_USER_ENTITIES_BRD; FF_USER_ENTITIES_BRI; FF_USER_ENTITIES_BRU; FF_USER_ENTITIES_WHO
PUBLIC: FF_USER_ENTITIES