Search Results receiving_txn_date




Overview
Explore in AI Chat

Overview

APPS.CSTBV_RCV_ACQ_COSTS is a Business Intelligence System (BIS) view in Oracle E-Business Suite that presents a periodic acquisition cost summary for receiving transactions. The view aggregates acquisition cost data for each receipt, organized by cost group, cost type, and PAC (Periodic Average Cost) period. It is documented in Oracle's ETRM metadata with the FND Design Data reference BOM.CSTBV_RCV_ACQ_COSTS, indicating that the object originates from the Bills of Material product family and is exposed in the APPS schema as a read-only reporting interface.

Because it is a view rather than a base table, it exists purely for reporting and integration purposes. It provides a denormalized, business-friendly representation of acquisition cost activity that would otherwise require joins across multiple cost management and receiving tables. The view is marked VALID and carries an Oracle Proprietary, Confidential Information designation, consistent with other ETRM-documented dictionary objects.

Underlying Base Objects

According to the documented dependency information, CSTBV_RCV_ACQ_COSTS is defined over the following base objects, all referenced through APPS synonyms:

  • CST_RCV_ACQ_COSTS — the core acquisition cost table storing periodic cost details per receipt transaction.
  • CST_COST_GROUPS — supplies cost group identifiers and names used to segment acquisition costs.
  • CST_COST_TYPES — supplies the costing method context (for example, standard or average) associated with the acquisition cost records.
  • CST_PAC_PERIODS — defines the PAC period to which each periodic acquisition cost row belongs.
  • RCV_TRANSACTIONS — the receiving transaction table providing receipt type, transaction date, and receipt-level attributes.

The view is not referenced by any other database object, confirming its role as a terminal reporting layer. The joins between CST_RCV_ACQ_COSTS and RCV_TRANSACTIONS supply the RECEIVING_TXN_TYPE and RECEIVING_TXN_DATE columns that users frequently filter on.

Key Columns

The view exposes identifiers, quantities, amounts, and descriptive attributes. Important columns include:

Common Use Cases and Queries

This view is typically used to reconcile acquisition costs against receiving and invoicing activity, analyze cost variances by cost group or cost type, and support period-end close reporting for periodic average costing. Because the user search term was "receiving_txn_type," a typical query filters on that column to isolate specific transaction classes such as RECEIVE or RETURN TO VENDOR:

  • Receipt-level acquisition cost detail: SELECT RCV_TRANSACTION_ID, RECEIVING_TXN_TYPE, RECEIVING_TXN_DATE, NET_QUANTITY_RECEIVED, ACQUISITION_COST FROM APPS.CSTBV_RCV_ACQ_COSTS WHERE RECEIVING_TXN_TYPE = 'RECEIVE';
  • Period summary by cost group: SELECT COST_GROUP_NAME, COST_TYPE_NAME, PAC_PERIOD_NAME, SUM(ACQUISITION_COST) ACQ_COST FROM APPS.CSTBV_RCV_ACQ_COSTS GROUP BY COST_GROUP_NAME, COST_TYPE_NAME, PAC_PERIOD_NAME ORDER BY PAC_PERIOD_NAME;
  • Invoice versus PO price variance: SELECT RCV_TRANSACTION_ID, TOTAL_INVOICE_AMOUNT, AMOUNT_AT_PO_PRICE, (TOTAL_INVOICE_AMOUNT - AMOUNT_AT_PO_PRICE) VARIANCE FROM APPS.CSTBV_RCV_ACQ_COSTS WHERE PAC_PERIOD_NAME = :period;

Because the view exposes COST_GROUP_NAME, COST_TYPE_NAME, and PAC_PERIOD_NAME as VARCHAR2 descriptive columns, it is well suited to ad-hoc reporting tools, BI Publisher data models, and custom concurrent programs that require acquisition cost summaries without writing complex multi-table joins.