Search Results mtl_shipping_network_view




Overview
Explore in AI Chat

Overview

The view APPS.MTL_SHIPPING_NETWORK_VIEW belongs to the Oracle Inventory (INV) product module and is delivered in the APPS schema with a documented status of VALID. It is described in the ETRM metadata as a retrofitted object, indicating that it was introduced or re-pointed as part of an upgrade or retrofit effort rather than a fresh design in the current release. The view presents the shipping network configuration between pairs of inventory organizations, denormalizing the raw inter-organization parameters stored in MTL_INTERORG_PARAMETERS and enriching each row with organization codes, organization names, and selected costing attributes from MTL_PARAMETERS and HR_ORGANIZATION_UNITS.

Functionally, the view answers the question "how does inventory move from organization A to organization B?" — including the in-transit type, distance, FOB point, transfer charge percent, inter-company accounting accounts, and intransit routing information. This makes it a convenient single source for reporting, inquiries, and integration extracts that need both the numeric organization identifiers and their human-readable codes and names.

The user's search term, interorg_trnsfr_charge_percent, maps directly to a column exposed by this view. Both a "dummy" version (FROM_CHARGE_PERCENT_DUMMY) drawn from MTL_PARAMETERS and the authoritative INTERORG_TRNSFR_CHARGE_PERCENT from MTL_INTERORG_PARAMETERS appear in the select list, so the view is a natural starting point for anyone investigating that attribute.

Underlying Base Objects

The documented 12.2.2 referenced base objects are:

  • MTL_INTERORG_PARAMETERS (SYNONYM) — the driving table, aliased NET, holding one row per from/to organization pair with the inter-organization transfer charge percent, in-transit information, and inter-company accounts.
  • MTL_PARAMETERS (SYNONYM) — joined twice, as MP1 on the from-organization and MP2 on the to-organization, supplying organization codes, primary cost method, and the charge percent "dummy" columns.
  • HR_ORGANIZATION_UNITS (VIEW) — joined as HOU1 and HOU2 to provide the organization names and location IDs for each side of the network.
  • HR_GENERAL (PACKAGE) and HR_SECURITY (PACKAGE) — supporting security/organization resolution objects referenced by the HR organization view layer.

The join predicates link MP1.ORGANIZATION_ID = NET.FROM_ORGANIZATION_ID, MP2.ORGANIZATION_ID = NET.TO_ORGANIZATION_ID, and the corresponding HOU1/HOU2.ORGANIZATION_ID columns, ensuring each row is fully labeled on both ends of the transfer.

Key Columns

Common Use Cases and Queries

The view is typically used to review or report on inter-organization transfer setups and to audit the transfer charge percent and in-transit configuration across the shipping network.

  • Auditing charge percentages between specific organizations.
  • Reporting the full shipping network with readable organization names.
  • Verifying in-transit and inter-company accounting configuration.

Sample query to investigate the searched attribute:

SELECT from_organization_code,
  from_organization_name,
  to_organization_code,
  to_organization_name,
  interorg_trnsfr_charge_percent,
  intransit_type,
  fob_point
FROM apps.mtl_shipping_network_view
WHERE from_organization_code = '&from_org'
  AND to_organization_code = '&to_org';

Because the view is owned by APPS and exposed as a single denormalized rowset, it can be joined directly to reporting tools, custom concurrent programs, and integration extracts without re-implementing the joins to MTL_INTERORG_PARAMETERS, MTL_PARAMETERS, and HR_ORGANIZATION_UNITS.