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

VIEW: APPS.BOM_ORG_CAL_DATES_VIEW

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

View Type

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


This view allows you to retrieve data from BOM_CALENDAR_DATES without knowing the exception set or calendar name for an organization. The 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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
CALENDAR_DATE DATE
Yes Calendar date
SEQ_NUM NUMBER

Sequence number for working days
PRIOR_SEQ_NUM NUMBER
Yes Prior sequence number
PRIOR_DATE DATE
Yes Calendar date for prior sequence number
NEXT_SEQ_NUM NUMBER
Yes Next sequence number
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
,      CALENDAR_DATE
,      SEQ_NUM
,      PRIOR_SEQ_NUM
,      PRIOR_DATE
,      NEXT_SEQ_NUM
,      NEXT_DATE
FROM APPS.BOM_ORG_CAL_DATES_VIEW;

Dependencies

[top of page]

APPS.BOM_ORG_CAL_DATES_VIEW references the following:

SchemaAPPS
SynonymBOM_CALENDAR_DATES
SynonymMTL_PARAMETERS

APPS.BOM_ORG_CAL_DATES_VIEW is not referenced by any database object