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_ICD_SS_CONFIG

Object Details

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

Exchange rates for EFC conversion for CWB.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_ICD_SS_CONFIG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INPUT_VALUE_ID
BEN_ICD_SS_CONFIG_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INPUT_VALUE_ID_CHAR
BEN_ICD_SS_CONFIG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_TYPE_ID	NUMBER	(15)	Yes	Foreign Key to PAY_ELEMENT_TYPES_F
ELEMENT_LINK_ID	NUMBER	(15)		Foreign Key to PAY_ELEMENT_LINKS_F
INPUT_VALUE_ID	NUMBER	(15)	Yes	Foreign key to PAY_INPUT_VALUES_F
UOM	VARCHAR2	(30)		Unit of Measure
SHOW_ON_OVERVIEW_FLAG	VARCHAR2	(30)		Show the input value on the ICD overview page
USER_ENTERABLE_FLAG	VARCHAR2	(30)		User enterable flag
INPUT_VALUE_ID_CHAR	VARCHAR2	(60)		Input value ID in character format
ORDER_NUM	NUMBER	(15)		Display sequence number for the input value.

Query Text

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


SELECT ELEMENT_TYPE_ID
,      ELEMENT_LINK_ID
,      INPUT_VALUE_ID
,      UOM
,      SHOW_ON_OVERVIEW_FLAG
,      USER_ENTERABLE_FLAG
,      INPUT_VALUE_ID_CHAR
,      ORDER_NUM
FROM BEN.BEN_ICD_SS_CONFIG;

Dependencies

[top of page]

BEN.BEN_ICD_SS_CONFIG does not reference any database object

BEN.BEN_ICD_SS_CONFIG is referenced by following:

BEN: BEN_ICD_SS_CONFIG#