CAC Inventory Account Alias Setup

Description

Categories
Enginatics
Repository
GitHub
Report to show accounts assigned for inventory account aliases

/* +=============================================================================+
-- | Copyright 2011 - 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.4 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Program Name: xxx_acct_alias_setup_rept.sql
-- |
-- | Parameters:
-- | p_ledger -- Ledger you wish to report, enter a null for all
-- | ledgers. (optional)
-- |
-- | Description:
-- | Report to show accounts used for account aliases
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 03 Feb 2011 Douglas Volz Initial Coding
-- | 1.1 28 Mar 2011 Douglas Volz Added Ledger parameter, effective date
-- | and disable date
-- | 1.2 07 Oct 2015 Douglas Volz Removed prior client's org restrictions.
-- | 1.3 27 Apr 2020 Douglas Volz Changed to multi-language views for the
-- | inventory orgs and operating units.

SQL 35 lines

Parameters 3

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