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 与所有现行清单组织有关的所有分类账 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 所有现行清单组织代码，不包括主组织 2E59E39AB5794D13E0630100007FE7D1 with accrual_type as (select 'ACCRUAL TYPE' lookup_type, to_char(mtt.transaction_type_id) lookup_code, mtt.transaction_type_name accrual_match_type from mtl_transaction_types mtt union all select 'ACCRUAL TYPE' lookup_type, flvv.lookup_code, flvv.meaning accrual_match_type from fnd_lookup_values_vl flvv where flvv.lookup_type in ('ACCRUAL TYPE','RCV TRANSACTION TYPE') ) -- accrual_type ------------ SQL query starts here ---------------- -- =========================================================================================== -- This first select finds those entries that join to a PO and PO line for Receiving -- =========================================================================================== select gl.name Ledger, haou.name Operating_Unit, -- Revision for version 1.5 at.accrual_match_type Match_Type, mp.organization_code Org_Code, gcc.concatenated_segments Accrual_Account, -- End revision for version 1.5 &segment_columns gl.currency_code Currency_Code, -- Revision for version 1.1 -- Not all upgraded summary rows have links to the xla tables -- Revision for version 1.4 ... keep this logic sum(decode(ah.je_category_name, 'Receiving', nvl(capr.amount,0), 0)) Receiving_Amount, sum(decode(ah.je_category_name, 'Purchase Invoices', nvl(capr.amount,0), 0)) Payables_Amount, sum(decode(ah.je_category_name, 'INVENTORY', nvl(capr.amount,0), 'Inventory', nvl(capr.amount,0), 'MTL', nvl(capr.amount,0),0)) Inventory_Amount, sum(decode(ah.je_category_name, 'INVENTORY', 0, 'Inventory', 0, 'MTL', 0, 'Receiving', 0, 'Purchase Invoices', 0, nvl(capr.amount,0))) Other_Amount, -- Revision for version 1.4 -- Comment out this upgrade code -- sum(decode(capr.rcv_transaction_id, null, 0, nvl(capr.amount,0))) Receiving_Amount, -- sum(decode(capr.invoice_distribution_id, null, 0, nvl(capr.amount,0))) Payables_Amount, -- Revision for version 1.3 -- sum(decode(capr.inventory_transaction_id, null, 0, nvl(capr.amount,0))) Inventory_Amount, -- sum(0) Inventory_Amount, -- sum(case -- when (capr.rcv_transaction_id is null and -- capr.invoice_distribution_id is null and -- -- capr.inventory_transaction_id is null and -- capr.write_off_id is null -- ) then nvl(capr.amount,0) -- else 0 -- end) Other_Amount, -- sum((nvl(capr.amount,0))) Total_Accounted_Amount, -- End for revision for version 1.4 sum(decode(capr.write_off_id, null, nvl(capr.amount,0), 0)) Total_Accounted_Amount, sum(decode(capr.write_off_id, null, 0, nvl(capr.amount,0))) Write_Offs, sum((nvl(capr.amount,0))) Net_Accounted_Amount -- End revision for version 1.1 from cst_ap_po_reconciliation capr, gl_code_combinations_kfv gcc, hr_organization_information hoi, hr_all_organization_units haou, -- operating unit -- Revision for version 1.1 -- Not all upgraded summary rows have links to the xla tables -- Revision for version 1.4 ... keep this logic xla_ae_headers ah, xla_ae_lines al, -- End revision for version 1.1 gl_ledgers gl, -- Revision for version 1.5 po_distributions_all pod, mtl_parameters mp, accrual_type at -- Revision for version 1.1 -- Not all upgraded summary rows have links to the xla tables -- Revision for version 1.4 ... keep this logic where capr.ae_header_id = ah.ae_header_id (+) and capr.ae_line_num = al.ae_line_num (+) and capr.ae_header_id = al.ae_header_id (+) and al.application_id in (200, 707) -- 200 is Payables, 707 is Cost Management -- End revision for version 1.1 and capr.accrual_account_id = gcc.code_combination_id (+) and al.code_combination_id = gcc.code_combination_id -- Revision for version 1.1 -- Revision for version 1.4 ... keep this logic and ah.ledger_id = gl.ledger_id and gl.ledger_id = to_number(hoi.org_information3) -- this joins OU to GL -- Revision for version 1.1 -- =================================================================== -- using the base tables to avoid the performance issues with the -- views org_organization_definitions and hr_operating_units -- =================================================================== and hoi.org_information_context = 'Operating Unit Information' and hoi.organization_id = haou.organization_id and capr.operating_unit_id = haou.organization_id -- Revision for version 1.5 and pod.po_distribution_id = capr.po_distribution_id and mp.organization_id (+) = pod.destination_organization_id and at.lookup_code (+) = capr.transaction_type_code and 1=1 -- p_operating_unit, p_ledger and 2=2 -- p_trx_from, p_trx_date_to and (nvl(fnd_profile.value('XXEN_REPORT_USE_LEDGER_SECURITY'),'N')='N' or gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)) -- End revision for version 1.5 group by gl.name, haou.name, -- Revision for version 1.5 at.accrual_match_type, -- Match Type mp.organization_code, gcc.concatenated_segments, -- Accrual Account -- End revision for version 1.5 &segment_columns_grp gl.currency_code union all -- =========================================================================================== -- This second select finds those entries that do not join to a PO and PO line (AP NO MATCH) -- =========================================================================================== select gl.name Ledger, haou.name Operating_Unit, -- Revision for version 1.5 at.accrual_match_type Match_Type, mp.organization_code, gcc.concatenated_segments Accrual_Account, -- End revision for version 1.5 &segment_columns gl.currency_code Currency_Code, -- Revision for version 1.1 -- Not all upgraded summary rows have links to the xla tables -- Revision for version 1.4 ... keep this logic sum(decode(ah.je_category_name, 'Receiving', nvl(cmr.amount,0), 0)) Receiving_Amount, sum(decode(ah.je_category_name, 'Purchase Invoices', nvl(cmr.amount,0), 0)) Payables_Amount, sum(decode(ah.je_category_name, 'INVENTORY', nvl(cmr.amount,0), 'Inventory', nvl(cmr.amount,0), 'MTL', nvl(cmr.amount,0),0)) Inventory_Amount, sum(decode(ah.je_category_name, 'INVENTORY', 0, 'Inventory', 0, 'MTL', 0, 'Receiving', 0, 'Purchase Invoices', 0, nvl(cmr.amount,0))) Other_Amount, sum((nvl(cmr.amount,0))) Total_Accounted_Amount, sum(decode(cmr.write_off_select_flag, null, 0, 'N', 0, nvl(cmr.amount,0))) Write_Offs, sum(decode(cmr.write_off_select_flag, null, nvl(cmr.amount,0), 'N', nvl(cmr.amount,0), 0)) Net_Accounted_Amount -- sum(0) "Receiving Amount", -- sum(decode(cmr.invoice_distribution_id, null, 0, nvl(cmr.amount,0))) "Payables Amount", -- sum(decode(cmr.inventory_transaction_id, null, 0, nvl(cmr.amount,0))) "Inventory Amount", -- sum(case -- when ( cmr.invoice_distribution_id is null and -- cmr.inventory_transaction_id is null and -- cmr.write_off_select_flag is null) then nvl(cmr.amount,0) -- else 0 -- end) "Other Amount", -- sum(decode(cmr.write_off_select_flag, null, nvl(cmr.amount,0), 0)) "Total Accounted Amount", -- sum(decode(cmr.write_off_select_flag, null, 0, nvl(cmr.amount,0))) "Write-Offs", -- sum((nvl(cmr.amount,0))) "Net Accounted Amount" -- End revision for version 1.1 from cst_misc_reconciliation cmr, gl_code_combinations_kfv gcc, hr_organization_information hoi, hr_all_organization_units haou, -- operating unit -- Revision for version 1.1 -- Not all upgraded summary rows have links to the xla tables -- Revision for version 1.4 ... keep this logic xla_ae_headers ah, xla_ae_lines al, gl_ledgers gl, -- Revision for version 1.5 mtl_parameters mp, accrual_type at where cmr.ae_header_id = ah.ae_header_id and cmr.ae_line_num = al.ae_line_num and cmr.ae_header_id = al.ae_header_id and al.application_id in (200, 707) -- 200 is Payables, 707 is Cost Management and cmr.accrual_account_id = gcc.code_combination_id (+) and al.code_combination_id = gcc.code_combination_id -- =================================================================== -- using the base tables to avoid the performance issues with the -- views org_organization_definitions and hr_operating_units -- =================================================================== and hoi.org_information_context = 'Operating Unit Information' and hoi.organization_id = haou.organization_id and cmr.operating_unit_id = haou.organization_id -- Revision for version 1.4 ... keep this logic and ah.ledger_id = gl.ledger_id and gl.ledger_id = to_number(hoi.org_information3) -- this joins OU to GL -- Revision for version 1.5 and mp.organization_id (+) = cmr.inventory_organization_id and at.lookup_code (+) = cmr.transaction_type_code and 1=1 -- p_operating_unit, p_ledger and 3=3 -- p_trx_from, p_trx_date_to -- End revision for version 1.5 and (nvl(fnd_profile.value('XXEN_REPORT_USE_LEDGER_SECURITY'),'N')='N' or gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)) group by gl.name, haou.name, -- Revision for version 1.5 at.accrual_match_type, -- Match Type mp.organization_code, gcc.concatenated_segments, -- Accrual Account -- End revision for version 1.5 &segment_columns_grp gl.currency_code -- Order by Ledger, Operating Unit, Match Type, Org Code, Accounts order by 1,2,3,4,5 Replaced tab characters with spaces Y US CAC AP Accrual Reconciliation Summary by Match Type Use this report to summarize the A/P Accrual entries from the Accrual Reconcilation Report tables, by operating unit, accrual match type and inventory organization. Use this report for summary reconciliation purposes, to justify the "at time of receipt" accrual balances for your inventory and expense A/P accrual accounts. Parameters: =========== Transaction Date From: enter the accrual starting transaction date you wish to report. Defaults to the earliest date found (mandatory). Transaction Date To: enter the accrual ending transaction date you wish to report. Defaults to the latest date found (mandatory). Operating Unit: operating unit you wish to report (optional). Ledger: general ledger you wish to report (optional). /* +=============================================================================+ -- | Copyright 2011-2025 Douglas Volz Consulting, Inc. -- | All rights reserved. -- | Permission to use this code is granted provided the original author is -- | acknowledged. -- +=============================================================================+ -- | -- | Original Author: Douglas Volz (doug@volzconsulting.com) -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 11 Nov 2011 Douglas Volz Initial Coding based on xxx_ap_accrual_summary_rept.sql -- | Retrofitted to R12 A/P Accrual tables -- | 1.1 07 May 2019 Douglas Volz Modified for upgrade client -- | 1.2 06 Feb 2020 Douglas Volz Added Ledger parameter. -- | 1.3 09 Apr 2020 Douglas Volz Commented out capr.inventory_transaction_id column -- | Was added by Oracle for consignment transactions in -- | Release 12.1.6. -- | 1.4 15 Apr 2020 Douglas Volz Undid modifications for upgrade client -- | 1.5 17 Feb 2025 Douglas Volz Formatted for Blitz Report. -- +=============================================================================+*/ Enginatics &segment_columns &segment_columns_grp 1=1 2=2 3=3 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')) Y US Chart of Accounts 2 &segment_columns_grp 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 2=2 capr.transaction_date >= :p_trx_date_from Date select min(accrual.min_transaction_date) from (select min(capr.transaction_date) min_transaction_date from cst_ap_po_reconciliation capr, hr_operating_units hou where hou.organization_id = capr.operating_unit_id and sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) union all select min(cmr.transaction_date) min_transaction_date from cst_misc_reconciliation cmr, hr_operating_units hou where hou.organization_id = cmr.operating_unit_id and sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) accrual Y US Transaction Date From 4 3=3 cmr.transaction_date >= :p_trx_date_from US Transaction Date From 5 20 2=2 capr.transaction_date < :p_trx_date_to + 1 Date select max(oap.schedule_close_date) from org_acct_periods oap, mtl_parameters mp where mp.organization_id = oap.organization_id and mp.organization_id <> mp.master_organization_id Y US Transaction Date To 6 3=3 cmr.transaction_date < :p_trx_date_to + 1 US Transaction Date To 7 110 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 8 120 1=1 haou.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 9 130 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 Transaction Date From :$flex$.operating_unit Operating Unit Organization Code Pivot by Operating Unit MFG -9.0018 ACCOUNTING_LINE_TYPE 5 ACCRUAL_ACCOUNT -29.0035 AMOUNT -9.0011 ASSEMBLY_DESCRIPTION -9.001 ASSEMBLY_NUMBER 8 Account -9.0021 CLASS_TYPE 11 CURRENCY_CODE -9.0016 Class 6 Company -9.0024 DESCRIPTION 7 Department -9.0015 Family 14 INVENTORY_AMOUNT -9.0012 ITEM_TYPE -9.0017 Inv.Items Description 1 LEDGER 3 MATCH_TYPE -29.003 MATERIAL_AMOUNT -29.0031 MATERIAL_OVERHEAD_AMOUNT 18 NET_ACCOUNTED_AMOUNT 2 OPERATING_UNIT 4 ORG_CODE 15 OTHER_AMOUNT -29.0033 OUTSIDE_PROCESSING_AMOUNT -29.0034 OVERHEAD_AMOUNT 13 PAYABLES_AMOUNT -3.0004 PERIOD_NAME -9.0028 PRIMARY_QUANTITY 10 Product -9.0013 Product Cat -9.0014 Product Description 12 RECEIVING_AMOUNT -29.0032 RESOURCE_AMOUNT 9 Sub-Account 16 TOTAL_ACCOUNTED_AMOUNT -9.0019 TRANSACTION_TYPE -9.0027 UOM_CODE -9.002 WIP_CLASS -9.0025 WIP_DEPARTMENT -9.0023 WIP_JOB -9.0026 WIP_RESOURCE -9.0022 WIP_TYPE 17 WRITE_OFFS ACCRUAL_ACCOUNT ROW 3 AMOUNT VALUE 7 SUM INVENTORY_AMOUNT VALUE 3 SUM LEDGER ROW 1 MATCH_TYPE ROW 4 MATERIAL_AMOUNT VALUE 2 SUM MATERIAL_OVERHEAD_AMOUNT VALUE 3 SUM NET_ACCOUNTED_AMOUNT VALUE 7 SUM OPERATING_UNIT ROW 2 OTHER_AMOUNT VALUE 4 SUM OUTSIDE_PROCESSING_AMOUNT VALUE 5 SUM OVERHEAD_AMOUNT VALUE 6 SUM PAYABLES_AMOUNT VALUE 2 SUM PRIMARY_QUANTITY VALUE 1 SUM RECEIVING_AMOUNT VALUE 1 SUM RESOURCE_AMOUNT VALUE 4 SUM TOTAL_ACCOUNTED_AMOUNT VALUE 5 SUM WRITE_OFFS VALUE 6 SUM S Site Pivot by Operating Unit and Match Type MFG -9.0018 ACCOUNTING_LINE_TYPE -29.0035 AMOUNT -9.0011 ASSEMBLY_DESCRIPTION -9.001 ASSEMBLY_NUMBER 7 Account -9.0021 CLASS_TYPE 10 CURRENCY_CODE -9.0016 Class 5 Company -9.0024 DESCRIPTION 6 Department -9.0015 Family 13 INVENTORY_AMOUNT -9.0012 ITEM_TYPE -9.0017 Inv.Items Description 1 LEDGER 3 MATCH_TYPE -29.003 MATERIAL_AMOUNT -29.0031 MATERIAL_OVERHEAD_AMOUNT 17 NET_ACCOUNTED_AMOUNT 2 OPERATING_UNIT 4 ORG_CODE 14 OTHER_AMOUNT -29.0033 OUTSIDE_PROCESSING_AMOUNT -29.0034 OVERHEAD_AMOUNT 12 PAYABLES_AMOUNT -3.0004 PERIOD_NAME -9.0028 PRIMARY_QUANTITY 9 Product -9.0013 Product Cat -9.0014 Product Description 11 RECEIVING_AMOUNT -29.0032 RESOURCE_AMOUNT 8 Sub-Account 15 TOTAL_ACCOUNTED_AMOUNT -9.0019 TRANSACTION_TYPE -9.0027 UOM_CODE -9.002 WIP_CLASS -9.0025 WIP_DEPARTMENT -9.0023 WIP_JOB -9.0026 WIP_RESOURCE -9.0022 WIP_TYPE 16 WRITE_OFFS AMOUNT VALUE 7 SUM INVENTORY_AMOUNT VALUE 3 SUM LEDGER ROW 1 MATCH_TYPE ROW 3 MATERIAL_AMOUNT VALUE 2 SUM MATERIAL_OVERHEAD_AMOUNT VALUE 3 SUM NET_ACCOUNTED_AMOUNT VALUE 7 SUM OPERATING_UNIT ROW 2 OTHER_AMOUNT VALUE 4 SUM OUTSIDE_PROCESSING_AMOUNT VALUE 5 SUM OVERHEAD_AMOUNT VALUE 6 SUM PAYABLES_AMOUNT VALUE 2 SUM PRIMARY_QUANTITY VALUE 1 SUM RECEIVING_AMOUNT VALUE 1 SUM RESOURCE_AMOUNT VALUE 4 SUM TOTAL_ACCOUNTED_AMOUNT VALUE 5 SUM WRITE_OFFS VALUE 6 SUM S Site Pivot by Operating Unit