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

TABLE: BEN.BEN_ROUND_CODE_VALUES_EFC

Object Details
Object Name: BEN_ROUND_CODE_VALUES_EFC
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_ROUND_CODE_VALUES_EFC
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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_ROUND_CODE_VALUES_EFC_PK
  1. ColumnEFC_ACTION_ID
  2. ColumnTABLE_NAME
  3. ColumnPK_ID
  4. ColumnEFFECTIVE_START_DATE
  5. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
BEN_ROUND_CODE_VALUES_EFC_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEFC_ACTION_ID
ColumnTABLE_NAME
ColumnPK_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
EFC_ACTION_ID NUMBER
Yes Foreign Key to HR_EFC_ACTIONS.
TABLE_NAME VARCHAR2 (90) Yes Table name of modified table.
RNDCDCOL_NAME VARCHAR2 (90) Yes Rounding Code column name on the modified table.
PK_ID NUMBER
Yes Primary Key Identifier for modified row.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
RNDCDCOL_VALUE VARCHAR2 (90)
Rounding Code value from the modified table
Query Text

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


SELECT EFC_ACTION_ID
,      TABLE_NAME
,      RNDCDCOL_NAME
,      PK_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RNDCDCOL_VALUE
FROM BEN.BEN_ROUND_CODE_VALUES_EFC;

Dependencies

[top of page]

BEN.BEN_ROUND_CODE_VALUES_EFC does not reference any database object

BEN.BEN_ROUND_CODE_VALUES_EFC is referenced by following:

SchemaBEN
ViewBEN_ROUND_CODE_VALUES_EFC#