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: BIS.EDW_SIZE_INPUT

Object Details

Object Name:	EDW_SIZE_INPUT
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.EDW_SIZE_INPUT
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:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_NAME	VARCHAR2	(70)	Yes	Physical name of the table
TABLE_OWNER	VARCHAR2	(30)	Yes
TABLE_TYPE	VARCHAR2	(30)	Yes
TABLE_LOGICAL_NAME	VARCHAR2	(240)	Yes
NUM_ROWS_PROC_NAME	VARCHAR2	(120)	Yes	Procedure name to count number of rows
ROW_LEN_PROC_NAME	VARCHAR2	(120)	Yes	Procedure name to estimate the average row length
NUM_OF_LEVELS	NUMBER
AVG_ROW_LEN1	NUMBER			Average Row Length of the increasing part
AVG_ROW_LEN2	NUMBER			Average Row Length of indexes of staging table
AVG_ROW_LEN3	NUMBER			Average Row Length of indexes of a fact or Average Row Length of increasing part of level tables for a dimension
AVG_ROW_LEN4	NUMBER			Average Row Length of indexes of level tables for a dimension
AVG_ROW_LEN5	NUMBER			Average Row Length of increasing part of a star table
AVG_ROW_LEN6	NUMBER			Average Row Length of indexes of a star table
MAX_ROW_LEN_SS	NUMBER			Maximum Row Length on source side
MAX_ROW_LEN_M	NUMBER			Maximum Row Length among all joined dimensions
MAX_ROW_LEN_L	NUMBER			Maximum Row Length among all levels of a dimension
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT TABLE_NAME
,      TABLE_OWNER
,      TABLE_TYPE
,      TABLE_LOGICAL_NAME
,      NUM_ROWS_PROC_NAME
,      ROW_LEN_PROC_NAME
,      NUM_OF_LEVELS
,      AVG_ROW_LEN1
,      AVG_ROW_LEN2
,      AVG_ROW_LEN3
,      AVG_ROW_LEN4
,      AVG_ROW_LEN5
,      AVG_ROW_LEN6
,      MAX_ROW_LEN_SS
,      MAX_ROW_LEN_M
,      MAX_ROW_LEN_L
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
FROM BIS.EDW_SIZE_INPUT;

Dependencies

[top of page]

BIS.EDW_SIZE_INPUT does not reference any database object

BIS.EDW_SIZE_INPUT is referenced by following:

APPS: EDW_SIZE_INPUT