Search Results order_number_flag




Overview
Explore in AI Chat

Overview

APPS.WSHBV_PICK_LINE_GROUPING_RULE is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes the pick-slip grouping rules defined for Warehouse Management. A grouping rule determines how pick lines are consolidated onto a single pick slip during the pick-release process, controlling the level at which the system batches demand into picking documents. The view is owned by the APPS schema and functions as a read-oriented presentation layer over the underlying pick-slip rules table, presenting both the rule's attributes and its grouping flags with renamed column aliases that align to Oracle Warehouse Management (WSH) conventions. Because it is a view rather than a table, no data is physically stored in it; every query traverses to the base object at run time. This makes it suitable for reports, Discoverer workbooks, BI Publisher data models, custom concurrent programs, and inbound/outbound integrations that need to read grouping-rule configuration without touching the base table directly.

Underlying Base Objects

The view is defined over a single documented base object: WSH_PICK_SLIP_RULES (referenced through a synonym). The SELECT list projects the pick slip rule identifier, its name, description, the individual grouping flags, the active date range, and the standard Oracle EBS audit and concurrent-program columns (WHO columns and the request identifiers). Several columns are exposed with aliases that differ from their base names; for example, ORDER_NUMBER_FLAG is aliased as GROUPB_BY_ORDER_NUMBER_FLAG, SUBINVENTORY_FLAG as GROUP_BY_SUBINVENTORY_FLAG, CUSTOMER_FLAG as GROUP_BY_CUSTOMER_FLAG, CARRIER_FLAG as GROUP_BY_CARRIER_FLAG, SHIPMENT_PRIORITY_FLAG as GROUP_BY_SHIP_PRIORITY_FLAG, DEPARTURE_FLAG as GROUP_DEPARTURE_FLAG, and DELIVERY_FLAG as GROUP_BY_DELIVERY_FLAG. Note the documented alias typo "GROUPB_BY_ORDER_NUMBER_FLAG," which must be quoted or reproduced verbatim if referenced in code.

Key Columns

Common Use Cases and Queries

Typical usage includes reporting on active grouping rules, validating configuration before go-live, and integrating carrier-driven grouping logic into external systems.

  • Retrieve all active rules: SELECT pick_slip_rule_id, name, group_by_carrier_flag FROM apps.wshbv_pick_line_grouping_rule WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
  • Filter rules that group by carrier: SELECT pick_slip_rule_id, name FROM apps.wshbv_pick_line_grouping_rule WHERE group_by_carrier_flag = 'Y';
  • Join to assignments to identify which rules apply to a warehouse or organization.

Because the view is a thin projection over WSH_PICK_SLIP_RULES, performance is governed by the base table's indexes; queries should filter on PICK_SLIP_RULE_ID or active-date predicates wherever possible.