Results for “cst_material_ovhd_rules_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CST_MATERIAL_OVHD_RULES_V is an APPS-owned database view that exposes material overhead rule definitions maintained in the Bills of Material (BOM) and Cost Management (CST) functional areas. It presents the rows stored in the base table CST_MATERIAL_OVHD_RULES (aliased CMOHR) enriched with decoded lookup descriptions and cost type names, so that the raw coded values used by the costing engine are rendered in a form suitable for reporting and integration. Material overhead rules determine when and how material overhead is applied to a transaction, based on organization, transaction type, selection criteria, item range, item type, and ship-from organization.

The view is defined in the APPS schema and carries a status of VALID in Oracle EBS 12.1.1 and 12.2.2. Because the view joins lookup and cost type information at query time, it is a convenient read-only reporting source for cost accountants, implementation consultants, and custom interfaces that need to display rule configuration without navigating the coded foreign keys in the base table.

The view is commonly queried when a user searches on the "item_from" column, which is one of the stored range attributes of a material overhead rule.

Underlying Base Objects

The documented referenced objects for this view are:

• CST_MATERIAL_OVHD_RULES (SYNONYM) — the primary base table supplying all rule attributes, including ROWID, RULE_ID, ORGANIZATION_ID, TRANSACTION_TYPE, SELECTION_CRITERIA, CATEGORY_ID, ITEM_FROM, ITEM_TO, ITEM_TYPE, SHIP_FROM_ORG, EARN_MOH, and COST_TYPE_ID.
• MFG_LOOKUPS (VIEW) — joined twice via aliases MFG1 and MFG2 to decode TRANSACTION_TYPE (lookup type CST_MOH_RULES_TRANSACTION) and ITEM_TYPE (lookup type CST_MTL_ITEM_TYPE).
• CST_COST_TYPES (SYNONYM) — joined to resolve the cost type name when a rule explicitly specifies a cost type.
• MTL_PARAMETERS (SYNONYM) — used in a scalar subquery to supply a default cost type when COST_TYPE_ID is null, taking the organization's average rates cost type (defaulting to 1).

The view therefore relates to the base rule table on a one-to-one row basis, with additional descriptive columns derived through outer joins and a decode-based default.

Key Columns

• ROW_ID — the ROWID of the underlying base table row.
• RULE_ID — primary key of the material overhead rule.
• ORGANIZATION_ID — organization to which the rule applies.
• TRANSACTION_TYPE / TRANSACTION_TYPE_NAME — coded transaction type and its MFG_LOOKUPS meaning.
• SELECTION_CRITERIA / CATEGORY_ID — how the rule selects items, and the optional category filter.
• ITEM_FROM / ITEM_TO — the item range boundary values for rules that select items by range.
• ITEM_TYPE / ITEM_TYPE_NAME — coded item type and its MFG_LOOKUPS meaning.
• SHIP_FROM_ORG — originating organization constraint.
• EARN_MOH — flag indicating whether material overhead is earned by the rule.
• COST_TYPE_ID / COST_TYPE — explicit or defaulted cost type.

Common Use Cases and Queries

Typical usage includes listing all rules for a given organization, identifying rules whose item range covers a specific item, and auditing which cost type a rule resolves to after defaulting.

• Rules for an organization: SELECT RULE_ID, TRANSACTION_TYPE_NAME, SELECTION_CRITERIA, ITEM_FROM, ITEM_TO, EARN_MOH FROM CST_MATERIAL_OVHD_RULES_V WHERE ORGANIZATION_ID = :org_id;
• Rules by item_from range: SELECT RULE_ID, ITEM_FROM, ITEM_TO, COST_TYPE FROM CST_MATERIAL_OVHD_RULES_V WHERE ITEM_FROM = :item_from;
• Decoded cost type audit: SELECT RULE_ID, NVL(COST_TYPE, 'DEFAULT') COST_TYPE_RESOLVED FROM CST_MATERIAL_OVHD_RULES_V;

Such queries support configuration review and reconciliation against costing setups.