Results for “inventory_atp_flag”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MRP_SCHEDULE_DESIGNATORS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the MRP (Master Scheduling/MRP) product family. Its documented description is "Master schedules view," and it exposes the set of schedule designators that drive master scheduling, material requirements planning, and their associated ATP, demand class, and production behaviors across organizations. The view is classified as VALID in the ETRM metadata for 12.1.1 and 12.2.2 and is considered an Oracle Proprietary, Confidential Information object.

Functionally, the view serves as the presentation and lookup layer over the base schedule designators used by the planning engine. Because it resolves the owning organization through a join to MRP_ORGANIZATIONS_V, callers receive a consistent organization identifier suitable for multi-organization planning windows and concurrent programs without needing to reconstruct the join themselves. It is commonly referenced by forms, concurrent program LOVs, and integration extracts that need to enumerate or filter valid planning schedule designators. The column USE_NEW_PLANNER, which appears in the search term associated with this object, is exposed here and reflects whether a given designator participates in the newer planner logic.

Underlying Base Objects

The view is defined over two documented referenced objects: the synonym MRP_SCHEDULE_DESIGNATORS (aliased MSD) as the driving source, and the view MRP_ORGANIZATIONS_V (aliased MO) as an outer-joined lookup. The documented view text is:

The (+) outer-join operators ensure that designators without a matching row in MRP_ORGANIZATIONS_V are still returned. The join keys are ORGANIZATION_ID and SCHEDULE_DESIGNATOR, so a designator may resolve to a planned organization different from its owning organization. This distinction is central to how the view presents multi-organization planning data.

Key Columns

  • ROW_ID — the ROWID of the base designator row, useful for identifying the underlying record.
  • SCHEDULE_DESIGNATOR — the unique name identifying the master schedule or planning schedule.
  • ORGANIZATION_ID — the effective organization, derived as NVL(MO.PLANNED_ORGANIZATION, MSD.ORGANIZATION_ID).
  • OWNING_ORGANIZATION_ID — the organization that actually owns the designator row.
  • SCHEDULE_TYPE — indicates whether the designator is used for MPS or MRP planning.
  • MPS_RELIEF — controls whether MPS entries relieve dependent demand.
  • INVENTORY_ATP_FLAG — indicates ATP availability check behavior against inventory.
  • DESCRIPTION — descriptive text for the schedule designator.
  • DISABLE_DATE — the date on which the designator becomes inactive.
  • DEMAND_CLASS — the demand class associated with the schedule.
  • USE_NEW_PLANNER — flag indicating whether the newer planner logic applies to this designator.
  • PRODUCTION — production-related indicator for the designator.
  • ORGANIZATION_SELECTION — controls organization selection behavior during planning.

Common Use Cases and Queries

Typical scenarios include populating schedule designator LOVs, auditing which designators use the new planner, and extracting active schedules for integration. A basic query listing active designators is:

  • SELECT SCHEDULE_DESIGNATOR, ORGANIZATION_ID, OWNING_ORGANIZATION_ID, SCHEDULE_TYPE, USE_NEW_PLANNER FROM APPS.MRP_SCHEDULE_DESIGNATORS_V WHERE DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE;

To isolate designators flagged for the newer planner logic, filter on USE_NEW_PLANNER = 'Y'. To distinguish owned versus planned organizations, compare OWNING_ORGANIZATION_ID with ORGANIZATION_ID, since they differ whenever MRP_ORGANIZATIONS_V supplies a PLANNED_ORGANIZATION value. Joining the view to MRP_ORGANIZATIONS_V or to inventory organization tables by ORGANIZATION_ID supports reporting on planning organizations that consume each designator.