Search Results gml_batch_so_reservations_v1




Overview
Explore in AI Chat

Overview

The GML_BATCH_SO_RESERVATIONS_V1 view, owned by the APPS schema, is a reporting construct within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. Its stated purpose, per the ETRM documentation, is to present "OM Batch reservation" information, serving as a consolidated read-only interface joining Oracle Order Management (OM) sales orders with Process Manufacturing batch and reservation data. The view is most relevant in Oracle EBS 12.1.1 and 12.2.2 environments where discrete batch reservations against process-manufactured goods must be reconciled with open sales orders.

The view exposes batch-level reservation detail aligned to sales order headers and lines, batch header attributes, item master properties, and customer identification. It is typically used by reporting tools, integration feeds, and customer-facing operational dashboards where batch traceability must be tied to order fulfillment activity.

Underlying Base Objects

The view is defined over the following documented base objects, all accessed via APPS synonyms:

Joins are driven by BATCH_ID, ITEM_ID, ORDER_ID, SO_LINE_ID, and ORGANIZATION_ID, with filters restricting batches to active statuses (BATCH_STATUS between 1 and 3) and excluding logically deleted reservations (DELETE_MARK = 0). Language localization is enforced via USERENV('LANG') against the order type translation table.

Key Columns

The view surfaces several categories of information:

Common Use Cases and Queries

Typical uses include identifying reservations on lot-controlled items, reconciling open sales orders to WIP batches, and feeding warehouse or shipping systems with batch allocation detail.

Query for reservations on lot-controlled items:

  • SELECT order_number, line_number, batch_no, item_no, reserved_qty, lot_ctl FROM apps.gml_batch_so_reservations_v1 WHERE lot_ctl = 1;

Query for reservations by customer and batch status:

  • SELECT customer_name, order_number, batch_no, batch_status, reserved_qty FROM apps.gml_batch_so_reservations_v1 WHERE batch_status = 'WIP' ORDER BY customer_name;

Query to summarize reserved quantity per sales order line:

  • SELECT order_number, line_number, item_no, SUM(reserved_qty) FROM apps.gml_batch_so_reservations_v1 GROUP BY order_number, line_number, item_no;

Because the view is read-only and filtered to active, non-deleted reservations, it should be used for reporting and integration rather than transactional updates. Applications should account for the USERENV language filter to ensure order type descriptions resolve in the intended locale.