Results for “processing_lead_time”

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

Overview

MRP_PO_SUPPLIERS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. It is a component of the MRP (Master Scheduling/MRP) product and is described in the source metadata as a "supplier item view." Its purpose is to expose, in a single denormalized result set, the sourcing relationships that connect a planned item to an approved supplier and supplier site, together with the purchasing attributes that govern how that item is procured. Because the view joins master-level item and organization data to the approved supplier list (ASL) and its attributes, it is consumed by planning, sourcing, and procurement reporting logic rather than being a transactional entry point.

The view is registered as VALID, confirming that it compiles against the current object definitions in both the 12.1.1 and 12.2.2 data models. It is read-only in nature; no DML is supported against a view of this construction.

Underlying Base Objects

The documented base objects underlying MRP_PO_SUPPLIERS_V are:

• MRP_PLAN_ORGANIZATIONS_V (VIEW) — supplies the organization context for planned organizations.
• MRP_SYSTEM_ITEMS (SYNONYM) — provides item master and organization-level item data, including inventory item identifiers and compile designators.
• PO_APPROVED_SUPPLIER_LIS_VAL_V (VIEW) — the approved supplier list view, supplying ASL identifiers, vendor and vendor site references, and the using organization.
• PO_ASL_ATTRIBUTES (SYNONYM) — provides the ASL-level purchasing attributes such as processing lead time, minimum order quantity, fixed lot multiple, delivery calendar, and purchasing unit of measure.
• PO_ASL_SV (PACKAGE) — invoked through its CHECK_ASL_ACTION function to qualify rows for the '2_SOURCING' action.

The joins are driven by inventory item, organization, and ASL identifiers. A notable filter is ASL.USING_ORGANIZATION_ID = -1, which restricts the approved supplier list to the master (global) level rather than organization-specific entries. The view additionally correlates MRP_SYSTEM_ITEMS.COMPILE_DESIGNATOR and ORGANIZATION_ID with MRP_PLAN_ORGANIZATIONS_V to anchor items to planned organizations. The final predicate requires PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING', ...) to return a non-zero value, so only ASL rows passing that sourcing validation are returned.

Key Columns

• COMPILE_DESIGNATOR — identifies the MRP compile or plan designator associated with the item and organization pairing.
• INVENTORY_ITEM_ID — the inventory item identifier from the item master.
• ORGANIZATION_ID — the planned organization for which the item is evaluated.
• USING_ORGANIZATION_ID — the organization context of the ASL row; documented queries filter on -1 for global sourcing.
• ASL_ID — the approved supplier list identifier linking item to supplier.
• SUPPLIER_ID / SUPPLIER_SITE_ID — the vendor and vendor site qualified for the item.
• PROCESSING_LEAD_TIME — procurement lead time used by planning calculations.
• MINIMUM_ORDER_QUANTITY and FIXED_LOT_MULTIPLIER — order modifiers applied when generating planned orders.
• DELIVERY_CALENDAR_CODE — the calendar governing delivery scheduling.
• PURCHASING_UNIT_OF_MEASURE and PRIMARY_UOM_CODE — the unit of measure in which the item is purchased versus its primary stocking UOM.

Common Use Cases and Queries

Typical uses include validating that a planned item has an approved, sourcing-eligible supplier before MRP generates planned purchase orders, and reporting which vendors and purchasing attributes apply to items within a plan. A representative query:

• SELECT inventory_item_id, organization_id, supplier_id, supplier_site_id, processing_lead_time, minimum_order_quantity, fixed_lot_multiplier FROM mrp_po_suppliers_v WHERE organization_id = :org_id;
• Join the view to MRP_SYSTEM_ITEMS or item master queries on INVENTORY_ITEM_ID and ORGANIZATION_ID to enrich sourcing reports with item descriptions.
• Filter on COMPILE_DESIGNATOR to isolate rows for a specific plan or compile run when auditing planned-order sourcing.