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

VIEW: APPS.MSD_ORG_CALENDAR_CS_V

Object Details
Object Name: MSD_ORG_CALENDAR_CS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_ORG_CALENDAR_CS_V
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


[View Source]

Columns
Name Datatype Length Mandatory Comments
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 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_CS_V;

Dependencies

[top of page]

APPS.MSD_ORG_CALENDAR_CS_V references the following:

SchemaAPPS
SynonymMSD_LEVEL_VALUES
SynonymMSD_ORG_CALENDARS
SynonymMSD_TIME

APPS.MSD_ORG_CALENDAR_CS_V is not referenced by any database object