Search Results model_option_component_code

Overview

WSHBV_PICK_LINE is a backward-compatibility view owned by the APPS schema in Oracle E-Business Suite, registered under the Order Entry (OE) product family. Its description in the ETRM metadata is marked "Retrofitted", indicating that it was introduced or re-created to preserve column and object names that earlier releases of Oracle Applications exposed to external callers, reports, and custom extensions. The view presents a renamed projection of the picking-line data stored in SO_PICKING_LINES_ALL, mapping the physical column names of that table to the historical names expected by legacy code and by Oracle's own shipping and inventory interfaces.

The object was returned in a search for the term "model_option_component_ratio", which appears as a column of this view. That column is not a native attribute of SO_PICKING_LINES_ALL; it is the aliased form of SPL.COMPONENT_RATIO. The alias preserves the terminology used by the Bills of Material and configuration model logic, in which a ratio expresses the quantity of a component relative to its parent model. Users who locate WSHBV_PICK_LINE through this term are generally working with configured items — pick-to-order or assemble-to-order models — where component ratios govern how child lines are exploded and shipped. The view exists in the shipping execution data model and is therefore relevant to both order management reporting and warehouse-level picking and shipping integrations.

The object was VALID in the documented environment and is catalogued in ETRM for both 12.1.1 and 12.2.2. In 12.2.2, the sole referenced base object listed is the synonym SO_PICKING_LINES_ALL.

Underlying Base Objects

The view is defined over a single source: SO_PICKING_LINES_ALL, referenced through its APPS synonym. The definition selects all significant business and audit columns from that table and applies aliasing to those whose retired names must be retained. The table SO_PICKING_LINES_ALL stores picking line details for each picking header in the shipping execution module, and each row in WSHBV_PICK_LINE corresponds one-to-one with a row in that table. Because the view performs no joins, aggregation, or filtering, it carries no additional performance cost beyond the base table access, and it inherits the base table's indexes, including the primary key on PICKING_LINE_ID and the foreign key to PICKING_HEADER_ID.

The naming prefix indicates that the object is classified as a shipping view ("WSH"), despite its ETRM product assignment to Order Entry. This dual association reflects the fact that the underlying picking data is shared across Order Management, Shipping Execution, and Inventory, and that the view is consumed from several of these modules.

Key Columns

• PICKING_LINE_ID — Primary key of the picking line and the unique row identifier within the view.
• PICKING_HEADER_ID / ORDER_LINE_ID / LINE_DETAIL_ID — Foreign keys linking the line to its picking header, the originating order line, and the order line detail respectively.
• MODEL_OPTION_COMPONENT_RATIO — Aliased form of SPL.COMPONENT_RATIO. For configured items, expresses the ratio in which the component contributes to the model, and is the attribute most often associated with model option explosion logic.
• MODEL_OPTION_COMPONENT_CODE — Aliased form of SPL.COMPONENT_CODE, identifying the component within the configuration.
• COMPONENT_SEQUENCE_ID / CONFIGURATION_ITEM_FLAG — Identify component ordering and whether the line corresponds to a configuration item.
• CURRENT_REQUEST_QUANTITY — Aliased form of SPL.REQUESTED_QUANTITY, the quantity currently requested for the line.
• ORIGINAL_REQUESTED_QUANTITY / SHIPPED_QUANTITY / CANCELLED_QUANTITY / INVOICED_QUANTITY — Lifecycle quantities tracking demand, shipment, cancellation, and invoicing.
• CONFIRMED_DATE / SCHEDULE_DATE / DATE_REQUESTED / LATEST_ACCEPTABLE_DATE — Scheduling and confirmation dates governing the shipment timeline.
• RECEIVABLE_INTERFACE_STATUS / INVENTORY_INT_STATUS / SERVICE_INTERFACE_STATUS — Aliased status columns used to track progression of the line through receivables, inventory, and service interfaces.
• WAREHOUSE_ID / SHIP_TO_SITE_USE_ID / SHIP_METHOD_CODE / SHIPMENT_PRIORITY_CODE — Logistics attributes identifying where and how the line is to be shipped.
• ORG_ID — Operating unit identifier, supporting multi-org security predicates applied by the calling report or form.

Common Use Cases and Queries

The view is typically queried by custom shipping reports, conversion programs, and integrations that were written against earlier column naming conventions. It is also useful for reporting on configured item picks, where the model option component ratio is required to reconcile parent and child quantities.

The following query lists picked lines for a given picking header, exposing the model option columns:

SELECT picking_line_id, picking_header_id, order_line_id,
       model_option_component_code, model_option_component_ratio,
       current_request_quantity, shipped_quantity, cancelled_quantity,
       warehouse_id, confirmed_date
  FROM wshbv_pick_line
 WHERE picking_header_id = :p_header_id
 ORDER BY component_sequence_id;

A second common pattern isolates configuration lines to verify component ratios against shipped quantities:

SELECT order_line_id, model_option_component_code,
       model_option_component_ratio, original_requested_quantity,
       shipped_quantity, configuration_item_flag
  FROM wshbv_pick_line
 WHERE org_id = :p_org_id
   AND configuration_item_flag = 'Y';

Because the view exposes ORG_ID and the standard WHO audit columns, it can be used safely within multi-org reports provided the appropriate operating unit predicate is applied. Reporting tools that reference deprecated column names should be migrated toward SO_PICKING_LINES_ALL, but until then WSHBV_PICK_LINE remains the supported access path for the legacy interface.