Results for “cst_cg_wip_acct_classes_v”

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

Overview

The APPS.CST_CG_WIP_ACCT_CLASSES_V view, titled "Accounting classes valid for cost groups," is a Bills of Material (BOM) product object in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2). It exposes the set of Work in Process (WIP) accounting classes that are effectively valid for a given cost group within an inventory organization. Its purpose is to reconcile two independent configurations: the accounting classes defined per organization on WIP_ACCOUNTING_CLASSES, and the cost group to accounting class assignments maintained on CST_CG_WIP_ACCT_CLASSES. Because the underlying logic resolves the effective cost group identifier and filters out disabled records, the view is a reliable reporting and integration source for cost group / accounting class validation, particularly for users and processes that need to know which cost group a WIP accounting class will resolve to — the referenced column DEFAULT_COST_GROUP_ID is central to that resolution.

Underlying Base Objects

The view is defined over three base objects (all accessed via APPS synonyms): MTL_PARAMETERS, WIP_ACCOUNTING_CLASSES, and CST_CG_WIP_ACCT_CLASSES. MTL_PARAMETERS is the driving table at the organization level; each row supplies the ORGANIZATION_ID and the organization's PRIMARY_COST_METHOD. WIP_ACCOUNTING_CLASSES is joined to MTL_PARAMETERS on ORGANIZATION_ID and provides the class definitions, including CLASS_CODE, CLASS_TYPE, and DISABLE_DATE. CST_CG_WIP_ACCT_CLASSES is outer-joined (CCWAC) on both ORGANIZATION_ID and CLASS_CODE, supplying any explicitly configured COST_GROUP_ID and DISABLE_DATE for the class. The key resolution logic is expressed as NVL(CCWAC.COST_GROUP_ID, DECODE(MP.PRIMARY_COST_METHOD, 1, -1, DEFAULT_COST_GROUP_ID)): if an explicit cost group assignment exists on CST_CG_WIP_ACCT_CLASSES it is returned; otherwise, for standard costing organizations (method 1) the value -1 is returned, and for all other cost methods the organization's DEFAULT_COST_GROUP_ID is used. The view also filters by disable date, keeping only records where both WAC.DISABLE_DATE and CCWAC.DISABLE_DATE are null or in the future.

Key Columns

• ORGANIZATION_ID — The inventory organization for which the accounting class and cost group are evaluated; inherited from MTL_PARAMETERS.
• CLASS_CODE — The WIP accounting class code describing the class of work in process transactions.
• CLASS_TYPE — The accounting class type associated with the class code.
• COST_GROUP_ID — The effective cost group identifier. This is the resolved value: an explicit CST_CG_WIP_ACCT_CLASSES assignment when present, -1 for standard-cost organizations (PRIMARY_COST_METHOD = 1), otherwise the organization's DEFAULT_COST_GROUP_ID.
• DISABLE_DATE — The effective disable date, taken from CCWAC.DISABLE_DATE when populated and falling back to WAC.DISABLE_DATE.

Common Use Cases and Queries

Typical usage includes validating that each WIP accounting class in an organization resolves to an expected cost group, diagnosing cost group / class mismatches during period close, and feeding integration or conversion routines that need the effective cost group for a class. A representative query returns all valid classes for an organization:

• SELECT ORGANIZATION_ID, CLASS_CODE, CLASS_TYPE, COST_GROUP_ID FROM APPS.CST_CG_WIP_ACCT_CLASSES_V WHERE ORGANIZATION_ID = :org_id ORDER BY CLASS_CODE;
• SELECT CLASS_CODE, COST_GROUP_ID FROM APPS.CST_CG_WIP_ACCT_CLASSES_V WHERE ORGANIZATION_ID = :org_id AND CLASS_TYPE = :class_type;
• To identify classes falling back to the organization default: SELECT CLASS_CODE, COST_GROUP_ID FROM APPS.CST_CG_WIP_ACCT_CLASSES_V WHERE ORGANIZATION_ID = :org_id AND COST_GROUP_ID = (SELECT DEFAULT_COST_GROUP_ID FROM APPS.MTL_PARAMETERS WHERE ORGANIZATION_ID = :org_id);

Because the view already excludes disabled records and resolves the fallback cost group, it should be preferred over direct joins to CST_CG_WIP_ACCT_CLASSES when an application-consistent answer for "which cost group applies to this WIP accounting class" is required.