Results for “cst_distribution_lite_v”

46 results




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

Overview

CST_DISTRIBUTION_LITE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, associated with the BOM (Bills of Material) product family. It presents cost distribution information for Work in Process (WIP) jobs — discrete, repetitive, and related manufacturing transactions — in a flattened, denormalized form suited to reporting and integration. As its name indicates, the view is a "lite" variant of the more comprehensive CST_DISTRIBUTION_V: it joins to fewer base objects and exposes fewer columns, reducing the cost of query execution for consumers that do not require the full distribution attribute set. It is registered in ETRM with a VALID status in both 12.1.1 and 12.2.2.

Because it surfaces transactional accounting data — material transaction amounts, transaction values, currency conversion attributes, cost element classification, and the contra_set_id reference — the view is relevant to cost accounting, WIP valuation, and financial reconciliation reporting.

Underlying Base Objects

The documented base objects underlying CST_DISTRIBUTION_LITE_V (ETRM 12.2.2) are:

This is a materially smaller join footprint than CST_DISTRIBUTION_V, which is the explicit design intent of the LITE view.

Key Columns

The view projects core transaction identifiers and accounting attributes, including:

Common Use Cases and Queries

Typical scenarios include reconciling WIP material distributions to the general ledger, extracting transaction-level costs for a period, and isolating contra entries for a specific job. Because CONTRA_SET_ID is directly projected, common filters on this column work as follows:

  • List distributions for a specific WIP entity and accounting period.
  • Group by CONTRA_SET_ID to inspect balancing entries across cost elements.
  • Join to GL batch information for reconciliation.

A representative query:

SELECT transaction_id, organization_id, wip_entity_id, transaction_date,
       transaction_type_name, cost_element classification,
       transaction_value, base_transaction_value, contra_set_id, gl_batch_id
  FROM apps.cst_distribution_lite_v
 WHERE organization_id = :org_id
   AND acct_period_id = :period_id
   AND contra_set_id = :contra_set_id;

Given its reduced join set, CST_DISTRIBUTION_LITE_V is preferred over CST_DISTRIBUTION_V for high-volume extracts and lightweight integration queries where the omitted columns are not required.