Search Results allocation_method

Overview

WSH_PICKING_RULES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the WSH (Shipping Execution) product family and exposes picking rule definitions configured for warehouse operations. A picking rule determines how the pick release process selects and sequences eligible delivery details from the order management tables, controlling criteria such as shipment priority, ship method, customer, requested dates, and scheduled ship dates. The view is the primary reporting and integration surface for reviewing how a picking rule is defined without querying the underlying WSH_PICKING_RULES base table directly. It resolves descriptive values—meanings for lookup codes, party names for customers, order numbers, order type names, and ship set numbers—so that a picking rule can be interpreted in business terms. The view is exposed under APPS in standard EBS installations and carries VALID status.

Underlying Base Objects

The view is defined against WSH_PICKING_RULES along with several supporting tables and synonyms. Lookup meanings are supplied through OE_LOOKUPS for flags such as BACKORDERS and shipment priority. Customer context is resolved via HZ_PARTIES and HZ_CUST_ACCOUNTS. Order header information is drawn from OE_ORDER_HEADERS_ALL, order types from OE_TRXT_TYPES_NOORGS_VL, and ship set names from OE_SETS. Location data comes from WSH_LOCATIONS and HR organization structures. The documented referenced objects additionally include FND_PROFILE, HR_ALL_ORGANIZATION_UNITS_TL, HR_GENERAL, HR_ORG_UNITS_NO_JOIN, HR_SECURITY, MTL_PARAMETERS, PA_CROSS_BUSINESS_GRP, PA_PROJECT_UTILS, PA_SECURITY, PA_TASK_UTILS, PJM_PROJECTS_ALL_V, PJM_TASKS_V, WSH_PICK_GROUPING_RULES, WSH_PICK_SEQUENCE_RULES, and WSH_REPORT_SETS. The picking rule itself is the row driver; grouping and sequencing rule tables supply the operational profile associated with the rule.

Key Columns

• PICKING_RULE_ID, PICKING_RULE_NAME — Primary identifier and user-defined name of the picking rule.
• BACKORDERS_ONLY_FLAG, BACKORDERS — Flag and resolved meaning indicating whether only backordered lines are eligible.
• EXISTING_RSVS_ONLY_FLAG, RESERVATION_STAR — Indicates restriction to lines that already carry reservations.
• SHIPMENT_PRIORITY_CODE, SHIPMENT_PRIORITY — Priority code and its lookup meaning.
• SHIP_METHOD_CODE — Ship method restriction applied by the rule.
• CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_NUMBER — Customer account and party identifiers resolved from HZ_PARTIES.
• ORDER_HEADER_ID, ORDER_NUMBER — Source order reference.
• ORDER_TYPE_ID, ORDER_TYPE — Order type identifier and name.
• INVENTORY_ITEM_ID — Item restriction in the rule.
• FROM_REQUESTED_DATE, TO_REQUESTED_DATE, FROM_SCHEDULED_SHIP_DATE, TO_SCHEDULED_SHIP_DATE — Date range criteria; date-only values default to the current date with the stored time.
• SHIP_TO_LOCATION_ID — Destination location restriction.

Common Use Cases and Queries

Shipping and order management analysts use this view to audit rule definitions, reproduce pick release behavior, and confirm the criteria applied during allocation. A typical query listing active rules and their flag meanings is:

• SELECT PICKING_RULE_ID, PICKING_RULE_NAME, BACKORDERS, RESERVATION_STAR, SHIPMENT_PRIORITY FROM WSH_PICKING_RULES_V;
• SELECT PICKING_RULE_NAME, ORDER_NUMBER, CUSTOMER_NAME, FROM_REQUESTED_DATE, TO_REQUESTED_DATE FROM WSH_PICKING_RULES_V WHERE SHIP_METHOD_CODE = :method;
• SELECT PICKING_RULE_ID, PICKING_RULE_NAME, SHIP_SET_NUMBER, ORDER_TYPE FROM WSH_PICKING_RULES_V WHERE CUSTOMER_ID = :cust_id;

Because the view resolves lookup meanings and party attributes inline, it is suitable for concurrent report data sources, BI Publisher extracts, and integration interfaces that must present picking rule configuration in readable form without joins to lookup tables.