Search Results group_by_subinventory_flag

Overview

The WSHFV_PICK_LINE_GROUPING_RULE view is a reporting and integration object in the Oracle E-Business Suite Order Entry (OE) module. In the ETRM 12.2.2 metadata it is documented as a retrofitted view owned by the APPS schema. Its purpose is to expose the pick-slip line grouping rules that control how pick slip lines are consolidated when Oracle Warehouse Management or Order Management generates picking documents. Each row in the view represents a single named pick-slip rule, identified by the PICK_SLIP_RULE_ID, together with the flags that determine the grouping criteria applied to that rule.

Because the object is a view rather than a base table, it does not store data itself. It provides a stable, read-oriented interface over the underlying configuration table, allowing reports, concurrent programs, and external integrations to query grouping rules without directly referencing the base table. This is significant for customers upgrading from earlier releases, since the "Retrofitted" description indicates the view was created to preserve backward compatibility for code and reports that previously relied on the older naming conventions.

Underlying Base Objects

The view is defined over a single documented base object: WSH_PICK_SLIP_RULES, accessed through a synonym. No joins to other tables are present in the documented view text. The defining query selects a subset of columns from WSH_PICK_SLIP_RULES and applies column aliases to expose the grouping flags under names that include the GROUP_BY_ prefix. For example, ORDER_NUMBER_FLAG is exposed as GROUP_BY_ORDER_NUMBER_FLAG, and SUBINVENTORY_FLAG becomes GROUP_BY_SUBINVENTORY_FLAG. This aliasing makes the semantic intent of each flag explicit to consuming applications.

The view also carries the standard Oracle EBS "who" columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the concurrent program audit columns (PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID). These are inherited directly from the base table and support auditing and traceability of rule configuration changes.

Key Columns

The most important identifier column is PICK_SLIP_RULE_ID, the primary key of the underlying rule. This is the column most commonly searched for, as it links a rule definition to pick slip documents and to the warehouse configuration that references it. Other notable columns include:

• NAME and DESCRIPTION — the user-defined rule name and its descriptive text.
• GROUP_BY_ORDER_NUMBER_FLAG — indicates whether pick lines are grouped by order number.
• GROUP_BY_SUBINVENTORY_FLAG — indicates whether grouping considers the subinventory.
• GROUP_BY_CUSTOMER_FLAG — indicates grouping by customer.
• SHIP_TO_FLAG — controls grouping by ship-to location.
• GROUP_BY_CARRIER_FLAG, GROUP_BY_SHIP_PRIORITY_FLAG, GROUP_DEPARTURE_FLAG, and GROUP_BY_DELIVERY_FLAG — additional grouping dimensions covering carrier, shipment priority, departure, and delivery.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range during which the rule is active.

Common Use Cases and Queries

Typical uses include validating which grouping flags are enabled for a given rule, generating configuration reports, and troubleshooting pick slip consolidation behavior. The following query retrieves the grouping configuration for a specific rule:

SELECT pick_slip_rule_id, name, description, group_by_order_number_flag, group_by_subinventory_flag, start_date_active, end_date_active FROM wshfv_pick_line_grouping_rule WHERE pick_slip_rule_id = :rule_id;

A second common pattern lists all currently active rules:

SELECT pick_slip_rule_id, name, group_by_customer_flag, group_by_carrier_flag FROM wshfv_pick_line_grouping_rule WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

These queries are frequently embedded in custom reports and data-extraction routines that audit warehouse picking configuration across operating units and organizations.