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

TABLE: MSD.MSD_DELETED_LEVEL_VALUES

Object Details
Object Name: MSD_DELETED_LEVEL_VALUES
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_DELETED_LEVEL_VALUES
Subobject Name:
Status: VALID


This table stores all the deleted level values Information including the system generated primary key and the level value attributes. This is not stripped by the Demand Plan Id.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40)
Source instance ID.
LEVEL_ID NUMBER

Level identifier.
LEVEL_VALUE VARCHAR2 (240)
Value of the level.
SR_LEVEL_PK VARCHAR2 (240)
Primary key for the level for the source instance.
LEVEL_PK NUMBER

System generated primary key for level.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.
REQUEST_ID NUMBER

Extended who column.
PROGRAM_APPLICATION_ID NUMBER

Extended who column.
PROGRAM_ID NUMBER

Extended who column.
PROGRAM_UPDATE_DATE DATE

Extended who column.
LAST_REFRESH_NUM NUMBER

Last refresh number
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
Query Text

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


SELECT INSTANCE
,      LEVEL_ID
,      LEVEL_VALUE
,      SR_LEVEL_PK
,      LEVEL_PK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
FROM MSD.MSD_DELETED_LEVEL_VALUES;

Dependencies

[top of page]

MSD.MSD_DELETED_LEVEL_VALUES does not reference any database object

MSD.MSD_DELETED_LEVEL_VALUES is referenced by following:

SchemaMSD
ViewMSD_DELETED_LEVEL_VALUES#