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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Name SQL text Validation
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 Sourcing Rule CST Item Cost Upload
Blitz Report™

Blitz Report™ provides multiple benefits: