Search Results inv_ui_rcv_lovs




Overview
Explore in AI Chat

Overview

The APPS.INV_UI_RCV_LOVS package body provides the server-side list of values (LOV) queries used by the Oracle E-Business Suite receiving user interface. Its primary responsibility is to populate the selection lists that appear on the Receiving, Receipt, Delivery, and Inspection forms, dynamically constructing the underlying SQL based on the current operating unit, inventory organization, and mobile form context. The package is classified under the OTHER API category in ETRM and is owned by the APPS schema. It is a UI-support utility rather than a transactional API; it does not post receipts or update inventory, but instead retrieves the reference data that a user must select before a receipt transaction can be recorded.

The header comment ($Header: INVRCVLB.pls 120.31.12010000.6) confirms the package is an Oracle-shipped file delivered with the Receiving product. It exposes 33 documented procedures, each dedicated to a specific LOV.

Key Procedures and Functions

The documented procedures are grouped by the reference data they resolve:

Tables Accessed

The LOV SQL reads from a broad set of APPS synonyms:

Usage Notes

This package is invoked at runtime by the Receiving forms (including the mobile receipt and delivery forms, referenced by the p_mobile_form parameter) whenever a user opens an LOV field. Because it is a pure retrieval utility, it is well suited for reuse in custom Forms personalizations and OAF pages that require the same validated lists. Developers should note that the SQL reflects Multi-Org Access Control through calls such as MO_GLOBAL.get_ou_name, so results are filtered by the caller's operating unit; organization context is passed explicitly through parameters such as p_organization_id. The package is referenced by one other APPS package and should be treated as an internal Receiving component rather than a general-purpose integration API.