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


TABLE: BIS.EDW_FACTS_MD

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


EDW_FACTS_MD


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_FACTS_MD_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFACT_ID
EDW_FACTS_MD_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFACT_NAME
Columns
Name Datatype Length Mandatory Comments
FACT_ID NUMBER (9)
Description
FACT_NAME VARCHAR2 (255)
Description
FACT_LONGNAME VARCHAR2 (4000)
Description
FACT_DESCRIPTION VARCHAR2 (4000)
Description
Query Text

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


SELECT FACT_ID
,      FACT_NAME
,      FACT_LONGNAME
,      FACT_DESCRIPTION
FROM BIS.EDW_FACTS_MD;

Dependencies

[top of page]

BIS.EDW_FACTS_MD does not reference any database object

BIS.EDW_FACTS_MD is referenced by following:

SchemaAPPS
SynonymEDW_FACTS_MD