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_ROUTES

Object Details

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

FF_ROUTES holds the route definitions that are the FROM and WHERE
clauses of a SQL statement that describe how to access a specific data
item. The complete statement combines this with the definition text
on the database item.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: FF_ROUTES_PK

ROUTE_ID

Unique Key: FF_ROUTES_UK2

ROUTE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
FF_ROUTES_PK	NORMAL	UNIQUE	APPS_TS_SEED	ROUTE_ID
FF_ROUTES_UK2	NORMAL	UNIQUE	APPS_TS_SEED	ROUTE_NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
FF_ROUTE_CONTEXT_USAGES	FF_ROUTES	FF_ROUTE_CONTEXT_USAGES ROUTE_ID
FF_ROUTE_PARAMETERS	FF_ROUTES	FF_ROUTE_PARAMETERS ROUTE_ID
FF_USER_ENTITIES	FF_ROUTES	FF_USER_ENTITIES ROUTE_ID
PAY_BALANCE_DIMENSIONS	FF_ROUTES	PAY_BALANCE_DIMENSIONS ROUTE_ID
PAY_DIMENSION_ROUTES	FF_ROUTES	PAY_DIMENSION_ROUTES ROUTE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ROUTE_ID	NUMBER	(9)	Yes	Unique identifier for the route.
ROUTE_NAME	VARCHAR2	(80)	Yes	Name of the route.
USER_DEFINED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the route should be preserved in upgrades.
DESCRIPTION	VARCHAR2	(240)		Description of what the route does.
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.
TEXT	LONG	(0)		The text of the FROM clause (actually a LONG type).
OPTIMIZER_HINT	VARCHAR2	(2000)		Hint to the Cost Based Optimizer

Query Text

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


SELECT ROUTE_ID
,      ROUTE_NAME
,      USER_DEFINED_FLAG
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TEXT
,      OPTIMIZER_HINT
FROM HR.FF_ROUTES;

Dependencies

[top of page]

HR.FF_ROUTES does not reference any database object

HR.FF_ROUTES is referenced by following:

APPS: FF_ROUTES; FF_ROUTES_WHO
PUBLIC: FF_ROUTES