CST Historical WIP Standard Cost Adjustment – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

WIP standard cost adjustment details recorded by a completed standard cost update, based on Oracle’s Historical WIP Standard Cost Adjustment Report (CSTCUSJA).

The report shows one line per WIP discrete job, transaction type, item or resource operation and cost element, with the old and new unit costs, adjustment quantity and adjustment value, and the WIP job’s valuation and standard cost adjustment accounts.

The Cost Update parameter offers the completed standard cost updates of the selected organization that saved their adjustment details, matching Oracle’s View Cost Update History form. Oracle’s Delete Snapshot option is deliberately not included, so the stored adjustment details are never removed by this report.

Report Parameters

Organization Code, Cost Update

Oracle EBS Tables Used

gl_code_combinations_kfv, cst_cost_updates, cst_cost_types, org_organization_definitions, gl_ledgers, fnd_currencies, cst_std_cost_adj_values, wip_entities, wip_discrete_jobs, mtl_system_items_vl, bom_resources, cst_cost_elements

Report Categories

Enginatics

FA Asset Impairments, FSG Drilldown Diagnostic, GL Code Combinations, AR Customer Upload, GL Journals (Drilldown)

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output CST Historical WIP Standard Cost Adjustment 05-Aug-2026 123629.xlsx
Blitz Report™ XML Import CST_Historical_WIP_Standard_Cost_Adjustment.xml
Full SQL on Enginatics www.enginatics.com/reports/cst-historical-wip-standard-cost-adjustment/

© 2026 Enginatics