CAC Number of Item Costs by Cost Type

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. |
-- | 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
-- | 1.2 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+*/

SQL 38 lines

Parameters 4

ParameterTypeList of values SQL
From Cost TypeLOV
cct.cost_type=:p_from_cost_type
To Cost TypeLOV
cct.cost_type=:p_to_cost_type
From Org CodeLOV
mp.organization_code=:p_from_org_code
To Org CodeLOV
mp.organization_code=:p_to_org_code