[Home] [Help] [Dependency Information]

TABLE: BIS.EDW_SEC_DIM_INFO_T

Object Details

Object Name:	EDW_SEC_DIM_INFO_T
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.EDW_SEC_DIM_INFO_T
Subobject Name:
Status:	VALID

Security Metadata Dimension Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_SEC_DIM_INFO_T_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIM_ID
EDW_SEC_DIM_INFO_T_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIM_NAME

Columns

Query Text

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

SELECT DIM_ID
,      DIM_NAME
,      DIM_LONG_NAME
,      TABLE_NAME
,      LOWEST_LEVEL_COL_NAME
,      CONTEXT_NAME
FROM BIS.EDW_SEC_DIM_INFO_T;

Dependencies

[top of page]

BIS.EDW_SEC_DIM_INFO_T does not reference any database object

BIS.EDW_SEC_DIM_INFO_T is referenced by following:

APPS

EDW_SEC_DIM_INFO_T