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

VIEW: APPS.BOM_SHIFT_MONTHS_VIEW

Object Details
Object Name: BOM_SHIFT_MONTHS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_SHIFT_MONTHS_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_NUM NUMBER

Month Number
MONTH VARCHAR2 (9)
Calendar Month
FIRST_DAY DATE

First day of the month
Query Text

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


SELECT CALENDAR_CODE
,      EXCEPTION_SET_ID
,      SHIFT_NUM
,      YEAR
,      MONTH_NUM
,      MONTH
,      FIRST_DAY
FROM APPS.BOM_SHIFT_MONTHS_VIEW;

Dependencies

[top of page]

APPS.BOM_SHIFT_MONTHS_VIEW references the following:

SchemaAPPS
SynonymBOM_SHIFT_DATES

APPS.BOM_SHIFT_MONTHS_VIEW is not referenced by any database object