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_EQUATIONS

Object Details

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

Equation of dynamic calculation, Operator, logical condition etc are stored here.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EQUATION_ID	NUMBER	(15)	Yes	Equation Id
DEFINITION_ID	NUMBER	(15)	Yes	Definition Id
CONDITION_ID	NUMBER	(15)		Condition Id
ORDR_NUM	NUMBER	(15)	Yes	Equation Order
VIEW_ATTRIBUTE	VARCHAR2	(60)		View Object Attribute Name
OPERATOR	VARCHAR2	(30)		Mathematical Operator
LOGICAL	VARCHAR2	(30)		Logical Operator
DATA_TYPE	VARCHAR2	(30)		Data Type
ATTRIBUTE1	VARCHAR2	(60)		Equation Attribute 1
ATTRIBUTE2	VARCHAR2	(60)		Equation Attribute 2
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
VIEW_ATTRIBUTE1	VARCHAR2	(60)		View Attribute1
VIEW_ATTRIBUTE2	VARCHAR2	(60)		View Attribute2

Query Text

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


SELECT EQUATION_ID
,      DEFINITION_ID
,      CONDITION_ID
,      ORDR_NUM
,      VIEW_ATTRIBUTE
,      OPERATOR
,      LOGICAL
,      DATA_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      OBJECT_VERSION_NUMBER
,      VIEW_ATTRIBUTE1
,      VIEW_ATTRIBUTE2
FROM BEN.BEN_CALC_EQUATIONS;

Dependencies

[top of page]

BEN.BEN_CALC_EQUATIONS does not reference any database object

BEN.BEN_CALC_EQUATIONS is referenced by following:

BEN: BEN_CALC_EQUATIONS#