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

VIEW: APPS.BOM_ORG_CAL_WEEKS_VIEW

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

View Type

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


This view lets you see data from BOM_CAL_WEEK_START_DATES without knowing the calendar and the exception set for any given organization. This view joins with MTL_PARAMETERS and finds the
calendar name and exception set an organization is pointing to.
Further, joining to BOM_CAL_WEEK_START_DATES gives the week start
date, sequence number, next date, and prior date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
WEEK_START_DATE DATE
Yes Week start date
SEQ_NUM NUMBER
Yes Sequence number
NEXT_DATE DATE
Yes Next date
PRIOR_DATE DATE
Yes Prior date
Query Text

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


SELECT ORGANIZATION_ID
,      WEEK_START_DATE
,      SEQ_NUM
,      NEXT_DATE
,      PRIOR_DATE
FROM APPS.BOM_ORG_CAL_WEEKS_VIEW;

Dependencies

[top of page]

APPS.BOM_ORG_CAL_WEEKS_VIEW references the following:

SchemaAPPS
SynonymBOM_CAL_WEEK_START_DATES
SynonymMTL_PARAMETERS
APPS.BOM_ORG_CAL_WEEKS_VIEW is referenced by following:

SchemaAPPS
ViewWIP_BIS_PERF_TO_PLAN_V