Search Results inv_consign_util




Overview
Explore in AI Chat

Overview

INV_CONSIGN_UTIL is a public PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite. Its name reflects its role in supporting consigned inventory processing, where goods are held at a buying organization's location but legal title remains with the supplier until consumption. In this model, an accurate Approved Supplier List (ASL) entry is essential, because sourcing, receipt, and consumption of consigned material must resolve to a valid supplier agreement. The package provides a single, centralized resolution routine that returns the correct ASL identifier for a given item, vendor, vendor site, and using organization combination.

The source header dates the package to 2003 and marks it as not shipped at the time of that revision, indicating it is an internal utility rather than a standalone entry point for users. It is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling schema, relying on APPS-owned synonyms for access to the underlying purchasing tables.

Key Procedures and Functions

The package exposes one documented function, GET_ASL_ID. It returns a NUMBER, which is the ASL identifier. Its documented inputs are the item, vendor, vendor site, and using organization identifiers, all marked as required. The function performs the lookup with two important business rules encoded in its logic:

  • Preference for local ASL over global ASL. Where both a global sourcing rule and an organization-specific ASL exist, the local (organization-level) entry is returned, because it represents the more specific sourcing decision for that receiving or using organization.
  • Eligibility filtering. The returned ASL must not be disabled, and its status must permit the intended sourcing action. ASL statuses control which procurement activities (for example, purchasing or receipt) an entry is authorized for; entries whose status blocks the action are excluded from consideration.

No other public programs are documented for this package in the 12.1.1/12.2.2 reference metadata.

Tables Accessed

The package reads from PO_ASL_ATTRIBUTES (accessed through an APPS synonym). This table stores the attribute-level details attached to ASL entries, including the item, vendor, vendor site, and organization relationships, as well as the status and disabled flag that determine eligibility. The function uses these columns to join the sourcing dimensions supplied by the caller and to apply the local-versus-global preference and status checks. The metadata lists no other referenced tables, and the package is not documented as writing to any table; it is a read-only resolution utility.

Usage Notes

GET_ASL_ID is typically invoked from consigned inventory logic where the application already knows the item, supplier, supplier site, and destination organization but must determine which ASL record authorizes the transaction. Because the metadata records zero packages referencing INV_CONSIGN_UTIL, direct callers are more likely to be forms, concurrent programs, or custom extensions than other PL/SQL packages within the documented set.

When calling the function, all four parameters are mandatory; passing a null item, vendor, vendor site, or organization defeats the lookup. Callers should treat the returned value as a candidate ASL identifier and be prepared for a null result when no eligible entry exists, since the function filters out disabled ASL records and those whose status does not allow the action. Because the local preference rule is applied internally, callers do not need to pass a global organization or pre-resolve sourcing hierarchy; supplying the actual using organization yields the correct local-first result. Custom code that duplicates this lookup should instead call GET_ASL_ID to remain consistent with standard consigned sourcing behavior across releases.