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

TABLE: MSD.MSD_DP_CALENDARS

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


This table stores Demand Plan related Calendars.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_DP_CALENDARS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEMAND_PLAN_ID
ColumnCALENDAR_TYPE
ColumnCALENDAR_CODE
Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER (15) Yes Demand Plan ID.
CALENDAR_TYPE VARCHAR2 (30) Yes Calendar Type
CALENDAR_CODE VARCHAR2 (30) Yes Calendar Code
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 DEMAND_PLAN_ID
,      CALENDAR_TYPE
,      CALENDAR_CODE
,      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_CALENDARS;

Dependencies

[top of page]

MSD.MSD_DP_CALENDARS does not reference any database object

MSD.MSD_DP_CALENDARS is referenced by following:

SchemaAPPS
SynonymMSD_DP_CALENDARS