Search Results to_primary_cost_dummy

Overview

APPS.MTL_SHIPPING_NETWORK_VIEW is a denormalized reporting view in Oracle E-Business Suite that presents the inter-organization shipping network configuration maintained in Oracle Inventory. Each row represents a directed shipping relationship between a "from" organization and a "to" organization, enriched with organization codes, organization names, location identifiers, costing method indicators, and the full set of interorg transfer parameters and accounting accounts. The view is a joined projection over MTL_INTERORG_PARAMETERS, MTL_PARAMETERS, and HR_ORGANIZATION_UNITS, and therefore does not store data itself; it is a read-only convenience layer used by reports, extracts, and integration routines that require a human-readable representation of the shipping network.

The object is documented in ETRM 12.2.2 under the APPS schema and is compatible with the 12.1.1 and 12.2.2 table structures. Because it exposes descriptive codes and names alongside the raw identifiers, it is commonly used in Oracle Inventory, Order Management, and intercompany/interorg transfer reporting where a direct join between MTL_INTERORG_PARAMETERS and HR_ORGANIZATION_UNITS would otherwise be required.

Underlying Base Objects

The ETRM metadata lists the following referenced base objects: HR_GENERAL (PACKAGE), HR_ORGANIZATION_UNITS (VIEW), HR_SECURITY (PACKAGE), MTL_INTERORG_PARAMETERS (SYNONYM), and MTL_PARAMETERS (SYNONYM). The view definition joins these as follows:

• MTL_INTERORG_PARAMETERS NET — the driving table, supplying the from/to organization IDs, in-transit type, distance UOM and distance, transfer charge percent, FOB point, routing header, internal order flag, and all interorg accounting accounts. It is aliased NET because it defines the network edges.
• MTL_PARAMETERS MP1 and MP2 — joined on ORGANIZATION_ID to NET.FROM_ORGANIZATION_ID and NET.TO_ORGANIZATION_ID respectively, supplying organization code, primary cost method, and the interorg transfer charge percent columns that are exposed as dummy aliases.
• HR_ORGANIZATION_UNITS HOU1 and HOU2 — joined on ORGANIZATION_ID to the corresponding MTL_PARAMETERS rows, supplying the organization name and location ID for each side of the network.

HR_GENERAL and HR_SECURITY are referenced by the underlying HR_ORGANIZATION_UNITS view and the organization security model, which governs row-level access to organizations in a multi-org environment.

Key Columns

• ROW_ID — the ROWID of the MTL_INTERORG_PARAMETERS row.
• FROM_ORGANIZATION_CODE / TO_ORGANIZATION_CODE — organization codes from MTL_PARAMETERS for each side of the transfer.
• FROM_ORGANIZATION_NAME / TO_ORGANIZATION_NAME — descriptive names from HR_ORGANIZATION_UNITS.
• FROM_CHARGE_PERCENT_DUMMY / TO_PRIMARY_COST_DUMMY / FROM_PRIMARY_COST_DUMMY — alias names exposing MP1.INTERORG_TRNSFR_CHARGE_PERCENT and the primary cost method columns. The "DUMMY" suffix reflects legacy column naming conventions carried forward for backward compatibility.
• FROM_ORGANIZATION_ID / TO_ORGANIZATION_ID — the numeric organization identifiers defining the network edge.
• INTRANSIT_TYPE, DISTANCE_UOM_CODE, TO_ORGANIZATION_DISTANCE — in-transit inventory handling and distance attributes.
• INTERORG_TRNSFR_CHARGE_PERCENT, FOB_POINT, ROUTING_HEADER_ID, INTERNAL_ORDER_REQUIRED_FLAG — operational transfer parameters.
• INTRANSIT_INV_ACCOUNT, INTERORG_TRANSFER_CR_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PAYABLES_ACCOUNT, INTERORG_PRICE_VAR_ACCOUNT, INTERORG_PROFIT_ACCOUNT — the interorg accounting accounts.
• ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield columns.
• ELEMENTAL_VISIBILITY_ENABLED — DECODE-normalized to 'N' when NULL.
• FROM_LOCATION_ID / TO_LOCATION_ID — location identifiers from HR_ORGANIZATION_UNITS.

Common Use Cases and Queries

The view is typically queried to list all valid shipping lanes, to verify accounting setups, or to drive transfer pricing logic. A sample query retrieving the network with descriptive names is:

SELECT from_organization_code, from_organization_name,
       to_organization_code, to_organization_name,
       interorg_trnsfr_charge_percent, intransit_type
FROM   apps.mtl_shipping_network_view
WHERE  from_organization_code = :p_org
ORDER BY to_organization_code;

For the far more common search term from_charge_percent_dummy, the column is used when a report needs the charge percent sourced from the "from" organization's MTL_PARAMETERS record rather than from the network row itself:

SELECT from_organization_code, from_charge_percent_dummy,
       interorg_trnsfr_charge_percent
FROM   apps.mtl_shipping_network_view;

Other practical uses include validating that each to-organization has receivable and payable accounts defined, auditing FOB point and in-transit ownership, and feeding interorg transfer extracts for Order Management and Cost Management interfaces.