Search Results mtl_txn_backorders_v




Overview
Explore in AI Chat

Overview

APPS.MTL_TXN_BACKORDERS_V is a reporting and integration view in the Oracle E-Business Suite Inventory (INV) module. It exposes move order lines that could not be fully staged or transacted, surfacing the shortfall between the quantity originally requested on a move order line and the quantity that could actually be detailed or picked. This shortfall is published as the derived column BACKORDERED_QUANTITY, defined in the view text as (MOL.QUANTITY - MOL.QUANTITY_DETAILED).

The view is defined with a filter restricting output to genuinely short move order demand: MOL.QUANTITY_DETAILED IS NOT NULL AND MOL.QUANTITY > MOL.QUANTITY_DETAILED. Lines with no detailing performed, or those fully satisfied, are excluded. Because the view joins header, line, lookup and cost group objects in a single accessible structure, it serves as a convenient source for operational reports, alerts, and inbound integrations that monitor unfilled material movement demand rather than requiring custom joins across the move order tables. Its status is VALID and it is owned by APPS. The object is present in both EBS 12.1.1 and 12.2.2, and the documented ETRM metadata is consistent across those releases.

Underlying Base Objects

The view is defined over four referenced base objects, all resolved through APPS-owned synonyms or views:

  • MTL_TXN_REQUEST_HEADERS (SYNONYM) — the move order header, aliased MOH. Supplies header-level attributes such as request number, move order type, organization, date required and header status.
  • MTL_TXN_REQUEST_LINES (SYNONYM) — the move order line, aliased MOL. Supplies item, revision, subinventory and locator detail, lot and serial ranges, UOM and the quantity columns used to derive the backordered quantity.
  • MFG_LOOKUPS (VIEW) — referenced three times (MFG1, MFG2, MFG3) to translate lookup codes into meanings for move order type, header status and line status.
  • CST_COST_GROUPS (SYNONYM) — referenced twice (CST, CST2) via outer joins to resolve the from and to cost group names.

The header and line objects are joined on MOH.HEADER_ID = MOL.HEADER_ID. Lookup joins are equijoins constrained by lookup type (MOVE_ORDER_TYPE, MTL_TXN_REQUEST_STATUS), and the cost group joins are outer joins using the (+) operator on COST_GROUP_ID, so lines without a cost group still return.

Key Columns

Common Use Cases and Queries

Typical uses include monitoring move orders that are partially staged, driving replenishment or expediting workflows, feeding material shortage dashboards, and populating alert notifications for planners. A basic listing of backorders for one organization, ordered by required date, is:

  • SELECT request_number, line_number, organization_id, inventory_item_id, uom_code, backordered_quantity, date_required FROM apps.mtl_txn_backorders_v WHERE organization_id = :org_id ORDER BY date_required, request_number, line_number;

Because the view exposes BACKORDERED_QUANTITY directly, aggregate queries are straightforward for shortage analysis by item:

  • SELECT inventory_item_id, uom_code, SUM(backordered_quantity) total_backordered FROM apps.mtl_txn_backorders_v WHERE organization_id = :org_id GROUP BY inventory_item_id, uom_code ORDER BY total_backordered DESC;

Filtering by move order type or status meaning supports operational queues, for example restricted to a given MOVE_ORDER_TYPE_NAME or HEADER_STATUS. Integrations can extract the full column list to synchronize backorder demand into external planning systems, keying on HEADER_ID/LINE_ID. Note that only lines with a populated QUANTITY_DETAILED and a positive difference are returned, so fully satisfied move orders never appear.