Search Results get_valid_serial_rec_5




Overview
Explore in AI Chat

Overview

INV_TRANSACTION_LOVS is a public PL/SQL package in the APPS schema that provides the value-set query logic behind the List of Values (LOV) fields used throughout Oracle Inventory transaction entry. Its procedures return REF CURSOR result sets rather than scalar values, allowing Oracle Forms and other callers to populate dynamic LOV windows with context-sensitive data such as valid transaction types, reasons, carriers, accounts, items, locators, subinventories, and lot, revision, and serial numbers. In effect, the package encapsulates the business rules that determine whether a given value is selectable for a specific transaction, organization, or item, so that the same validation logic is reused consistently across the Inventory transaction forms.

The package is declared with AUTHID CURRENT_USER, meaning its database objects are resolved using the privileges of the invoking user rather than the package owner's privileges. It is classified as an "OTHER" API in the ETRM metadata and is referenced by one other package, reflecting its role as a supporting LOV provider rather than a business transaction API itself.

Key Procedures and Functions

The documented procedures return data for LOV windows; none of them perform transaction processing. Their purposes are as follows:

  • GET_TXN_REASONS — Returns the list of valid transaction reasons.
  • GET_TXN_TYPES — Returns valid transaction types, with overloads supporting either a transaction action and source type plus type name, or a source type identifier for move-order transaction types.
  • GET_CARRIER — Returns the list of carriers available for a transfer, filtered by the from-organization, to-organization, and a carrier search criterion. This is the procedure associated with the user's search term "get_carrier".
  • GET_ACCOUNT_ALIAS — Returns account aliases for an organization.
  • GET_ACCOUNTS — Returns valid accounts for an organization based on a concatenated segment value.
  • GET_ITEMS — Returns items for an organization based on a concatenated segment value.
  • GET_TRANSACTABLE_ITEMS — Returns items that are valid for a given transaction action and, optionally, a destination organization.
  • GET_VALID_LOCATORS — Returns valid locators for an organization, subinventory, and item, subject to a locator restriction setting.
  • GET_VALID_TO_LOCS — Returns valid destination locators for a transaction action and destination organization.
  • GET_VALID_SUBS, GET_FROM_SUBS, GET_TO_SUB — Return valid subinventories for the applicable side of a transaction.
  • GET_ORG, GET_TO_ORG — Return valid organizations for source or destination selection.
  • GET_VALID_UOMS — Returns valid units of measure.
  • GET_VALID_LOTS, GET_VALID_REVS — Return valid lot numbers and item revisions.
  • GET_VALID_SERIAL_REC_2, GET_VALID_SERIAL_REC_5, GET_VALID_SERIAL_ISSUE — Return valid serial numbers for receiving and issue contexts.

Tables Accessed

The package reads from a focused set of Inventory and HR tables through APPS synonyms. Organization information comes from HR_ALL_ORGANIZATION_UNITS and MTL_PARAMETERS. Item data is drawn from MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV, with MTL_ITEM_REVISIONS supplying revision values and MTL_GENERIC_DISPOSITIONS supporting disposition lookups. Locator and subinventory validation uses MTL_SECONDARY_INVENTORIES and MTL_SECONDARY_LOCATORS. Transaction types and reasons come from MTL_TRANSACTION_TYPES and MTL_TRANSACTION_REASONS. On-hand and serialization data is read from MTL_ONHAND_QUANTITIES_DETAIL, MTL_LOT_NUMBERS, and MTL_SERIAL_NUMBERS. Inter-organization transfer parameters are read from MTL_INTERORG_PARAMETERS, and DUAL is used for single-row evaluations.

Usage Notes

INV_TRANSACTION_LOVS is typically invoked from the Oracle Inventory transaction forms (such as the miscellaneous transaction, subinventory transfer, and inter-organization transfer windows) and from any custom form or concurrent program that needs the same validated LOV result sets. Callers open the returned REF CURSOR, fetch rows into the LOV record group, and close the cursor. Because the procedures apply organization, item, and transaction context filters, they should be called with the correct identifiers to prevent users from selecting invalid values. Custom code referencing this package should account for its AUTHID CURRENT_USER behavior and ensure the invoking user has the necessary privileges on the underlying Inventory tables.