[Home] [Help] [Dependency Information]
Object Name: | FF_COMPILED_INFO_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | FF.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FF_COMPILED_INFO_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FORMULA_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
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. |
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;
HR.FF_COMPILED_INFO_F does not reference any database object
HR.FF_COMPILED_INFO_F is referenced by following:
|
|
|