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_HARNESS

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: FF_HARNESS_PK

TEST_ID
FORMULA_ID
ITEM_NAME
USAGE

Indexes

Index	Type	Uniqueness	Tablespace	Column
FF_HARNESS_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	TEST_ID FORMULA_ID ITEM_NAME USAGE
FF_HARNESS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	FORMULA_ID ITEM_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TEST_ID	NUMBER	(9)	Yes	Unique identifier for a test formula run.
FORMULA_ID	NUMBER	(9)	Yes	Foreign key to FF_FORMULAS.
ITEM_NAME	VARCHAR2	(80)	Yes	Foreign key to FF_FDI_USAGES.
USAGE	VARCHAR2	(1)	Yes	Denormalised from formula data item usages.
DATA_TYPE	VARCHAR2	(1)	Yes	Denormalised from formula data item usages.
INDICATOR	NUMBER	(9)		Indicator which identifies order of values in return statement.
VALUE	VARCHAR2	(240)		Value of item before and/or after running formula.
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.

Query Text

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


SELECT TEST_ID
,      FORMULA_ID
,      ITEM_NAME
,      USAGE
,      DATA_TYPE
,      INDICATOR
,      VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.FF_HARNESS;

Dependencies

[top of page]

HR.FF_HARNESS does not reference any database object

HR.FF_HARNESS is referenced by following:

APPS: FF_HARNESS; FF_HARNESS_WHO
PUBLIC: FF_HARNESS