ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN D0A52889BF1D2E49E0530100007F74EA CST Report Mode Y select ml.meaning value, ml.lookup_code description from mfg_lookups ml where ml.lookup_type='CST_RPT_DETAIL_OPTION' order by ml.meaning US Report summary or detail. 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 与库存组织有关的会计科目表 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and 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 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, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where 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) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 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 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 所有现行清单组织代码，不包括主组织 2F0F7F246B9F6B92E0630100007F6BEA select ml.meaning Report_Mode, &p_det_col1 -- nvl(gl.short_name, gl.name) Ledger, iso_match.operating_unit Operating_Unit, &p_det_col2 -- iso_match.organization_code Org_Code, iso_match.period_name Period_Name, gcc.concatenated_segments Accounts, &segment_columns iso_match.order_number ISO_Number, iso_match.line_number ISO_Line_Num, &p_det_col3 -- iso_match.transaction_source Transaction_Source, -- iso_match.party_name Customer, -- iso_match.party_number Customer_Number, iso_match.vendor_name Supplier, &p_det_col4 -- trunc(iso_match.transaction_date) Transaction_Date, -- iso_match.transaction_type_code Transaction_Type, msiv.concatenated_segments Item_Number, msiv.description Item_Description, &category_columns &p_det_col5 -- iso_match.inventory_transaction_id Inventory_Transaction_Id, -- iso_match.ap_invoice_num Invoice_Number, -- iso_match.ap_invoice_line AP_Line_Num, sum(nvl(iso_match.receipt_quantity,0)) Receipt_Quantity, sum(nvl(iso_match.invoice_quantity,0)) Invoice_Quantity, sum(nvl(iso_match.receipt_quantity,0)) + sum(nvl(iso_match.invoice_quantity,0)) Net_Quantity, sum(nvl(iso_match.receipt_amount,0)) Receipt_Amount, sum(nvl(iso_match.invoice_amount,0)) Invoice_Amount, sum(nvl(iso_match.receipt_amount,0)) + sum(nvl(iso_match.invoice_amount,0)) Net_Amount from gl_code_combinations_kfv gcc, gl_ledgers gl, mtl_system_items_vl msiv, mfg_lookups ml, -- ============================================== -- 1.0 Select the Inventory Internal Order Activity -- for Logical Intercompany Receipts and Returns -- ============================================== (select to_number(hoi.org_information1) ledger_id, haou2.name operating_unit, mp.organization_code, cmr.operating_unit_id, cmr.inventory_organization_id, xah.period_name, xal.code_combination_id, iso.order_number, iso_line.line_number, 'INV' transaction_source, cmr.transaction_date, mtt.transaction_type_name transaction_type_code, cmr.inventory_item_id, cmr.inventory_transaction_id, null ap_invoice_num, null ap_invoice_line, null party_name, null party_number, pv.vendor_name, cmr.vendor_id, sum(nvl(cmr.quantity,0) * -1) receipt_quantity, sum(0) invoice_quantity, sum(nvl(cmr.quantity,0) * -1) net_quantity, sum(nvl(cmr.amount,0)) receipt_amount, sum(0) invoice_amount, sum(nvl(cmr.amount,0)) net_amount from cst_misc_reconciliation cmr, mtl_material_transactions mmt, mtl_transaction_types mtt, oe_order_headers_all iso, oe_order_lines_all iso_line, po_vendors pv, xla_ae_headers xah, xla_ae_lines xal, mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou, -- inv_organization_id hr_all_organization_units haou2 -- operating unit -- ======================================================== -- Join Misc. Accrual Internal Order entries to Material Txns -- ======================================================== where mmt.transaction_id = cmr.inventory_transaction_id -- Revision for version 1.4, went back to version 1.2 and added a new union all and cmr.transaction_type_code IN ('10','13') -- ======================================================== -- Internal SO joins, headers to lines, to Material Txns -- ======================================================== -- Revision for version 1.8 -- Needed to add iso_line.order_source_id = 6 for Logical -- Intercompany Shipment Receipt transactions and iso_line.order_source_id IN (0,6) -- "this is an Oracle WOW" and iso_line.line_category_code = 'ORDER' and iso.header_id = iso_line.header_id and mmt.trx_source_line_id = iso_line.line_id and mmt.inventory_item_id = iso_line.inventory_item_id -- Revision for version 1.4, went back to version 1.2 and added a new union all -- for Txn Source Type 7 for Int Req Intr Rcpt transactions and mmt.transaction_source_type_id = 13 and mmt.inventory_item_id = cmr.inventory_item_id and mtt.transaction_type_id = mmt.transaction_type_id and mp.organization_id = cmr.inventory_organization_id and cmr.ae_header_id = xah.ae_header_id and xah.ae_header_id = xal.ae_header_id and cmr.ae_line_num = xal.ae_line_num and pv.vendor_id (+) = cmr.vendor_id -- Inventory org and operating units joins 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 cmr.operating_unit_id = haou2.organization_id -- Revision for Operating Unit Security and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou2.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)) and 2=2 -- p_operating_unit, p_trx_date_from, p_trx_date_to, p_transaction_type group by to_number(hoi.org_information1), -- ledger_id haou2.name, mp.organization_code, cmr.operating_unit_id, cmr.inventory_organization_id, xah.period_name, xal.code_combination_id, iso.order_number, iso_line.line_number, 'INV', cmr.transaction_date, mtt.transaction_type_name, cmr.inventory_item_id, cmr.inventory_transaction_id, null, -- ap_invoice_line null, -- ap_invoice_num null, -- party_name, null, -- party_number pv.vendor_name, cmr.vendor_id -- ============================================== -- 2.0 Select the Inventory Internal Order Activity -- for Internal Order Intransit Receipts -- Note: get the SO information from the parent -- material intransit shipment transaction -- ============================================== union all select to_number(hoi.org_information1) ledger_id, haou2.name operating_unit, mp.organization_code, cmr.operating_unit_id, cmr.inventory_organization_id, xah.period_name, xal.code_combination_id, iso.order_number, iso_line.line_number, 'INV' transaction_source, cmr.transaction_date, mtt.transaction_type_name transaction_type_code, cmr.inventory_item_id, cmr.inventory_transaction_id, null ap_invoice_num, null ap_invoice_line, null party_name, null party_number, pv.vendor_name, cmr.vendor_id, sum(nvl(cmr.quantity,0) * -1) receipt_quantity, sum(0) invoice_quantity, sum(nvl(cmr.quantity,0) * -1) net_quantity, sum(nvl(cmr.amount,0)) receipt_amount, sum(0) invoice_amount, sum(nvl(cmr.amount,0)) net_amount from cst_misc_reconciliation cmr, mtl_material_transactions mmt, mtl_transaction_types mtt, mtl_material_transactions mmt2, oe_order_headers_all iso, oe_order_lines_all iso_line, po_vendors pv, xla_ae_headers xah, xla_ae_lines xal, mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou, -- inv_organization_id hr_all_organization_units haou2 -- operating unit -- ======================================================== -- Join Misc. Accrual Internal Order entries to Material Txns -- ======================================================== where mmt.transaction_id = cmr.inventory_transaction_id and cmr.transaction_type_code = '61' and mmt.transaction_source_type_id = 7 -- Int Order Intr Rcpt and mtt.transaction_type_id = mmt.transaction_type_id -- Joins to find the Internal Order Shipment Transaction and mmt.transfer_transaction_id = mmt2.transaction_id and mmt2.transaction_source_type_id = 8 -- Int Order Intr Ship -- ======================================================== -- Internal SO joins, headers to lines, to internal order shipments -- ======================================================== and iso_line.order_source_id = 10 -- for internal orders and iso_line.line_category_code = 'ORDER' and iso.header_id = iso_line.header_id and mmt2.trx_source_line_id = iso_line.LINE_ID and mmt2.inventory_item_id = iso_line.inventory_item_id and mmt.inventory_item_id = cmr.inventory_item_id and mp.organization_id = cmr.inventory_organization_id and cmr.ae_header_id = xah.ae_header_id and xah.ae_header_id = xal.ae_header_id and cmr.ae_line_num = xal.ae_line_num and pv.vendor_id (+) = cmr.vendor_id -- Inventory org and operating units joins 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 cmr.operating_unit_id = haou2.organization_id -- Revision for Operating Unit Security and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou2.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)) and 2=2 -- p_operating_unit, p_trx_date_from, p_trx_date_to, p_transaction_type group by to_number(hoi.org_information1), -- ledger_id haou2.name, mp.organization_code, cmr.operating_unit_id, cmr.inventory_organization_id, xah.period_name, xal.code_combination_id, iso.order_number, iso_line.line_number, 'INV', cmr.transaction_date, mtt.transaction_type_name, cmr.inventory_item_id, cmr.inventory_transaction_id, null, -- ap_invoice_line null, -- ap_invoice_num null, -- party_name, null, -- party_number pv.vendor_name, cmr.vendor_id -- ============================================== -- 3.0 Select the Payables Internal Order Activity -- ============================================== union all select to_number(hoi.org_information1) ledger_id, haou2.name operating_unit, mp.organization_code, cmr.operating_unit_id, rctl.warehouse_id inventory_organization_id, xah.period_name, xal.code_combination_id, to_number(rctl.sales_order) order_number, to_number(rctl.interface_line_attribute2) line_number, 'A/P' transaction_source, cmr.transaction_date, cmr.transaction_type_code, cmr.inventory_item_id, null inventory_transaction_id, ai.invoice_num ap_invoice_num, ail.line_number ap_invoice_line, hp.party_name customer_name, hp.party_number customer_number, pv.vendor_name, cmr.vendor_id, sum(0) receipt_quantity, -- cmr has a null quantity, had to use rctl sum(nvl(rctl.quantity_invoiced,0)) invoice_quantity, sum(nvl(rctl.quantity_invoiced,0)) net_quantity, sum(0) receipt_amount, sum(nvl(cmr.amount,0)) invoice_amount, sum(nvl(cmr.amount,0)) net_amount from cst_misc_reconciliation cmr, ap_invoices_all ai, ap_invoice_lines_all ail, ap_invoice_distributions_all aid, ra_customer_trx_lines_all rctl, ra_customer_trx_all rct, po_vendors pv, hz_cust_accounts hca, hz_parties hp, xla_ae_headers xah, xla_ae_lines xal, mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou, -- inv_organization_id hr_all_organization_units haou2 -- operating unit -- ======================================================== -- Invoice, invoice line, distribution and PO Vendor Joins -- ======================================================== where cmr.transaction_type_code = 'AP NO PO' and cmr.invoice_distribution_id = aid.invoice_distribution_id and ai.invoice_id = aid.invoice_id and ai.invoice_id = ail.invoice_id -- aid has an index on invoice_id, invoice_ line_number and org_id -- ail has an index on invoice_id and line_number and aid.invoice_id = ail.invoice_id and aid.invoice_line_number = ail.line_number and aid.po_distribution_id is null -- AP entries not matched to POs -- ======================================================== -- Only get A/P distributions for Internal Orders -- ======================================================== and aid.reference_1 is not null -- Internal Orders customer_trx_line_id and aid.Reference_2 is not null -- Internal Orders Logical IC Sales Issue -- ======================================================== -- Join Payables to Receivables to get internal order info -- ======================================================== -- Use ail to join to RA tables to avoid to_number qualifiers -- on aid reference columns and ail.source_trx_id = rctl.customer_trx_id and ail.source_line_id = rctl.customer_trx_line_id and rctl.interface_line_context = 'INTERCOMPANY' and rct.customer_trx_id = rctl.customer_trx_id -- ======================================================== -- Joins for Items, Organizations and Customers -- Note: ra_customers does not have organizations as customers -- ======================================================== and cmr.inventory_item_id = rctl.inventory_item_id and cmr.inventory_organization_id = rctl.warehouse_id and mp.organization_id = rctl.warehouse_id and hca.cust_account_id = rct.sold_to_customer_id -- Revision for version 1.6 -- Comment out the customer type, bad client setups -- and hca.customer_type = 'I' -- Inventory and hp.party_id = hca.party_id and hp.party_type = 'ORGANIZATION' and cmr.ae_header_id = xah.ae_header_id and xah.ae_header_id = xal.ae_header_id and cmr.ae_line_num = xal.ae_line_num and pv.vendor_id (+) = cmr.vendor_id -- Inventory org and operating units joins 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 cmr.operating_unit_id = haou2.organization_id -- Revision for Operating Unit Security and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou2.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)) and 2=2 -- p_operating_unit, p_trx_date_from, p_trx_date_to, p_transaction_type group by to_number(hoi.org_information1), -- ledger_id haou2.name, -- operating_unit mp.organization_code, cmr.operating_unit_id, rctl.warehouse_id, xah.period_name, xal.code_combination_id, to_number(rctl.sales_order), to_number(rctl.interface_line_attribute2), 'A/P', cmr.transaction_date, cmr.transaction_type_code, cmr.inventory_item_id, null, -- inventory_transaction_id ai.invoice_num, ail.line_number, hp.party_name, hp.party_number, pv.vendor_name, cmr.vendor_id -- ============================================== -- Revision for version 1.7 -- 4.0 Select the Inventory Internal Order Activity -- for Internal Order Intransit Shipments -- Where the order is booked in one Operating -- Unit but shipped from another Operating Unit -- Note: directly get the SO information from -- the Intransit Shipment Transaction. -- ============================================== union all select to_number(hoi.org_information1) ledger_id, haou2.name operating_unit, mp.organization_code, cmr.operating_unit_id, cmr.inventory_organization_id, xah.period_name, xal.code_combination_id, iso.order_number, iso_line.line_number, 'INV' transaction_source, cmr.transaction_date, mtt.transaction_type_name transaction_type_code, cmr.inventory_item_id, cmr.inventory_transaction_id, null ap_invoice_num, null ap_invoice_line, null party_name, null party_number, pv.vendor_name, cmr.vendor_id, -- Already a negative quantity sum(nvl(cmr.quantity,0)) receipt_quantity, sum(0) invoice_quantity, -- Already a negative quantity sum(nvl(cmr.quantity,0)) net_quantity, sum(nvl(cmr.amount,0)) receipt_amount, sum(0) invoice_amount, sum(nvl(cmr.amount,0)) net_amount FROM cst_misc_reconciliation cmr, mtl_material_transactions mmt, mtl_transaction_types mtt, oe_order_headers_all iso, oe_order_lines_all iso_line, po_vendors pv, xla_ae_headers xah, xla_ae_lines xal, mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou, -- inv_organization_id hr_all_organization_units haou2 -- operating unit -- ======================================================== -- Join Misc. Accrual Internal Order entries to Material Txns -- ======================================================== where mmt.transaction_id = cmr.inventory_transaction_id and mtt.transaction_type_id = mmt.transaction_type_id -- Joins to find the Internal Order Shipment Transaction and cmr.transaction_type_code = '62' and mmt.transaction_source_type_id = 8 -- Int Order Intr Ship -- ======================================================== -- Internal SO joins, headers to lines, to internal SOs and items -- ======================================================== and iso_line.order_source_id = 10 -- for internal orders and iso_line.line_category_code = 'ORDER' and iso.header_id = iso_line.header_id and mmt.trx_source_line_id = iso_line.line_id and mmt.inventory_item_id = iso_line.inventory_item_id -- ======================================================== -- Joins for the item master and inventory organization -- ======================================================== and mmt.inventory_item_id = cmr.inventory_item_id and mp.organization_id = cmr.inventory_organization_id and cmr.ae_header_id = xah.ae_header_id and xah.ae_header_id = xal.ae_header_id and cmr.ae_line_num = xal.ae_line_num and pv.vendor_id (+) = cmr.vendor_id -- Inventory org and operating units joins and hoi.org_information_context = 'Accounting Information' -- Get the organization information from where the goods -- are being shipped to as the FOB Point is FOB Shipment and hoi.organization_id = mmt.transfer_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 cmr.operating_unit_id = haou2.organization_id -- Revision for Operating Unit Security and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou2.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)) and 2=2 -- p_operating_unit, p_trx_date_from, p_trx_date_to, p_transaction_type group by to_number(hoi.org_information1), -- ledger_id haou2.name, mp.organization_code, cmr.operating_unit_id, cmr.inventory_organization_id, xah.period_name, xal.code_combination_id, iso.order_number, iso_line.line_number, 'INV', -- transaction_source cmr.transaction_date, mtt.transaction_type_name, cmr.inventory_item_id, cmr.inventory_transaction_id, null, -- ap_invoice_line null, -- ap_invoice_num null, -- party_name, null, -- party_number pv.vendor_name, cmr.vendor_id -- ============================================== -- 5.0 Select the Payables Activity Not Related -- to intercompany IR/ISO or Logical Transactions -- Revision for version 1.8 -- ============================================== union all select to_number(hoi.org_information1) ledger_id, haou2.name operating_unit, mp.organization_code, cmr.operating_unit_id, mp.organization_id inventory_organization_id, xah.period_name, xal.code_combination_id, null order_number, null line_number, 'A/P' transaction_source, cmr.transaction_date, cmr.transaction_type_code, null inventory_item_id, null inventory_transaction_id, ai.invoice_num ap_invoice_num, ail.line_number ap_invoice_line, null customer_name, null customer_number, pv.vendor_name, cmr.vendor_id, sum(0) receipt_quantity, -- cmr has a null quantity, had to use rctl sum(nvl(cmr.quantity,0)) invoice_quantity, sum(nvl(cmr.quantity,0)) net_quantity, sum(0) receipt_amount, sum(nvl(cmr.amount,0)) invoice_amount, sum(nvl(cmr.amount,0)) net_amount from cst_misc_reconciliation cmr, ap_invoices_all ai, ap_invoice_lines_all ail, ap_invoice_distributions_all aid, po_vendors pv, financials_system_params_all fsp, mtl_parameters mp, xla_ae_headers xah, xla_ae_lines xal, hr_organization_information hoi, hr_all_organization_units haou, -- inv_organization_id hr_all_organization_units haou2 -- operating unit -- ======================================================== -- Invoice, invoice line, distribution and PO Vendor Joins -- ======================================================== where cmr.transaction_type_code = 'AP NO PO' and cmr.invoice_distribution_id = aid.invoice_distribution_id and ai.invoice_id = aid.invoice_id and ai.invoice_id = ail.invoice_id -- aid has an index on invoice_id, invoice_ line_number and org_id -- ail has an index on invoice_id and line_number and aid.invoice_id = ail.invoice_id and aid.invoice_line_number = ail.line_number and aid.po_distribution_id is null -- A/P distributions not matched to POs -- ======================================================== -- Get A/P distributions not related to Internal Orders -- ======================================================== and aid.reference_1 is null -- not related to Internal Orders customer_trx_line_id and aid.reference_2 is null -- not related to Internal Orders Logical IC Sales Issue and cmr.ae_header_id = xah.ae_header_id and xah.ae_header_id = xal.ae_header_id and cmr.ae_line_num = xal.ae_line_num and pv.vendor_id (+) = cmr.vendor_id -- Inventory org and operating units joins and fsp.org_id = cmr.operating_unit_id and mp.organization_id = fsp.inventory_organization_id 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 cmr.operating_unit_id = haou2.organization_id -- Revision for Operating Unit Security and (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou2.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)) and 2=2 -- p_operating_unit, p_trx_date_from, p_trx_date_to, p_transaction_type group by to_number(hoi.org_information1), -- ledger_id haou2.name, -- operating_unit mp.organization_code, cmr.operating_unit_id, mp.organization_id, xah.period_name, xal.code_combination_id, null, -- Sales Order null, -- Line Number 'A/P', cmr.transaction_date, cmr.transaction_type_code, null, -- item number null, -- item description null, -- inventory_item_id, null, -- inventory_transaction_id ai.invoice_num, ail.line_number, null, -- customer name, null, -- customer number pv.vendor_name, cmr.vendor_id ) iso_match where gcc.code_combination_id = iso_match.code_combination_id and gl.ledger_id = iso_match.ledger_id and msiv.inventory_item_id (+) = iso_match.inventory_item_id and msiv.organization_id (+) = iso_match.inventory_organization_id and ml.lookup_type = 'CST_RPT_DETAIL_OPTION' and ml.meaning = :p_report_mode -- Revision for GL Security 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 1=1 -- p_ledger, p_report_type, p_item_number group by ml.meaning, -- Report Mode &p_det_grp1 -- nvl(gl.short_name, gl.name), iso_match.operating_unit, &p_det_grp2 -- iso_match.organization_code, iso_match.period_name, gcc.concatenated_segments, &segment_columns_grp iso_match.order_number, iso_match.line_number, &p_det_grp3 -- iso_match.transaction_source, -- iso_match.party_name, -- iso_match.party_number, iso_match.vendor_name, &p_det_grp4 -- trunc(iso_match.transaction_date), -- iso_match.transaction_type_code, msiv.concatenated_segments, msiv.description, -- Needed for category selects msiv.inventory_item_id, msiv.organization_id &p_det_grp5 -- ,iso_match.inventory_transaction_id, -- iso_match.ap_invoice_num, -- iso_match.ap_invoice_line order by 4,5,6,7,8,9,10,11,12,13,14,15 desc 1.9 26 Feb 2025 Douglas Volz Removed tabs, cleaned up for Blitz Report. Y US CAC AP Accrual IR ISO Match Analysis Use this report to match the A/P Accrual entries for internal order inventory receipts with the internal order payables invoices, by the internal sale order and line number. If run in Detail Mode, shows inventory receipts and payables invoices on separate lines with detailed information, if run in Summary Mode, the sales order line is summarized into one row. Parameters: =========== Report Mode: you can get a summary by sales order and line or a detailed report, enter Detail or Summary (mandatory). Transaction Date from: enter the IR/ISO beginning transaction date you wish to report (optional). Transaction Date to: enter the IR/ISO ending transaction date you wish to report (optional). Transaction Type: enter the transaction type you wish to report (optional). Category Set 1: the first item category set to report, typically the Cost or Product Line Category Set (optional). Category Set 2: the second item category set to report, typically the Inventory Category Set (optional). Category Set 3: the third item category set to report (optional). Item Number: enter the item numbers 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 2016 - 2025 Douglas Volz Consulting, Inc. -- | All rights reserved. -- | Permission to use this code is granted provided the original author is -- | acknowledged.09o warranties, express or otherwise is included in this permission. -- +=============================================================================+ -- | -- | Original Author: Douglas Volz (doug@volzconsulting.com) -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 23 Nov 2016 Douglas Volz Initial Coding -- | 1.1 15 Dec 2016 Douglas Volz Added Customer Name for A/P Invoice -- | 1.2 20 Dec 2016 Douglas Volz Fixed calculation bug for Net Amount -- | 1.3 10 Jan 2017 Douglas Volz Added Transaction Type Code 61 and Transaction -- | Source Type 7 in order to report internal -- | order receipts for txn type Int Req Intr Rcpt -- | and corrected SIGN of net quantity. -- | 1.4 17 Jan 2017 Douglas Volz Added Int Req Intr Rcpt to the Inventory Queries -- | corrected the transaction type code for material -- | transactions, truncated the transaction date -- | and corrected the report sort by order number and -- | transaction type (receipts first). -- | 1.5 18 Jan 2017 Douglas Volz Added Vendor Name and Transaction Source. -- | 1.6 19 Jan 2017 Douglas Volz Commented out the customer type indicator, was -- | preventing A/P invoices from being reported. -- | 1.7 09 Jun 2017 Douglas Volz Added new section to report Intransit Shipments -- | for FOB Shipment with the order booked in one -- | OU but shipped from another OU -- | 1.8 11 Jun 2017 Douglas Volz Added Transaction Date and Operating Unit -- | Parameters. Added new section 5 for Payables -- | invoices which are unmatched to POs or for IR/ISOs. -- | 1.9 26 Feb 2025 Douglas Volz Removed tabs, cleaned up for Blitz Report. -- +=============================================================================+*/ Enginatics &category_columns &p_det_col1 &p_det_col2 &p_det_col3 &p_det_col4 &p_det_col5 &p_det_grp1 &p_det_grp2 &p_det_grp3 &p_det_grp4 &p_det_grp5 &segment_columns &segment_columns_grp 1=1 2=2 :p_report_mode 1 -10 &segment_columns select 'gcc.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) 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_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 1=1 ml.meaning = :p_report_mode LOV CST Report Mode D0A52889BF1D2E49E0530100007F74EA Y select ml.meaning value, ml.lookup_code description from mfg_lookups ml where ml.lookup_type='CST_RPT_DETAIL_OPTION' order by ml.meaning select ml.meaning value, ml.lookup_code description from mfg_lookups ml where ml.lookup_type='CST_RPT_DETAIL_OPTION' and ml.lookup_code = 2 order by ml.lookup_code US Report Mode 4 &p_det_col1 nvl(gl.short_name, gl.name) Ledger, Detail US Report Mode 5 &p_det_col2 iso_match.organization_code Org_Code, Detail US Report Mode 6 &p_det_col3 iso_match.transaction_source Transaction_Source, iso_match.party_name Customer, iso_match.party_number Customer_Number, Detail US Report Mode 7 &p_det_col4 trunc(iso_match.transaction_date) Transaction_Date, iso_match.transaction_type_code Transaction_Type, Detail US Report Mode 8 &p_det_col5 iso_match.inventory_transaction_id Inventory_Transaction_Id, iso_match.ap_invoice_num Invoice_Number, iso_match.ap_invoice_line AP_Line_Num, Detail US Report Mode 9 &p_det_grp1 nvl(gl.short_name, gl.name), Detail US Report Mode 10 &p_det_grp2 iso_match.organization_code, Detail US Report Mode 11 &p_det_grp3 iso_match.transaction_source, iso_match.party_name, iso_match.party_number, Detail US Report Mode 12 &p_det_grp4 trunc(iso_match.transaction_date), iso_match.transaction_type_code, Detail US Report Mode 13 &p_det_grp5 ,iso_match.inventory_transaction_id, iso_match.ap_invoice_num, iso_match.ap_invoice_line Detail US Report Mode 14 20 2=2 cmr.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 US Transaction Date From 15 30 2=2 cmr.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 US Transaction Date To 16 40 2=2 cmr.transaction_type_code = :p_trx_type LOV custom Y select value, null description from (select distinct mtt.transaction_type_name value from mtl_transaction_types mtt where exists (select null from cst_misc_reconciliation cmr where cmr.transaction_type_code = to_char(mtt.transaction_type_id) ) union select crc.displayed_field value from cst_reconciliation_codes crc where crc.lookup_type in ( 'ACCRUAL WRITE-OFF ACTION','ACCRUAL TYPE') and exists (select null from cst_misc_reconciliation cmr where cmr.transaction_type_code = crc.lookup_code ) ) order by value US Transaction Type 17 50 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 18 60 &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 19 70 &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 20 80 &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 21 90 2=2 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 US Organization Code 22 100 2=2 haou2.name = :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where 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) order by hou.name US Operating Unit 23 110 1=1 gl.name = :p_ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and 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 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, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name US Ledger :$flex$.chart_of_accounts Chart of Accounts Ledger :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Organization Code :$flex$.ledger Ledger Transaction Date From :$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 C6739F873B07875872FEFDEBB477EDBE Summary by Operating Unit and Accounts MFG 5 ACCOUNTS 28 AP_LINE_NUM 8 Account 14 CUSTOMER 15 CUSTOMER_NUMBER 24 Class 6 Company 7 Department 23 Family 26 INVENTORY_TRANSACTION_ID 33 INVOICE_AMOUNT 27 INVOICE_NUMBER 30 INVOICE_QUANTITY 12 ISO_LINE_NUM 11 ISO_NUMBER 20 ITEM_DESCRIPTION 19 ITEM_NUMBER 25 Inv.Items Description 1 LEDGER 34 NET_AMOUNT 31 NET_QUANTITY 2 OPERATING_UNIT 3 ORG_CODE 4 PERIOD_NAME 10 Product 21 Product Cat 22 Product Description 32 RECEIPT_AMOUNT 29 RECEIPT_QUANTITY 16 SUPPLIER 9 Sub-Account 17 TRANSACTION_DATE 13 TRANSACTION_SOURCE 18 TRANSACTION_TYPE ACCOUNTS ROW 3 INVOICE_AMOUNT VALUE 5 SUM INVOICE_QUANTITY VALUE 2 SUM LEDGER ROW 1 NET_AMOUNT VALUE 6 SUM NET_QUANTITY VALUE 3 SUM OPERATING_UNIT ROW 2 RECEIPT_AMOUNT VALUE 4 SUM RECEIPT_QUANTITY VALUE 1 SUM S Site C6739F873B07875872FEFDEBB477EDBE