Results for “pos_asl_tolerance_v”

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

Overview

The POS_ASL_TOLERANCE_V view is a seeded database object owned by the APPS schema within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is associated with the ICX module, otherwise known as Oracle iProcurement. The view consolidates approved supplier list (ASL) information with supplier item tolerance definitions, presenting a denormalized result set that joins the ASL header data to its associated receiving tolerance configuration.

In the context of iProcurement and the broader purchasing flow, this view provides a single, query-friendly source for determining the quantity and time-based tolerances that apply to a specific supplier, item, and vendor site combination. Rather than requiring application code or reports to join two separate tables and resolve the correct organization context, the view exposes all relevant identifiers and tolerance attributes in a flat structure. This makes it particularly valuable for reporting, diagnostics, and integration logic where tolerance values must be evaluated against receipts or order quantities.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed as synonyms in the APPS schema:

• PO_APPROVED_SUPPLIER_LIST (aliased ASL) — the master ASL table storing vendor, item, and vendor site relationships.
• PO_SUPPLIER_ITEM_TOLERANCE (aliased ITO) — the table that stores tolerance definitions keyed to an ASL identifier.

The join is performed on the ASL identifier: ASL.ASL_ID = ITO.ASL_ID. This means the view returns one row for every ASL record that has at least one corresponding tolerance definition. ASL records without a tolerance entry will not appear in the result set, which is an important consideration when tolerance absence must be distinguished from zero tolerance.

Key Columns

• ASL_ID — Primary key linking the approved supplier list entry to its tolerance record; the central join key.
• USING_ORGANIZATION_ID — The inventory organization in whose context the ASL and tolerance apply. This is critical for multi-org filtering.
• NUMBER_OF_DAYS — The number of days defining the time window over which the tolerance is evaluated. This is the column most frequently referenced in searches such as "number_of_days".
• TOLERANCE — The tolerance value (typically a percentage or quantity threshold) permitted for the associated supplier item.
• VENDOR_ID — Identifier of the supplier associated with the ASL entry.
• ITEM_ID — Identifier of the inventory item to which the ASL and tolerance apply.
• VENDOR_SITE_ID — Identifier of the specific supplier site associated with the ASL entry.

Common Use Cases and Queries

Typical usage centers on reporting and validation of receiving tolerances by supplier, item, and organization.

• Listing tolerances for a specific organization and supplier:

SELECT asl_id,
       vendor_id,
       item_id,
       vendor_site_id,
       number_of_days,
       tolerance
FROM   apps.pos_asl_tolerance_v
WHERE  using_organization_id = :org_id
AND    vendor_id = :vendor_id;

• Retrieving the tolerance window (number_of_days) for a particular item and vendor site:

SELECT number_of_days, tolerance
FROM   apps.pos_asl_tolerance_v
WHERE  item_id = :item_id
AND    vendor_site_id = :vendor_site_id
AND    using_organization_id = :org_id;

• Supporting integration or diagnostic queries that must reconcile ASL configuration against receipt or order data, where the view provides the authoritative tolerance reference without requiring direct joins to the base tables.

Because the view is a simple inner join, performance is generally governed by the indexes on PO_APPROVED_SUPPLIER_LIST and PO_SUPPLIER_ITEM_TOLERANCE on ASL_ID, and by filtering on USING_ORGANIZATION_ID to constrain the result set in multi-organization deployments.