[Home] [Help] [Dependency Information]
Object Name: | FF_DATABASE_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | FF.FF_DATABASE_ITEMS |
Subobject Name: | |
Status: | VALID |
FF_DATABASE_ITEMS holds the definitions of database items that can
be used in formulas. Database items are short names that a user can
use to identify a specific item of data in the database without
knowing specific table or column details. The formula must provide a
sufficient context to enable the select item clause to find the
specific data item. For example, formulas of a type that provide the
context EMPLOYEE_ID might access database items such as EMPLOYEE_NAME
or MANAGER_NAME.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FF_DATABASE_ITEMS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
USER_NAME
USER_ENTITY_ID |
FF_DATABASE_ITEMS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USER_ENTITY_ID |
Table | |
Foreign Table | Foreign Key Column | FF_DATABASE_ITEMS | FF_USER_ENTITIES | FF_DATABASE_ITEMS USER_ENTITY_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_NAME | VARCHAR2 | (240) | Yes | Name of the database item. |
USER_ENTITY_ID | NUMBER | (9) | Yes | Foreign key to FF_USER_ENTITIES. |
DATA_TYPE | VARCHAR2 | (1) | Yes | Data type of the database item. |
DEFINITION_TEXT | VARCHAR2 | (240) | Yes | Select item text for use in the built-up SQL statement. |
NULL_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether a NULL value will cause a formula error. |
DESCRIPTION | VARCHAR2 | (240) | A description of the database item. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT USER_NAME
, USER_ENTITY_ID
, DATA_TYPE
, DEFINITION_TEXT
, NULL_ALLOWED_FLAG
, DESCRIPTION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.FF_DATABASE_ITEMS;
HR.FF_DATABASE_ITEMS does not reference any database object
HR.FF_DATABASE_ITEMS is referenced by following:
|
|
|