Search Results item_svrid




Overview
Explore in AI Chat

Overview

The view ICX_COMPONENT_SELECTIONS_BCE_V is a legacy Oracle E-Business Suite database object associated with the ICX — Oracle iProcurement product family. Per the ETRM metadata, this view is documented as Obsolete and is not implemented in the current database for the 12.1.1 / 12.2.2 releases. Its historical purpose was to present a consolidated, normalized result set of configured component selections required by iProcurement and Oracle Configurator integration flows, used to reconcile ordered quantities against bill-of-material (BOM) configuration explosions.

Functionally, the view merged two logically distinct record types into a single row set: quote lines drawn from iProcurement sourcing (row qualifier AS_QUOTE_LINES) and configuration explosion component lines drawn from the BOM engine (row qualifier BCE). This union pattern allowed downstream iProcurement screens and concurrent programs to consume a single, uniform structure without branching query logic.

Underlying Base Objects

The view text is defined as a UNION of two queries over these documented base objects:

  • AS_QUOTE_LINES (AQL) — supplies the header, quote, group, item, warehouse, and attribute information for quote-line rows. The qualifier literal 'AS_QUOTE_LINES' identifies these rows.
  • AS_QUOTES (AQ) — joined to AS_QUOTE_LINES on AQ.QUOTE_ID = AQL.QUOTE_ID to supply the ship-to site use identifier.
  • BOM_CONFIG_EXPLOSIONS — supplies configuration component rows, qualified by the literal 'BCE'. Key source columns include COMPONENT_ITEM_ID, NUM_COL1 (sequence), COMPONENT_CODE, SELECT_QUANTITY, and context/attribute flexfields.

The two branches are unified through aliasing so identity and descriptive columns align positionally, producing a stable 29-column projection. Because this view is flagged obsolete and reported as not implemented, no live base object dependencies exist in current 12.2.2 ETRM metadata, and the view should be treated as a historical artifact.

Key Columns

  • ROW_ID / ROW_QUALIFIER — the physical ROWID and a discriminator literal (AS_QUOTE_LINES or BCE) enabling callers to branch on record origin.
  • LINE_ID / HEADER_ID / GROUP_ID — lineage identifiers tying rows back to their quote header and grouping key.
  • PARENT_LINE_ID / SEQUENCE_NUMBER — structural ordering, defaulting to -1 for quote lines and derived from NUM_COL1 for BCE rows.
  • INVENTORY_ITEM_ID / COMPONENT_CODE — the configured item and its component identifier (blank for quote lines).
  • ORDERED_QUANTITY / CANCELLED_QUANTITY — quantity measures. Quote lines populate ORDERED_QUANTITY from AQL.QUANTITY; BCE rows populate it from SELECT_QUANTITY — the column underlying the user's search term.
  • WAREHOUSE_ID / SHIP_TO_SITE_USE_ID / ITEM_SVRID — sourcing and fulfillment context.
  • CONTEXT and ATTRIBUTE1–15 — descriptive flexfield segments carried through from both source branches.

Common Use Cases and Queries

Historically this view supported reconciliation between selected configuration quantities and quoted line quantities in iProcurement checkout pipelines. A representative query filtering on the search term column is:

  • SELECT ROW_QUALIFIER, LINE_ID, INVENTORY_ITEM_ID, COMPONENT_CODE, ORDERED_QUANTITY FROM ICX_COMPONENT_SELECTIONS_BCE_V WHERE ORDERED_QUANTITY > 0 ORDER BY GROUP_ID, SEQUENCE_NUMBER;
  • SELECT GROUP_ID, SUM(ORDERED_QUANTITY) FROM ICX_COMPONENT_SELECTIONS_BCE_V WHERE ROW_QUALIFIER = 'BCE' GROUP BY GROUP_ID; to aggregate configured component selections.

Because the object is obsolete and not implemented in 12.1.1 / 12.2.2, these queries will not execute in a current instance. Integrations must instead rely on the current sanctioned configuration and sourcing views. This entry is retained solely for documentation and migration reference.