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
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 |
|
LOV | |
To Cost Type |
|
LOV | |
From Org Code |
|
LOV | |
To Org Code |
|
LOV |