Search Results org_vendor




Overview
Explore in AI Chat

Overview

APPS.MSC_SR_VIEW_EXP_V is a supplementary view in the Oracle E-Business Suite Applications schema (APPS), classified under the Advanced Supply Chain Planning (ASCP) module and delivered through the MSC product family. The view's FND design data identifier is MSC.MSC_SR_VIEW_EXP_V, and its status is VALID in both Oracle EBS 12.1.1 and 12.2.2. Oracle explicitly documents this object as a supplementary view intended to simplify Oracle Forms coding. Oracle does not recommend that customers query or alter data through it, because its definition may change dramatically in subsequent minor or major releases.

Functionally, the view presents sourcing-rule and sourcing-receipt information that combines organization, vendor, and allocation attributes. The name SR_VIEW_EXP reflects its role as an "expanded" sourcing view, exposing denormalized descriptive columns such as vendor name, vendor site, source organization code, and the derived ORG_VENDOR column. This makes it convenient for planning reports and integration extracts that must present sourcing data in a human-readable, concatenated form without joining the underlying transactional tables.

Underlying Base Objects

The documented dependency list for APPS.MSC_SR_VIEW_EXP_V identifies four referenced objects:

The metadata states that APPS.MSC_SR_VIEW_EXP_V is not referenced by any database object, confirming that it is a terminal, leaf-level view. All four base objects reside in the APPS schema, so no cross-schema privileges are required to query it. Because the view is a Forms-supporting construct rather than a documented integration interface, its column list should be treated as subject to change.

Key Columns

The view exposes twenty columns, which fall into logical groups:

The VARCHAR2(4000) datatypes on the descriptive columns reflect that they are populated by concatenation and name-resolution logic rather than by direct column storage. This is the source of the term org_vendor that a user searching on the object would encounter.

Common Use Cases and Queries

The primary practical use of APPS.MSC_SR_VIEW_EXP_V is troubleshooting and read-only reporting on sourcing rules and their allocation splits. A typical diagnostic query retrieves the sourcing rule, source organization, vendor, and allocation percentage for a given receipt organization:

SELECT SOURCING_RULE_ID, SOURCE_ORGANIZATION_CODE, VENDOR_NAME, VENDOR_SITE, ALLOCATION_PERCENT, RANK, ORG_VENDOR FROM APPS.MSC_SR_VIEW_EXP_V WHERE RECEIPT_ORGANIZATION_ID = :org_id ORDER BY RANK;

Because ORG_VENDOR is a derived descriptor, it is frequently useful in validation queries that compare the concatenated value against the separately exposed SOURCE_ORGANIZATION_CODE and VENDOR_NAME columns to confirm the view's name-resolution behavior:

SELECT SOURCING_RULE_ID, ORG_VENDOR, ALLOCATION_PERCENT FROM APPS.MSC_SR_VIEW_EXP_V WHERE ORG_VENDOR LIKE '%' || :vendor_fragment || '%';

Users should treat results as read-only, avoid embedding the view in custom database objects, and re-validate the column list following any patch or upgrade, because Oracle reserves the right to redefine this Forms-oriented view between releases.