[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
---|
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 |
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;
HR.FF_ROUTES does not reference any database object
HR.FF_ROUTES is referenced by following:
|
|
|