Search Results mrp_ap_designators_v

Overview

MRP_AP_DESIGNATORS_V is a reporting view within the Oracle EBS Master Scheduling/MRP (MRP) module. It exposes designator-level scheduling attributes used by the Oracle Advanced Planning and Scheduling (APS) and Master Production Scheduling engines. A "designator" identifies a scheduling group or production resource configuration, and this view surfaces the configuration flags, scheduling type, and lifecycle dates associated with each designator within an organization. In practice, the view serves as a convenient relational projection over the underlying scheduling designator table, allowing reporting tools and integration interfaces to query designator metadata without accessing the base table directly.

Users searching for the string "mrp_ap_schd_dsgs_sn" have reached the correct object. The view text confirms that MRP_AP_DESIGNATORS_V is defined entirely over the table MRP_AP_SCHD_DSGS_SN (aliased as MSD). The view therefore acts as a renamed, column-subsetted access layer over that single base object.

Underlying Base Objects

The documented view definition references exactly one base object: MRP_AP_SCHD_DSGS_SN. No other tables or joins are documented in the ETRM metadata. The "_SN" suffix is consistent with Oracle's convention for a table holding a snapshot or a specific data set variant of scheduling designators, and the view simply selects columns from this table without applying any filter predicate, join, or aggregation.

Because the view is a straight projection, its row cardinality and data integrity are wholly determined by MRP_AP_SCHD_DSGS_SN. Note that the ETRM metadata records the view as "Not implemented in this database," which indicates that the object may not be present in every environment or release; where it does exist, it is a read-only convenience object.

Key Columns

• DESIGNATOR — The identifying name or code of the scheduling designator. This is the primary business key exposed by the view.
• ORGANIZATION_ID — The inventory organization to which the designator belongs, enabling multi-organization filtering.
• MPS_RELIEF — Indicates whether master production schedule relief is enabled for the designator, controlling consumption of MPS entries against actual demand.
• INVENTORY_ATP_FLAG — Flag governing whether inventory is considered in available-to-promise calculations for the designator.
• DESCRIPTION — Free-text description of the designator.
• DISABLE_DATE — Date on which the designator becomes inactive.
• DEMAND_CLASS — Demand classification associated with the designator, used to group and prioritize demand.
• ORGANIZATION_SELECTION — Controls the scope of organizations to which the designator applies.
• PRODUCTION — Flag indicating whether the designator participates in production scheduling.
• SCHEDULE_TYPE — The scheduling method associated with the designator (for example, rate-based or discrete scheduling).
• RN1 (as RN) — A row number generated by the ROW_NUMBER() analytic function in the view text, used to order the designators within the result set.

Common Use Cases and Queries

Typical usage includes validating designator configuration across organizations, identifying disabled designators, and feeding downstream APS or reporting extracts. A basic query lists all active designators for an organization:

SELECT DESIGNATOR, ORGANIZATION_ID, SCHEDULE_TYPE, PRODUCTION, MPS_RELIEF, INVENTORY_ATP_FLAG
FROM MRP_AP_DESIGNATORS_V
WHERE ORGANIZATION_ID = :org_id
AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);

To review production-relevant designators grouped by scheduling type:

SELECT SCHEDULE_TYPE, COUNT(*)
FROM MRP_AP_DESIGNATORS_V
WHERE PRODUCTION = 'Y'
GROUP BY SCHEDULE_TYPE;

Because the view filters nothing, all designator rows in MRP_AP_SCHD_DSGS_SN are returned; consumers should always supply ORGANIZATION_ID or DESIGNATOR predicates to limit scope. For higher-fidelity control, the base table MRP_AP_SCHD_DSGS_SN can be queried directly when the view is absent, as noted in the ETRM metadata.