[Home] [Help] [Dependency Information]
Object Name: | BOM_ORG_CAL_PERIODS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.BOM_ORG_CAL_PERIODS_VIEW |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|