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

TABLE: MSD.MSD_DP_EVENTS

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


This table stores Demand Plan related Events.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_DP_EVENTS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEMAND_PLAN_ID
ColumnEVENT_ID
MSD_DP_EVENTS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDP_EVENT_ID
Columns
Name Datatype Length Mandatory Comments
DP_EVENT_ID NUMBER (15) Yes Primary Key.
EVENT_ID NUMBER (15) Yes Event ID.
DEMAND_PLAN_ID NUMBER (15) Yes Demand Plan ID.
CREATION_DATE DATE
Yes Who Column.
CREATED_BY NUMBER
Yes Who Column.
LAST_UPDATE_DATE DATE
Yes Who Column.
LAST_UPDATED_BY NUMBER
Yes Who Column.
LAST_UPDATE_LOGIN NUMBER

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.
DELETEABLE_FLAG VARCHAR2 (15)
Indicates whether the record is deleteable or not
ENABLE_NONSEED_FLAG VARCHAR2 (15)
Indicates whether the fields for this record need to be disabled for non seeded records also
Query Text

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


SELECT DP_EVENT_ID
,      EVENT_ID
,      DEMAND_PLAN_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELETEABLE_FLAG
,      ENABLE_NONSEED_FLAG
FROM MSD.MSD_DP_EVENTS;

Dependencies

[top of page]

MSD.MSD_DP_EVENTS does not reference any database object

MSD.MSD_DP_EVENTS is referenced by following:

SchemaAPPS
SynonymMSD_DP_EVENTS