Results for “bom_org_cal_dates_view”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BOM_ORG_CAL_DATES_VIEW is a VALID APPS-owned database view within the Oracle E-Business Suite Bills of Material (BOM) product. Its documented purpose is to present calendar dates by organization. The view joins organization-level manufacturing parameters to the calendar date definitions that apply to each organization, effectively resolving the abstract calendar code and exception set assigned to an organization into a concrete, ordered sequence of working calendar dates.
In Oracle EBS 12.1.1 and 12.2.2, manufacturing calendars drive scheduling throughout the BOM, Work in Process, and manufacturing planning modules. Rather than requiring each consumer to resolve the organization-to-calendar association manually, BOM_ORG_CAL_DATES_VIEW exposes a flattened, organization-scoped date stream. Each row represents a single calendar date belonging to a specific organization, enriched with pointers to that date's predecessor and successor within the same calendar. This makes the view particularly valuable for reporting, integration extracts, and any logic that must reason about adjacent working days for a given organization without repeatedly joining BOM_CALENDAR_DATES to MTL_PARAMETERS.
Underlying Base Objects
The view is defined over two documented base objects, both referenced as synonyms in the APPS schema: BOM_CALENDAR_DATES and MTL_PARAMETERS. The view text joins these sources on two conditions: the organization's calendar code must match the calendar code on the calendar date row, and the organization's calendar exception set identifier must match the exception set identifier on the calendar date row. This dual join ensures that only the date rows valid for the organization's specific calendar and exception set are returned.
MTL_PARAMETERS supplies the ORGANIZATION_ID and the calendar assignments (CALENDAR_CODE and CALENDAR_EXCEPTION_SET_ID) for each inventory organization. BOM_CALENDAR_DATES supplies the actual date records, including the sequence numbering and adjacent-date references. The view therefore functions as an organization-aware projection of the calendar date table, filtered by each organization's configured calendar.
Key Columns
- ORGANIZATION_ID — The inventory organization identifier from MTL_PARAMETERS. This is the primary scoping key for the row.
- CALENDAR_DATE — The actual calendar date value from BOM_CALENDAR_DATES for the organization.
- SEQ_NUM — The sequence number of the date within the calendar, providing an ordered index.
- PRIOR_SEQ_NUM — The sequence number of the immediately preceding calendar date. This is the column most directly associated with the search term "prior_seq_num."
- PRIOR_DATE — The calendar date value of the preceding entry, resolving PRIOR_SEQ_NUM to an actual date.
- NEXT_SEQ_NUM — The sequence number of the immediately following calendar date.
- NEXT_DATE — The calendar date value of the following entry.
Common Use Cases and Queries
A frequent requirement is to determine the prior working day for an organization relative to a given date. Because the view pre-computes PRIOR_SEQ_NUM and PRIOR_DATE, this can be answered directly:
- Find the prior working date: SELECT organization_id, calendar_date, prior_date, prior_seq_num FROM bom_org_cal_dates_view WHERE organization_id = :org AND calendar_date = :date;
- Enumerate a date range: SELECT calendar_date, seq_num FROM bom_org_cal_dates_view WHERE organization_id = :org AND calendar_date BETWEEN :start_date AND :end_date ORDER BY seq_num;
- Validate sequencing gaps: SELECT calendar_date, seq_num, prior_seq_num FROM bom_org_cal_dates_view WHERE organization_id = :org AND seq_num - prior_seq_num > 1;
These patterns suit shop-floor scheduling reports, lead-time calculations, and integration extracts that must propagate organization-specific working-day logic into external planning systems.
-
View: BOM_ORG_CAL_DATES_VIEW 12.2.2
Calendar dates by organization
APPS.BOM_ORG_CAL_DATES_VIEW·↳ BOM_CALENDAR_DATES·↳ MTL_PARAMETERS·Explore BOM module →
-
View: BOM_ORG_CAL_DATES_VIEW 12.1.1
Calendar dates by organization
APPS.BOM_ORG_CAL_DATES_VIEW·↳ BOM_CALENDAR_DATES·↳ MTL_PARAMETERS·Explore BOM module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.2.2
-
SYNONYM: APPS.MTL_PARAMETERS 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - BOM Tables and Views 12.2.2
Table to map wip transactions to their corresponding event types.
-
eTRM - BOM Tables and Views 12.1.1
Table to map wip transactions to their corresponding event types.
-
eTRM - BOM Tables and Views 12.1.1
Table to map wip transactions to their corresponding event types.
-
eTRM - BOM Tables and Views 12.2.2
Table to map wip transactions to their corresponding event types.