Search Results cost_group_description




Overview
Explore in AI Chat

Overview

MTL_FISCAL_CAT_ACCOUNTS_V is an APPS-owned, VALID database view within the INV (Inventory) product family of Oracle E-Business Suite. Its documented description is "PAC Category Accounts," reflecting its purpose: presenting the Periodic Average Costing (PAC) account mapping that associates a legal entity, cost type, cost group, and inventory category with the set of general ledger accounts used to record inventory and manufacturing transactions. The view joins the fiscal category accounts base table with descriptive attributes — cost type, cost group, category, legal entity, and set of books — so that account assignment data is exposed in a denormalized, user-readable form.

In both EBS 12.1.1 and 12.2.2, this view serves reporting, inquiry, and integration functions. Rather than querying the underlying normalized tables directly, developers, report authors, and interface designers can retrieve the account mapping alongside the human-readable names and descriptions required by users. Because it surfaces the column COST_GROUP_DESCRIPTION (sourced from CST_COST_GROUPS.DESCRIPTION), it is the principal object queried when a user searches for cost group description information in the context of inventory cost accounts.

Underlying Base Objects

The view text defines joins across seven documented base objects, each referenced as a synonym or view under APPS:

Join conditions are enforced on cost group ID plus legal entity, category ID, cost type ID, legal entity plus cost type (through CST_LE_COST_TYPES), set of books ID, and legal entity ID. The view exposes the MFC.ROWID as ROW_ID.

Key Columns

Common Use Cases and Queries

Typical scenarios include verifying account assignments before costing period close, generating account mapping reports by legal entity or cost group, and extracting mappings for integration with external systems. A representative query retrieving cost group descriptions for a legal entity is:

  • SELECT legal_entity, cost_type, cost_group_name, cost_group_description, category_description, material_account, material_overhead_account, resource_account, overhead_account FROM mtl_fiscal_cat_accounts_v WHERE legal_entity_id = :p_legal_entity_id ORDER BY cost_group_name, category_description;
  • SELECT cost_group_name, cost_group_description, set_of_books_name, chart_of_accounts_id FROM mtl_fiscal_cat_accounts_v WHERE cost_type_id = :p_cost_type_id;

Because the view joins several base objects, queries should filter on indexed identifiers such as LEGAL_ENTITY_ID, COST_TYPE_ID, or COST_GROUP_ID rather than descriptive text to avoid unnecessary full scans.