CAC Department Overhead Rates

Description

Categories
Enginatics
Repository
GitHub
Report to show departmental overheads and rates

/* +=============================================================================+
-- | Copyright 2016 - 2020 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. |
-- | 1.5 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Program Name: xxx_dept_ovhd_rates.sql
-- |
-- | Parameters:
-- | p_ledger -- Ledger you wish to report, enter a null or blank for all
-- | ledgers.
-- | p_cost_type -- Cost Type you wish to report, enter a null or blank for all
-- | cost types.
-- |
-- | Description:
-- | Report to show departmental overheads and rates.
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 17 Sep 2013 Douglas Volz Initial Coding
-- | 1.1 18 Oct 2016 Douglas Volz Added organization information
-- | 1.2 6 Sep 2019 Douglas Volz Added last update date
-- | 1.3 27 Jan 2020 Douglas Volz Added Operating Unit parameter
-- | 1.4 26 Apr 2020 Douglas Volz Changed to multi-language views for
-- | operating units.+=============================================================================+*/

SQL 42 lines

Parameters 4

ParameterTypeList of values SQL
Cost TypeLOV
cct.cost_type=:p_cost_type
Organization CodeLOV
mp.organization_code=:p_org_code
Operating UnitLOV
haouv_ou.name=:p_operating_unit
LedgerLOV
gl.name=:p_ledger