[Home] [Help] [Dependency Information]

TABLE: BIS.EDW_FLEX_DIM37_M

Object Details

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

User Defined Dimension 37 Table

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_FLEX_DIM37_M_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	L2_PK L2_PK_KEY
EDW_FLEX_DIM37_M_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	L2_PK_KEY

Columns

Query Text

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

SELECT L1_PK_KEY
,      L2_PK_KEY
,      L1_FK_KEY
,      L2_FK_KEY
,      L1_DESCRIPTION
,      L1_ACTUAL_VALUE
,      L2_FK
,      L2_DESCRIPTION
,      L2_ACTUAL_VALUE
,      L1_PK
,      L1_INSTANCE
,      L1_FK
,      L2_PK
,      L2_INSTANCE
,      L1_CREATION_DATE
,      L2_CREATION_DATE
,      L1_LAST_UPDATE_DATE
,      L2_LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      L1_NAME
,      L2_NAME
FROM BIS.EDW_FLEX_DIM37_M;

Dependencies

[top of page]

BIS.EDW_FLEX_DIM37_M does not reference any database object

BIS.EDW_FLEX_DIM37_M is referenced by following:

APPS

EDW_FLEX_DIM37_M