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

VIEW: APPS.BOM_ORG_SHIFT_DATES_VIEW

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

View Type

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


BOM_ORG_SHIFT_DATES_VIEW allows you to retrieve data from
BOM_SHIFT_DATES without knowing the exception set or calendar
name for an organization and shift number. This view joins with
MTL_PARAMETERS and determines the calendar and exception set to which
the organization points. Further, joining to BOM_CALENDAR_DATES gets
the calendar dates, sequence number, prior sequence num, prior date,
next sequence number, and next date. This view is used in Calendar
Define window to show the shift dates for a compiled calendar.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
SHIFT_NUM NUMBER
Yes Shift number
SHIFT_DATE DATE
Yes Calendar date
SEQ_NUM NUMBER

Sequence Number
PRIOR_SEQ_NUM NUMBER
Yes Sequence number for prior working date
PRIOR_DATE DATE
Yes Calendar date for prior sequence number
NEXT_SEQ_NUM NUMBER
Yes Sequence number for next working date
NEXT_DATE DATE
Yes Calendar date for next sequence number
Query Text

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


SELECT ORGANIZATION_ID
,      SHIFT_NUM
,      SHIFT_DATE
,      SEQ_NUM
,      PRIOR_SEQ_NUM
,      PRIOR_DATE
,      NEXT_SEQ_NUM
,      NEXT_DATE
FROM APPS.BOM_ORG_SHIFT_DATES_VIEW;

Dependencies

[top of page]

APPS.BOM_ORG_SHIFT_DATES_VIEW references the following:

SchemaAPPS
SynonymBOM_SHIFT_DATES
SynonymMTL_PARAMETERS

APPS.BOM_ORG_SHIFT_DATES_VIEW is not referenced by any database object