Search Results transfer_transaction_id




Overview
Explore in AI Chat

Overview

CST_XLA_INV_REF_V is an APPS-owned database view in Oracle E-Business Suite (validated across 12.1.1 and 12.2.2) that belongs to the BOM (Bills of Material) product family. It exposes inventory and costing transaction reference data that the Subledger Accounting (XLA) engine consumes when generating accounting entries for material movements. The view consolidates transactional, cost, and cross-reference attributes drawn primarily from Material Transactions and its associated accounting records, allowing SLA/costing programs and custom reports to resolve the full business context of a single inventory or work-in-process transaction without joining multiple base tables manually. Although catalogued under BOM, its scope spans the broader Cost Management and Inventory integration surface, since the columns it projects originate from material transaction accounting and COGS recognition logic.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects, each accessed through a synonym in APPS:

  • MTL_MATERIAL_TRANSACTIONS — the driving source (aliased MMT), supplying transaction identifiers, quantities, UOM, reason, source references, transfer and costing attributes, DFFs (ATTRIBUTE1–15), and physical/cycle count linkages.
  • MTL_TRANSACTION_ACCOUNTS — aliased MTA, supplying base and entered transaction values used to derive encumbrance reversal amounts.
  • CST_COGS_EVENTS — aliased CCE, supplying COGS percentage and prior COGS percentage for recognition percentage calculations.
  • RCV_TRANSACTIONS — supplying receiving linkage data such as SHIPMENT_NUMBER.
  • PO_REQUISITION_LINES_ALL — referenced as part of the purchasing/receiving provenance chain.

The view is therefore a denormalized projection over the material transaction core, joining accounting and receiving context to produce a single accounting-ready row per transaction.

Key Columns

Notable columns include TRANSACTION_ID, TRANSACTION_QUANTITY, and TRANSACTION_UOM for the primary movement; TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, and TRANSACTION_REFERENCE for provenance; TRX_SOURCE_LINE_ID, RCV_TRANSACTION_ID, MOVE_TRANSACTION_ID, and COMPLETION_TRANSACTION_ID for cross-referencing related transactions; and PARENT_TRANSACTION_ID for hierarchical relationships. Costing columns include PPV_VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, ENCUMBRANCE_REVERSAL_AMOUNT, and ENCUM_REVERSAL_AMOUNT_ENTERED. COGS logic is exposed through COGS_RECOGNITION_PERCENT, COGS_RECOGN_PERCENT_CHANGE, and COGS_PERCENTAGE. Logical/transfer attributes include LOGICAL_TRANSACTION, LOGICAL_TRX_TYPE_CODE, INTERCOMPANY_PRICING_OPTION, and TRANSFER_PERCENTAGE. SHIPMENT_NUMBER appears through the receiving snapshot.

Common Use Cases and Queries

The view is commonly used to reconstruct the accounting reference context for a material transaction, to analyze COGS recognition and encumbrance reversals, and to trace receiving or transfer lineage. A representative query retrieving accounting reference detail for a transaction follows:

  • SELECT transaction_id, transaction_quantity, transaction_uom, ppv_variance_amount, cogs_recognition_percent, shipment_number FROM cst_xla_inv_ref_v WHERE transaction_id = :p_transaction_id;
  • SELECT transaction_source_name, transaction_reference, encumbrance_reversal_amount FROM cst_xla_inv_ref_v WHERE trx_source_line_id = :p_line_id;

The user search term repetitive_line_id is not exposed as a column in this view; repetitive manufacturing context is not projected here, and callers seeking that attribute must reference the underlying source tables directly.