Results for “assignment_set_id”

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

Overview

PO_AUTOSOURCE_RULES_V is an APPS-owned view in the Oracle E-Business Suite Purchasing (PO) module, documented as "Retrofitted" in ETRM for releases 12.1.1 and 12.2.2. It exposes the effective Approved Supplier List (ASL) sourcing rules that govern automatic source document creation for a given inventory item and organization. In practice, the view answers the question: for this item in this organization, which approved vendors and vendor sites are currently eligible to be used as sourcing, and in what rank order or allocation split? The view is consumed by the Purchasing autosource engine, which selects a default supplier when a requisition or purchase order line is created with sourcing rules enabled.

The view's defining characteristic is that it is not a static listing of the ASL. It dynamically filters to rules that are effective as of the current system date, and it further validates each candidate row through the PO_ASL_SV.CHECK_ASL_ACTION server-side package before exposing it. Users searching for mrp_item_sourcing_levels_v should note that this MRP view is the primary source of the row data; PO_AUTOSOURCE_RULES_V is the Purchasing-side wrapper that layers vendor validation, ASL eligibility checking, and descriptive joins on top of it.

Underlying Base Objects

The documented base objects for this view are FINANCIALS_SYSTEM_PARAMETERS, FND_GLOBAL (package), MRP_ITEM_SOURCING_LEVELS_V (view), MTL_PARAMETERS, MTL_SYSTEM_ITEMS, PO_ASL_SV (package), PO_VENDORS, and PO_VENDOR_SITES_ALL. The view text shows a join from MRP_ITEM_SOURCING_LEVELS_V (aliased SR) to PO_VENDORS (PV) on VENDOR_ID, to PO_VENDOR_SITES_ALL (PVS) on VENDOR_SITE_ID (outer-joined), to MTL_SYSTEM_ITEMS (MSI) on INVENTORY_ITEM_ID, and to MTL_PARAMETERS (MP) on ORGANIZATION_ID (outer-joined). FINANCIALS_SYSTEM_PARAMETERS (FSP) is joined to ensure the item's inventory organization matches the operating unit's inventory organization context. FND_GLOBAL supplies session context such as organization and user identifiers used by the ASL check.

Two filters are significant. The date predicate SYSDATE BETWEEN NVL(SR.EFFECTIVE_DATE, SYSDATE) AND NVL(SR.DISABLE_DATE, SYSDATE) restricts output to currently effective rules. The call PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING', ...) returns non-zero only when the vendor/site is genuinely valid for sourcing the item, which enforces ASL status, approved item-vendor-site combinations, and security/access rules that a direct query against MRP_ITEM_SOURCING_LEVELS_V would bypass.

Key Columns

• AUTOSOURCE_RULE_ID / AUTOSOURCE_RULE_NAME — identifier and name of the sourcing rule row.
• ITEM_ID / ITEM_DESCRIPTION — inventory item identifier and its description from MTL_SYSTEM_ITEMS.
• START_DATE / END_DATE — effective and disable dates bounding the rule's validity.
• VENDOR_RANK — priority order in which vendors are selected when multiple approved sources exist.
• VENDOR_ID / VENDOR_NAME — approved supplier from PO_VENDORS.
• VENDOR_SITE_ID / VENDOR_SITE_CODE — the specific purchasing site from PO_VENDOR_SITES_ALL.
• VENDOR_SPLIT — allocation percentage assigned to the vendor when a sourcing rule splits demand.
• ASSIGNMENT_SET_ID — the assignment set associated with the sourcing rule.
• ORGANIZATION_ID / ORGANIZATION_CODE — inventory organization in which the rule applies.
• ASL_INSTALLED_FLAG — literal 'Y' indicating ASL functionality is active for the returned row.

Common Use Cases and Queries

Typical uses include diagnosing why a specific vendor is or is not defaulted onto a requisition, validating that ASL effective dates are aligned, and reporting on sourcing splits across vendors for a planner. A basic query returning the current approved sources for one item in one organization is:

SELECT item_id, item_description, vendor_name, vendor_site_code, vendor_rank, vendor_split, start_date, end_date FROM apps.po_autosource_rules_v WHERE item_id = :p_item_id AND organization_id = :p_org_id ORDER BY vendor_rank, vendor_name;

To audit rules that will expire within the next thirty days, filter on END_DATE: SELECT item_id, vendor_name, end_date FROM apps.po_autosource_rules_v WHERE end_date BETWEEN SYSDATE AND SYSDATE + 30 ORDER BY end_date;

Because PO_ASL_SV.CHECK_ASL_ACTION is executed per row, this view is not designed for unrestricted full-table scans in high-volume extracts. For bulk reporting, query MRP_ITEM_SOURCING_LEVELS_V directly and apply vendor validation separately. Where the view returns no rows for an item that has MRP sourcing levels defined, the usual causes are an ASL status of "Not Approved," a vendor-site outside its effective window, or an organization mismatch between the item and the operating unit.