Search Results cstbv_rcv_acq_costs




Overview
Explore in AI Chat

Overview

CSTBV_RCV_ACQ_COSTS is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It is catalogued under the BOM (Bills of Material) product family and is part of the Cost Management and receiving acquisition cost reporting infrastructure. The view denormalizes the base acquisition cost table CST_RCV_ACQ_COSTS by resolving foreign key identifiers into their descriptive equivalents, presenting receiving acquisition cost records together with cost group, cost type, PAC period, and receiving transaction context in a single, query-ready result set.

Its principal role is to expose acquisition cost information tied to receiving transactions in a form that is directly consumable by reports, concurrent programs, and downstream integrations without requiring join logic on the part of the caller. Because the view is defined with the WITH READ ONLY clause, it supports query access only and cannot be used as a DML target, which reinforces its intended use as a reporting and inquiry object rather than a transactional interface. Typical consumers include cost accounting analysis reports, period-close reconciliation queries, and custom extracts that need to correlate invoice amounts, purchase order prices, and acquisition costs at the receipt level.

Underlying Base Objects

The view is defined over five documented base objects, all referenced through synonyms in the APPS schema:

  • CST_RCV_ACQ_COSTS (alias CRAC) — the primary driving table holding the acquisition cost detail, including quantities, invoice amounts, PO price amounts, and acquisition cost values. Its HEADER_ID is exposed as the primary key of the view.
  • CST_PAC_PERIODS (alias CPP) — supplies the PAC period context; joined on PAC_PERIOD_ID to resolve the period name.
  • CST_COST_GROUPS (alias CCG) — supplies the descriptive cost group name, joined on COST_GROUP_ID.
  • CST_COST_TYPES (alias CCT) — supplies the descriptive cost type name, joined on COST_TYPE_ID.
  • RCV_TRANSACTIONS (alias RT) — supplies the receiving transaction type and transaction date, joined on TRANSACTION_ID.

All joins are inner joins on the corresponding identifier columns, meaning a row is returned only when matching period, cost group, cost type, and receiving transaction records exist.

Key Columns

The view exposes identity, quantity, and value columns from the acquisition cost table together with resolved descriptive columns:

Common Use Cases and Queries

The view is commonly used to reconcile received quantities against invoiced and costed quantities, to analyze acquisition cost by period, cost group, and cost type, and to trace acquisition cost back to a specific receiving transaction and PO shipment.

A basic query retrieving costs for a given period and cost group:

  • SELECT header_id, cost_group_name, cost_type_name, pac_period_name, net_quantity_received, total_invoice_amount, acquisition_cost, po_unit_price FROM apps.cstbv_rcv_acq_costs WHERE pac_period_name = :period AND cost_group_name = :cost_group;

A query correlating acquisition cost with receiving transaction detail for a PO shipment:

  • SELECT receiving_txn_type, receiving_txn_date, rcv_transaction_id, costed_quantity, acquisition_cost, total_amount FROM apps.cstbv_rcv_acq_costs WHERE po_line_location_id = :po_line_location_id ORDER BY receiving_txn_date;

Because all descriptive attributes are pre-resolved, these queries require no additional joins, making the view well suited to ad hoc analysis, report data sources, and period-end acquisition cost reconciliation.