Search Results mrp_sr_view_con_v




Overview
Explore in AI Chat

Overview

The MRP_SR_VIEW_CON_V view is an Oracle E-Business Suite (EBS) database object owned by the APPS schema. It is documented as a "Sourcing rule/BOD condensed view" within the MRP (Master Scheduling/MRP) product family. In the context of EBS 12.1.1 and 12.2.2, this view provides a simplified, de-normalized projection of sourcing rule data, specifically narrowing the underlying sourcing rule receipt organization records down to two identifying attributes: the sourcing rule and the receipt organization. The view is classified as VALID in the ETRM repository and is intended for lightweight querying and integration scenarios where a condensed representation of sourcing rules is sufficient.

The user search term receipt_organization_id corresponds directly to one of the two columns exposed by this view, indicating that the view is frequently consulted when resolving which receipt organizations are associated with a given sourcing rule.

Underlying Base Objects

ETRM metadata documents that the view is defined over the following base object:

  • MRP_SR_RECEIPT_ORG (referenced via a SYNONYM) — the sourcing rule receipt organization table that stores the association between sourcing rules and the organizations from which receipts are expected.

The documented view text is:

This establishes that the view applies a DISTINCT operation to eliminate duplicate combinations of sourcing rule and receipt organization, producing a clean, unique listing. The relationship to the base object is therefore a direct projection-and-deduplication: no joins, filters, or aggregations beyond DISTINCT are applied. The synonym indirection means the view relies on the APPS synonym mapping to the underlying table, consistent with standard EBS schema design.

Key Columns

The view exposes exactly two columns, as documented:

  • SOURCING_RULE_ID — The identifier of the sourcing rule. This is the foreign key linking to the sourcing rule definition, and it is the primary grouping attribute in the view.
  • RECEIPT_ORGANIZATION_ID — The identifier of the receipt organization associated with the sourcing rule. This column represents the organization into which receipts are directed under the given sourcing rule and is the attribute most commonly searched by users and integration routines.

Because the view returns only these two identifiers, it functions as a concise mapping between sourcing rules and their receipt organizations, without any descriptive or attribute-level detail such as organization names or rule descriptions.

Common Use Cases and Queries

The primary use case is resolving the set of receipt organizations tied to a sourcing rule, or conversely, finding the sourcing rules that direct receipts to a particular organization. This supports sourcing rule validation, receipt routing analysis, and integration feeds that require only the key relationship.

  • Retrieve all receipt organizations for a given sourcing rule:
    SELECT receipt_organization_id FROM apps.mrp_sr_view_con_v WHERE sourcing_rule_id = :rule_id;
  • Retrieve all sourcing rules that reference a specific receipt organization:
    SELECT sourcing_rule_id FROM apps.mrp_sr_view_con_v WHERE receipt_organization_id = :org_id;
  • Confirm uniqueness of the sourcing rule / receipt organization mapping:
    SELECT sourcing_rule_id, receipt_organization_id FROM apps.mrp_sr_view_con_v;

Because the view is condensed and applies DISTINCT, it is well suited to lookups and existence checks rather than to detailed sourcing rule reporting, which would typically require joining to the full sourcing rule definition tables.