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


TABLE: BIS.EDW_PVT_MAP_KEY_USAGES_MD

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


EDW_PVT_MAP_KEY_USAGES_MD


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_PVT_MAP_KEY_USAGES_MDN1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_USAGE_ID
EDW_PVT_MAP_KEY_USAGES_MDN2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAPPING_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_USAGE_ID NUMBER (9)
comment
PARENT_TABLE_USAGE_ID NUMBER (9)
comment
FOREIGN_KEY_USAGE_ID NUMBER (9)
comment
FOREIGN_KEY_ID NUMBER (9)
comment
UNIQUE_KEY_ID NUMBER (9)
comment
MAPPING_ID NUMBER

comment
Query Text

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


SELECT SOURCE_USAGE_ID
,      PARENT_TABLE_USAGE_ID
,      FOREIGN_KEY_USAGE_ID
,      FOREIGN_KEY_ID
,      UNIQUE_KEY_ID
,      MAPPING_ID
FROM BIS.EDW_PVT_MAP_KEY_USAGES_MD;

Dependencies

[top of page]

BIS.EDW_PVT_MAP_KEY_USAGES_MD does not reference any database object

BIS.EDW_PVT_MAP_KEY_USAGES_MD is referenced by following:

SchemaAPPS
SynonymEDW_PVT_MAP_KEY_USAGES_MD