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

VIEW: APPS.BOM_SHIFT_WEEKS_VIEW

Object Details
Object Name: BOM_SHIFT_WEEKS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_SHIFT_WEEKS_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CALENDAR_CODE VARCHAR2 (10) Yes Workday calendar identifier
EXCEPTION_SET_ID NUMBER
Yes Exception set unique identifier
SHIFT_NUM NUMBER
Yes Shift number
YEAR NUMBER

Calendar Year
MONTH VARCHAR2 (3)
Month
MONTH_NUM NUMBER

Month Number
WEEK NUMBER

Week
SUN NUMBER

Sunday
SUN_ON VARCHAR2 (1)
Exception Type
MON NUMBER

Monday
MON_ON VARCHAR2 (1)
Exception type
TUE NUMBER

Tuesday
TUE_ON VARCHAR2 (1)
Exception type
WED NUMBER

Wednusday
WED_ON VARCHAR2 (1)
Exception Type
THU NUMBER

Thursday
THU_ON VARCHAR2 (1)
Exception Type
FRI NUMBER

Friday
FRI_ON VARCHAR2 (1)
Exception Type
SAT NUMBER

Saturday
SAT_ON VARCHAR2 (1)
Exception type
Query Text

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


SELECT CALENDAR_CODE
,      EXCEPTION_SET_ID
,      SHIFT_NUM
,      YEAR
,      MONTH
,      MONTH_NUM
,      WEEK
,      SUN
,      SUN_ON
,      MON
,      MON_ON
,      TUE
,      TUE_ON
,      WED
,      WED_ON
,      THU
,      THU_ON
,      FRI
,      FRI_ON
,      SAT
,      SAT_ON
FROM APPS.BOM_SHIFT_WEEKS_VIEW;

Dependencies

[top of page]

APPS.BOM_SHIFT_WEEKS_VIEW references the following:

SchemaAPPS
SynonymBOM_SHIFT_DATES

APPS.BOM_SHIFT_WEEKS_VIEW is not referenced by any database object