ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 92C63F4C20A21E85E053BB6B63585CC8 CST Cost Type Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type US 92DADAD6B54BA363E053BB6B6358D65B 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 Y #,##0;[Red](#,##0) US CAC Number of Item Costs by Cost Type 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 (doug@volzconsulting.com) -- | -- | 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 -- +=============================================================================+*/ Enginatics 1=1 2=2 1 10 1=1 cct.cost_type = :p_from_cost_type LOV CST Cost Type 92C63F4C20A21E85E053BB6B63585CC8 Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type Y US From Cost Type 2 20 2=2 cct.cost_type = :p_to_cost_type LOV CST Cost Type 92C63F4C20A21E85E053BB6B63585CC8 Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type Y US To Cost Type 3 30 1=1 mp.organization_code = :p_from_org_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US From Org Code 4 40 2=2 mp.organization_code = :p_to_org_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US To Org Code