Search Results cst_ap_variance_v




Overview
Explore in AI Chat

Overview

CST_AP_VARIANCE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the BOM (Bills of Material) product family. It consolidates Accounts Payable invoice price variances against the cost layers and purchase order distributions that generated them, joining variance header, line, and batch records to purchasing, receiving, inventory, and payables data. The view serves as the primary denormalized source for investigating purchase price variance (PPV) at the batch, invoice, and item level.

Because the view exposes BATCH_ID adjacent to CAVB.DESCRIPTION, it directly supports the user search term batch_description: the batch description is the human-readable label for a cost adjustment batch created when AP variances are processed. Analysts use this view to trace how a specific invoice variance batch flowed into inventory valuation, accrual balances, and project costs.

Underlying Base Objects

The view joins core variance tables with transactional and master data. Documented base objects include:

The view also references HR_GENERAL and HR_SECURITY packages internally, consistent with organization security enforcement.

Key Columns

Common Use Cases and Queries

Typical uses include batch-level variance auditing, PPV reconciliation to AP invoices, and cost layer revaluation analysis.

Locate a variance batch by its description:

SELECT batch_id, description, organization_code, cost_group,
       header_var_amount, transaction_date
FROM   apps.cst_ap_variance_v
WHERE  description LIKE '%'||:batch_description||'%';

Reconcile PPV to an invoice:

SELECT invoice_num, po_number, po_line_num, current_quantity,
       current_item_cost, value_change, pcnt_value_change
FROM   apps.cst_ap_variance_v
WHERE  invoice_num = :invoice_num
ORDER  BY variance_line_id;

Report total variance by batch and organization:

SELECT batch_id, description, organization_code,
       SUM(header_var_amount) total_variance
FROM   apps.cst_ap_variance_v
GROUP  BY batch_id, description, organization_code;