Search Results release_seq_rule_name

Overview

SO_PICKING_RULES_V is an Order Entry (OE) view in Oracle E-Business Suite that exposes picking rule definitions used by the shipping and order release process. Per the ETRM metadata, the object is flagged as "10SC ONLY," indicating its availability is restricted to the Discrete Manufacturing / 10SC context rather than being a general-purpose Applications view. In the 12.2.2 ETRM record the view is documented with no registered owner and no referenced base objects, and the implementation note states it is "not implemented in this database." Consequently, SO_PICKING_RULES_V should be treated as a reference artifact for environments where picking rules are configured and consumed, rather than a guaranteed runtime object.

The view is primarily read-only in character, presenting coded picking rule attributes alongside their decoded lookup meanings. It is commonly encountered in reporting and integration contexts where the goal is to display the human-readable meaning of a rule flag (such as a reservation indicator) rather than its raw Y/N value.

Underlying Base Objects

Based on the view text, SO_PICKING_RULES_V is defined over a join of several tables. The driving table is MTL_PARAMETERS (aliased ORG), which supplies warehouse organization context. Supporting joins include HR_ORG_UNITS_NO_JOIN and HR_ALL_ORGANIZATION_UNITS_TL for warehouse naming, RA_CUSTOMERS for customer name and number, SO_LOOKUPS three times (S1, S2, S3) to decode the backorders, shipment priority, and reservation flags, WSH_PICK_SLIP_RULES and WSH_RELEASE_SEQ_RULES for pick slip and release sequence rule names, SO_ORDER_TYPES for the order type name, and RA_SITE_USES with the underlying site-use data. The metadata does not document standalone referenced base objects, so these relationships are derived directly from the view definition.

Key Columns

• PICKING_RULE — the picking rule identifier exposed by the view.
• BACKORDERS_ONLY_FLAG / BACKORDERS — the raw flag and its decoded meaning from SO_LOOKUPS.
• EXISTING_RSVS_ONLY_FLAG and RESERVATION_STAR — the flag restricting the rule to existing reservations, and a derived marker that emits an asterisk ('*') when the flag equals 'Y'. This RESERVATION_STAR column is the direct match for a search on "reservation_star".
• RESERVATION — the decoded lookup meaning associated with the reservation flag.
• SHIPMENT_PRIORITY_CODE / SHIPMENT_PRIORITY — coded and decoded shipment priority values.
• SHIP_METHOD_CODE, CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_NUMBER — shipping and customer identification fields.
• ORDER_NUMBER, ORDER_TYPE, SHIP_SET_NUMBER, INVENTORY_ITEM_ID — order and item context.
• WAREHOUSE_ID, WAREHOUSE_CODE, WAREHOUSE, SUBINVENTORY — inventory organization and subinventory assignment.
• PICK_SLIP_RULE_NAME, RELEASE_SEQ_RULE_NAME — names of the associated pick slip and release sequence rules.
• PARTIAL_ALLOWED_FLAG, INCLUDE_PLANNED_LINES, START_DATE_ACTIVE, END_DATE_ACTIVE, AUTOCREATE_DELIVERY_FLAG — behavioral and effective-dating attributes of the rule.

Common Use Cases and Queries

The view is most useful for reporting which picking rules are reservation-restricted. A typical query retrieves the reservation marker and its decoded meaning alongside the picking rule name:

• SELECT picking_rule, existing_rsvs_only_flag, reservation_star, reservation FROM so_picking_rules_v;

Analysts also filter by warehouse or customer to review rule configuration, for example selecting warehouse_code, pick_slip_rule_name, and release_seq_rule_name for a specific organization. Because the ETRM record notes the view is not implemented in the documented database and is limited to the 10SC context, queries should be validated against the target instance before being relied upon for production reporting.