Search Results mtl_client_parameters_v




Overview
Explore in AI Chat

Overview

MTL_CLIENT_PARAMETERS_V is an Oracle E-Business Suite Inventory (INV) reporting view owned by the APPS schema. It presents client-level receiving and shipping control parameters maintained in the MTL_CLIENT_PARAMETERS table, enriched with descriptive attributes drawn from Oracle Receiving, Oracle Shipping Execution, and Oracle Trading Community Architecture (HZ) tables. The view consolidates configuration data that governs inbound receipt processing, advance ship notice (ASN) behavior, RMA routing, delivery grouping, ship confirmation, and license plate number (LPN) generation for a given client (trading partner).

The view is primarily used for reporting, data extraction, and integration scenarios requiring resolved, human-readable values rather than raw identifiers. While the underlying configuration is stored in MTL_CLIENT_PARAMETERS, the view resolves party names, routing names, ship confirm rule names, and delivery report set names, eliminating the need for downstream join logic. The inclusion of the CLIENT_NUMBER column makes the view a natural reference point for queries searching on client_number, since that identifier appears directly in the view's SELECT list.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

Common Use Cases and Queries

Typical uses include validating client receiving parameters, auditing ship confirmation configuration, verifying LPN numbering schemes, and feeding integration extracts. A common lookup is retrieval of parameters by client number:

  • SELECT client_id, client_code, client_name, client_number, ship_confirm_rule_name, lpn_prefix, lpn_suffix
  • FROM apps.mtl_client_parameters_v
  • WHERE client_number = :p_client_number;

Reporting clients with LPN control:

  • SELECT client_number, client_name, lpn_prefix, total_lpn_length
  • FROM apps.mtl_client_parameters_v
  • WHERE lpn_prefix IS NOT NULL;

The view should be treated as read-only configuration reference data; parameter changes are made through the Inventory receiving and shipping setup forms, not directly against the view.