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

TABLE: HR.FF_ROUTES

Object Details
Object Name: FF_ROUTES
Object Type: TABLE
Owner: HR
FND Design Data: TableFF.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: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FF_ROUTES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_ID
ColumnZD_EDITION_NAME
FF_ROUTES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_NAME
ColumnZD_EDITION_NAME
SYS_IL0000034222C00010$$ LOB UNIQUE TablespaceAPPS_TS_SEED
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 CLOB (4000)
The text of the FROM clause (actually a LONG type).
OPTIMIZER_HINT VARCHAR2 (2000)
Hint to the Cost Based Optimizer
ZD_EDITION_NAME VARCHAR2 (30) Yes
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
,      ZD_EDITION_NAME
FROM HR.FF_ROUTES;

Dependencies

[top of page]

HR.FF_ROUTES does not reference any database object

HR.FF_ROUTES is referenced by following:

SchemaHR
ViewFF_ROUTES#