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

TABLE: HR.FF_ROUTE_CONTEXT_USAGES

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


FF_ROUTE_CONTEXT_USAGES holds the single usage of a context as a
bind variable in the ROUTE SQL statement.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: FF_ROUTE_CONTEXT_USAGES_PK
  1. ColumnROUTE_ID
  2. ColumnCONTEXT_ID
Unique Key: FF_ROUTE_CONTEXT_USAGES_UK2
  1. ColumnROUTE_ID
  2. ColumnSEQUENCE_NO
Indexes
Index Type Uniqueness Tablespace Column
FF_ROUTE_CONTEXT_USAGES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_ID
ColumnCONTEXT_ID
FF_ROUTE_CONTEXT_USAGES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_ID
ColumnSEQUENCE_NO
FF_ROUTE_CONTEXT_USAGES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCONTEXT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FF_ROUTE_CONTEXT_USAGES FF_ROUTE_CONTEXT_USAGES_FK1 TableFF_CONTEXTS FF_ROUTE_CONTEXT_USAGES CONTEXT_ID
FF_ROUTE_CONTEXT_USAGES FF_ROUTE_CONTEXT_USAGES_FK2 TableFF_ROUTES FF_ROUTE_CONTEXT_USAGES ROUTE_ID
Columns
Name Datatype Length Mandatory Comments
ROUTE_ID NUMBER (9) Yes Foreign key to FF_ROUTES.
CONTEXT_ID NUMBER (9) Yes Foreign key to FF_CONTEXTS.
SEQUENCE_NO NUMBER (9) Yes Cross reference to the contexts place in the FROM text.
Query Text

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


SELECT ROUTE_ID
,      CONTEXT_ID
,      SEQUENCE_NO
FROM HR.FF_ROUTE_CONTEXT_USAGES;

Dependencies

[top of page]

HR.FF_ROUTE_CONTEXT_USAGES does not reference any database object

HR.FF_ROUTE_CONTEXT_USAGES is referenced by following:

SchemaAPPS
SynonymFF_ROUTE_CONTEXT_USAGES
TriggerFF_ROUTE_CONTEXT_USAGES_BRD
TriggerFF_ROUTE_CONTEXT_USAGES_BRI
SchemaPUBLIC
SynonymFF_ROUTE_CONTEXT_USAGES