[Home] [Help] [Dependency Information]
Object Name: | FF_FDI_USAGES_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | FF.FF_FDI_USAGES_F |
Subobject Name: | |
Status: | VALID |
FF_FDI_USAGES_F is a DateTracked table that holds one entry for
every data item used in a specific formula. It is generated by the
FastFormula compiler from the user defined formula.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FF_FDI_USAGES_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FORMULA_ID
ITEM_NAME EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
FF_FDI_USAGES_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ROUTE_ID |
FF_FDI_USAGES_F_N50 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ITEM_NAME |
FF_FDI_USAGES_F_N51 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ALTERNATIVE_ITEM_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_ID | NUMBER | (9) | Yes | Foreign key to FF_FORMULAS. |
ITEM_NAME | VARCHAR2 | (240) | Yes | Name of the item the usage is for. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
DATA_TYPE | VARCHAR2 | (1) | Yes | Data type of the data item. |
ITEM_GENERATED_NAME | VARCHAR2 | (30) | Yes | System generated PL/SQL bind variable for the item. |
LOAD_WHEN_RUNNING | VARCHAR2 | (1) | Yes | Y or N flag that indicates whether item gets loaded at runtime. |
USAGE | VARCHAR2 | (1) | Yes | Subtype field (D, G, L, I, O, B, U). |
CONTEXT_LEVEL_SUM | NUMBER | (16) | Number representing the context usage of an item. | |
INDICATOR_VAR_NAME | VARCHAR2 | (30) | Generated PL/SQL bind variable for use as a flexfield indicator variable. | |
GLOBAL_ID | NUMBER | (9) | Foreign key to FF_GLOBALS. | |
CONTEXT_ID | NUMBER | (9) | Foreign key to FF_CONTEXTS for a context usage. Hash key for database item cache for a database item usage. | |
ALTERNATIVE_ITEM_NAME | VARCHAR2 | (240) | Alternative name for this item. | |
ROUTE_ID | NUMBER | (9) | Foreign key to FF_ROUTES. |
Cut, paste (and edit) the following text to query this object:
SELECT FORMULA_ID
, ITEM_NAME
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DATA_TYPE
, ITEM_GENERATED_NAME
, LOAD_WHEN_RUNNING
, USAGE
, CONTEXT_LEVEL_SUM
, INDICATOR_VAR_NAME
, GLOBAL_ID
, CONTEXT_ID
, ALTERNATIVE_ITEM_NAME
, ROUTE_ID
FROM HR.FF_FDI_USAGES_F;
HR.FF_FDI_USAGES_F does not reference any database object
HR.FF_FDI_USAGES_F is referenced by following:
|
|
|