Search Results elemental_visibility_enabled

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

• FROM_ORGANIZATION_CODE, TO_ORGANIZATION_CODE — organization codes from MTL_PARAMETERS.
• FROM_ORGANIZATION_NAME, TO_ORGANIZATION_NAME — descriptive names from HR_ORGANIZATION_UNITS.
• INTERORG_TRNSFR_CHARGE_PERCENT — the transfer charge percentage configured for this organization pair.
• INTRANSIT_TYPE, DISTANCE_UOM_CODE, TO_ORGANIZATION_DISTANCE — logistics and in-transit characteristics.
• MATL_INTERORG_TRANSFER_CODE, FOB_POINT, ROUTING_HEADER_ID — material transfer and routing configuration.
• INTERNAL_ORDER_REQUIRED_FLAG — whether an internal order is mandatory.
• INTRANSIT_INV_ACCOUNT, INTERORG_TRANSFER_CR_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PAYABLES_ACCOUNT, INTERORG_PRICE_VAR_ACCOUNT, INTERORG_PROFIT_ACCOUNT — inter-company accounting accounts.
• ELEMENTAL_VISIBILITY_ENABLED — a DECODE-normalized flag defaulting to 'N' when null.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard descriptive flexfield columns.
• Audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

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.