Results for “cstbv_mfg_txn_distributions”

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

Overview

CSTBV_MFG_TXN_DISTRIBUTIONS is an APPS-owned database view in the Oracle E-Business Suite BOM (Bills of Material) product family. Its ETRM documentation classifies the object as a mapping/interface view described as "Retrofitted," indicating that it was adapted from an earlier release and revalidated for the 12.1.1 and 12.2.2 code lines. The view exposes manufacturing transaction accounting distributions created by the Cost Management and Work in Process costing engines. Its documented purpose is to present granular accounting line detail — including transaction amounts, quantities, overhead basis information, currency conversion attributes, and the associated accounting flexfield reference — in a flat, denormalized structure suitable for reporting, extracts, and external integration.

The leading comment blocks in the view text (/* UNIQUE ATTRIBUTES */ and /* REGULAR ATTRIBUTES */) indicate that this object was generated by Oracle's Business Intelligence/ETRM attribute-extraction framework, which tags columns so downstream analytical tools and Oracle's own reporting layers can categorize them correctly.

Underlying Base Objects

The view is defined over a single base object, WIP_TRANSACTION_ACCOUNTS, referenced through a synonym (aliased as WTA in the query). WIP_TRANSACTION_ACCOUNTS is the core table in which Work in Process stores the accounting distributions generated for every manufacturing transaction — material issues, resource charges, overhead absorption, completion receipts, and variance settlements. Each row in that table represents one debit or credit line destined for the General Ledger.

The view applies only light transformation logic. It selects a defined column list from WIP_TRANSACTION_ACCOUNTS and resolves two lookup columns using the standard Oracle Application Object Library value-set mechanism:

• _LA:WTA.ACCOUNTING_LINE_TYPE:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING — returns the meaning of the accounting line type from the CST_ACCOUNTING_LINE_TYPE lookup.
• _LA:WTA.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING — returns the meaning of the overhead basis type from the CST_BASIS lookup.

A row-level security predicate, '_SEC:WTA.ORGANIZATION_ID' IS NOT NULL, enforces organization-level access control. The view is declared WITH READ ONLY, so it cannot be used as the target of DML.

Key Columns

The column set includes the attributes below. Because the user search term is transaction_value, that column is treated first.

• TRANSACTION_VALUE — the monetary amount of the distribution line expressed in the transaction currency. This is the primary figure used in manufacturing cost reporting and reconciliation.
• BASE_TRANSACTION_VALUE — the same amount converted to the ledger's base (functional) currency.
• PRIMARY_QUANTITY — the quantity on which the transaction value is based.
• RATE_OR_AMOUNT — the per-unit rate or fixed amount used to derive the transaction value.
• OVERHEAD_BASIS_FACTOR — the applied factor when the line represents absorbed overhead.
• TRANSACTION_DATE — the accounting date of the distribution.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE — the currency and conversion attributes applied when translating to the base currency.
• ORGANIZATION_ID — the inventory organization, also the security key.
• WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID — the work order or repetitive schedule that produced the transaction.
• RESOURCE_ID, BASIS_RESOURCE_ID, ACTIVITY_ID — the resource and activity that incurred or absorbed cost.
• COST_ELEMENT_ID — the cost element (material, material overhead, resource, outside processing, overhead) charged.
• REFERENCE_ACCOUNT / OFFSET_ACCOUNT, CONTRA_SET_ID, GL_BATCH_ID — the accounting flexfield reference and the GL interface batch identifier.
• ACCOUNTING_LINE_TYPE, BASIS_TYPE — decoded lookup meanings.
• WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

Typical uses include manufacturing cost analysis, WIP-to-GL reconciliation, overhead absorption reporting, and extracts feeding a data warehouse. A representative query retrieving transaction values by organization and cost element is shown below:

SELECT transaction_id, wip_entity_id, organization_id,
       transaction_date, cost_element_id, transaction_value,
       base_transaction_value, currency_code
  FROM apps.cstbv_mfg_txn_distributions
 WHERE organization_id = :org_id
    AND transaction_date BETWEEN :start_date AND :end_date
 ORDER BY transaction_date, transaction_id;

For overhead analysis, filter on overhead_basis_factor IS NOT NULL and group by basis_type. For GL reconciliation, aggregate base_transaction_value by gl_batch_id and compare to the corresponding GL journal batch.