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


TABLE: HR.FF_FUNCTION_CONTEXT_USAGES

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


FF_FUNCTION_CONTEXT_USAGES describes the contexts which are
required by a function. Contexts are passed to the function before
any function parameters.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: FF_FUNCTION_CONTEXT_USAGES_PK
  1. ColumnFUNCTION_ID
  2. ColumnSEQUENCE_NUMBER
Unique Key: FF_FUNCTION_CONTEXT_USAGES_UK2
  1. ColumnFUNCTION_ID
  2. ColumnCONTEXT_ID
Indexes
Index Type Uniqueness Tablespace Column
FF_FUNCTION_CONTEXT_USAGES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUNCTION_ID
ColumnSEQUENCE_NUMBER
FF_FUNCTION_CONTEXT_USAGES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUNCTION_ID
ColumnCONTEXT_ID
FF_FUNCTION_CONTEXT_USAGES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTEXT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FF_FUNCTION_CONTEXT_USAGES FF_FUNCTION_CONTEXT_USAGES_FK2 TableFF_CONTEXTS FF_FUNCTION_CONTEXT_USAGES CONTEXT_ID
FF_FUNCTION_CONTEXT_USAGES FF_FUNCTION_CONTEXT_USAGES_FK1 TableFF_FUNCTIONS FF_FUNCTION_CONTEXT_USAGES FUNCTION_ID
Columns
Name Datatype Length Mandatory Comments
FUNCTION_ID NUMBER (9) Yes Foreign key to FF_FUNCTIONS.
SEQUENCE_NUMBER NUMBER (2) Yes Sequence number of the context usage.
CONTEXT_ID NUMBER (9) Yes Foreign key to FF_CONTEXTS.
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.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
Query Text

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


SELECT FUNCTION_ID
,      SEQUENCE_NUMBER
,      CONTEXT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.FF_FUNCTION_CONTEXT_USAGES;

Dependencies

[top of page]

HR.FF_FUNCTION_CONTEXT_USAGES does not reference any database object

HR.FF_FUNCTION_CONTEXT_USAGES is referenced by following:

SchemaAPPS
SynonymFF_FUNCTION_CONTEXT_USAGES
TriggerFF_FUNCTION_CONTEXT_USAGES_OVN
TriggerFF_FUNCTION_CONTEXT_USAGES_WHO
SchemaPUBLIC
SynonymFF_FUNCTION_CONTEXT_USAGES