[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_MFG_TIME_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_MFG_TIME_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the Source View for Manufacturing Calendar. This view would be applied to an Oracle Applications 11i instance from which the Manufacturing Forecast information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (10) | Yes | Calendar Code |
SEQ_NUM | NUMBER | Sequence Number | ||
YEAR | VARCHAR2 | (0) | Year | |
YEAR_DESCRIPTION | VARCHAR2 | (0) | Reserved | |
YEAR_START_DATE | VARCHAR2 | (0) | Reserved | |
YEAR_END_DATE | VARCHAR2 | (0) | Reserved | |
QUARTER | VARCHAR2 | (0) | Reserved | |
QUARTER_DESCRIPTION | VARCHAR2 | (0) | Reserved | |
QUARTER_START_DATE | VARCHAR2 | (0) | Reserved | |
QUARTER_END_DATE | VARCHAR2 | (0) | Reserved | |
MONTH | VARCHAR2 | (8) | Month | |
MONTH_DESCRIPTION | VARCHAR2 | (17) | Month Description | |
MONTH_START_DATE | DATE | Yes | Month Start Date | |
MONTH_END_DATE | DATE | Month End Date | ||
WEEK | VARCHAR2 | (15) | Week | |
WEEK_DESCRIPTION | VARCHAR2 | (15) | Week Description | |
WEEK_START_DATE | DATE | Yes | Week Start Date | |
WEEK_END_DATE | DATE | Week End Date | ||
DAY | DATE | Yes | Day | |
DAY_DESCRIPTION | DATE | Yes | Day Description |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_CODE
, SEQ_NUM
, YEAR
, YEAR_DESCRIPTION
, YEAR_START_DATE
, YEAR_END_DATE
, QUARTER
, QUARTER_DESCRIPTION
, QUARTER_START_DATE
, QUARTER_END_DATE
, MONTH
, MONTH_DESCRIPTION
, MONTH_START_DATE
, MONTH_END_DATE
, WEEK
, WEEK_DESCRIPTION
, WEEK_START_DATE
, WEEK_END_DATE
, DAY
, DAY_DESCRIPTION
FROM APPS.MSD_SR_MFG_TIME_V;
APPS.MSD_SR_MFG_TIME_V is not referenced by any database object
|
|
|