ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEC879D2E0530100007F1FF2 GL Chart of Accounts (inv org related) Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name AR دليل الحسابات المتعلقة بمنظمات المخزون D Kontenplan für Bestandsorganisationen E Plan de cuentas relacionado con las organizaciones de inventario F Plan comptable relatif aux organismes d'inventaire I Piano dei conti relativo alle organizzazioni dell'inventario JA 棚卸し組織に関する勘定科目一覧表 KO 재고 조직과 관련된 계정과 목표 PTB Plano de contas relacionado às organizações de inventário RU План счетов организаций, занимающихся инвентаризацией S Kontoplan relaterade till lagerorganisationer TR Envanter organizasyonları ile ilgili hesap planı US Chart of accounts related to inventory organizations ZHS 与库存组织有关的会计科目表 8E2FF36EDF3A79D2E0530100007F1FF2 GL Ledger (inv org related) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name AR جميع دفاتر الأستاذ المتعلقة بجميع منظمات المخزون النشطة D Alle Ledger, die sich auf alle aktiven Inventarorganisationen beziehen E Todos los libros de contabilidad relacionados con todas las organizaciones de inventario activas F Tous les grands livres relatifs à tous les organismes d'inventaire actifs I Tutti i libri contabili relativi a tutte le organizzazioni di inventario attive JA すべてのアクティブな在庫組織に関連するすべての台帳 KO 모든 활성 재고 조직과 관련된 모든 원장 PTB Todos os livros contábeis relacionados a todas as organizações de inventário ativas RU Все бухгалтерские книги, относящиеся ко всем организациям, занимающимся активным инвентаризацией. S Alla huvudböcker relaterade till alla aktiva lagerorganisationer TR Tüm aktif envanter organizasyonlarıyla ilgili tüm defterler US All ledgers related to all active inventory organizations ZHS 与所有现行清单组织有关的所有分类账 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US EC5CECA520510FC8E0530100007F5EB3 INV Item Number (costing enabled only items) Y Y select distinct msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and (xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) ) and (msiv.costing_enabled_flag='Y' or mp.process_enabled_flag='Y') order by msiv.concatenated_segments US 9B9627743E84607DE053BB6B635805FB INV Operating Unit Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 AR جميع وحدات التشغيل المرتبطة بمؤسسة مخزون غير رئيسية نشطة D Alle Betriebseinheiten, die mit einer aktiven Nicht-Master-Inventarisierungsorganisation verbunden sind E Todas las unidades operativas relacionadas con una organización de inventario no maestra activa F Toutes les unités opérationnelles liées à un organisme d'inventaire non maître actif I Tutte le unità operative legate a un'organizzazione di inventario non master attiva JA アクティブな非マスターインベントリ組織に関連するすべてのオペレーティング・ユニット KO 활성 비 마스터 재고 조직과 관련된 모든 운영 단위 PTB Todas as unidades operacionais relacionadas a uma organização ativa de inventário não-mestre RU Все операционные единицы, относящиеся к действующей организации, не являющейся ведущим поставщиком инвентарных запасов. S Alla operativa enheter relaterade till en aktiv organisation som inte är huvudlager TR Etkin bir ana envanter organizasyonu ile ilgili tüm işletim birimleri US All operating units related to an active non master inventory organization ZHS 与在用的非总清单组织有关的所有业务单位： 91D3167A33531204E053BB6B63585EE3 INV Organization Code (excluding master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code AR جميع رموز تنظيم المخزون النشط باستثناء المؤسسات الرئيسية D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master JA マスター組織を除くすべてのアクティブなインベントリ組織コード KO 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre RU Все действующие инвентаризационные коды организаций, за исключением основных организаций S Alla aktiva organisationskoder för inventarier exklusive huvudorganisationer TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları US All active inventory organization codes excluding master organizations ZHS 所有现行清单组织代码，不包括主组织 91E8680353217CCEE053BB6B635868C2 INV Period (closed and summarized) Y select distinct oap.period_name value, max(oap.period_year||'-'||oap.period_num||', '||xxen_util.meaning(nvl2(oap.period_close_date,decode(oap.open_flag,'P',2,'N',decode(oap.summarized_flag,'N',65,66),4),3),'MTL_ACCT_PERIOD_STATUS',700)||' ('||oap.period_start_date||' - '||oap.schedule_close_date||')') over (partition by oap.period_name) description, max(oap.period_start_date) over (partition by oap.period_name) period_start_date, max(oap.effective_period_num) over (partition by oap.period_name) effective_period_num from gl_ledgers gl, org_organization_definitions ood, mtl_parameters mp, (select oap.period_year*10000+oap.period_num effective_period_num, oap.* from org_acct_periods oap) oap where oap.period_close_date is not null and oap.summarized_flag='Y' and oap.period_start_date<=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') and ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and gl.period_set_name=oap.period_set_name and gl.ledger_id=ood.set_of_books_id and ood.organization_id=oap.organization_id order by period_start_date desc, effective_period_num desc, oap.period_name AR فترات دفتر الأستاذ العام للمخزون المغلقة والملخصة السابقة (يعتمد دفتر الأستاذ و / أو معلمة رمز المؤسسة) للمؤسسات غير الرئيسية D Vergangene abgeschlossene und zusammengefasste Bestands-GL-Perioden (abhängig von Ledger- und/oder Organisationscode-Parametern) für Nicht-Master-Organisationen E Períodos GL de inventario cerrados y resumidos en el pasado (dependiente de los parámetros del libro mayor y/o del código de organización) para organizaciones no maestras F Périodes de GL d'inventaire clôturées et résumées passées (en fonction du grand livre et/ou du code d'organisation) pour les organisations non maîtresses I Inventario passato chiuso e riassunto dei periodi GL (dipendente dal parametro del ledger e/o del codice dell'organizzazione) per organizzazioni non master JA 過去のクローズしたインベントリGL期間を要約した（元帳および/または組織コードパラメータに依存する）非マスター組織のために KO 비 마스터 조직에 대한 과거 마감 및 요약 된 재고 GL 기간 (원장 및 / 또는 조직 코드 매개 변수에 따라 다름) PTB Períodos anteriores de inventário fechado e resumido GL (ledger e/ou código de organização dependente do parâmetro) para organizações não-mestras RU Прошлые закрытые и обобщенные инвентарные запасы Периоды GL (в зависимости от бухгалтерской книги и/или параметра организационного кода) для неосновных организаций S Tidigare slutna och sammanfattade GL-perioder för inventering (storbok och / eller organisationskodsparameterberoende) för icke-huvudorganisationer TR Ana olmayan kuruluşlar için geçmiş kapatılmış ve özetlenmiş envanter GL dönemleri (genel muhasebe ve / veya kuruluş kodu parametresine bağlı) US Past closed and summarized inventory GL periods (ledger and/or organization code parameter dependent) for non master organizations ZHS 非主组织过去已结束的和汇总的库存GL期(取决于分类账和/或组织代码参数) A486BD05719C2A82E053BB6B6358FC8E select nvl(gl.short_name, gl.name) Ledger, -- ============================================== -- This first select gets the subinventory values -- ============================================== haou2.name Operating_Unit, mp.organization_code Org_Code, -- Revision for version 1.14 -- (select ccg.cost_group -- from cst_cost_groups ccg -- where ccg.cost_group_id = cpcs.cost_group_id) Cost_Group, -- End revision for version 1.14 oap.period_name Period_Name, &segment_columns msiv.concatenated_segments Item_Number, msiv.description Item_Description, -- Revision for version 1.12 fcl.meaning Item_Type, -- Revision for version 1.18 misv.inventory_item_status_code_tl Item_Status, &category_columns -- Revision for version 1.18 nvl(cpcs.subinventory_code, ml.meaning) Subinventory_or_Intransit, muomv.uom_code UOM_Code, round(sum(nvl(cpcs.rollback_quantity, 0)),3) Quantity, round(sum(nvl(cpcs.rollback_value, 0)),2) Onhand_Value, round(sum(nvl(cpcs.accounted_value, 0)),2) Accounted_Value, round(sum((nvl(cpcs.onhand_value_discrepancy, 0)) + (nvl(cpcs.intransit_value_discrepancy, 0))),2) Difference -- End revision for version 1.18 from cst_period_close_summary cpcs, org_acct_periods oap, mtl_parameters mp, mtl_system_items_vl msiv, -- Revision for version 1.18 mtl_item_status_vl misv, mtl_units_of_measure_vl muomv, mfg_lookups ml, -- End revision for version 1.18 -- Revision for version 1.13 -- Get valuation accounts based on Costing_Method and Cost Group Accounting (-- Standard Costing, no Cost Group Accounting select msub.organization_id, msub.secondary_inventory_name, msub.material_account from mtl_secondary_inventories msub, mtl_parameters mp where msub.organization_id = mp.organization_id and nvl(mp.cost_group_accounting,2) = 2 -- No and mp.primary_cost_method = 1 -- Standard Costing union all -- Not Standard Costing, no Cost Group Accounting select msub.organization_id, msub.secondary_inventory_name, mp.material_account from mtl_secondary_inventories msub, mtl_parameters mp where msub.organization_id = mp.organization_id and nvl(mp.cost_group_accounting,2) = 2 -- No and mp.primary_cost_method <> 1 -- not Standard Average Costing union all -- With Cost Group Accounting select msub.organization_id, msub.secondary_inventory_name, ccga.material_account from mtl_secondary_inventories msub, cst_cost_group_accounts ccga, mtl_parameters mp where msub.organization_id = mp.organization_id and mp.cost_group_accounting = 1 -- Yes and ccga.cost_group_id = msub.default_cost_group_id union all -- Cost Group Accounting but the Subinventory Cost Group Id is null select msub.organization_id, msub.secondary_inventory_name, ccga.material_account from mtl_secondary_inventories msub, cst_cost_group_accounts ccga, mtl_parameters mp where msub.organization_id = mp.organization_id and mp.cost_group_accounting = 1 -- Yes and msub.default_cost_group_id is null and ccga.cost_group_id = mp.default_cost_group_id ) msub, gl_code_combinations gcc, hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl, -- Revsion for version 1.12 fnd_common_lookups fcl where oap.acct_period_id = cpcs.acct_period_id and oap.organization_id = mp.organization_id and cpcs.subinventory_code = msub.secondary_inventory_name and cpcs.organization_id = msub.organization_id and mp.organization_id = cpcs.organization_id and msiv.organization_id = cpcs.organization_id and msiv.inventory_item_id = cpcs.inventory_item_id -- Revision for version 1.18 and misv.inventory_item_status_code = msiv.inventory_item_status_code and msiv.primary_uom_code = muomv.uom_code and ml.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' and ml.lookup_code = 14 -- Intransit Inventory and msub.material_account = gcc.code_combination_id (+) -- End revision for version 1.18 -- =================================================================== -- using the base tables to avoid the performance issues -- with org_organization_definitions and hr_operating_units -- =================================================================== -- avoid selecting disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate + 1) and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- get the ledger_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and 1=1 -- p_period_name, p_item_number, p_org_code, p_operating_unit, p_ledger -- =================================================================== -- Lookup Values, added for revision 1.12 -- =================================================================== and fcl.lookup_code (+) = msiv.item_type and fcl.lookup_type (+) = 'ITEM_TYPE' group by nvl(gl.short_name, gl.name), haou2.name, mp.organization_code, -- Revision for version 1.14 -- cpcs.cost_group_id, oap.period_name, &segment_columns2 msiv.concatenated_segments, msiv.description, -- Revision for version 1.12 fcl.meaning, -- Revision for version 1.18 misv.inventory_item_status_code_tl, nvl(cpcs.subinventory_code, ml.meaning), muomv.uom_code, -- End revision for version 1.18 -- Needed for inline select msiv.inventory_item_id, msiv.organization_id having abs(sum(nvl(cpcs.onhand_value_discrepancy, 0) + nvl(cpcs.intransit_value_discrepancy, 0))) >= :p_min_value_diff -- p_min_value_diff -- ============================================== -- This second select gets the intransit values -- ============================================== union all select nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, mp.organization_code Org_Code, -- Revision for version 1.14 -- (select ccg.cost_group -- from cst_cost_groups ccg -- where ccg.cost_group_id = cpcs.cost_group_id) Cost_Group, -- End revision for version 1.14 oap.period_name Period_Name, &segment_columns msiv.concatenated_segments Item_Number, msiv.description Item_Description, -- Revision for version 1.12 fcl.meaning Item_Type, -- Revision for version 1.18 misv.inventory_item_status_code_tl Item_Status, &category_columns -- End revision for version 1.12 -- Revision for version 1.18 nvl(cpcs.subinventory_code, ml.meaning) Subinventory_or_Intransit, muomv.uom_code UOM_Code, round(sum(nvl(cpcs.rollback_quantity, 0)),3) Quantity, round(sum(nvl(cpcs.rollback_value, 0)),2) Onhand_Value, round(sum(nvl(cpcs.accounted_value, 0)),2) Accounted_Value, round(sum((nvl(cpcs.onhand_value_discrepancy, 0)) + (nvl(cpcs.intransit_value_discrepancy, 0))),2) Difference -- End revision for version 1.18 from cst_period_close_summary cpcs, org_acct_periods oap, mtl_parameters mp, mtl_system_items_vl msiv, -- Revision for version 1.18 mtl_item_status_vl misv, mtl_units_of_measure_vl muomv, mfg_lookups ml, -- End revision for version 1.18 -- Fix for version 1.11 -- mtl_interorg_parameters mip, gl_code_combinations gcc, hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl, -- Revsion for version 1.12 fnd_common_lookups fcl where oap.acct_period_id = cpcs.acct_period_id and oap.organization_id = mp.organization_id -- Fix for version 1.11 -- and mp.organization_id = mip.to_organization_id -- End fix for version 1.11 and cpcs.subinventory_code is null and mp.organization_id = cpcs.organization_id and msiv.organization_id = cpcs.organization_id and msiv.inventory_item_id = cpcs.inventory_item_id -- Revision for version 1.18 and misv.inventory_item_status_code = msiv.inventory_item_status_code and msiv.primary_uom_code = muomv.uom_code and ml.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' and ml.lookup_code = 14 -- Intransit Inventory -- End revision for version 1.18 -- Fix for version 1.11 -- and mip.intransit_inv_account = gcc.code_combination_id and mp.intransit_inv_account = gcc.code_combination_id (+) -- =================================================================== -- using the base tables to avoid using org_organization_definitions -- and hr_operating_units -- =================================================================== -- avoid selecting disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate + 1) and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- get the ledger_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and 1=1 -- p_period_name, p_item_number, p_org_code, p_operating_unit, p_ledger -- =================================================================== -- Lookup Values, added for revision 1.12 -- =================================================================== and fcl.lookup_code (+) = msiv.item_type and fcl.lookup_type (+) = 'ITEM_TYPE' group by nvl(gl.short_name, gl.name), haou2.name, mp.organization_code, -- Revision for version 1.14 -- cpcs.cost_group_id, oap.period_name, &segment_columns2 msiv.concatenated_segments, msiv.description, -- Revision for version 1.12 fcl.meaning, misv.inventory_item_status_code_tl, -- End for version 1.12 -- Revision for version 1.18 nvl(cpcs.subinventory_code, ml.meaning), muomv.uom_code, -- End revision for version 1.18 -- Needed for inline select msiv.inventory_item_id, msiv.organization_id having abs(sum(nvl(cpcs.onhand_value_discrepancy, 0) + nvl(cpcs.intransit_value_discrepancy, 0))) >= :p_min_value_diff -- p_min_value_diff -- Order by Ledger, Operating_Unit, Accounts, Item and Subinventory order by 1,2,5,6,7,8,9,10,11,12,15 -- | 1.19 14 Jun 2024 Douglas Volz Remove tabs, reinstall parameters and org access controls. Y AR CAC Inventory Out-of-Balance تقرير لإظهار أي اختلافات في لقطة نهاية الفترة التي تم إنشاؤها عند إغلاق فترات المخزون. يمثل هذا أي اختلافات بين إدخالات محاسبة المخزون التراكمية والتقييم المباشر للمخزونات الفرعية ومواقع المخزون الداخلي. / * + ================================================ =============================== + - | حقوق النشر 2006-2020 شركة دوغلاس فولز للاستشارات | - | يتم منح الإذن باستخدام هذا الرمز بشرط أن يكون المؤلف الأصلي هو | - | اعترف. لا توجد ضمانات ، صريحة أو غير مضمنة في هذا | - | الإذن. | - + ================================================ =============================== + - | - | المؤلف الأصلي: دوغلاس فولز (doug@volzconsulting.com) - | - | اسم البرنامج: xxx_inv_snapshot_diff_rept.sql - | - | العوامل: - | p_org_code - مؤسسة مخزون معينة ترغب في الإبلاغ عنها (اختياري) - | p_operating_unit - وحدة التشغيل التي ترغب في الإبلاغ عنها ، اتركها فارغة للجميع - | وحدات التشغيل (اختياري) - | p_ledger - دفتر الأستاذ العام الذي ترغب في الإبلاغ عنه ، اتركه فارغًا للجميع - | دفاتر الأستاذ (اختياري) - | p_period_name - الفترة المحاسبية المطلوب الإبلاغ عنها ، إلزامية - | p_min_value_diff - أدنى فرق يمكن جمعه حسب المؤسسة حسب الفترة ، - | يتم تعيين هذا على القيمة الافتراضية 1 إذا لم يتم إدخال أي شيء - | p_category_set1 - فئة العنصر الأولى التي تم تعيينها للإبلاغ ، وعادةً ما يكون ملف - | التكلفة أو مجموعة فئة خط المنتج - | p_category_set2 - فئة العنصر الثانية التي تم تعيينها للإبلاغ ، وعادةً ما يكون ملف - | مجموعة فئة الجرد - | - | وصف: - | تقرير لإظهار أي اختلافات في لقطة نهاية الفترة التي تم إنشاؤها - | عند إغلاق فترات الجرد. هذا يمثل أي اختلافات - | بين إدخالات محاسبة المخزون التراكمية والعملية - | تقييم المستودعات الفرعية ومواقع المخزون الداخلي. - | - | تم تعديل الإصدار حسب الوصف - | ======= =========== =============== ================== ======================== - | 1.0 02 أبريل 2006 ترميز دوجلاس فولز الأولي - | 1.14 19 نوفمبر 2015 علق دوجلاس فولز على معلومات مجموعة التكلفة. غير متسق. - | 1.15 17 يوليو 2018 أبلغ دوجلاس فولز الآن عن الاسم المختصر للأستاذ العام. - | 1.16 06 يناير 2020 أضاف دوجلاس فولز كود المؤسسة ومعلمات وحدة التشغيل. - | 1.17 30 أبريل 2020 تم تغيير Douglas Volz إلى عروض متعددة اللغات للعنصر - | الرئيسية ، منظمات المخزون ووحدات التشغيل. - | 1.18 18 مايو 2020 لغة دوجلاس فولز المضافة لحالة العنصر. - + ================================================ =============================== + * / D CAC Inventory Out-of-Balance Bericht, um etwaige Differenzen im Periodenend-Snapshot anzuzeigen, der erstellt wird, wenn Sie die Bestandsperioden abschließen. Dies stellt etwaige Differenzen zwischen den kumulierten Bestandsbuchungseinträgen und der Bestandsbewertung der Teilbestände und Intransitlagerorte dar. /* +=============================================================================+ -- | Copyright 2006-2020 Douglas Volz Consulting, Inc. | -- | | Die Erlaubnis zur Verwendung dieses Codes wird erteilt, sofern der Originalautor | -- | | anerkannt wird. Diese | | | Erlaubnis beinhaltet keine ausdrücklichen oder anderweitigen Garantien. -- | | Erlaubnis. | -- +=============================================================================+ -- | -- | Originalautor: Douglas Volz (doug@volzconsulting.com) -- | -- | | Programmname: xxx_inv_snapshot_diff_rept.sql -- | -- | Parameter: -- | p_org_code -- Spezifische Bestandsorganisation, die Sie melden möchten (optional) -- | p_operating_unit -- Betriebseinheit, die Sie melden möchten, für alle leer lassen -- | Betriebseinheiten (optional) -- | p_ledger -- Hauptbuch, über das Sie berichten möchten, für alle leer lassen -- | ledger (optional) -- | p_period_name -- die zu berichtende Buchhaltungsperiode, obligatorisch -- | p_min_value_diff -- die minimale Differenz, die von Org nach Periode aufaddiert werden soll, -- | Dieser Wert wird standardmäßig auf 1 gesetzt, wenn nichts eingegeben wird -- | p_category_set1 -- Die erste zu berichtende Positionskategorie, typischerweise die -- | Kosten- oder Produktlinien-Kategoriesatz -- | p_category_set2 -- Die zweite zu meldende Artikelkategorie, typischerweise die -- | Bestandskategoriesatz -- | -- | Beschreibung: -- | Bericht zur Anzeige von Unterschieden im Periodenend-Snapshot, der erstellt wird -- -- | wenn Sie die Bestandsperioden schließen. Dies stellt alle Differenzen -- | zwischen den kumulierten Bestandsbuchungen und der Bestands -- | Bewertung der Teilbestände und Transitlagerorte. -- | -- | Version Geändert am Geändert von Beschreibung -- | ======= =========== ============== ========================================= -- | 1.0 02 APR 2006 Douglas Volz Erstcodierung -- | 1.14 19 Nov 2015 Douglas Volz Die Kostengruppeninformationen wurden auskommentiert. Nicht konsistent. -- | 1.15 17 Jul 2018 Douglas Volz Meldet jetzt Sachkontenkurzbezeichnung. -- | 1.16 06 Jan 2020 Douglas Volz Parameter Org Code und Operating Unit hinzugefügt. -- | 1.17 30 Apr 2020 Douglas Volz Umstellung auf mehrsprachige Ansichten für den Artikel -- | Master, Inventar-Orgs und Operating Units. -- | 1.18 18. Mai 2020 Douglas Volz Sprache für Artikelstatus hinzugefügt. -- +=============================================================================+*/ E CAC Inventory Out-of-Balance Informe para mostrar cualquier diferencia en la instantánea de fin de período que se crea al cerrar los períodos de inventario. Esto representa cualquier diferencia entre las entradas contables de inventario acumuladas y la valoración en mano de los subinventarios y las ubicaciones de stock en tránsito. /* +=============================================================================+ -- Copyright 2006-2020 Douglas Volz Consulting, Inc. | -- Se permite el uso de este código siempre y cuando se reconozca al autor original. -- | reconocido. Este permiso no incluye ninguna garantía, expresa o de otro tipo. -- | permiso. | -- +=============================================================================+ -- | -- | Autor original: Douglas Volz (doug@volzconsulting.com) -- | -- -- Nombre del programa: xxx_inv_snapshot_diff_rept.sql -- | -- -- Parámetros: -- | p_org_code -- Organización de inventario específica de la que desea informar (opcional) -- | p_operating_unit -- Unidad operativa que desea reportar, dejar en blanco para todas -- | unidades operativas (opcional) -- | p_ledger -- Libro mayor del que desea informar, dejar en blanco para todos -- | libros mayores (opcional) -- | p_period_name -- el periodo contable a reportar, obligatorio -- | p_min_value_diff -- diferencia mínima a sumar por org por periodo, -- | se fija por defecto en un valor de 1 si no se introduce nada -- | p_category_set1 -- El primer conjunto de categorías de artículos a reportar, típicamente el -- | Conjunto de categorías de costes o líneas de productos -- | p_category_set2 -- El segundo tipo de artículo a reportar, típicamente el -- | Conjunto de categorías de inventario -- | -- | Descripción: -- | Informe para mostrar cualquier diferencia en la instantánea de fin de período que se crea -- | cuando se cierran los períodos de inventario. Esto representa cualquier diferencia -- | entre los asientos contables del inventario acumulado y la valoración -- | valoración de los subinventarios y las ubicaciones de stock en tránsito. -- | -- | Versión Modificada en Modificada por Descripción -- | ======= =========== ============== ========================================= -- | 1.0 02 ABR 2006 Douglas Volz Codificación inicial -- | 1.14 19 nov 2015 Douglas Volz Comentado la información del Grupo de Costos. No es consistente. -- | 1.15 17 Jul 2018 Douglas Volz Ahora reporta el nombre corto de G/L. -- | 1.16 06 Ene 2020 Douglas Volz Añadidos los parámetros de Código Org y Unidad Operativa. -- | 1.17 30 Abr 2020 Douglas Volz Cambiado a vistas multi-idioma para el artículo -- | maestro, orgs de inventario y unidades operativas. -- | 1.18 18 May 2020 Douglas Volz Añadido el idioma para el estado del artículo. -- +=============================================================================+*/ F CAC Inventory Out-of-Balance Rapport pour montrer les différences dans l'instantané de fin de période qui est créé lorsque vous clôturez les périodes d'inventaire. Cela représente les différences entre les écritures comptables d'inventaire cumulées et l'évaluation en cours des sous-inventaires et des emplacements de stock en transit. /* +=============================================================================+ | Copyright 2006-2020 Douglas Volz Consulting, Inc. | -- | L'autorisation d'utiliser ce code est accordée à condition que l'auteur original soit | -- | reconnu. Aucune garantie, expresse ou autre, n'est incluse dans ce | -- | permission. | -- +=============================================================================+ -- | -- | Auteur original : Douglas Volz (doug@volzconsulting.com) -- | | Nom du programme : xxx_inv_snapshot_diff_rept.sql -- | -- | Paramètres : -- | p_org_code -- Organisation spécifique de l'inventaire que vous souhaitez signaler (facultatif) | p_operating_unit -- Unité opérationnelle que vous souhaitez signaler, laissez vide pour tous | unités d'exploitation (facultatif) -- | p_ledger -- grand livre général que vous souhaitez déclarer, laissez vide pour tous -- | grands livres (facultatif) | p_period_name -- l'exercice comptable à déclarer, obligatoire | p_min_value_diff -- différence minimale à additionner par org par période, | est réglé par défaut sur une valeur de 1 si rien n'est saisi | p_category_set1 -- La première catégorie d'articles à signaler, généralement le | Ensemble de catégories de coûts ou de lignes de produits | p_category_set2 -- La deuxième catégorie d'articles à signaler, généralement le | Ensemble de catégories d'inventaire -- | -- | Description : -- | Rapport montrant les différences dans l'instantané de fin de période qui est créé -- | lorsque vous clôturez les périodes d'inventaire. Cela représente les différences éventuelles | entre les écritures comptables de l'inventaire cumulé et le -- | l'évaluation des sous-inventaires et des emplacements des stocks en transit. -- | -- | Version modifiée le Modifié par la description -- | ======= =========== ============== ========================================= -- | 1.0 02 APR 2006 Codage initial de Douglas Volz | 1.14 19 nov. 2015 Douglas Volz commente les informations sur le groupe de coûts. Pas cohérent. -- | 1.15 17 Jul 2018 Douglas Volz Rapporte maintenant le nom court du G/L. | 1.16 06 Jan 2020 Douglas Volz a ajouté le code Org et les paramètres de l'unité opérationnelle. -- | 1.17 30 avr 2020 Douglas Volz Passe à des vues multilingues pour le point -- | maître, orgs d'inventaire et unités opérationnelles. -- | 1.18 18 mai 2020 Douglas Volz Ajout d'une langue pour le statut des articles. -- +=============================================================================+*/ I CAC Inventory Out-of-Balance Report per mostrare qualsiasi differenza nell'istantanea di fine periodo che viene creata quando si chiudono i periodi di inventario. Questo rappresenta qualsiasi differenza tra le voci contabili cumulative dell'inventario e la valutazione onhand dei sottoinventari e delle posizioni di magazzino intransitate. /* +=============================================================================+ -- | Copyright 2006-2020 Douglas Volz Consulting, Inc. | -- | Il permesso di usare questo codice è concesso a condizione che l'autore originale sia | -- | riconosciuto. Nessuna garanzia, espressa o di altro tipo, è inclusa in questo permesso. -- | permesso. | -- +=============================================================================+ -- | -- | Autore originale: Douglas Volz (doug@volzconsulting.com) -- | -- | Nome del programma: xxx_inv_snapshot_diff_rept.sql -- | -- | Parametri: -- | p_org_code -- Organizzazione specifica dell'inventario che vuoi segnalare (opzionale) -- | p_operating_unit -- Unità operativa che vuoi segnalare, lascia vuoto per tutte -- | unità operative (opzionale) -- p_ledger -- Contabilità generale che vuoi segnalare, lascia in bianco per tutti -- | ledger (opzionale) -- | p_period_name -- il periodo contabile da riportare, obbligatorio -- | p_min_value_diff -- differenza minima da sommare per org per periodo, -- | questo è impostato di default ad un valore di 1 se non viene inserito nulla -- | p_category_set1 -- La prima categoria di voci da riportare, tipicamente la -- | categoria di costo o linea di prodotto impostata -- | p_category_set2 -- La seconda categoria di articoli da riportare, tipicamente la -- | Set di categorie di inventario -- | -- | Descrizione: -- | Report per mostrare qualsiasi differenza nell'istantanea di fine periodo che viene creata -- | | quando si chiudono i periodi di inventario. Questo rappresenta qualsiasi differenza -- | tra le registrazioni contabili cumulative dell'inventario e la valutazione -- | valutazione dei sottoinventari e delle locazioni di magazzino in transito. -- | -- | Versione Modificata il Modificato da Descrizione -- | ======= =========== ============== ========================================= -- | 1.0 02 APR 2006 Douglas Volz Codifica iniziale -- | 1.14 19 Nov 2015 Douglas Volz Ha commentato le informazioni del gruppo di costo. Non coerente. -- | 1.15 17 Jul 2018 Douglas Volz Ora riporta G/L nome breve. -- | 1.16 06 Jan 2020 Douglas Volz Aggiunti i parametri Org Code e Operating Unit. -- | 1.17 30 Apr 2020 Douglas Volz Cambiato in viste multilingue per l'articolo -- | master, org di inventario e unità operative. -- | 1.18 18 maggio 2020 Douglas Volz Aggiunta la lingua per lo stato degli articoli. -- +=============================================================================+*/ JA CAC Inventory Out-of-Balance 棚卸資産の期間を閉じるときに作成される期間終了スナップショットの差分を表示するためのレポート。 これは、累積インベントリ会計エントリとサブインベントリおよび通過中の在庫ロケーションの手元評価との間のあらゆる相違を表しています。 /* +=============================================================================+ --｜著作権 2006-2020 Douglas Volz Consulting, Inc. | --｜このコードの使用を許可するには、原著作者が｜原著作者であることが条件となります。 -- : - - 認められています。 本製品には、明示的であるか否かにかかわらず、いかなる保証も含まれていません。 -- --｜permission. | -- +=============================================================================+ -- | -- --｜原著者。ダグラス・ヴォルツ (doug@volzconsulting.com) -- | --｜プログラム名: xxx_inv_snapshot_diff_rept.sql -- | -- | パラメータ。 -- | p_org_code -- レポートを作成したいインベントリ組織を指定します(オプション) -- | p_operating_unit -- 報告したい操作ユニット、すべて空白のままにしておく。 -- 操作ユニット(オプション) -- | p_ledger -- 報告したい総勘定元帳、すべて空白のままにしておきます。 --｜元帳（オプション | p_period_name -- 報告する会計期間、必須 -- | p_min_value_diff -- 周期ごとに組織ごとに足し算する最小の差。 -- -- 何も入力されていない場合のデフォルト値は1に設定されています。 | p_category_set1 -- レポートする最初の項目カテゴリセット、通常は -- コストまたは製品ラインのカテゴリーセット | p_category_set2 -- 報告するために設定された2番目の項目カテゴリ、通常は -- 在庫区分セット -- | --｜説明。 -- | 作成された期間終了時のスナップショットの相違点を表示するためのレポート --｜インベントリ期間を閉じるとき。 これは -- 棚卸資産会計の累積項目と手元の棚卸資産との間にある --｜サブインベントリーとトランジットの在庫位置を評価します。 -- | -- 説明文で変更されています。 -- | ======= =========== ============== ========================================= --｜1.0 02 APR 2006 ダグラス・ヴォルツの初期コーディング --｜1.14 2015年11月19日 ダグラス・ヴォルツ コストグループの情報をコメントアウトしました。 一貫性がありません。 --｜1.15 2018年07月17日 Douglas Volz G/Lの短縮名を報告するようにしました。 --｜1.16 2020年01月06日 Douglas Volz Org CodeとOperating Unitのパラメータを追加しました。 --｜1.17 2020年04月30日 Douglas Volz 項目の多言語表示に変更しました。 --｜マスター、インベントリ、オペレーションユニット。 --｜1.18 18 May 2020 Douglas Volz アイテムの状態を表す言語を追加した。 -- +=============================================================================+*/ KO CAC Inventory Out-of-Balance 재고 기간을 마감 할 때 생성되는 기말 스냅 샷의 차이를 표시하는 보고서입니다. 이는 누적 재고 회계 입력과 창고 및 미착 재고 위치의 현재 고 평가 간의 차이를 나타냅니다. / * + ============================================= ============================= + -| 저작권 2006-2020 Douglas Volz Consulting, Inc. | -| 이 코드를 사용할 수있는 권한은 원래 작성자가 | -| 인정. 여기에는 명시 적 또는 기타 어떠한 보증도 포함되지 않습니다. -| 허가. | -+ ============================================= ============================= + -| -| 원저자 : Douglas Volz (doug@volzconsulting.com) -| -| 프로그램 이름 : xxx_inv_snapshot_diff_rept.sql -| -| 매개 변수 : -| p_org_code-보고 할 특정 재고 조직 (선택 사항) -| p_operating_unit-보고 할 운영 단위, 모두 비워 둡니다. -| 운영 단위 (선택 사항) -| p_ledger-보고하려는 총계정 원장, 모두 비워 둡니다. -| 원장 (선택 사항) -| p_period_name-보고 할 회계 기간, 필수 -| p_min_value_diff-기간별로 조직별로 합산 할 최소 차이, -| 아무것도 입력하지 않으면 기본값 1로 설정됩니다. -| p_category_set1-보고 할 첫 번째 항목 범주 세트, 일반적으로 -| 비용 또는 제품 라인 범주 세트 -| p_category_set2-보고 할 두 번째 항목 범주로, 일반적으로 -| 재고 범주 세트 -| -| 기술: -| 생성 된 기말 스냅 샷의 차이를 보여주는 보고서 -| 재고 기간을 마감 할 때. 이것은 차이점을 나타냅니다. -| 누적 재고 회계 입력과 현재 고 간 -| 창고 및 미착 재고 위치 평가 -| -| 수정 된 버전 설명에 의해 수정 됨 -| ======= =========== =============================== ======================= -| 1.0 02 APR 2006 Douglas Volz 초기 코딩 -| 1.14 2015 년 11 월 19 일 Douglas Volz가 Cost Group 정보를 주석 처리했습니다. 일관성이 없습니다. -| 1.15 2018 년 7 월 17 일 Douglas Volz는 이제 G / L 짧은 이름을보고합니다. -| 1.16 06 Jan 2020 Douglas Volz는 조직 코드 및 운영 단위 매개 변수를 추가했습니다. -| 1.17 2020 년 4 월 30 일 Douglas Volz 항목에 대한 다국어보기로 변경됨 -| 마스터, 재고 조직 및 운영 단위. -| 1.18 2020 년 5 월 18 일 Douglas Volz 항목 상태에 대한 언어가 추가되었습니다. -+ ============================================== ============================= + * / PTB CAC Inventory Out-of-Balance Relatório para mostrar quaisquer diferenças no snapshot de fim de período que é criado quando se encerra os períodos de inventário. Isto representa quaisquer diferenças entre os lançamentos contábeis de estoque acumulados e a avaliação manual dos subinventariados e dos locais de estoque intransitórios. /* +=============================================================================+ | Copyright 2006-2020 Douglas Volz Consulting, Inc., Copyright 2006-2020 Douglas Volz Consulting, Inc., Copyright 2006-2020 Douglas Volz Consulting, Inc. | | A permissão para usar este código é concedida desde que o autor original seja | | reconhecido. Nenhuma garantia, expressa ou não, está incluída nisto |. | permissão. | -- +=============================================================================+ -- | Autor original: Douglas Volz (doug@volzconsulting.com) | Nome do programa: xxx_inv_snapshot_diff_rept.sql | Parâmetros: | p_org_code -- Organização de inventário específica que você deseja relatar (opcional) | p_operating_unit -- Unidade operacional que você deseja relatar, deixe em branco para todos | unidades operacionais (opcional) | p_ledger -- livro razão geral que você deseja relatar, deixe em branco para todos | ledgers (opcional) | p_nome_do_período -- o período contábil a relatar, obrigatório | p_min_value_diff -- diferença mínima para somar por org por período, | isto é definido como padrão para um valor de 1 se nada for inserido | p_category_set1 -- A primeira categoria de item definida para relatar, tipicamente o | Conjunto de categorias de custo ou linha de produtos | p_category_set2 -- A segunda categoria de item definida para relatar, tipicamente o | Conjunto de Categorias de Estoque -- | Descrição: | Relatório para mostrar quaisquer diferenças no instantâneo de fim de período que é criado | quando se encerra os períodos de inventário. Isto representa quaisquer diferenças | entre os lançamentos contábeis de estoque acumulados e os manuais | avaliação dos subinventários e dos locais de estoque intransitórios. -- | | Versão Modificada em Modificada por Descrição -- | ======= =========== ============== ========================================= | 1.0 02 ABR 2006 Douglas Volz Codificação Inicial | 1.14 19 Nov 2015 Douglas Volz Comentou as informações do Grupo de Custos. Não Consistente. | 1.15 17 Jul 2018 Douglas Volz Agora informe o nome abreviado G/L. | 1.16 06 Jan 2020 Douglas Volz Acrescentou o Código Orgânico e os parâmetros da Unidade Operacional. | 1.17 30 Abr 2020 Douglas Volz Mudou para visualizações em vários idiomas para o item | master, orgs de inventário e unidades operacionais. | 1.18 18 de maio de 2020 Douglas Volz Adicionado o idioma para o status do item. -- +=============================================================================+*/ S CAC Inventory Out-of-Balance Rapportera för att visa eventuella skillnader i ögonblicksbilden för periodens slut som skapas när du stänger lagerperioderna. Detta representerar eventuella skillnader mellan de kumulativa lagerbokföringsposterna och utvärderingen av underlagren och lagerlokalerna. / * + ================================================== ================================ + - | Copyright 2006-2020 Douglas Volz Consulting, Inc. | - | Tillstånd att använda den här koden beviljas förutsatt att den ursprungliga författaren är | - | erkänd. Inga garantier, uttryckliga eller på annat sätt ingår i detta | - | lov. | - + ================================================= ================================ + - | - | Ursprunglig författare: Douglas Volz (doug@volzconsulting.com) - | - | Programnamn: xxx_inv_snapshot_diff_rept.sql - | - | Parametrar: - | p_org_code - Specifik inventeringsorganisation som du vill rapportera (valfritt) - | p_operating_unit - Operationsenhet som du vill rapportera, lämna tom för alla - | manöverenheter (tillval) - | p_ledger - huvudbok som du vill rapportera, lämna tomt för alla - | ledgers (valfritt) - | p_period_name - den redovisningsperiod som ska rapporteras, obligatorisk - | p_min_value_diff - minsta skillnad att lägga till efter organisation efter period, - | detta är inställt som standardvärde 1 om inget anges - | p_category_set1 - Den första artikelkategorin som ska rapporteras, vanligtvis - | Kostnad eller produktlinjekategoriuppsättning - | p_category_set2 - Den andra artikelkategorin som ska rapporteras, vanligtvis - | Inventory Category Set - | - | Beskrivning: - | Rapportera för att visa eventuella skillnader i ögonblicksbilden för periodens slut som skapas - | när du stänger lagerperioderna. Detta representerar alla skillnader - | mellan de ackumulerade bokföringsposterna och onhand - | värdering av delinventeringar och intransit lagerplatser. - | - | Version modifierad på modifierad av beskrivning - | ===================================================== ========================= - | 1.0 02 APR 2006 Douglas Volz inledande kodning - | 1.14 19 nov 2015 Douglas Volz kommenterade information om kostnadsgruppen. Inte konsekvent. - | 1.15 17 jul 2018 Douglas Volz Nu rapporterar bokstäver kort namn. - | 1.16 06 jan 2020 Douglas Volz har lagt till organisationskod och parametrar för operativ enhet. - | 1.17 30 apr 2020 Douglas Volz Ändrad till flerspråkiga vyer för artikeln - | befälhavare, lagerorganisationer och driftsenheter. - | 1.18 18 maj 2020 Douglas Volz Lagt till språk för artikelstatus. - + ================================================== ================================ + * / TR CAC Inventory Out-of-Balance Stok dönemlerini kapattığınızda oluşturulan dönem sonu anlık görüntüsündeki tüm farklılıkları gösteren rapor. Bu, kümülatif envanter muhasebesi girişleri ile alt stokların ve intransit stok konumlarının önceden değerlemesi arasındaki herhangi bir farkı temsil eder. / * + ============================================= ============================ + - | Telif Hakkı 2006-2020 Douglas Volz Consulting, Inc. | - | Bu kodu kullanma izni, orijinal yazarın | - | kabul edildi. Buna açık veya başka hiçbir garanti dahil edilmemiştir | - | izin. | - + =============================================== ============================ + - | - | Orijinal Yazar: Douglas Volz (doug@volzconsulting.com) - | - | Program Adı: xxx_inv_snapshot_diff_rept.sql - | - | Parametreler: - | p_org_code - Raporlamak istediğiniz belirli envanter organizasyonu (isteğe bağlı) - | p_operating_unit - Bildirmek istediğiniz İşletim Birimi, tümü için boş bırakın - | işletim birimleri (isteğe bağlı) - | p_ledger - rapor etmek istediğiniz genel muhasebe, tümü için boş bırakın - | defterler (isteğe bağlı) - | p_period_name - raporlanacak hesap dönemi, zorunlu - | p_min_value_diff - döneme göre organa eklenecek minimum fark, - | bu, hiçbir şey girilmezse varsayılan olarak 1 değerine ayarlanır - | p_category_set1 - Raporlanacak ilk öğe kategorisi, genellikle - | Maliyet veya Ürün Grubu Kategori Kümesi - | p_category_set2 - Raporlanacak ikinci öğe kategorisi, genellikle - | Envanter Kategori Kümesi - | - | Açıklama: - | Oluşturulan dönem sonu anlık görüntüsündeki tüm farklılıkları gösteren rapor - | envanter dönemlerini kapattığınızda. Bu, herhangi bir farklılığı temsil eder - | kümülatif stok muhasebesi girişleri ile önceden - | alt stokların ve intransit stok yerlerinin değerlemesi. - | - | Açıklamaya Göre Değiştirildiğinde Değiştirilen Sürüm - | ======= =========== ============== ================== ======================= - | 1.0 02 Nisan 2006 Douglas Volz İlk Kodlama - | 1.14 19 Kasım 2015 Douglas Volz Maliyet Grubu bilgilerini yorumladı. Tutarsız. - | 1.15 17 Temmuz 2018 Douglas Volz Şimdi defteri kebir kısa adını rapor edin. - | 1.16 06 Ocak 2020 Douglas Volz Kuruluş Kodu ve İşletim Birimi parametreleri eklendi. - | 1.17 30 Nis 2020 Douglas Volz Öğenin çoklu dil görünümlerine değiştirildi - | ana, envanter kuruluşları ve işletim birimleri. - | 1.18 18 Mayıs 2020 Douglas Volz Eşya durumu için dil eklendi. - + =============================================== ============================ + * / US CAC Inventory Out-of-Balance Report to show any differences in the period end snapshot that is created when you close the inventory periods. This represents any differences between the cumulative inventory accounting entries and the onhand valuation of the subinventories and intransit stock locations. Parameters: =========== Period Name (Closed): the closed inventory accounting period you wish to report (mandatory). Minimum Value Difference: the minimum difference to report, defaulted to a value of one. To see all differences enter a value of zero (mandatory). Category Set 1: any item category you wish, typically the Cost or Product Line category set (optional). Category Set 2: any item category you wish, typically the Inventory category set (optional). Item Number: enter the specific item number(s) you wish to report (optional). Organization Code: enter the specific inventory organization(s) you wish to report (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 2006-2024 Douglas Volz Consulting, Inc. -- | 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 (doug@volzconsulting.com) -- | -- | Program Name: xxx_inv_snapshot_diff_rept.sql -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 02 APR 2006 Douglas Volz Initial Coding -- | 1.14 19 Nov 2015 Douglas Volz Commented out the Cost Group information. Not Consistent. -- | 1.15 17 Jul 2018 Douglas Volz Now report G/L short name. -- | 1.16 06 Jan 2020 Douglas Volz Added Org Code and Operating Unit parameters. -- | 1.17 30 Apr 2020 Douglas Volz Changed to multi-language views for the item -- | master, inventory orgs and operating units. -- | 1.18 18 May 2020 Douglas Volz Added language for item status. -- | 1.19 14 Jun 2024 Douglas Volz Remove tabs, reinstall parameters and org access controls. -- +=============================================================================+*/ ZHS CAC Inventory Out-of-Balance 报告，以显示关闭库存期时创建的期末快照中的任何差异。 这表示累计库存会计分录与子库存和在途库存位置的手头估价之间的任何差异。 /* +=============================================================================+ -- 版权所有 2006-2020 道格拉斯-沃尔兹咨询公司。 | -- 允许使用该代码，但前提是原作者必须是｜。 -- 认可。 不包含任何明示或暗示的保证。 -- 允许。 | -- +=============================================================================+ -- | -- 原作者：Douglas Volz ()Douglas Volz (doug@volzconsulting.com) -- | -- 程序名称：xxx_inv_snapshot_diff_rept.sql。 -- | -- 参数。 -- p_org_code -- 您希望报告的具体清单组织（可选）。 -- | p_operating_unit -- 您希望报告的操作单位，所有单位留空。 -- 操作单元(可选) -- p_ledger -- 你想报告的总账，所有的总账留空。 -- 账目（可选） -- -- p_period_name -- -- 要报告的会计期间，必须填写。 -- -- p_min_value_diff -- -- 各组织按时期相加的最小差额。 -- 如果没有输入任何信息，则设置为默认值1。 -- p_category_set1 -- 要报告的第一个项目类别，通常是p_category_set1。 -- 成本或产品系列类别集 -- p_category_set2 -- 要报告的第二个项目类别，通常是p_category_set2。 -- 库存类别集 -- | -- 描述。 -- 报告显示创建的期末快照中的任何差异。 -- 当您关闭库存期时。 这代表了任何差异 -- 累计存货核算分录与库存之间的关系。 -- 子库存和在途库存地点的估值。 -- | -- | ======= =========== ============== ========================================= -- 1.0 2006年4月2日 Douglas Volz初始编码。 -- -- 1.14 2015年11月19日 Douglas Volz 评论了成本组信息。 不一致。 -- 1.15 17 Jul 2018 Douglas Volz Now report G/L short name. -- 1.16 06 Jan 2020 Douglas Volz 增加了组织机构代码和经营单位参数。 -- 1.17 2020年4月30日 Douglas Volz 改为多语言浏览项目。 -- -- 1.18 2020年5月18日 Douglas Volz 为物品状态添加了语言。 -- +=============================================================================+*/ Enginatics R12 only &category_columns &segment_columns &segment_columns2 1=1 :p_min_value_diff 1 -10 &segment_columns select 'gcc.'||lower(fifsv.application_column_name)||' "'||fifsv.form_left_prompt||'",' text from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num LOV GL Chart of Accounts (inv org related) 8E2FF36EDEC879D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num=(select ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) US Chart of Accounts 2 &segment_columns2 select 'gcc.'||lower(fifsv.application_column_name)||',' text from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num US Chart of Accounts 3 10 1=1 oap.period_name = :p_period_name LOV INV Period (closed and summarized) 91E8680353217CCEE053BB6B635868C2 Y select distinct oap.period_name value, max(oap.period_year||'-'||oap.period_num||', '||xxen_util.meaning(nvl2(oap.period_close_date,decode(oap.open_flag,'P',2,'N',decode(oap.summarized_flag,'N',65,66),4),3),'MTL_ACCT_PERIOD_STATUS',700)||' ('||oap.period_start_date||' - '||oap.schedule_close_date||')') over (partition by oap.period_name) description, max(oap.period_start_date) over (partition by oap.period_name) period_start_date, max(oap.effective_period_num) over (partition by oap.period_name) effective_period_num from gl_ledgers gl, org_organization_definitions ood, mtl_parameters mp, (select oap.period_year*10000+oap.period_num effective_period_num, oap.* from org_acct_periods oap) oap where oap.period_close_date is not null and oap.summarized_flag='Y' and oap.period_start_date<=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') and ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and gl.period_set_name=oap.period_set_name and gl.ledger_id=ood.set_of_books_id and ood.organization_id=oap.organization_id order by period_start_date desc, effective_period_num desc, oap.period_name select distinct oap.period_name value from org_acct_periods oap, (select max(oap.schedule_close_date) default_date from org_acct_periods oap, org_organization_definitions ood where ood.organization_id = oap.organization_id and (oap.period_close_date is not null and oap.summarized_flag = 'Y') and nvl(ood.disable_date, sysdate + 1) > sysdate) max where oap.schedule_close_date = max.default_date and rownum = 1 Y US Period Name (Closed) 4 20 :p_min_value_diff Number 1 Y US Minimum Value Difference 5 30 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=11)) US Category Set 1 6 40 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=5)) US Category Set 2 7 50 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 8 60 1=1 msiv.concatenated_segments = :p_item_number LOV INV Item Number (costing enabled only items) EC5CECA520510FC8E0530100007F5EB3 Y Y select distinct msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and (xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) ) and (msiv.costing_enabled_flag='Y' or mp.process_enabled_flag='Y') order by msiv.concatenated_segments US Item Number 9 70 1=1 mp.organization_code = :p_org_code LOV INV Organization Code (excluding master) 91D3167A33531204E053BB6B63585EE3 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 10 80 1=1 haou2.name = :p_operating_unit LOV INV Operating Unit 9B9627743E84607DE053BB6B635805FB Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 US Operating Unit 11 90 1=1 gl.name = :p_ledger LOV GL Ledger (inv org related) 8E2FF36EDF3A79D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name US Ledger :$flex$.chart_of_accounts Chart of Accounts Ledger :$flex$.ledger Ledger Organization Code :$flex$.ledger Ledger Period Name (Closed) :$flex$.operating_unit Operating Unit Organization Code :$flex$.organization_code Organization Code Category Set 1 :$flex$.organization_code Organization Code Category Set 2 :$flex$.organization_code Organization Code Category Set 3 :$flex$.organization_code Organization Code Item Number :$flex$.organization_code Organization Code Period Name (Closed) Pivot by Org Y MFG 23 ACCOUNTED_VALUE 7 Account 17 Class 5 Company 24 DIFFERENCE 6 Department 16 Family 11 ITEM_DESCRIPTION 10 ITEM_NUMBER 13 ITEM_STATUS 12 ITEM_TYPE 18 Inv.Items Description 1 LEDGER 22 ONHAND_VALUE 2 OPERATING_UNIT 3 ORG_CODE 4 PERIOD_NAME 9 Product 14 Product Cat 15 Product Description 21 QUANTITY 19 SUBINVENTORY_OR_INTRANSIT 8 Sub-Account 20 UOM_CODE ACCOUNTED_VALUE VALUE 2 SUM DIFFERENCE VALUE 3 SUM LEDGER ROW 1 ONHAND_VALUE VALUE 1 SUM OPERATING_UNIT ROW 2 ORG_CODE ROW 3 PERIOD_NAME ROW 4 S Site Pivot by Org