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


TABLE: HR.FF_CONTEXTS

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


FF_CONTEXTS holds details of the contexts that can be passed into a
formula to describe the objects the formula can act on. Each
context is a unique identifier within an application such as
employee or assignment number.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: FF_CONTEXTS_PK
  1. ColumnCONTEXT_ID
Unique Key: FF_CONTEXTS_UK2
  1. ColumnCONTEXT_NAME
Indexes
Index Type Uniqueness Tablespace Column
FF_CONTEXTS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCONTEXT_ID
FF_CONTEXTS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCONTEXT_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableFF_FTYPE_CONTEXT_USAGES FF_FTYPE_CONTEXT_USAGES_FK2 FF_CONTEXTS FF_FTYPE_CONTEXT_USAGES CONTEXT_ID
TableFF_FUNCTION_CONTEXT_USAGES FF_FUNCTION_CONTEXT_USAGES_FK2 FF_CONTEXTS FF_FUNCTION_CONTEXT_USAGES CONTEXT_ID
TableFF_ROUTE_CONTEXT_USAGES FF_ROUTE_CONTEXT_USAGES_FK1 FF_CONTEXTS FF_ROUTE_CONTEXT_USAGES CONTEXT_ID
TablePAY_ACTION_CONTEXTS PAY_ACTION_CONTEXTS_FK1 FF_CONTEXTS PAY_ACTION_CONTEXTS CONTEXT_ID
TablePAY_BALANCE_CONTEXT_VALUES PAY_BALANCE_CONTEXT_VALUES_FK1 FF_CONTEXTS PAY_BALANCE_CONTEXT_VALUES CONTEXT_ID
Columns
Name Datatype Length Mandatory Comments
CONTEXT_ID NUMBER (9) Yes Unique identifier for the context.
CONTEXT_LEVEL NUMBER (16) Yes A power of 2 number which is unique to a context.
CONTEXT_NAME VARCHAR2 (30) Yes Name of the context.
DATA_TYPE VARCHAR2 (1) Yes Data type (N,T or D) of the context.
Query Text

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


SELECT CONTEXT_ID
,      CONTEXT_LEVEL
,      CONTEXT_NAME
,      DATA_TYPE
FROM HR.FF_CONTEXTS;

Dependencies

[top of page]

HR.FF_CONTEXTS does not reference any database object

HR.FF_CONTEXTS is referenced by following:

SchemaAPPS
SynonymFF_CONTEXTS
TriggerFF_CONTEXTS_BRD
TriggerFF_CONTEXTS_BRI
TriggerFF_CONTEXTS_BRU
SchemaPUBLIC
SynonymFF_CONTEXTS