Search Results mtl_transaction_flows_v




Overview
Explore in AI Chat

Overview

MTL_TRANSACTION_FLOWS_V is a seeded Oracle E-Business Suite view owned by the APPS schema and shipped with the Inventory (INV) product. It is VALID in both the 12.1.1 and 12.2.2 releases. The view exposes Intercompany transaction flows of type shipping and procuring, and is the principal reporting and integration surface for the accounting and trading relationships that govern how one operating unit transacts with another. It is not an operational entry form; it is a denormalized read-only projection over the intercompany flow header, line, and parameter tables, allowing users to resolve flow definitions without writing the three-way join themselves.

For users who search on the column name expense_accrual_account_id, this view is the documented source. That column carries the General Ledger account used to accrue the expense side of an intercompany shipment or receipt when the inventory and intercompany accounting entries are generated.

Underlying Base Objects

The view text joins three synonyms that resolve to the following APPS tables:

  • MTL_INTERCOMPANY_PARAMETERS (aliased IC) — holds the trading-partner and accounting configuration for a given ship organization, sell organization, and flow type.
  • MTL_TRANSACTION_FLOW_HEADERS (aliased H) — holds the flow header, including flow type, qualifier, date range, and pricing options.
  • MTL_TRANSACTION_FLOW_LINES (aliased L) — holds the flow line rows, including line number and the from/to organization identifiers.

The join is driven as: H.HEADER_ID = L.HEADER_ID, with L.FROM_ORG_ID = IC.SHIP_ORGANIZATION_ID, L.TO_ORG_ID = IC.SELL_ORGANIZATION_ID, and H.FLOW_TYPE = IC.FLOW_TYPE. Because MTL_INTERCOMPANY_PARAMETERS is the tuning key, the header/line combination is effectively filtered to parameters that already exist for that ship/sell/flow combination.

Key Columns

Common Use Cases and Queries

Typical uses include validating intercompany setup prior to period close, auditing the accrual and COGS accounts assigned to a ship/sell pair, and extracting flow definitions for reconciliation or data-warehouse loads.

To find the expense accrual account for all active shipping flows:

SELECT header_id, from_org_id, to_org_id, flow_type, expense_accrual_account_id
FROM apps.mtl_transaction_flows_v
WHERE flow_type = 'SHIPPING';

To list the complete accounting configuration for a specific ship/sell pair:

SELECT header_id, line_number, from_org_id, to_org_id,
       inventory_accrual_account_id, expense_accrual_account_id,
       intercompany_cogs_account_id
FROM apps.mtl_transaction_flows_v
WHERE from_org_id = &ship_org
  AND to_org_id = &sell_org;

Because accounts are stored as code_combination_id references, results are normally joined to FND_FLEX_VALUES or GL_CODE_COMBINATIONS to render the concatenated account string for reporting.