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

VIEW: APPS.BOM_ORG_CAL_PERIODS_VIEW

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

View Type

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


You can view period information from this view without knowing the calendar name and the exception set for an organization. This view joins with MTL_PARAMETERS to find which calendar and
exception set an organization is pointing to. Further, joining to BOM_PERIOD_START_DATES gets all the information on the period start dates, sequence number, period name, next date and prior date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
PERIOD_START_DATE DATE
Yes Period start date
PERIOD_SEQUENCE_NUM NUMBER

Period sequence number
PERIOD_NAME VARCHAR2 (3)
Period name
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
,      PERIOD_START_DATE
,      PERIOD_SEQUENCE_NUM
,      PERIOD_NAME
,      NEXT_DATE
,      PRIOR_DATE
FROM APPS.BOM_ORG_CAL_PERIODS_VIEW;

Dependencies

[top of page]

APPS.BOM_ORG_CAL_PERIODS_VIEW references the following:

SchemaAPPS
SynonymBOM_PERIOD_START_DATES
SynonymMTL_PARAMETERS
APPS.BOM_ORG_CAL_PERIODS_VIEW is referenced by following:

SchemaAPPS
Package BodyENG_ECO_COST - show dependent code