Results for “cst_completion_cost_src”

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

Overview

The APPS.WIPBV_ACCOUNTING_CLASSES view is a business view (WIPBV prefix) that exposes the accounting class definitions stored in Oracle Work in Process. An accounting class in WIP defines the set of General Ledger accounts that the system uses to record and value discrete manufacturing transactions for a given organization. This view presents one row per accounting class per organization, joined with descriptive lookup meanings and foreign key resolutions so that the data is directly reportable without additional joins.

The view is defined as a read-only view (WITH READ ONLY), which means it is intended purely for querying and reporting rather than for DML. In the context of the user search term "wip_class_type," the view exposes the class type of each accounting class through the resolved MEANING column derived from the WIP_CLASS_TYPE lookup. This makes it the primary reference for verifying which accounting classes are defined as Discrete, Repetitive, or other supported class types within an organization.

Underlying Base Objects

The view is defined over four documented base objects:

• WIP_ACCOUNTING_CLASSES (accessed via synonym) — the primary entity holding the accounting class records, including account flexfield IDs, class code, class type, and cost type.
• MTL_PARAMETERS (syncronym) — joined on ORGANIZATION_ID to resolve the organization code via ORGANIZATION_CODE.
• HR_ALL_ORGANIZATION_UNITS (synonym) — joined on ORGANIZATION_ID to resolve the organization name via NAME.
• MFG_LOOKUPS (view) — joined three times to resolve lookup code meanings for class type, completion cost source, and system completion options.

The three MFG_LOOKUPS joins are aliased LO1, LO2, and LO3. LO1 is a non-outer join resolving WIP_CLASS_TYPE; LO2 and LO3 are outer joins (marked with (+)) resolving CST_COMPLETION_COST_SRC and CST_SYSTEM_COMPLETION_OPTIONS respectively.

Key Columns

• CLASS_CODE — the user-defined accounting class identifier.
• ORGANIZATION_ID — the operating organization to which the class belongs.
• LO1.MEANING — the descriptive meaning of the class type, resolved from the WIP_CLASS_TYPE lookup and the value relevant to "wip_class_type" searches.
• DISABLE_DATE / DESCRIPTION — lifecycle and descriptive attributes of the class.
• LO2.MEANING / LO3.MEANING — completion cost source and system completion option meanings.
• ORGANIZATION_CODE / NAME — foreign key resolutions for the organization.
• Account columns — MATERIAL_ACCOUNT, MATERIAL_VARIANCE_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, RESOURCE_VARIANCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OUTSIDE_PROC_VARIANCE_ACCOUNT, OVERHEAD_ACCOUNT, OVERHEAD_VARIANCE_ACCOUNT, STD_COST_ADJUSTMENT_ACCOUNT, BRIDGING_ACCOUNT, and EXPENSE_ACCOUNT. Each stores a GL account flexfield combination ID.
• COST_TYPE_ID — the cost type associated with the class.
• WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

A frequent requirement is to list all accounting classes for an organization and their class types:

• SELECT organization_code, class_code, meaning wip_class_type, cost_type_id FROM apps.wipbv_accounting_classes WHERE organization_id = :org_id;
• Auditing which GL accounts are configured for material and resource variance, to reconcile WIP balances.
• Identifying disabled classes by filtering on DISABLE_DATE.
• Reporting on bridging and expense accounts for period-close validation.

Because the view already resolves organization codes and lookup meanings, it is well suited for use in custom reports, BI Publisher data templates, and integration extracts without additional lookup joins.