Search Results backorder_flag




Overview
Explore in AI Chat

Overview

IBE_SH_QLINES_SITEMS_V is a reporting and integration view within the Oracle E-Business Suite iStore (IBE) module. Its name reflects its function: it joins iStore quote lines (IBE) with shipping-related attributes to item master information (SITEMS, i.e., system items). The view presents a denormalized, query-ready projection of sales quote line data enriched with item concatenated segment descriptions and unit of measure information, allowing reporting tools, concurrent programs, and integration interfaces to retrieve quote line details alongside human-readable item attributes without writing complex multi-table joins.

The view is documented in the ETRM repository but is marked as not implemented in this database, meaning it is a seeded or delivered definition that may not be deployed in every instance. This is consistent with many iStore views that are conditionally created depending on licensed modules and applied patches. Where present, it serves as a read-only convenience layer for quote-to-order and quote-to-cart processes, exposing both transactional quote data and descriptive item data in a single row.

The view is particularly relevant to configuration discussions around order fulfillment behavior. The presence of the SPLIT_SHIPMENT_FLAG column makes it a target for users investigating how quote lines are flagged for shipment splitting — a common search term in EBS support and implementation contexts.

Underlying Base Objects

The view text is defined over three objects, combined through inner joins on item and unit-of-measure identifiers:

Join conditions require that the item's INVENTORY_ITEM_ID and ORGANIZATION_ID match those on the quote line, and that the line's UOM_CODE equals the units-of-measure code. Because all joins are inner joins, quote lines lacking a valid item or unit of measure are excluded from the result set. No additional documented base objects are cited in the ETRM metadata.

Key Columns

The view exposes the full column set of ASO_QUOTE_LINES_ALL plus three descriptive columns from the joined views. Notable columns include:

  • QUOTE_LINE_ID / QUOTE_HEADER_ID — primary and foreign key references linking the line to its quote header.
  • SPLIT_SHIPMENT_FLAG — controls whether the quote line permits shipment splitting when transferred to order management, a frequent subject of functional investigation.
  • BACKORDER_FLAG — indicates backorder allowance for the line.
  • INVENTORY_ITEM_ID / ORGANIZATION_ID — item and inventory organization context.
  • CONCATENATED_SEGMENTS / DESCRIPTION — the formatted item identifier and item description from MTL_SYSTEM_ITEMS_VL.
  • UNIT_OF_MEASURE — the units-of-measure name from MTL_UNITS_OF_MEASURE_VL, complementing the raw UOM_CODE.
  • QUANTITY, CURRENCY_CODE, LINE_LIST_PRICE, LINE_QUOTE_PRICE — commercial attributes for line-level pricing analysis.
  • ATTRIBUTE1 through ATTRIBUTE15 — the standard descriptive flexfield columns for customer-specific extensions.

Common Use Cases and Queries

The view is typically consumed for quote line reporting, item-enriched extracts, and diagnostics of fulfillment flags. A representative query targeting the split shipment flag follows:

  • Fulfillment flag audit: SELECT QUOTE_HEADER_ID, QUOTE_LINE_ID, CONCATENATED_SEGMENTS, SPLIT_SHIPMENT_FLAG, BACKORDER_FLAG FROM IBE_SH_QLINES_SITEMS_V WHERE SPLIT_SHIPMENT_FLAG = 'Y';
  • Item-level quote extract: SELECT CONCATENATED_SEGMENTS, DESCRIPTION, QUANTITY, UNIT_OF_MEASURE, LINE_QUOTE_PRICE FROM IBE_SH_QLINES_SITEMS_V WHERE ORG_ID = :org;
  • Interface staging: joining the view to order import or pricing tables for downstream integration.

Teams should verify availability of the view in their specific instance, given the ETRM notation that it is not implemented in the documented database.