Search Results so_item_group_lines




Overview
Explore in AI Chat

Overview

The SO_ITEM_GROUP_LINES table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module. It functions as the detail repository for price list item groups, which are collections of inventory items used for pricing and promotional purposes. Its primary role is to define the specific membership of items within a group, enabling the application of consistent pricing rules, discounts, or surcharges to a predefined set of products. This table is essential for implementing complex, rule-based pricing strategies that target specific product categories or bundles, directly impacting the pricing engine's calculations during sales order entry.

Key Information Stored

The table stores the association between an item group and the individual items or pricing rules that constitute it. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal the critical data points. The GROUP_LINE_ID column serves as the unique primary key identifier for each line. The GROUP_ID column is a foreign key linking the line to its parent definition in the SO_ITEM_GROUPS table. The PRICING_RULE_ID column is a foreign key linking to the SO_PRICING_RULES_B table, indicating that a line can reference either a specific inventory item or a broader pricing rule. Additional columns typically include sequence numbers for ordering, effective dates, and context or attribute columns for flexfield data.

Common Use Cases and Queries

A primary use case is analyzing the composition of item groups for pricing audits or troubleshooting order pricing discrepancies. For instance, to list all items within a specific group for a report, a query would join SO_ITEM_GROUP_LINES to inventory tables via the item_id or to pricing rules tables. Another common scenario is validating pricing setup before a promotion goes live. A sample SQL pattern to fetch group details might be:

  • SELECT igl.group_line_id, ig.group_name, msi.segment1 item_code
  • FROM oe.so_item_group_lines igl,
  • oe.so_item_groups ig,
  • inv.mtl_system_items_b msi
  • WHERE igl.group_id = ig.group_id
  • AND igl.inventory_item_id = msi.inventory_item_id
  • AND igl.organization_id = msi.organization_id
  • AND ig.group_name = '&GROUP_NAME';

Data from this table is also critical for custom pricing reports and interfaces that require understanding which items are subject to specific promotional rules.

Related Objects

The SO_ITEM_GROUP_LINES table maintains defined foreign key relationships with two key parent tables, as documented in the ETRM metadata.

  • SO_ITEM_GROUPS: This is the parent table for the group header. The relationship is established via the column SO_ITEM_GROUP_LINES.GROUP_ID referencing SO_ITEM_GROUPS. This join retrieves the group's name and header-level attributes.
  • SO_PRICING_RULES_B: This table defines pricing rules. The relationship is via the column SO_ITEM_GROUP_LINES.PRICING_RULE_ID. This allows a group line to reference a rule (like "all items in category X") instead of a specific inventory item, providing flexibility in group definition.

As a child of SO_ITEM_GROUPS, this table is also intrinsically linked to pricing and modifier setups that reference those groups throughout the Order Management and Advanced Pricing modules.