CAC Number of Item Costs by Cost Type
Description
Categories: Enginatics
Repository: Github
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. ... more
/* +=============================================================================+
-- | Copyright 2017 - 2019 Douglas Volz Consulting, Inc. |
-- | All rights reserved. ... more
Run
CAC Number of Item Costs by Cost Type and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
|
LOV | |
To Cost Type |
|
LOV | |
From Org Code |
|
LOV | |
To Org Code |
|
LOV |