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

VIEW: APPS.BOM_CALENDAR_WEEKS_VIEW

Object Details
Object Name: BOM_CALENDAR_WEEKS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_CALENDAR_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
YEAR NUMBER

Calendar year
MONTH VARCHAR2 (3)
Calendar month
MONTH_NUM NUMBER

Calendar month number
WEEK NUMBER

Calendar 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
,      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_CALENDAR_WEEKS_VIEW;

Dependencies

[top of page]

APPS.BOM_CALENDAR_WEEKS_VIEW references the following:

SchemaAPPS
SynonymBOM_CALENDAR_DATES

APPS.BOM_CALENDAR_WEEKS_VIEW is not referenced by any database object