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


TABLE: MSD.MSD_DEM_CALENDARS

Object Details
Object Name: MSD_DEM_CALENDARS
Object Type: TABLE
Owner: MSD
Subobject Name:
Status: VALID


Table contains list of calendars which are collected into demantra.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (10)
Source instance name
CALENDAR_TYPE VARCHAR2 (30)
Calendar type: Manufacturing, Accounting & Gregorian
CALENDAR_CODE VARCHAR2 (200)
Workday calendar identifier along with instance name
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
Query Text

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


SELECT INSTANCE
,      CALENDAR_TYPE
,      CALENDAR_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSD.MSD_DEM_CALENDARS;

Dependencies

[top of page]

MSD.MSD_DEM_CALENDARS does not reference any database object

MSD.MSD_DEM_CALENDARS is referenced by following:

SchemaMSD
ViewMSD_DEM_CALENDARS#