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


TABLE: BIS.EDW_CDI_DIM_MISSING_KEYS

Object Details
Object Name: EDW_CDI_DIM_MISSING_KEYS
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.EDW_CDI_DIM_MISSING_KEYS
Subobject Name:
Status: VALID


EDW_CALSUM4_BSC_LOG


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_CDI_DIM_MISSING_KEYSN1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIM_ID
EDW_CDI_DIM_MISSING_KEYSN2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFACT_ID
Columns
Name Datatype Length Mandatory Comments
DIM_ID NUMBER

Description
FACT_ID NUMBER

Description
INSTANCE VARCHAR2 (40)
Description
KEY_VALUE VARCHAR2 (400)
Description
NUMBER_KEY_VALUE NUMBER

Description
MISSING_DATE NUMBER

Description
Query Text

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


SELECT DIM_ID
,      FACT_ID
,      INSTANCE
,      KEY_VALUE
,      NUMBER_KEY_VALUE
,      MISSING_DATE
FROM BIS.EDW_CDI_DIM_MISSING_KEYS;

Dependencies

[top of page]

BIS.EDW_CDI_DIM_MISSING_KEYS does not reference any database object

BIS.EDW_CDI_DIM_MISSING_KEYS is referenced by following:

SchemaAPPS
SynonymEDW_CDI_DIM_MISSING_KEYS