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

VIEW: APPS.GMP_SR_MFG_TIME_V

Object Details
Object Name: GMP_SR_MFG_TIME_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.GMP_SR_MFG_TIME_V
Subobject Name:
Status: VALID

View Type

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


Manfacturing calendar / time view for Demand Planner


[View Source]

Columns
Name Datatype Length Mandatory Comments
CALENDAR_CODE VARCHAR2 (0)
Calendar Code
SEQ_NUM NUMBER

Sequence Number
YEAR VARCHAR2 (0)
Year Name
YEAR_DESCRIPTION VARCHAR2 (0)
Description of the year
YEAR_START_DATE VARCHAR2 (0)
Start Date of the year
YEAR_END_DATE VARCHAR2 (0)
End Date of the year
QUARTER VARCHAR2 (0)
Quarter Number
QUARTER_DESCRIPTION VARCHAR2 (0)
Description for the quarter
QUARTER_START_DATE VARCHAR2 (0)
Start Date for the quarter
QUARTER_END_DATE VARCHAR2 (0)
End Date for the quarter
MONTH VARCHAR2 (0)
Month Number
MONTH_DESCRIPTION VARCHAR2 (0)
Month description
MONTH_START_DATE DATE

Start date of month
MONTH_END_DATE DATE

Month End date
WEEK VARCHAR2 (0)
Week number
WEEK_DESCRIPTION VARCHAR2 (0)
Week descripion
WEEK_START_DATE DATE

Start date of the week
WEEK_END_DATE DATE

End date of the week
DAY DATE

Day in calendar
DAY_DESCRIPTION DATE

Description of the day
Query Text

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.GMP_SR_MFG_TIME_V;

Dependencies

[top of page]

APPS.GMP_SR_MFG_TIME_V references the following:

SchemaSYS
TableDUAL

APPS.GMP_SR_MFG_TIME_V is not referenced by any database object