Results for “cstfv_rcv_acq_costs”

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

Overview

CSTFV_RCV_ACQ_COSTS is an APPS-owned, read-only view in Oracle E-Business Suite (validated on 12.1.1 and 12.2.2) that reports acquisition costs captured against receiving transactions. It is catalogued under the BOM — Bills of Material product family, but it operates on the Cost Management acquisition cost model, joining receiving activity to purchasing, perpetual costing periods, cost groups, cost types, and inventory organization definitions.

The view resolves foreign keys to descriptive names so that consumer reports and integrations need not perform additional lookups. It exposes the shipment match option, PO number, line and shipment numbers, receiving transaction type and date, period, cost group, cost type, and organization code. Critically for the user's search on ship_to_organization_name, the view derives the destination organization by joining HR_ALL_ORGANIZATION_UNITS (HAOU) to PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID and MTL_PARAMETERS (MP) on the same SHIP_TO_ORGANIZATION_ID. HAOU.NAME supplies the ship-to organization name, while MP.ORGANIZATION_CODE supplies the inventory organization code; MP is aliased to ORGANIZATION_CODE in the documented column list.

The view is defined WITH READ ONLY and performs outer joins to purchase order header, line, and line location tables (the (+) operator on PHA, PLA, and PLLA), so acquisition cost rows persist even when purchase order references are incomplete — matching the acquisition costing population, which may include receipt-only transactions.

Underlying Base Objects

The documented base objects are CST_RCV_ACQ_COSTS, CST_PAC_PERIODS, CST_COST_GROUPS, CST_COST_TYPES, RCV_TRANSACTIONS, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, HR_ALL_ORGANIZATION_UNITS, and MTL_PARAMETERS. Each is referenced through an APPS synonym.

CST_RCV_ACQ_COSTS is the driving table (HEADER_ID as primary key), joined to CST_PAC_PERIODS on PERIOD_ID = PAC_PERIOD_ID, to CST_COST_GROUPS on COST_GROUP_ID, to CST_COST_TYPES on COST_TYPE_ID, and to RCV_TRANSACTIONS on RCV_TRANSACTION_ID. PO_LINE_LOCATIONS_ALL is joined on PO_LINE_LOCATION_ID, PO_LINES_ALL on PO_LINE_ID, and PO_HEADERS_ALL on PO_HEADER_ID. HR_ALL_ORGANIZATION_UNITS and MTL_PARAMETERS are both keyed to PLLA.SHIP_TO_ORGANIZATION_ID.

Key Columns

• HEADER_ID — primary key of the acquisition cost record.
• NET_QUANTITY_RECEIVED, COSTED_QUANTITY, TOTAL_QUANTITY_INVOICED, QUANTITY_AT_PO_PRICE — quantity measures for receipt, costing, invoicing, and PO-price valuation.
• ACQUISITION_COST, TOTAL_AMOUNT, TOTAL_INVOICE_AMOUNT, AMOUNT_AT_PO_PRICE — monetary measures used for cost and price variance analysis.
• PO_UNIT_PRICE, PRIMARY_UOM, REC_EXCHG_RATE — unit price, unit of measure, and the receiving exchange rate.
• COST_GROUP_NAME, COST_TYPE_NAME, PAC_PERIOD_NAME — resolved costing classification and period descriptors.
• PO_NUMBER, PO_LINE_NUMBER, SHIPMENT_NUM, MATC — purchasing references; MATC decodes MATCH_OPTION ('P' to 'PO', 'R' to 'RECEIPT').
• ORGANIZATION_CODE — inventory organization code from MTL_PARAMETERS.
• HAOU.NAME — the ship-to organization name, resolved from HR_ALL_ORGANIZATION_UNITS via SHIP_TO_ORGANIZATION_ID.
• RECEIVING_TXN_TYPE, RECEIVING_TXN_DATE — receiving transaction classification and date.
• WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY).

Common Use Cases and Queries

The view supports period-close acquisition cost reconciliation, purchase price variance reporting, and drill-down from cost to receiving transaction. Because the ship-to organization is exposed, users commonly filter or group by destination organization.

To attribute acquisition costs to a destination organization by name:

• SELECT po_number, ship_to_organization_name, organization_code, acquisition_cost, net_quantity_received, pac_period_name FROM cstfv_rcv_acq_costs WHERE ship_to_organization_name = :org_name;
• SELECT cost_group_name, cost_type_name, SUM(acquisition_cost) FROM cstfv_rcv_acq_costs WHERE pac_period_name = :period GROUP BY cost_group_name, cost_type_name;
• SELECT po_number, po_line_number, shipment_num, matc, receiving_txn_type, receiving_txn_date, total_amount FROM cstfv_rcv_acq_costs WHERE po_number = :po ORDER BY receiving_txn_date;

Note that the documented column list references the ship-to organization by HAOU.NAME; in deployments the projected column may appear as SHIP_TO_ORGANIZATION_NAME. All queries should be directed against the APPS synonym with read-only intent.