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

TABLE: HR.FF_COMPILED_INFO_F

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


FF_COMPILED_INFO_F is a DateTracked table that holds the executable
code run by the FastFormula execution engine. This is a PL/SQL
program that is generated by the FastFormula compiler.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: FF_COMPILED_INFO_F_PK
  1. ColumnFORMULA_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
FF_COMPILED_INFO_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORMULA_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
FORMULA_ID NUMBER (9) Yes Foreign key to FF_FORMULAS.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
FDIU_ENTRY_COUNT NUMBER (9) Yes Number of formula data item usage, (FDIU) entries for the formula.
SELECT_STATEMENT_COUNT NUMBER (9) Yes Number of separate SELECT statements in the PL/SQL.
TEXT_LENGTH NUMBER (9) Yes Length (in bytes) of the PL/SQL program.
COMPILED_TEXT LONG (0)
The PL/SQL program which represents the user formula.
Query Text

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


SELECT FORMULA_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      FDIU_ENTRY_COUNT
,      SELECT_STATEMENT_COUNT
,      TEXT_LENGTH
,      COMPILED_TEXT
FROM HR.FF_COMPILED_INFO_F;

Dependencies

[top of page]

HR.FF_COMPILED_INFO_F does not reference any database object

HR.FF_COMPILED_INFO_F is referenced by following:

SchemaAPPS
SynonymFF_COMPILED_INFO_F
SchemaPUBLIC
SynonymFF_COMPILED_INFO_F