Search Results mtl_move_order_lines_v

Overview

The MTL_MOVE_ORDER_LINES_V view is an Inventory (INV) module database object within Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes line-level detail for move orders, which are internal inventory requests used to transfer material between subinventories, locators, or organizations. Its documentation metadata classifies the object as "Retrofitted," indicating that the view was introduced or modified during the upgrade path to the current release, and the excerpt records "Not implemented in this database," meaning the object may be absent, disabled, or reserved in certain environment instances. The view is primarily intended for reporting and integration, providing a read-friendly projection of move order line data without requiring consumers to join the underlying move order tables directly.

Underlying Base Objects

The documented view text references the alias MMOL, which corresponds to the base move order lines table (MTL_MOVE_ORDER_LINES). The ETRM metadata lists no separately documented referenced base objects, so the view's relationship to the schema is inferred from the SELECT list: every projected column is sourced from the MMOL alias, and the view does not appear to join to move order headers, item masters, or subinventory tables. Header context must therefore be obtained separately through the move order header table using MOVE_ORDER_HEADER_ID.

Key Columns

• MOVE_ORDER_LINE_ID / MOVE_ORDER_HEADER_ID – Primary identifiers linking each line to its parent move order header.
• MOVE_ORDER_LINE_NUMBER – Sequential line ordering within the header.
• ORGANIZATION_ID / INVENTORY_ITEM_ID – Source organization and the item being moved.
• FROM_SUBINVENTORY_CODE / FROM_LOCATOR_ID – Origin subinventory and locator.
• TO_SUBINVENTORY_CODE / TO_SUBINVENTORY_ID – Destination subinventory and its numeric identifier; the TO_SUBINVENTORY_ID is the column most directly matching the user's search term.
• TO_LOCATOR_ID / TO_ACCOUNT_ID – Destination locator and the receiving account for the transfer.
• QUANTITY / QUANTITY_DELIVERED / QUANTITY_DETAILED – Requested, fulfilled, and detailed quantities.
• LINE_APPROVAL_STATUS / STATUS_DATE – Approval state and the timestamp of the last status change.
• DATE_REQUIRED, REASON_ID, REFERENCE – Business context for the move order line.
• PROJECT_ID / TASK_ID – Project accounting references for project-related transfers.
• ATTRIBUTE1 through ATTRIBUTE15 – Descriptive flexfield segments.
• Standard WHO columns and REQUEST_ID / PROGRAM_ID – Audit and concurrent program context.

Common Use Cases and Queries

The view supports reporting on pending and completed move order lines, integration with warehouse or logistics systems, and reconciliation of subinventory transfers. A typical query filters approved lines bound for a specific destination subinventory:

• SELECT move_order_line_id, move_order_header_id, inventory_item_id, from_subinventory_code, to_subinventory_code, to_subinventory_id, quantity, line_approval_status FROM mtl_move_order_lines_v WHERE to_subinventory_id IS NOT NULL AND line_approval_status = 'APPROVED';
• Quantity trending: aggregate QUANTITY versus QUANTITY_DELIVERED grouped by ORGANIZATION_ID and TO_SUBINVENTORY_ID to identify fulfillment gaps.
• Project transfers: filter on PROJECT_ID and TASK_ID to report material movements charged to specific projects.

Because the view is marked "Not implemented in this database," consumers should verify object existence against ALL_OBJECTS before depending on it in concurrent programs or interfaces.