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

TABLE: HR.FF_ROUTE_PARAMETERS

Object Details
Object Name: FF_ROUTE_PARAMETERS
Object Type: TABLE
Owner: HR
FND Design Data: TableFF.FF_ROUTE_PARAMETERS
Subobject Name:
Status: VALID


FF_ROUTE_PARAMETERS holds the parameters that can be passed to a
route and their sequence number when used by the route. These
restrict the number of rows returned by the route.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: FF_ROUTE_PARAMETERS_PK
  1. ColumnROUTE_PARAMETER_ID
Unique Key: FF_ROUTE_PARAMETERS_UK2
  1. ColumnROUTE_ID
  2. ColumnSEQUENCE_NO
Unique Key: FF_ROUTE_PARAMETERS_UK3
  1. ColumnPARAMETER_NAME
  2. ColumnROUTE_ID
Indexes
Index Type Uniqueness Tablespace Column
FF_ROUTE_PARAMETERS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_PARAMETER_ID
FF_ROUTE_PARAMETERS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_ID
ColumnSEQUENCE_NO
FF_ROUTE_PARAMETERS_UK3 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPARAMETER_NAME
ColumnROUTE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FF_ROUTE_PARAMETERS FF_ROUTE_PARAMETERS_FK1 TableFF_ROUTES FF_ROUTE_PARAMETERS ROUTE_ID
TableFF_ROUTE_PARAMETER_VALUES FF_ROUTE_PARAMETER_VALUES_FK2 FF_ROUTE_PARAMETERS FF_ROUTE_PARAMETER_VALUES ROUTE_PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
ROUTE_PARAMETER_ID NUMBER (9) Yes Unique identifier for a route parameter.
ROUTE_ID NUMBER (9) Yes Foreign key to FF_ROUTES.
DATA_TYPE VARCHAR2 (1) Yes Data type of the parameter. N for number, T for text, D for date.
PARAMETER_NAME VARCHAR2 (40) Yes Name of the parameter, for information only.
SEQUENCE_NO NUMBER (9) Yes Number of the parameter as used in the route text.
Query Text

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


SELECT ROUTE_PARAMETER_ID
,      ROUTE_ID
,      DATA_TYPE
,      PARAMETER_NAME
,      SEQUENCE_NO
FROM HR.FF_ROUTE_PARAMETERS;

Dependencies

[top of page]

HR.FF_ROUTE_PARAMETERS does not reference any database object

HR.FF_ROUTE_PARAMETERS is referenced by following:

SchemaAPPS
SynonymFF_ROUTE_PARAMETERS
TriggerFF_ROUTE_PARAMETERS_BRI
TriggerFF_ROUTE_PARAMETERS_BRUD
SchemaPUBLIC
SynonymFF_ROUTE_PARAMETERS