Results for “quantity_at_po_price”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CST_RCV_ACQ_COSTS is a BOM schema table in Oracle E-Business Suite that stores acquisition cost per period and organization cost group for periodic costing. It operates as a core repository within the Cost Management module, capturing the actual acquisition costs associated with receiving transactions as they are recognized for periodic average costing (PAC). The table links receiving activity to periodic cost calculation, allowing the system to accumulate receipts, invoice adjustments, and purchase order price variances before they are rolled up through the cost group and cost type hierarchy for a given accounting period.

Under a heuristic Data Vault classification mined from the foreign key structure, this table is satellite-leaning: its primary key is a surrogate HEADER_ID, and the majority of its columns are descriptive measures (quantities, amounts, rates) that describe a business event rather than acting as pure join keys. In a Data Vault model this would typically be modeled as a satellite attached to a receiving/cost link hub keyed by cost group, cost type, period, and receiving transaction.

Key Information Stored

• HEADER_ID — the surrogate primary key (CST_RCV_ACQ_COSTS_PK) and the unique business-key candidate defined by index CST_RCV_ACQ_COSTS_U1. It is also the column referenced by the child table CST_RCV_ACQ_COST_DETAILS.HEADER_ID.
• COST_GROUP_ID — foreign key to CST_COST_GROUPS, identifying the organization cost group whose costs are being accumulated.
• COST_TYPE_ID — foreign key to CST_COST_TYPES, indicating the cost type (for example, frozen or average) under which the acquisition cost applies.
• PERIOD_ID — foreign key to CST_PAC_PERIODS, tying each row to a specific periodic costing period.
• RCV_TRANSACTION_ID — foreign key to RCV_TRANSACTIONS, linking the record to the originating receiving transaction.
• NET_QUANTITY_RECEIVED, TOTAL_QUANTITY_INVOICED, QUANTITY_AT_PO_PRICE, COSTED_QUANTITY — quantity measures capturing receipt, invoiced, PO-priced, and costed volumes.
• TOTAL_INVOICE_AMOUNT, AMOUNT_AT_PO_PRICE, TOTAL_AMOUNT, ACQUISITION_COST — monetary measures representing invoice value, PO value, and the resulting acquisition cost.
• PO_LINE_LOCATION_ID, PO_UNIT_PRICE, PRIMARY_UOM — purchase order context.
• REC_EXCHG_RATE — the exchange rate applied to receipt amounts.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — concurrent request and program audit identifiers.

Common Use Cases and Queries

Typical reporting extracts acquisition cost by period and cost group for reconciliation against general ledger and inventory valuation. A representative join reconciles acquisitions to their source receiving transactions:

SELECT a.header_id, a.cost_group_id, a.period_id, a.acquisition_cost, r.transaction_id
FROM cst_rcv_acq_costs a, rcv_transactions r
WHERE a.rcv_transaction_id = r.transaction_id
AND a.period_id = :p_period;

Analysts also aggregate totals across cost groups to validate periodic costing runs, and drill into CST_RCV_ACQ_COST_DETAILS for line-level breakdown using HEADER_ID. Auditing scenarios compare AMOUNT_AT_PO_PRICE against TOTAL_INVOICE_AMOUNT to quantify purchase price variance, while Program/Request columns support tracing rows back to the concurrent process that populated them.

Related Objects

• CST_COST_GROUPS — joined on COST_GROUP_ID.
• CST_COST_TYPES — joined on COST_TYPE_ID.
• CST_PAC_PERIODS — joined on PERIOD_ID.
• RCV_TRANSACTIONS — joined on RCV_TRANSACTION_ID.
• CST_RCV_ACQ_COST_DETAILS — child table joined on HEADER_ID.