CAC Material Overhead Setup

Description

Categories
Enginatics
Repository
GitHub
Report to show the material overhead sub-element definition and the default material overheads, if any.

/* +=============================================================================+
-- | 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. |
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Program Name: xxx_mtl_ovhd_setup_rept.sql
-- |
-- | Parameters:
-- | p_org_code -- Specific inventory organization you wish to report (optional)
-- | 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)
-- | p_only_active -- include only active material overhead codes. Enter
-- | Yes (Yes) to return only active (non-disabled) material
-- | overhead codes. Enter No (No) to get all material
-- | overhead codes.
-- |
-- | Description:
-- | Report to show the material overhead sub-element definition and the default
-- | material overheads, if any.
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 05 Apr 2011 Douglas Volz Initial Coding
-- | 1.1 21 Feb 2016 Douglas Volz Modified Chart of Accounts to match client's COA
-- | 1.2 17 Jul 2018 Douglas Volz Modified Chart of Accounts to match client's COA
-- | 1.3 16 Jan 2020 Douglas Volz Add inventory org and operating unit parameters.
-- | 1.4 8 Apr 2020 Douglas Volz Fix for p_only_active parameter conditions and
-- | changed from fnd_lookup_values to mfg_lookups
-- | sys_yes_no for the Functional Currency column.
-- | Was duplicating rows.
-- | 1.5 28 Apr 2020 Douglas Volz Changed to multi-language views for the
-- | inventory orgs and operating units.
-- | 1.6 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+*/

SQL 51 lines

Parameters 4

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