CST Historical WIP Standard Cost Adjustment

Description

Categories
Enginatics
Repository
GitHub
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.

SQL 229 lines

Parameters 2

ParameterTypeList of values SQL
Organization CodeLOV
exists (select null from mtl_parameters mp where mp.organization_code=:organization_code and ccu.organization_id in (mp.organization_id,mp.cost_organization_id))
Cost UpdateLOV
ccu.cost_update_id=:cost_update