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_DM_TABLES

Object Details

Object Name:	BEN_DM_TABLES
Object Type:	TABLE
Owner:	BEN
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_DM_TABLES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TABLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_ID	NUMBER	(15)	Yes	Primary Key
TABLE_NAME	VARCHAR2	(30)		Name of the table
UPLOAD_TABLE_NAME	VARCHAR2	(30)		Name of the table as used by the TUPS. If the value is NULL then the TABLE_NAME is used.
TABLE_ALIAS	VARCHAR2	(30)		The cursor alias for the table
DATETRACK	VARCHAR2	(30)		A flag used to indicate if the table is data tracked, Y, or not data tracked, N
DERIVE_SQL	VARCHAR2	(4000)		The where clause of the select statement for person migration
SURROGATE_PK_COLUMN_NAME	VARCHAR2	(30)		Surrogate primary key column name for the table.
SHORT_NAME	VARCHAR2	(30)		A short form of the table name for use in dynamic SQL
LAST_GENERATED_DATE	DATE			The date of the last successful generation of the TDS;TUDS packages for this table
GENERATOR_VERSION	VARCHAR2	(2000)		The version details of the main generator
SEQUENCE_NAME	VARCHAR2	(30)		The sequence to be used to generate a new value for the primary key
LAST_UPDATE_DATE	DATE			WHO column
LAST_UPDATED_BY	NUMBER	(15)		WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column
CREATED_BY	NUMBER	(15)		WHO column
CREATION_DATE	DATE			WHO column

Query Text

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


SELECT TABLE_ID
,      TABLE_NAME
,      UPLOAD_TABLE_NAME
,      TABLE_ALIAS
,      DATETRACK
,      DERIVE_SQL
,      SURROGATE_PK_COLUMN_NAME
,      SHORT_NAME
,      LAST_GENERATED_DATE
,      GENERATOR_VERSION
,      SEQUENCE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_DM_TABLES;

Dependencies

[top of page]

BEN.BEN_DM_TABLES does not reference any database object

BEN.BEN_DM_TABLES is referenced by following:

APPS: BEN_DM_TABLES; BEN_DM_TABLES_WHO