CAC Number of Item Costs by Cost Type

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Report to show the count of item costs by cost type. Use this report after you copy from one cost type to another, to ensure all rows have been copied over.

/* +=============================================================================+
-- | Copyright 2017 - 2019 Douglas Volz Consulting, Inc. |
-- | All rights reserved.  ...  Report to show the count of item costs by cost type. Use this report after you copy from one cost type to another, to ensure all rows have been copied over.

/* +=============================================================================+
-- | Copyright 2017 - 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_count_costs_by_cost_type.sql
-- |
-- | Parameters:
-- | p_from_cost_type -- The cost type you copied from, mandatory
-- | p_to_cost_type -- The cost type you copied to, mandatory
-- | p_from_org_code -- The inventory organization you copied from, if
-- | enter a blank or null value you get all organizations
-- | p_to_org_code -- The inventory organization you copied to, if
-- | enter a blank or null value you get all organizations
-- |
-- | Description:
-- | Report to show the count of item costs by cost type. Use this report after
-- | you copy from one cost type to another, to ensure all rows have been copied over.
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 04 May 2017 Douglas Volz Initial Coding
-- | 1.1 31 Aug 2019 Douglas Volz Added to and from cost types and org codes
-- +=============================================================================+*/   more 
select count(*) Count,
 mp.organization_code Org_Code,
 cct.cost_type Cost_Type,
 cct.description Description
from    cst_item_costs cic,
 mtl_parameters mp,
 cst_cost_types cct
where cic.organization_id   = mp.organization_id
and cic.cost_type_id      = cct.cost_type_id
and 1=1
group by
 mp.organization_code,
 cct.description,
 cct.cost_type
union all
select count(*) Count,
 mp.organization_code Org_Code,
 cct.cost_type Cost_Type,
 cct.description Description
from    cst_item_costs cic,
 mtl_parameters mp,
 cst_cost_types cct
where cic.organization_id   = mp.organization_id
and cic.cost_type_id      = cct.cost_type_id
and 2=2
group by
 mp.organization_code,
 cct.description,
 cct.cost_type
-- Order by Cost Type, Organization Code
order by 2,3
Parameter NameSQL textValidation
From Cost Type
cct.cost_type = :p_from_cost_type
LOV
To Cost Type
cct.cost_type = :p_to_cost_type
LOV
From Org Code
mp.organization_code = :p_from_org_code
LOV
To Org Code
mp.organization_code = :p_to_org_code
LOV
Download
Related Blitz Reports
CAC Internal Order Shipment Margin CAC PO Price vs. Costing Method Comparison CAC Missing Material Accounting Transactions CAC Missing WIP Accounting Transactions CST Detailed Item Cost CAC Resource Costs CAC Inventory Pending Cost Adjustment - No Currencies CAC Inventory Lot and Locator OPM Value (Period-End) CST Item Cost Upload
Blitz Report™