eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.FF_GLOBALS_F

Object Details

Object Name:	FF_GLOBALS_F
Object Type:	TABLE
Owner:	HR
FND Design Data:	FF.FF_GLOBALS_F
Subobject Name:
Status:	VALID

FF_GLOBALS_F is a DateTracked table which holds the definitions and
actual values for global values. Global values are enterprise level
data items that are available to all formulas.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: FF_GLOBALS_F_PK

GLOBAL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Unique Key: FF_GLOBALS_F_UK2

GLOBAL_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
FF_GLOBALS_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GLOBAL_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
FF_GLOBALS_F_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	GLOBAL_NAME BUSINESS_GROUP_ID LEGISLATION_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
GLOBAL_ID	NUMBER	(9)	Yes	Unique identifier for global variable.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	VARCHAR2	(30)		Foreign key to FND_TERRITORIES.
DATA_TYPE	VARCHAR2	(1)	Yes	Describes the data type of the global.
GLOBAL_NAME	VARCHAR2	(80)	Yes	User name for the global variable.
GLOBAL_DESCRIPTION	VARCHAR2	(240)		Description of the global variable.
GLOBAL_VALUE	VARCHAR2	(240)		Holds the actual value of the global variable.
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 GLOBAL_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      DATA_TYPE
,      GLOBAL_NAME
,      GLOBAL_DESCRIPTION
,      GLOBAL_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.FF_GLOBALS_F;

Dependencies

[top of page]

HR.FF_GLOBALS_F does not reference any database object

HR.FF_GLOBALS_F is referenced by following:

APPS: FF_GLOBALS_F; FF_GLOBALS_F_AD; FF_GLOBALS_F_ASD; FF_GLOBALS_F_BD; FF_GLOBALS_F_BRD; FF_GLOBALS_F_BRI; FF_GLOBALS_F_BRU; FF_GLOBALS_F_BSD; FF_GLOBALS_F_MNT_TL_ARI; FF_GLOBALS_F_MNT_TL_ARU; FF_GLOBALS_F_MNT_TL_ASD; FF_GLOBALS_F_MNT_TL_ASI; FF_GLOBALS_F_MNT_TL_BRD; FF_GLOBALS_F_OVN; FF_GLOBALS_F_WHO
PUBLIC: FF_GLOBALS_F