Search Results reservation_star




Overview
Explore in AI Chat

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

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.