Search Results chk_wms_install

Overview

INV_PICK_SLIP_REPORT is an Oracle Inventory (INV) report package in the APPS schema that drives the extraction, filtering, and presentation logic behind the Move Order Pick Slip Report and related pick slip output in Oracle E-Business Suite. In release 12.1.1 and 12.2.2, this package provides the backend PL/SQL engine used to select move order transactions, resolve source and destination inventory attributes, and produce formatted pick slip output for warehouse personnel. It is classified as an OTHER API in the ETRM repository, meaning it is an internal report-support package rather than a public, declaratively supported integration API. Its principal consumers are the concurrent programs and print routines associated with move orders, sales order picks, and warehouse picking operations. The package is declared AUTHID CURRENT_USER, so it executes under the privileges of the calling session and depends on the APPS synonyms for the base inventory and shipping tables it references.

Key Procedures and Functions

The ETRM metadata documents two callable units.

• CHK_WMS_INSTALL — A function that reports whether Warehouse Management System (WMS) functionality is installed for a given organization. It accepts an organization identifier and returns the string TRUE when WMS is installed and FALSE otherwise. The header comment states the API is intended specifically for the Move Order Pick Slip Report's move order type value set, allowing the report to conditionally present or enable move order types that depend on WMS being present.
• RUN_DETAIL_ENGINE — The core report engine procedure. It accepts a comprehensive set of filter parameters covering organization, move order type and number range, source and destination subinventory and locator, sales order range, freight code, customer, requesting user, required date range, a plan-tasks flag, a pick slip group rule identifier, and a request identifier. It returns status through an OUT parameter. This procedure is the entry point corresponding to the "run_detail_engine" search term: it performs the detail-level data retrieval and assembly that underlies the pick slip report output.

The package header additionally exposes a PRINT_PICK_SLIP function in the supplied source; it is not enumerated among the ETRM-documented procedures but forms part of the same report package.

Tables Accessed

The package reaches the following tables through APPS synonyms:

• MTL_TXN_REQUEST_HEADERS and MTL_TXN_REQUEST_LINES — the move order header and line tables that supply the pickable demand, move order numbers, and transaction types filtered by the report parameters.
• MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_MATERIAL_TRANSACTIONS_S — transaction staging and the transaction sequence used to associate allocations and material movements with pick slip lines.
• MTL_SYSTEM_ITEMS — item master attributes used to describe and validate the items appearing on each pick slip.
• WSH_DELIVERY_DETAILS — shipping delivery detail records that link sales order demand to the picking activity being reported.
• DUAL — used for scalar evaluations, including the WMS installation check.

Usage Notes

INV_PICK_SLIP_REPORT is invoked indirectly rather than called directly by end users. The Move Order Pick Slip Report and associated pick slip print programs call PRINT_PICK_SLIP and the detail engine to retrieve and format data for a given request. Because RUN_DETAIL_ENGINE accepts a request identifier, it is designed to run within the context of a concurrent request, enabling output to be associated with that request. Two other packages reference this package, indicating it sits mid-tier in the reporting call chain. Customizations should treat it as an internal package: signatures and behavior are governed by the shipped source and may change between patch levels, so direct calls from custom code carry upgrade risk. The chk_wms_install function is the supported pattern for determining WMS availability when building or extending move order type value sets in report parameters.