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:
- MTL_MATERIAL_TRANSACTIONS (synonym) — the driving transaction rows
- MTL_TRANSACTION_ACCOUNTS (synonym) — distribution amounts, contra set, cost element, GL batch
- MTL_TRANSACTION_TYPES (synonym) — human-readable transaction type names
- MTL_SYSTEM_ITEMS (synonym) — primary UOM code for items
- WIP_ENTITIES (synonym) — WIP entity (job) attributes such as organization and primary item
- WIP_DISCRETE_JOBS (synonym) — discrete job references, including asset number fields
- WIP_REPETITIVE_ITEMS (synonym) — repetitive schedule references
- WIP_TRANSACTIONS and WIP_TRANSACTION_ACCOUNTS (synonyms) — WIP-side transaction and accounting data
- BOM_RESOURCES (synonym) — resource code
- MFG_LOOKUPS (view) — lookup meanings such as accounting line type
- PO_HEADERS_ALL (synonym) — purchasing header context for outside-processing distributions
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:
- TRANSACTION_ID, ORGANIZATION_ID, WIP_ENTITY_ID, PRIMARY_ITEM_ID, REPETITIVE_LINE_ID, ACCT_PERIOD_ID — identity and period keys for the transaction and its WIP context.
- TRANSACTION_TYPE_NAME, TRANSACTION_ACTION_ID, TRANSACTION_DATE, OPERATION_SEQ_NUM — classification and timing of the transaction.
- TRANSACTION_QUANTITY / PRIMARY_QUANTITY-derived quantity — a quantity column computed via DECODE on TRANSACTION_ACTION_ID (40, 41, 43 handled specially; otherwise the negated transaction quantity applies).
- TRANSACTION_VALUE, BASE_TRANSACTION_VALUE, RATE_OR_AMOUNT, REFERENCE_ACCOUNT + 0 — monetary distribution amounts.
- CONTRA_SET_ID — the contra set reference from MTL_TRANSACTION_ACCOUNTS, identifying the balancing/contra entry grouping for the distribution. This is the column the user search terms reference, and it is exposed unchanged from the base accounting table.
- CURRENCY_CODE, CURRENCY_CONVERSION_DATE/TYPE/RATE, GL_BATCH_ID — currency conversion and general ledger batch linkage.
- COST_ELEMENT_ID decoded to 'MATERIAL', 'RESOURCE', 'OVERHEAD', 'OUTSIDE PROCESSING', 'MATERIAL OVERHEAD' — cost element classification.
- SUBINVENTORY_CODE, REVISION, INVENTORY_ITEM_ID, RESOURCE_CODE, ASSET_NUMBER — item, resource, and asset context.
- Standard WHO columns (ROWID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID, etc.) — audit and concurrent program provenance.
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.
-
Distributions view for WIP jobs that joins to less tables than CST_DISTRIBUTION_V and has less columns.
APPS.CST_DISTRIBUTION_LITE_V·↳ BOM_RESOURCES·↳ MFG_LOOKUPS·↳ MTL_MATERIAL_TRANSACTIONS·Explore BOM module →
-
Distributions view for WIP jobs that joins to less tables than CST_DISTRIBUTION_V and has less columns.
APPS.CST_DISTRIBUTION_LITE_V·↳ BOM_RESOURCES·↳ MFG_LOOKUPS·↳ MTL_MATERIAL_TRANSACTIONS·Explore BOM module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.BOM_RESOURCES 12.1.1
-
SYNONYM: APPS.BOM_RESOURCES 12.2.2
-
SYNONYM: APPS.WIP_ENTITIES 12.2.2
-
SYNONYM: APPS.WIP_ENTITIES 12.1.1
-
VIEW: APPS.MFG_LOOKUPS 12.2.2
-
VIEW: APPS.MFG_LOOKUPS 12.1.1
-
SYNONYM: APPS.PO_HEADERS_ALL 12.1.1
-
SYNONYM: APPS.PO_HEADERS_ALL 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - BOM Tables and Views 12.2.2
Table to map wip transactions to their corresponding event types.
-
eTRM - BOM Tables and Views 12.1.1
Table to map wip transactions to their corresponding event types.
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - BOM Tables and Views 12.1.1
Table to map wip transactions to their corresponding event types.
-
eTRM - BOM Tables and Views 12.2.2
Table to map wip transactions to their corresponding event types.
-
eTRM - INV Tables and Views 12.1.1