[Home] [Help]
[Dependency Information]
| Object Name: | MSD_BACKUP_LEVEL_VALUES |
|---|---|
| Object Type: | TABLE |
| Owner: | MSD |
| FND Design Data: | MSD.MSD_BACKUP_LEVEL_VALUES
|
| Subobject Name: | |
| Status: | VALID |
This table stores level value pks during a level value collection. After a level is collected (in msd_level_values) it's pks are reverted to those from msd_backup_level_values.
| Tablespace: | APPS_TS_NOLOGGING |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSD_BACKUP_LEVEL_VALUES_U1 | NORMAL | UNIQUE |
APPS_TS_NOLOGGING
|
SR_LEVEL_PK
LEVEL_ID
INSTANCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTANCE | VARCHAR2 | (40) | Yes | Source Instance |
| LEVEL_ID | NUMBER | Yes | Level id | |
| SR_LEVEL_PK | VARCHAR2 | (240) | Yes | Source level pk |
| LEVEL_PK | NUMBER | Yes | Level primary key |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE
, LEVEL_ID
, SR_LEVEL_PK
, LEVEL_PK
FROM MSD.MSD_BACKUP_LEVEL_VALUES;
MSD.MSD_BACKUP_LEVEL_VALUES does not reference any database object
MSD.MSD_BACKUP_LEVEL_VALUES is referenced by following:
MSD
MSD_BACKUP_LEVEL_VALUES#
|
|
|
|