CAC Cost Vs. Planning Item Controls

Description
Categories: Cost Accounting - Assessment, Cost Accounting - Cost, Enginatics, OATUG Public
Repository: Github Columns: Report Type, Ledger, Operating Unit, Org Code, Cost Type, Item Number, Item Description, UOM Code, Item Type, Item Status ...
Compare item make/buy controls vs. costing based on rollup controls. There are five included reports, see below description for more information.
/* +=============================================================================+
-- | Copyright 2008-2019 Douglas Volz Consulting, Inc. |
-- | All rights reserved.  ... 
Compare item make/buy controls vs. costing based on rollup controls. There are five included reports, see below description for more information.
/* +=============================================================================+
-- | Copyright 2008-2019 Douglas Volz Consulting, Inc. |
-- | All rights reserved. |
-- | Permission to use this code is granted provided the original author is |
-- | acknowledged. No warranties, express or otherwise is included in this |
-- | permission. |
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Program Name: xxx_cost_vs_plan_ctrls_repts.sql
-- |
-- | Parameters:
-- |
-- | p_cost_type -- Desired cost type, mandatory
-- | p_assignment_set -- The assignment set you wish to report
-- | p_ledger -- Desired ledger to report, to get all values enter a
-- | null value or blank value
-- | p_item_number -- Specific item number, to get all values enter a
-- | null value or blank value
-- |
-- | Description:
-- | Use the below SQL scripts to compare the item costing rollup flags
-- | with the item's make / buy flag. For the any Cost Type.
-- | Report to show cost rollup flags which may be incorrect:
-- | 1. Based on Rollup Yes - No BOMS
-- | Find make or buy items where the item is set to be rolled up
-- | but there are no BOMs, routings or sourcing rules. May
-- | roll up to a zero cost.
-- | 2. Based On Rollup Yes - No Rollup
-- | Find items where it is set to be rolled up but there are
-- | no rolled up costs
-- | 3. Based on Rollup No - with BOMS
-- | Find make or buy items where the item is not set to be rolled up
-- | but BOMS, routings or sourcing rules exist.
-- | 4. User Defined Costs - Make Items
-- | For make items, where the planning_make_buy_code is Make,
-- | find records where the detailed item costs are user-defined
-- | (rollup source type is user-defined) instead of rolled-up or
-- | based on the cost rollup. May indicate a doubling up
-- | of your item costs.
-- | 5. Based on Rollup Yes - No Routing
-- | Find items where the planning_make_buy_code is "Buy" or "Make",
-- | costs are based on the cost rollup, BOMs exist but routings do not.

-- | 1.23 09 Jan 2017 Douglas Volz New report 5, BOM exists but routing does not
-- | 1.24 05 Nov 2018 Douglas Volz Don't report obsolete items
-- | 1.25 01 May 2019 Douglas Volz Changed gl.short_name to gl.short_name
-- | 1.25 01 May 2019 Douglas Volz Changed gl.short_name to gl.short_name
-- | 1.26 27 Jan 2020 Douglas Volz Added Org Code and Operating Unit parameters.
-- | 1.27 26 Apr 2020 Douglas Volz Changed to multi-language views for the item
-- | master and operating units.
-- | 1.28 31 May 2020 Douglas Volz Use multi-language table for UOM