Results for “distance_uom_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_INTERORG_PARAMETERS is the Oracle Inventory (INV) configuration table that defines the inter-organization transfer relationship between any two inventory organizations. Each row represents a directed pairing of a shipping (FROM) organization and a receiving (TO) organization, and it captures the shipping network, intransit behavior, financial accounting, and pricing rules that govern material movement between those organizations. In Oracle EBS 12.1.1 and 12.2.2 the table is owned by the INV schema and is central to inter-org transfers, internal requisitions, intransit inventory, kanban replenishment, and intercompany invoicing flows.

From a dimensional modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The row is keyed by a two-part identifier rather than a single surrogate, and it holds descriptive and accounting attributes that change over time for a given organization pair, which is consistent with satellite-style coverage around organizational hub entities.

Key Information Stored

The table contains 67 documented columns. The composite primary key MTL_INTERORG_PARAMETERS_PK is formed from FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID, both of which are foreign keys to MTL_PARAMETERS. A unique index, MTL_INTERORG_PARAMETERS_U1, covers the same two columns in the reverse order, confirming that the combination is the business key.

• FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID — define the direction and identity of the shipping/receiving relationship.
• INTRANSIT_TYPE — controls how goods are treated while in transit; determines which intransit accounting logic applies.
• INTRANSIT_INV_ACCOUNT — the GL account that holds intransit inventory value between shipment and receipt.
• INTERORG_TRANSFER_CR_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PAYABLES_ACCOUNT, INTERORG_PRICE_VAR_ACCOUNT — the intercompany accounting accounts used when the two organizations belong to different legal entities.
• INTERORG_TRNSFR_CHARGE_PERCENT — the percentage markup applied to transfer pricing.
• ROUTING_HEADER_ID — links to RCV_ROUTING_HEADERS to specify the shipment routing.
• PRICELIST_ID — references the price list (OP_PRCE_MST) used for inter-org transfer valuation.
• MATL_INTERORG_TRANSFER_CODE and FOB_POINT — control transfer documentation and title/ownership transfer timing.
• INTERNAL_ORDER_REQUIRED_FLAG — indicates whether an internal sales order must exist for the transfer.
• FOB_POINT and DISTANCE_UOM_CODE / TO_ORGANIZATION_DISTANCE — define shipping terms and transportation distance/duration.
• ATTRIBUTE1–15 and GLOBAL_ATTRIBUTE1–20 — descriptive flexfield and global descriptive flexfield segments for customer extensions.

Common Use Cases and Queries

A frequent requirement is to resolve the parameters in effect for a shipment between two organizations, for example to determine the intransit account or routing when processing an inter-org transfer or an internal requisition.

• Lookup the configuration for a specific FROM/TO pair:

  SELECT * FROM mtl_interorg_parameters WHERE from_organization_id = :from_org AND to_organization_id = :to_org;

• Join to MTL_PARAMETERS twice to report organization names and codes alongside their transfer settings.
• Reconcile intransit inventory accounting by joining INTRANSIT_INV_ACCOUNT to GL_CODE_COMBINATIONS for account validation and reporting.
• Identify organization pairs still using a default or legacy transfer charge percentage during pricing or intercompany setup reviews.

Related Objects

The table participates in a dense set of foreign-key relationships, both as a referencing and as a referenced object.

• MTL_PARAMETERS — referenced twice via FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID; provides organization-level parameters.
• GL_CODE_COMBINATIONS — referenced five times (INTRANSIT_INV_ACCOUNT, INTERORG_TRANSFER_CR_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PAYABLES_ACCOUNT, INTERORG_PRICE_VAR_ACCOUNT).
• RCV_ROUTING_HEADERS — via ROUTING_HEADER_ID, defining receipt routing.
• OP_PRCE_MST — via PRICELIST_ID for inter-org pricing.
• MTL_SUPPLY — references (FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID), linking the relationship to supply records.
• MTL_KANBAN_CARDS, MTL_KANBAN_PULL_SEQUENCES, and FLM_KANBAN_SUMMARY — reference (SOURCE_ORGANIZATION_ID, ORGANIZATION_ID), driving kanban replenishment across organizations.

Together these relationships make MTL_INTERORG_PARAMETERS a foundational configuration object for supply, kanban, intercompany, and inventory accounting operations within Oracle EBS.