Probably I didn’t explain well in my reply. History may not be right name for cst_standard_costs, lets consider this as audit trial table. Evey time cost is entered/updated, it logs a record into cst_standard costs while maintaining the current cost in cst_item_costs. When you purge audit trail, you can decide to purge entire records, then […]

Hi Bruce, BOM.cst_items_cost – stores the current cost information by each cost type including standard/average cost types. BOM.cst_standard_costs – stores the history of cost updates i.e. every time cost is inserted or updated it will have a record. By default oracle adds records in BOM.cst_standard_costs for every cost record in…[Read more]