Search Results chv_inq_sv




Overview
Explore in AI Chat

Overview

CHV_INQ_SV is an Oracle Applications (APPS) schema PL/SQL package that supports inquiry and validation logic for Oracle Supply Chain's supplier scheduling and cumulative management functionality. Its object name—combining "CHV" (the supplier scheduling module prefix) with "INQ" (inquiry) and "SV" (server-side routine)—indicates its role as the backend server package that supplies data and performs validation for the supplier scheduling inquiry forms and views. Within Oracle EBS 12.1.1 and 12.2.2, the supplier scheduling module (CHV) manages approved supplier schedules, cumulative quantities, and horizontal schedule buckets used in the automotive and high-volume manufacturing supply model. CHV_INQ_SV acts as the shared server-side logic engine behind the various inquiry-only views in that module.

The package's dependency metadata shows it is referenced by a substantial set of database views and packages, notably CHV_CUM_ITEMS_V, CHV_HORIZ_BKT_SCHEDULES_V, CHV_SCHEDULE_ITEMS_V, ICX_CHV_SCHEDULE_ITEMS_V, ICX_CHV_SCHEDULE_LINES_V, ICX_HORIZONTAL_SCHEDULE_V, POS_CHV_SCHEDULE_ITEMS_V, POS_HORIZONTAL_SCHEDULE_V, and ECE_SPSO_TRANS1. This pattern confirms that CHV_INQ_SV functions as a reusable query and validation layer consumed by inquiry views, self-service (ICX) pages, and external interface logic.

Key Procedures and Functions

The documented metadata lists five procedures or functions within APPS.CHV_INQ_SV. The ETRM record exposes only the count and the generic "NAME" placeholder for these program units, so individual signatures and parameter lists cannot be confirmed from the metadata. Based on the package's inquiry-oriented name and the views that depend on it, these routines are understood to perform data-retrieval and validation operations for supplier schedule inquiry, including:

  • Supplier schedule and horizontal bucket inquiry routines — functions that return schedule line and bucket data for display in inquiry forms and views such as CHV_HORIZ_BKT_SCHEDULES_V and CHV_SCHEDULE_ITEMS_V.
  • Cumulative quantity inquiry routines — logic that surfaces cumulative received and shipped quantities for items, consistent with the CHV_CUM_ITEMS_V view.
  • Validation routines — procedures that validate item, unit of measure, and shipment data referenced by the schedule inquiry views.

Because ETRM does not publish the individual routine names for this object, the precise enumeration of the five units cannot be stated without invention. Implementers should query the ALL_PROCEDURES or ALL_ARGUMENTS data dictionary views against APPS.CHV_INQ_SV to obtain the exact routine inventory.

Tables Accessed

The documented table references for CHV_INQ_SV are:

  • CHV_HORIZONTAL_SCHEDULES — the primary supplier scheduling table holding horizontal schedule bucket information; the package reads this to supply inquiry data.
  • MTL_UNITS_OF_MEASURE — provides the unit of measure definition for schedule items.
  • PO_HEADERS — purchase order header information associated with the supplier schedule.
  • RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES — receipt shipment data used to derive received quantities and cumulative totals.
  • RCV_TRANSACTIONS — receipt transaction detail used to compute cumulative received quantities.

Collectively these tables allow CHV_INQ_SV to join schedule buckets against receipt activity, thereby producing the cumulative and net schedule figures displayed to planners and suppliers.

Usage Notes

CHV_INQ_SV is typically invoked indirectly rather than through direct user execution. Its consumers are the inquiry views and associated form and self-service regions in the supplier scheduling module. Because it is referenced by nine other packages and multiple views, it forms a low-level shared service: Oracle Forms-based supplier schedule inquiry windows, the iSupplier/ICX schedule pages, and the POS (point-of-sale/order scheduling) and ECE (e-commerce gateway) integration views all rely on it. In EBS 12.2.2 the package resides in the APPS schema and remains in VALID status, meaning it compiles cleanly and requires no remediation. Customizations and extensions that need supplier schedule inquiry data should call the appropriate CHV_INQ_SV routine instead of querying the underlying tables directly, to preserve consistency with the delivered views. As with all APPS code, the package should be treated as Oracle-owned; modifications via CUSTOM schema wrapping are the supported extension approach.