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: BEN.BEN_CALC_DEFINITIONS

Object Details

Object Name:	BEN_CALC_DEFINITIONS
Object Type:	TABLE
Owner:	BEN
FND Design Data:	BEN.BEN_CALC_DEFINITIONS
Subobject Name:
Status:	VALID

Definition of a dynamic calculation is stored here.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_CALC_DEFINITIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KEY_TYPE DEF_KEY VIEW_ATTRIBUTE

Columns

Name	Datatype	Length	Mandatory	Comments
DEFINITION_ID	NUMBER	(15)	Yes	Definition Id
DEF_KEY	NUMBER	(15)	Yes	Definition Key
KEY_TYPE	VARCHAR2	(30)	Yes	Definition Key Type
VIEW_ATTRIBUTE	VARCHAR2	(60)	Yes	View Object Attribute Name
EXE_ORDR	NUMBER	(15)	Yes	Execution Order
CALC_TYPE	VARCHAR2	(30)		Calculation Type
RNDG_CD	VARCHAR2	(30)		Rounding Code
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number

Query Text

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


SELECT DEFINITION_ID
,      DEF_KEY
,      KEY_TYPE
,      VIEW_ATTRIBUTE
,      EXE_ORDR
,      CALC_TYPE
,      RNDG_CD
,      OBJECT_VERSION_NUMBER
FROM BEN.BEN_CALC_DEFINITIONS;

Dependencies

[top of page]

BEN.BEN_CALC_DEFINITIONS does not reference any database object

BEN.BEN_CALC_DEFINITIONS is referenced by following:

APPS: BEN_CALC_DEFINITIONS