Skip to content

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

VIEW: APPS.MSD_ORG_CALENDAR_DS_V

Object Details
Object Name: MSD_ORG_CALENDAR_DS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Working Day Allocation Stream Planning Server View. This view is striped by demand plan.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Id
ORG_LEVEL_VALUE_PK NUMBER
Yes Org Level Primary Key
ORG_LEVEL_ID NUMBER

Org Level Id
TIME_LEVEL_ID NUMBER

Time Level Id
QUANTITY NUMBER

Quantity
END_DATE DATE

Completion Date
CREATION_DATE DATE
Yes Who columns
CREATED_BY NUMBER
Yes Who columns
LAST_UPDATE_DATE DATE
Yes Who columns
LAST_UPDATED_BY NUMBER
Yes Who columns
LAST_UPDATE_LOGIN NUMBER
Yes Who columns
LAST_REFRESH_NUM NUMBER

last refresh number
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
ACTION_CODE CHAR (1)
DML action code
PRD_PARENT_LEVEL_ID NUMBER

Product Parent Level Id
PRD_PARENT_LEVEL_VALUE_PK NUMBER

Product Parent Level value Pk
Query Text

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


SELECT DEMAND_PLAN_ID
,      ORG_LEVEL_VALUE_PK
,      ORG_LEVEL_ID
,      TIME_LEVEL_ID
,      QUANTITY
,      END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
,      PRD_PARENT_LEVEL_ID
,      PRD_PARENT_LEVEL_VALUE_PK
FROM APPS.MSD_ORG_CALENDAR_DS_V;

Dependencies

[top of page]

APPS.MSD_ORG_CALENDAR_DS_V references the following:

SchemaAPPS
SynonymMSD_DP_SESSION
SynonymMSD_LEVEL_VALUES_DS
SynonymMSD_ORG_CALENDARS
SynonymMSD_TIME

APPS.MSD_ORG_CALENDAR_DS_V is not referenced by any database object