CAC Order Type Setup

Report to display the sales order transaction types with the corresponding receivables (A/R) transaction types.

/* +=============================================================================+
-- | 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. |
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Program Name: xxx_oe_transaction_types.sql
-- |
-- | Parameters:
-- | p_operating_unit -- Operating Unit you wish to report, leave blank for all
-- | operating units (optional)
-- | p_ledger -- general ledger you wish to report, leave blank for all
-- | ledgers (optional)
-- | Description:
-- | Report to display the sales order transaction types with the corresponding
-- | receivables (A/R) transaction types.
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 15 Nov 2016 Douglas Volz Initial Coding
-- | 1.1 09 Jan 2017 Douglas Volz Added description and Receivables Txn Type
-- | 1.2 11 Jan 2017 Douglas Volz Added Order Category, Order Type (DFF),
-- | and Disti Plus Pricing (DFF), and add a
-- | new section for Order Types with no COGS
-- | account.
-- | 1.3 14 Mar 2017 Douglas Volz Changed apps.ra_cust_trx_types to
-- | apps.ra_cust_trx_types_all, added A/R
-- | revenue account
-- | 1.4 23 Aug 2017 Douglas Volz Add user-defined field (descriptive flex-
-- | field) for the COGS ICP account, a contra-
-- | account which is used to record the ICP
-- | portion of the COGS entry.
-- | 1.5 13 Mar 2019 Douglas Volz Added Operating Unit Parameter.
-- | 1.6 22 May 2019 Douglas Volz Added missing ORG_ID join
-- | 1.7 14 Apr 2020 Douglas Volz Added creation date to report
-- | 1.8 16 Apr 2020 Douglas Volz Moved sales ccid joins to outer query
-- | and added Ledger parameter.
-- | 1.9 28 Apr 2020 Douglas Volz Changed to multi-language views for the
-- | inventory orgs and operating units.
-- | 1.10 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+*/