CAC AP Accrual Reconciliation Load Request

Description

Categories
Enginatics, R12 only
Repository
GitHub
Report to show when the A/P Accrual Reconciliation Load program was run and by whom, including the Ledger, Operating Unit, Build Id, Request Id, Creation Date and Last Updated By.

Parameters:
===========
Beginning Creation Date: enter the starting creation date to report, based on the operating unit for your session's inventory organization (optional).
Operating Unit: enter the specific operating unit(s) you wish to report (optional).
Ledger: enter the specific ledger(s) you wish to report (optional).

/* +=============================================================================+
-- | Copyright 2019 - 2025 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])
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 31 Oct 2019 Douglas Volz Initial Coding
-- | 1.1 28 Jan 2025 Douglas Volz Added creation date parameter
-- | 1.2 15 Feb 2025 Douglas Volz Added Operating Unit and Ledger Security
-- | Profile Controls and parameters.
-- | 1.3 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+*/

SQL 25 lines

Parameters 3

ParameterTypeList of values SQL
Beginning Creation DateDate
crb.creation_date>=:p_beg_creation_date
Operating UnitLOV
haouv.name=:p_operating_unit
LedgerLOV
gl.name=:p_ledger