Search Results unit_of_measure_name

Overview

OEFV_ITEM_GROUP_LINES is a read-only reporting view in the Oracle Order Entry (OE) module of Oracle E-Business Suite, exposed within the ETRM reference set as a "Retrofitted" object. It presents item group line data — the individual inventory items assigned to an item group, together with their pricing method, list price, unit of measure, and associated pricing rule — in a denormalized, human-readable form intended for reporting and integration rather than for transactional entry. Because the view joins descriptive lookup data (unit of measure, item name, group name, pricing rule name) to the underlying group-line records, it allows report writers and interface developers to retrieve meaningful text values without hand-coding joins to multiple master tables. The ETRM implementation note states "Not implemented in this database" for the documented instance, and the documented referenced base objects are listed as none; the view text nonetheless reveals the exact tables over which it is defined, as detailed below. The view carries a WITH READ ONLY clause, so it cannot be used for DML against the underlying data.

Underlying Base Objects

The view text defines OEFV_ITEM_GROUP_LINES over four base tables and one key flexfield view:

• SO_ITEM_GROUP_LINES GROUPLINE — the primary driver table, supplying the pricing method, list price, group line ID, inventory item ID, unit code, group ID, pricing rule ID, and audit columns.
• MTL_UNITS_OF_MEASURE UOM — outer-joined on UOM_CODE = UNIT_CODE to resolve the unit of measure description.
• MTL_SYSTEM_ITEMS_KFV ITEM — joined on INVENTORY_ITEM_ID to supply the concatenated item number key flexfield.
• SO_ITEM_GROUPS IGROUP — joined on GROUP_ID to supply the item group name (inner join).
• SO_PRICING_RULES RULE — outer-joined on PRICING_RULE_ID to supply the pricing rule name.

The outer joins (+) on UOM and RULE mean a group line is still returned when its unit code or pricing rule is null. The joins on IGROUP and ITEM are mandatory, so lines without a valid group or item are excluded.

Key Columns

• UNIT_OF_MEASURE_NAME — the unit of measure description from MTL_UNITS_OF_MEASURE, derived from UNIT_CODE (UOM_CODE). This is the primary unit-of-measure attribute surfaced by the view and the column users search for as "unit_of_measure_name."
• PRICING_METHOD — the pricing method code on the group line.
• LIST_PRICE — the list price defined on the group line.
• GROUP_NAME and PRICING_RULE_NAME — descriptive names for the item group and its pricing rule.
• "_KF:ITEM_NUMBER" — the item number key flexfield value from MTL_SYSTEM_ITEMS_KFV; "_DF" is a descriptive flexfield placeholder.
• INVENTORY_ITEM_ID, UOM_CODE, GROUP_LINE_ID, GROUP_ID, PRICING_RULE_ID — surrogate and foreign key identifiers for programmatic joins.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns.

Common Use Cases and Queries

Typical usage includes item-group price list reporting, validating pricing rule coverage across groups, and extracting item-to-UOM mappings for downstream interfaces.

List all group lines with descriptive attributes for a given group:

SELECT group_name, "_KF:ITEM_NUMBER" item_number,
       unit_of_measure_name, pricing_method, list_price,
       pricing_rule_name
FROM   oefv_item_group_lines
WHERE  group_id = :p_group_id
ORDER BY item_number;

Report items whose pricing rule is not yet assigned (null rule), leveraging the outer join:

SELECT group_name, "_KF:ITEM_NUMBER", unit_of_measure_name
FROM   oefv_item_group_lines
WHERE  pricing_rule_name IS NULL;

Retrieve item details for a specific inventory item across all groups:

SELECT group_name, unit_of_measure_name, list_price, pricing_method
FROM   oefv_item_group_lines
WHERE  inventory_item_id = :p_item_id;

Because only referenced base objects are documented (and none were listed), all query design should rely on the view text above as the authoritative column and join source. The read-only nature of the view makes it safe for concurrent query workloads in reporting environments.