Results for “invbv_move_orders_lines”

14 results




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

Overview

The APPS.INVBV_MOVE_ORDERS_LINES view is an Inventory (INV) module reporting and integration object in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the line-level detail of move orders — the internal replenishment and subinventory transfer documents managed by Oracle Inventory — in a flattened, security-filtered, read-only form. The view is defined with the WITH READ ONLY clause, meaning it cannot be used for DML operations and is intended purely for querying. It also carries an organization-level security predicate ('_SEC:TRL.ORGANIZATION_ID' IS NOT NULL), which restricts results to the organizations the querying user is authorized to access. In practice, INVBV_MOVE_ORDERS_LINES serves as the line-grain companion to the move order header view, giving developers, report authors, and integration builders a stable, denormalized surface over the underlying transaction request tables.

Underlying Base Objects

The view is defined over a single documented base object: MTL_TXN_REQUEST_LINES, accessed via its APPS synonym (aliased TRL in the view text). MTL_TXN_REQUEST_LINES is the Inventory table that stores individual move order lines, including the source and destination subinventory, locator, item, quantity, and status information. Because the view is a direct projection with no joins, essentially all of its columns map one-to-one to columns of MTL_TXN_REQUEST_LINES. The view adds value not by joining additional tables but by applying the organization security filter and by converting certain coded columns into user-readable values through Oracle's descriptive flexfield/attribute translation constructs.

Key Columns

The view exposes the source and destination details of each move order line, which is central to the user's search term from_subinventory_id:

Common Use Cases and Queries

Typical uses include move order open-line reporting, replenishment analysis, subinventory transfer auditing, and integration extracts feeding warehouse or planning systems. Because the view already resolves lookup meanings, reports can display status and reference type directly. A representative query filtering on the searched column is:

  • SELECT line_id, header_id, organization_id, inventory_item_id, from_subinventory_code, to_subinventory_code, quantity, quantity_delivered, line_status, "_LA:LINE_STATUS_NAME" FROM invbv_move_orders_lines WHERE from_subinventory_id = :p_from_subinventory_id AND organization_id = :p_org_id;
  • Joining to MTL_TXN_REQUEST_HEADERS on header_id retrieves header-level attributes such as request type and requesting user.
  • Filtering on line_status isolates open versus closed movement lines for reconciliation.

All queries return only rows for organizations the user is permitted to see, so results are implicitly organization-security compliant.