Results for “cst_distribution_v”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CST_DISTRIBUTION_V is a single-organization reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is catalogued under the BOM (Bills of Material) product family but draws its core data from the Cost Management (CST) and Work in Process (WIP) transaction model. The view presents transaction details alongside their accounting distributions for a discrete job or repetitive schedule within a given accounting period. Because it is a single-org view, callers must supply or filter on ORGANIZATION_ID; it does not perform the multi-org security enforcement that the corresponding _ALL or _V multi-org variants would apply through MO_GLOBAL or the organization hierarchy.
The view is primarily consumed by cost accountants, manufacturing analysts, and custom reporting/integration programs that need a flattened picture of material and resource movements posted to a job, together with the value, account, and cost-element information needed for reconciliation or extract. It exposes both the physical transaction (quantity, UOM, date, type, reason) and the accounting side (transaction value, base value, reference account, GL batch, cost element), which makes it a convenient single source for period-end variance, WIP-to-GL reconciliation, and job cost roll-up reports.
Underlying Base Objects
ETRM documents the view as defined over the following referenced objects: BOM_DEPARTMENTS, BOM_RESOURCES, CSI_ITEM_INSTANCES, CST_ACTIVITIES, MFG_LOOKUPS, MTL_MATERIAL_TRANSACTIONS, MTL_SYSTEM_ITEMS, MTL_TRANSACTION_ACCOUNTS, MTL_TRANSACTION_REASONS, MTL_TRANSACTION_TYPES, PO_HEADERS, WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_LINES, WIP_REPETITIVE_ITEMS, WIP_TRANSACTIONS, and WIP_TRANSACTION_ACCOUNTS. Most are exposed to APPS as synonyms over the corresponding base tables.
The driving table in the view text is MTL_MATERIAL_TRANSACTIONS (aliased MMT), joined to MTL_TRANSACTION_ACCOUNTS (MTA) for the accounting lines, MTL_SYSTEM_ITEMS (MSI) for the primary UOM, MTL_TRANSACTION_TYPES (MTT), MTL_TRANSACTION_REASONS (MTR), and MFG_LOOKUPS (LU2) to decode ACCOUNTING_LINE_TYPE. WIP_ENTITIES (WE) supplies the job name and organization, while WIP_LINES (WL), WIP_DISCRETE_JOBS, WIP_REPETITIVE_ITEMS, and WIP_TRANSACTION_ACCOUNTS tie the transaction back to the work order or repetitive schedule context. BOM_DEPARTMENTS and BOM_RESOURCES resolve the department and resource descriptions, and CST_ACTIVITIES supplies the activity. CSI_ITEM_INSTANCES and PO_HEADERS participate in specialized transaction joins (for example, lot/serial and purchase-order references).
Key Columns
- TRANSACTION_ID, ORGANIZATION_ID, WIP_ENTITY_ID, PRIMARY_ITEM_ID — core identifiers for the transaction, operating unit organization, job, and top-level assembly.
- REPETITIVE_LINE_ID, LINE_CODE — repetitive schedule linkage when the transaction is against a repetitive line rather than a discrete job.
- ACCT_PERIOD_ID, TRANSACTION_DATE — period and date keys used for cost-period grouping and period-close reporting.
- TRANSACTION_TYPE_NAME and the decoded TRANSACTION_QUANTITY — the nature of the movement and its signed quantity; the view uses DECODE on TRANSACTION_ACTION_ID to present issue/return quantities correctly.
- TRANSACTION_UOM, PRIMARY_QUANTITY, PRIMARY_UOM_CODE — quantity in the item's primary unit of measure.
- OPERATION_SEQ_NUM, DEPARTMENT_CODE, RESOURCE_CODE — routing context for resource and overhead charges.
- CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE — foreign-currency accounting attributes, with the view preferring the transaction-account values over the header values via NVL.
- REFERENCE_ACCOUNT, TRANSACTION_VALUE, BASE_TRANSACTION_VALUE, GL_BATCH_ID — the accounting distribution and its GL batch linkage.
- Cost-element decode over COST_ELEMENT_ID — MATERIAL, MATERIAL OVERHEAD, RESOURCE, OUTSIDE PROCESSING, or OVERHEAD.
- ACCOUNTING_LINE_TYPE, ACTIVITY, RATE_OR_AMOUNT, REASON_NAME, TRANSACTION_REFERENCE — descriptive and rate attributes for analysis.
- Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID, ROWID, etc.) for auditing and concurrency.
Common Use Cases and Queries
The view supports job-cost detail extracts, WIP accounting reconciliation, and cost-element analysis by accounting period. Because it is single-org, queries should always constrain ORGANIZATION_ID and ACCT_PERIOD_ID to keep the result set bounded. A typical extract is shown below.
SELECT organization_id,
wip_entity_id,
transaction_id,
acct_period_id,
transaction_type_name,
transaction_date,
inventory_item_id,
primary_quantity,
cost_element, -- decoded via COST_ELEMENT_ID
transaction_value,
base_transaction_value,
reference_account,
department_code,
resource_code
FROM apps.cst_distribution_v
WHERE organization_id = :p_org_id
AND acct_period_id = :p_period_id
ORDER BY wip_entity_id, transaction_id;
For cost-element summarisation, group by WIP_ENTITY_ID and the cost-element decode to compare material, resource, overhead, and outside-processing charges within a period. For GL tie-out, filter on GL_BATCH_ID to isolate distributions that have been posted, and reconcile BASE_TRANSACTION_VALUE against the batch totals. When investigating a specific movement, join back to the underlying MTL_MATERIAL_TRANSACTIONS.ROWID (exposed as the view's ROWID column) to retrieve the exact base row. Note that the referenced base objects are the synonyms listed above; any grant or synonym redefinition in a cloned environment should be verified before relying on the view in custom integrations. The view is marked VALID, so no recompilation concerns apply under normal patching and cloning sources.
-
View: CST_DISTRIBUTION_V 12.1.1
Transaction details and accounting distributions for a job or schedule in an accounting period : SINGLE-ORG view
APPS.CST_DISTRIBUTION_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CSI_ITEM_INSTANCES·Explore BOM module →
-
View: CST_DISTRIBUTION_V 12.2.2
Transaction details and accounting distributions for a job or schedule in an accounting period : SINGLE-ORG view
APPS.CST_DISTRIBUTION_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CSI_ITEM_INSTANCES·Explore BOM module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.CST_ACTIVITIES 12.2.2
-
SYNONYM: APPS.CST_ACTIVITIES 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.WIP_LINES 12.2.2
-
SYNONYM: APPS.WIP_LINES 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
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 →
-
SYNONYM: APPS.BOM_RESOURCES 12.2.2
-
SYNONYM: APPS.BOM_RESOURCES 12.1.1
-
SYNONYM: APPS.PO_HEADERS 12.1.1
-
SYNONYM: APPS.PO_HEADERS 12.2.2
-
SYNONYM: APPS.WIP_ENTITIES 12.1.1
-
SYNONYM: APPS.WIP_ENTITIES 12.2.2
-
VIEW: APPS.MFG_LOOKUPS 12.2.2
-
VIEW: APPS.MFG_LOOKUPS 12.1.1
-
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.2.2
Table to map wip transactions to their corresponding event types.