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 91D022B15B12FFB9E053BB6B63587F0B INV Item (master, costing enabled only) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') 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' order by msiv.concatenated_segments US All costing enabled items from item master org 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 所有现行清单组织代码，不包括主组织 A3FC6364E53AE72DE053BB6B6358E0C9 select nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, acct_dist.organization_code Org_Code, oap.period_name Period_Name, &segment_columns msiv.concatenated_segments Assembly_Number, msiv.description Assembly_Description, -- Revision for version 1.13 fcl.meaning item_type, -- Revision for version 1.9 &category_columns -- End revision for version 1.9 ml1.meaning Accounting_Line_Type, ml2.meaning Transaction_Type, wac.class_code WIP_Class, ml3.meaning Class_Type, -- Revision for version 1.13 ml4.meaning WIP_Type, -- Revision for version 1.17 &p_show_project &p_show_wip_job &p_show_wip_osp -- End revision for version 1.17 -- Revision for version 1.11, 1.12 and 1.16 &p_show_wip_job_uom round(sum(decode(acct_dist.transaction_type, 'Cost Update', 0, nvl(acct_dist.primary_quantity,0) ) ) ,3) Primary_Quantity, -- End revision for version 1.11 gl.currency_code Currency_Code, -- Revision for version 1.11 sum(decode(acct_dist.cost_element_id, 1, acct_dist.base_transaction_value, 0)) Material_Amount, sum(decode(acct_dist.cost_element_id, 2, acct_dist.base_transaction_value, 0)) Material_Overhead_Amount, sum(decode(acct_dist.cost_element_id, 3, acct_dist.base_transaction_value, 0)) Resource_Amount, sum(decode(acct_dist.cost_element_id, 4, acct_dist.base_transaction_value, 0)) Outside_Processing_Amount, sum(decode(acct_dist.cost_element_id, 5, acct_dist.base_transaction_value, 0)) Overhead_Amount, -- End revision for version 1.11 sum(acct_dist.base_transaction_value) Amount from wip_entities we, wip_accounting_classes wac, mtl_system_items_vl msiv, -- Revision for version 1.15 bom_departments bd, bom_resources br, org_acct_periods oap, gl_code_combinations gcc, mfg_lookups ml1, mfg_lookups ml2, mfg_lookups ml3, -- Revision for version 1.13 mfg_lookups ml4, -- Revision for version 1.10 fnd_common_lookups fcl, hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl, -- Revision for version 1.18 &project_tables &wip_osp_tables -- Revision for version 1.17 &wip_sla_tables (select mp.organization_code, mp.organization_id, wt.acct_period_id, wta.reference_account, nvl(wdj.primary_item_id, wfs.primary_item_id) primary_item_id, wta.accounting_line_type, wt.transaction_type, -- Revision for version 1.17 wt.transaction_id, wt.rcv_transaction_id, wt.move_transaction_id, wt.completion_transaction_id, wt.transaction_date, wt.creation_date, wt.created_by, -- Release 12.2 wt.reason_code, regexp_replace(wt.reference,'[^[:alnum:]'' '']', null) transaction_reference, -- End revision for version 1.17 nvl(wdj.class_code, wfs.class_code) class_code, nvl(wdj.wip_entity_id, wfs.wip_entity_id) wip_entity_id, wta.resource_id, wt.po_header_id, wt.po_line_id, wt.cost_update_id, -- Revision for version 1.17 -- Release 12.2 wt.resource_instance, -- Revision for version 1.15 wt.department_id, nvl(wdj.project_id, wfs.project_id) project_id, -- Revision for version 1.17 wt.task_id, wt.pm_cost_collected, wt.operation_seq_num, wt.resource_seq_num, wt.autocharge_type, wt.standard_rate_flag, -- Release 12.2 wt.usage_rate_of_amount, wt.actual_resource_rate, wt.standard_resource_rate, wta.rate_or_amount, wta.basis_type, wta.currency_code, wta.currency_conversion_date, wta.currency_conversion_rate, wta.overhead_basis_factor, wta.basis_resource_id, wt.activity_id, -- End revision for version 1.17 wt.transaction_uom, wt.primary_uom, wta.primary_quantity, wta.cost_element_id, wta.base_transaction_value, wta.wip_sub_ledger_id from wip_transaction_accounts wta, wip_transactions wt, wip_discrete_jobs wdj, -- Revision for version 1.18 wip_flow_schedules wfs, mtl_parameters mp -- ======================================================== -- WIP Transaction, org and item joins -- ======================================================== where wt.transaction_id = wta.transaction_id -- Revision for version 1.18 and wdj.wip_entity_id (+) = wta.wip_entity_id and wdj.organization_id (+) = wta.organization_id and wfs.wip_entity_id (+) = wta.wip_entity_id and wfs.organization_id (+) = wta.organization_id -- End revision for version 1.18 and mp.organization_id = wta.organization_id -- Revision for version 1.19 -- Improve logic to screen out zero job close and flow schedule variances -- Revision for version 1.17 -- Do not show zero job and flow schedule close variances -- and (wt.transaction_type <> 6 and wta.base_transaction_value <> 0) and 1 = case when wt.transaction_type = 5 and wta.base_transaction_value = 0 then 2 when wt.transaction_type = 6 and wta.base_transaction_value = 0 then 2 when wt.transaction_type = 7 and wta.base_transaction_value = 0 then 2 else 1 end -- End for revision for version 1.19 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 2=2 -- p_org_code, p_trx_date_from, p_trx_date_to, p_wip_job ) acct_dist -- ======================================================== -- WIP Transaction, org and item joins -- ======================================================== where msiv.organization_id = acct_dist.organization_id and msiv.inventory_item_id = acct_dist.primary_item_id -- Revision for version 1.15 and we.wip_entity_id = acct_dist.wip_entity_id and bd.department_id (+) = acct_dist.department_id and br.resource_id (+) = acct_dist.resource_id -- ======================================================== -- Dynamic SQL joins -- ======================================================== &project_table_joins &osp_wip_table_joins -- ======================================================== and wac.class_code (+) = acct_dist.class_code -- Revision for version 1.2 and wac.organization_id (+) = acct_dist.organization_id and we.wip_entity_id = acct_dist.wip_entity_id -- ======================================================== -- Inventory Org accounting period joins -- ======================================================== and oap.acct_period_id = acct_dist.acct_period_id and oap.organization_id = acct_dist.organization_id -- ======================================================== -- Version 1.3, added lookup values to see more detail -- ======================================================== and ml1.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' and ml1.lookup_code = acct_dist.accounting_line_type and ml2.lookup_type = 'WIP_TRANSACTION_TYPE_SHORT' and ml2.lookup_code = acct_dist.transaction_type and ml3.lookup_type = 'WIP_CLASS_TYPE' and ml3.lookup_code = wac.class_type -- Revision for version 1.13 and ml4.lookup_type = 'WIP_ENTITY' and ml4.lookup_code = we.entity_type -- ======================================================== -- Version 1.10, added Item_Type lookup values -- ======================================================== and fcl.lookup_code (+) = msiv.item_type and fcl.lookup_type (+) = 'ITEM_TYPE' -- End revision for version 1.10 -- ======================================================== -- using the base tables to avoid using -- org_organization_definitions and hr_operating_units -- ======================================================== and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = acct_dist.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 1=1 -- p_assy_number, p_operating_unit, p_ledger -- ======================================================== -- Revision for version 1.17, SLA and Non-SLA joins. -- ======================================================== &wip_sla_table_joins &wip_non_sla_table_joins -- ========================================================== group by nvl(gl.short_name, gl.name), haou2.name, acct_dist.organization_code, oap.period_name, &segment_columns_grp msiv.concatenated_segments, msiv.description, -- Revision for version 1.10 fcl.meaning, -- item_type ml1.meaning, -- Accounting Line Type ml2.meaning, -- WIP Transaction Type wac.class_code, ml3.meaning, -- WIP Class Type -- Revision for version 1.13 ml4.meaning, -- WIP Entity Type &group_by_project &group_by_wip_job &group_by_wip_osp -- Added for inline column selects -- Revision for version 1.12 msiv.organization_id, msiv.inventory_item_id, -- End revision for version 1.8 gl.currency_code order by -- Fix for version 1.10 -- 1,3,4,5,6,7,8,9,10,12,13 nvl(gl.short_name, gl.name), haou2.name, acct_dist.organization_code, oap.period_name, &segment_columns_grp msiv.concatenated_segments, ml1.meaning, -- Accounting_Line_Type ml2.meaning, -- Transaction_Type wac.class_code, -- WIP_Class -- Revision for version 1.13 ml4.meaning -- WIP Entity Type &order_by_project &order_by_wip_job &order_by_wip_osp ,msiv.organization_id -- | 1.20 20 Jun 2024 Douglas Volz Remove tabs, reinstall missing parameters and org access controls. Y AR CAC WIP Account Summary تقرير للحصول على توزيعات محاسبة العمل قيد التقدم ، باختصار ، حسب وظيفة العمل ، والموارد ، والنفقات العامة ، وتحديث تكلفة العمل قيد التقدم. وللمعالجة الخارجية ، بما في ذلك رقم أمر الشراء والسطر ورقم الإصدار. / * + ================================================ =============================== + - | حقوق الطبع والنشر 2009-2020 Douglas Volz Consulting، Inc. | - | كل الحقوق محفوظة. | - | يتم منح الإذن باستخدام هذا الرمز بشرط أن يكون المؤلف الأصلي هو | - | اعترف. لا توجد ضمانات ، صريحة أو غير مضمنة في هذا | - | الإذن. | - + ================================================ =============================== + - | - | المؤلف الأصلي: دوغلاس فولز (doug@volzconsulting.com) - | - | اسم البرنامج: xxx_wip_dist_xla_sum_rept.sql - | - | العوامل: - | p_trx_date_from - تاريخ بدء المعاملة لمعاملات محاسبة العمل تحت التنفيذ ، - | إلزامي. - | p_trx_date_to - تاريخ إنهاء المعاملة لمعاملات محاسبة العمل تحت التنفيذ ، - | إلزامي. - | p_item_number - أدخل رقم العنصر المحدد الذي ترغب في الإبلاغ عنه (اختياري) - | p_org_code - مؤسسة مخزون معينة ترغب في الإبلاغ عنها (اختياري) - | p_operating_unit - وحدة التشغيل التي ترغب في الإبلاغ عنها ، اتركها فارغة للجميع - | وحدات التشغيل (اختياري) - | p_ledger - دفتر الأستاذ العام الذي ترغب في الإبلاغ عنه ، اتركه فارغًا للجميع - | دفاتر الأستاذ (اختياري) - | p_category_set1 - فئة العنصر الأولى التي تم تعيينها للإبلاغ ، وعادةً ما يكون ملف - | التكلفة أو مجموعة فئة خط المنتج - | p_category_set2 - فئة العنصر الثانية التي تم تعيينها للإبلاغ ، وعادةً ما يكون ملف - | مجموعة فئة الجرد - | - | وصف: - | تقرير للحصول على توزيعات محاسبة الأعمال قيد التقدم ، باختصار ، حسب وظيفة العمل قيد التقدم ، - | الموارد والنفقات العامة وتحديث تكلفة العمل قيد التقدم. وللمعالجة الخارجية ، - | بما في ذلك رقم أمر الشراء والسطر ورقم الإصدار. - | - | تم تعديل الإصدار حسب الوصف - | ======= =========== =============== ================== ======================== - | 1.0 06 نوفمبر 2009 الترميز المبدئي لدوجلاس فولز - | 1.11 05 يوليو 2019 دوجلاس فولز تمت الإضافة: - | أ) تمت إضافة اندلاع تصاعد المعاملات حسب التكلفة - | جزء. - | ب) تمت إضافة مجموع ساعات الموارد / النفقات العامة أو - | يصل إلى عمود الكمية الأساسية ، بالإضافة إلى - | أضاف حقل الكمية UOM. - | 1.12 23 أبريل 2020 تم تغيير Douglas Volz إلى عروض متعددة اللغات للعنصر - | الرئيسية وفئات العناصر ووحدات التشغيل. - | تمت إضافة رقم المشروع. - + ================================================ =============================== + * / D CAC WIP Account Summary Bericht, um die WIP-Verteilung in der Buchhaltung zusammenfassend nach WIP-Job, Ressource, Gemeinkosten und WIP-Kostenfortschreibung zu erhalten. Und für die Fremdbearbeitung, einschließlich der Bestellnummer, Zeile und Freigabenummer. /* +=============================================================================+ -- | Copyright 2009- 2020 Douglas Volz Consulting, Inc. | -- | Alle Rechte vorbehalten. | -- | | Die Erlaubnis zur Verwendung dieses Codes wird erteilt, sofern der ursprüngliche Autor | -- | | anerkannt wird. Diese | -- | Erlaubnis beinhaltet keine ausdrücklichen oder sonstigen Garantien. | | | Erlaubnis. | -- +=============================================================================+ -- | -- | Originalautor: Douglas Volz (doug@volzconsulting.com) -- | -- | | Programmname: xxx_wip_dist_xla_sum_rept.sql -- | -- | Parameter: -- | p_trx_date_from -- Start-Transaktionsdatum für WIP-Buchhaltungstransaktionen, -- | obligatorisch. -- | p_trx_date_to -- End-Transaktionsdatum für WIP-Buchhaltungstransaktionen, -- | obligatorisch. -- | p_item_number -- Geben Sie die spezifische Positionsnummer ein, die Sie melden möchten (optional) -- | p_org_code -- Spezifische Bestandsorganisation, über die Sie berichten möchten (optional) -- | p_operating_unit -- Betriebseinheit, die Sie melden möchten, leer lassen für alle -- | operating units (optional) -- | p_ledger -- Hauptbuch, über das Sie berichten möchten, für alle leer lassen -- | ledger (optional) -- | p_category_set1 -- Der erste zu berichtende Positionstypen-Satz, typischerweise der -- | Kosten- oder Produktlinien-Kategoriesatz -- | p_category_set2 -- Die zweite zu meldende Artikelkategorie, typischerweise die -- | Bestandskategoriesatz -- | -- | Beschreibung: -- | Bericht, um die WIP-Abrechnungsverteilungen in einer Zusammenfassung nach WIP-Job zu erhalten, -- | Ressource, Gemeinkosten und WIP-Kostenfortschreibung. Und für die externe Verarbeitung, -- | einschließlich der Bestellnummer, Zeile und Freigabenummer. -- | -- | Version Geändert am Geändert von Beschreibung -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Erstcodierung -- | 1.11 05 Jul 2019 Douglas Volz Hinzugefügt: -- | | a) Die Aufschlüsselung der Transaktionsmounts nach Kosten wurde hinzugefügt. -- | Element. -- | b) Die Summe der Ressourcen-/Gemeinkostenstunden oder -- | Beträge zu einer primären Mengenspalte hinzugefügt, plus, -- | das Mengen-UOM-Feld hinzugefügt. -- | 1.12 23 Apr 2020 Douglas Volz Umstellung auf mehrsprachige Ansichten für den Artikel -- | Stamm, Positionstypen und Betriebseinheiten. -- | Projektnummer hinzugefügt. -- +=============================================================================+*/ E CAC WIP Account Summary Informe para obtener las distribuciones contables del WIP, en resumen, por trabajo WIP, recurso, gastos generales y actualización de costes WIP. Y para el procesamiento externo, incluyendo el número de orden de compra, la línea y el número de liberación. /* +=============================================================================+ | Copyright 2009- 2020 Douglas Volz Consulting, Inc. | | Todos los derechos reservados. | -- Se autoriza el uso de este código siempre que se reconozca al autor original. -- | reconocido. Este permiso no incluye ninguna garantía, expresa o de otro tipo. -- -- Permiso de uso de este código. | -- +=============================================================================+ -- | -- | Autor original: Douglas Volz (doug@volzconsulting.com) -- | -- -- Nombre del programa: xxx_wip_dist_xla_sum_rept.sql -- | -- -- Parámetros: -- | p_trx_date_from -- fecha de inicio de la transacción para las transacciones contables WIP, -- | obligatorio. -- | p_trx_date_to -- fecha de finalización de la transacción para las transacciones contables WIP, -- | obligatorio. -- | p_item_number -- Introduzca el número de artículo específico que desea informar (opcional). -- | p_org_code -- Organización de inventario específica sobre la que desea informar (opcional) -- | p_operating_unit -- Unidad operativa de la que desea informar, 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_category_set1 -- El primer conjunto de categorías de artículos sobre el que se va a informar, normalmente el -- | Conjunto de categorías de costes o líneas de productos -- | p_category_set2 -- El segundo conjunto de categorías de artículos a reportar, típicamente el -- | Conjunto de categorías de inventario -- | -- | Descripción: -- | Informe para obtener las distribuciones contables del WIP, en resumen, por trabajo WIP, -- | actualización de recursos, gastos generales y costes WIP. Y para el procesamiento externo, -- | incluyendo el número de orden de compra, línea y número de liberación. -- | -- | Versión modificada en Modificado por Descripción -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Codificación inicial -- | 1.11 05 jul 2019 Douglas Volz Añadido: -- | a) Se ha añadido el desglose de los montajes de las transacciones por coste -- | elemento. -- | b) Añadida la suma de horas de recursos / gastos generales o -- | cantidades a una columna de cantidad primaria, además, -- | añadido el campo de cantidad UOM. -- | 1.12 23 Abr 2020 Douglas Volz Cambiado a vistas multi-idioma para el artículo -- | maestro, categorías de artículos y unidades operativas. -- | Añadido el número de proyecto. -- +=============================================================================+*/ F CAC WIP Account Summary Rapport permettant d'obtenir la répartition comptable des TEC, en résumé, par emploi TEC, ressource, frais généraux et mise à jour des coûts TEC. Et pour le traitement externe, y compris le numéro de commande, la ligne et le numéro de lancement. /* +=============================================================================+ | Copyright 2009- 2020 Douglas Volz Consulting, Inc. | | Tous droits réservés. | -- | 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_wip_dist_xla_sum_rept.sql -- | -- | Paramètres : -- | p_trx_date_from -- date de début des transactions de la comptabilité des encours, -- | obligatoire. -- | p_trx_date_to -- date de fin de transaction pour les transactions de comptabilité WIP, -- | obligatoire. -- | p_item_number -- Saisissez le numéro d'article spécifique que vous souhaitez signaler (facultatif) | 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_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 permettant d'obtenir les répartitions comptables des TEC, en résumé, par poste de TEC, -- | mise à jour des ressources, des frais généraux et des coûts de l'IPF. Et pour le traitement externe, -- | y compris le numéro de commande, la ligne et le numéro de sortie. -- | -- | Version modifiée le Modifié par la description -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Codage initial de Douglas Volz -- | 1.11 05 Jul 2019 Douglas Volz Ajouté : -- | a) Ajout de la ventilation des montants des transactions par coût -- | élément. -- | b) Ajout de la somme des heures de ressources / frais généraux ou -- | correspond à une colonne de quantité primaire, plus, -- | a ajouté le champ de la quantité UOM. -- | 1.12 23 avr 2020 Douglas Volz passe en mode multi-langues pour l'article -- | maître, catégories d'articles et unités d'exploitation. -- | Numéro de projet ajouté. -- +=============================================================================+*/ I CAC WIP Account Summary Rapporto per ottenere le distribuzioni contabili WIP, in sintesi, per lavoro WIP, risorsa, spese generali e aggiornamento dei costi WIP. E per l'elaborazione esterna, incluso il numero dell'ordine di acquisto, la linea e il numero di rilascio. /* +=============================================================================+ -- | Copyright 2009- 2020 Douglas Volz Consulting, Inc. | -- | Tutti i diritti riservati. | -- | Il permesso di usare questo codice è concesso a condizione che l'autore originale sia | -- | | riconosciuto. Nessuna garanzia, espressa o di altro tipo, è inclusa in questa | -- -- | permesso. | -- +=============================================================================+ -- | -- | Autore originale: Douglas Volz (doug@volzconsulting.com) -- | -- | Nome del programma: xxx_wip_dist_xla_sum_rept.sql -- | -- | Parametri: -- | p_trx_date_from -- data iniziale della transazione per le transazioni contabili WIP, -- | obbligatorio. -- | p_trx_date_to -- data finale della transazione per le transazioni contabili WIP, -- | obbligatorio. -- | p_item_number -- Inserisci il numero di articolo specifico che vuoi segnalare (opzionale) -- | p_org_code -- Organizzazione specifica dell'inventario che vuoi riportare (opzionale) -- | p_operating_unit -- Unità operativa che volete segnalare, lasciate vuoto per tutte -- | unità operative (opzionale) -- p_ledger -- Contabilità generale che vuoi segnalare, lascia in bianco per tutti -- | ledger (opzionale) -- | p_category_set1 -- La prima categoria di voci da riportare, tipicamente la -- | categoria di costo o di linea di prodotto -- | p_category_set2 -- La seconda categoria di articoli da riportare, tipicamente la -- | Set di categorie di inventario -- | -- | Descrizione: -- | Report per ottenere le distribuzioni contabili WIP, in sintesi, per lavoro WIP, -- | risorse, spese generali e aggiornamento dei costi WIP. E per l'elaborazione esterna, -- | incluso il numero dell'ordine di acquisto, la linea e il numero di rilascio. -- | -- | Versione Modificata il Modificato da Descrizione -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Codifica iniziale -- | 1.11 05 Jul 2019 Douglas Volz Aggiunto: -- | a) Aggiunto il breakout dei supporti di transazione per costo -- | elemento. -- | b) Aggiunta la somma delle ore di risorse / spese generali o -- | importi a una colonna di quantità primaria, più, -- | aggiunto il campo quantità UOM. -- | 1.12 23 Apr 2020 Douglas Volz Modificate le viste multilingue per l'elemento -- | master, categorie di articoli e unità operative. -- | Aggiunto il numero di progetto. -- +=============================================================================+*/ JA CAC WIP Account Summary WIP会計の分配金を、WIPジョブ別、リソース別、オーバーヘッド別、WIPコスト更新別にまとめて取得するレポート。 また、外部処理については、発注番号、ライン、リリース番号を含む。 /* +=============================================================================+ --｜著作権 2009-2020 Douglas Volz Consulting, Inc. | | --｜このコードの使用を許可するには、原著作者が｜原著作者であることが条件となります。 -- : - - 認められています。 本製品には、明示的であるか否かにかかわらず、いかなる保証も含まれていません。 -- --｜permission. | -- +=============================================================================+ -- | -- --｜原著者。ダグラス・ヴォルツ (doug@volzconsulting.com) -- | --｜プログラム名: xxx_wip_dist_xla_sum_rept.sql -- | -- | パラメータ。 -- | p_trx_date_from -- WIP会計トランザクションのトランザクション開始日。 --｜必須。 -- | p_trx_date_to -- WIP会計トランザクションのトランザクション終了日。 --｜必須。 -- | p_item_number -- 報告したい特定の項目番号を入力してください(オプション) -- | p_org_code -- 報告したい特定のインベントリ組織 (オプション) -- | p_operating_unit -- 報告したい操作ユニット、すべて空白のままにしておく。 -- 操作ユニット(オプション) -- | p_ledger -- 報告したい総勘定元帳、すべて空白のままにしておきます。 --｜元帳（オプション | p_category_set1 -- レポートする最初の項目カテゴリセット、通常は -- コストまたは製品ラインのカテゴリーセット | p_category_set2 -- 報告するために設定された2番目の項目カテゴリ、典型的には -- 在庫区分セット -- | --｜説明。 --｜WIPジョブ別にWIP会計分布をまとめて取得するレポートです。 -- リソース、オーバーヘッド、WIPコストの更新。 また、外部処理のため。 --｜注文書番号、ライン番号、リリース番号を含む。 -- | -- 説明文で変更されています。 -- | ======= =========== ============== ========================================= --｜1.0 2009年11月06日 ダグラス・ボルツ初期コーディング --｜1.11 05 Jul 2019 Douglas Volz 追加しました。 -- | a) コスト別のトランザクションマウントのブレイクアウトを追加しました。 --｜要素を追加しました。 -- b) リソース/オーバーヘッド時間の総和を加算したもの、または --｜一次量列の量をプラスしています。 --｜数量UOMフィールドを追加した。 -- | 1.12 23 Apr 2020 Douglas Volz アイテムの多言語表示に変更した。 --｜マスター、アイテムカテゴリ、運営単位を追加しました。 --｜プロジェクト番号を追加しました。 -- +=============================================================================+*/ KO CAC WIP Account Summary 요약하여 WIP 작업, 자원, 간접비 및 WIP 비용 갱신별로 WIP 회계 분배를 가져 오려면보고하십시오. 그리고 구매 오더 번호, 라인 및 릴리스 번호를 포함한 외주 가공용. / * + ============================================= ============================= + -| 저작권 2009-2020 Douglas Volz Consulting, Inc. | -| 판권 소유. | -| 이 코드를 사용할 수있는 권한은 원래 작성자가 | -| 인정. 여기에는 명시 적 또는 기타 어떠한 보증도 포함되지 않습니다. -| 허가. | -+ ============================================= ============================= + -| -| 원저자 : Douglas Volz (doug@volzconsulting.com) -| -| 프로그램 이름 : xxx_wip_dist_xla_sum_rept.sql -| -| 매개 변수 : -| p_trx_date_from-WIP 회계 거래의 시작 거래 일자, -| 필수. -| p_trx_date_to-WIP 회계 거래에 대한 거래 종료일, -| 필수. -| p_item_number-보고 할 특정 품목 번호를 입력합니다 (선택 사항). -| p_org_code-보고 할 특정 재고 조직 (선택 사항) -| p_operating_unit-보고 할 운영 단위, 모두 비워 둡니다. -| 운영 단위 (선택 사항) -| p_ledger-보고하려는 총계정 원장, 모두 비워 둡니다. -| 원장 (선택 사항) -| p_category_set1-보고 할 첫 번째 항목 범주 세트, 일반적으로 -| 비용 또는 제품 라인 범주 세트 -| p_category_set2-보고 할 두 번째 항목 범주로, 일반적으로 -| 재고 범주 세트 -| -| 기술: -| 요약하면 WIP 작업별로 WIP 계정 분배를 가져 오는 보고서, -| 자원, 간접비 및 WIP 비용 갱신. 그리고 외주 가공의 경우 -| 구매 오더 번호, 라인 및 릴리스 번호를 포함합니다. -| -| 수정 된 버전 설명에 의해 수정 됨 -| ======= =========== =============================== ======================= -| 1.0 2009 년 11 월 6 일 Douglas Volz 초기 코딩 -| 1.11 2019 년 7 월 5 일 Douglas Volz 추가 : -| a) 비용에 따른 트랜잭션 마운트의 브레이크 아웃 추가 -| 요소. -| b) 자원 / 간접 시간의 합계를 추가하거나 -| 기본 수량 열에 금액을 추가하고 -| 수량 UOM 필드를 추가했습니다. -| 1.12 2020 년 4 월 23 일 Douglas Volz 항목에 대한 다국어보기로 변경됨 -| 마스터, 품목 범주 및 운영 단위. -| 프로젝트 번호가 추가되었습니다. -+ ============================================== ============================= + * / PTB CAC WIP Account Summary Relatório para obter as distribuições da contabilidade WIP, em resumo, por trabalho WIP, recursos, despesas gerais e atualização de custos WIP. E para processamento externo, incluindo o número do pedido de compra, linha e número de liberação. /* +=============================================================================+ | Copyright 2009- 2020 Douglas Volz Consulting, Inc. | | Todos os direitos reservados. | | 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_wip_dist_xla_sum_rept.sql | Parâmetros: | p_trx_date_from -- data de início da transação para as transações contábeis WIP, | obrigatório. | p_trx_date_to -- data final de transação para transações contábeis WIP, | obrigatório. | p_item_number -- Insira o número do item específico que você deseja relatar (opcional) | 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_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 obter as distribuições da contabilidade WIP, em resumo, por trabalho WIP, | atualização de recursos, despesas gerais e custos WIP. E para processamento externo, | incluindo o número do pedido de compra, linha e número de liberação. | Versão Modificada em Modificada por Descrição -- | ======= =========== ============== ========================================= | 1.0 06 Nov 2009 Douglas Volz Codificação Inicial | 1.11 05 Jul 2019 Douglas Volz Adicionado: | | a) Adicionada a quebra de montagens de transação por custo | elemento. -- | b) Acrescentou a soma dos recursos / horas gerais ou | corresponde a uma coluna de quantidade primária, mais, | acrescentou o campo UOM de quantidade. | 1.12 23 Abr 2020 Douglas Volz Mudou para visualizações em vários idiomas para o item | categorias principais, itens e unidades operacionais. -- | Adicionado número do projeto. -- +=============================================================================+*/ S CAC WIP Account Summary Rapportera för att få WIP-redovisningen fördelat, i sammandrag, efter WIP-jobb, resurs, overhead och WIP-kostnadsuppdatering. Och för extern behandling, inklusive inköpsordernummer, rad och släppnummer. / * + ================================================== ================================ + - | Upphovsrätt 2009-2020 Douglas Volz Consulting, Inc. | - | Alla rättigheter förbehållna. | - | 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_wip_dist_xla_sum_rept.sql - | - | Parametrar: - | p_trx_date_from - startdatum för WIP-redovisningstransaktioner, - | obligatorisk. - | p_trx_date_to - avslutande transaktionsdatum för WIP-redovisningstransaktioner, - | obligatorisk. - | p_item_number - Ange det specifika artikelnummer du vill rapportera (valfritt) - | 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_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 få WIP-redovisningen fördelat, i sammandrag, efter WIP-jobb, - | resurs-, overhead- och WIP-kostnadsuppdatering. Och för extern bearbetning, - | inklusive inköpsordernummer, rad och släppnummer. - | - | Version modifierad på modifierad av beskrivning - | ===================================================== ========================= - | 1.0 06 nov 2009 Douglas Volz inledande kodning - | 1.11 05 jul 2019 Douglas Volz Tillagt: - | a) Lade till fördelningen av transaktionsbelopp per kostnad - | element. - | b) Lade till summan av resurs / allmänna timmar eller - | uppgår till en primär kvantitetskolumn, plus - | lagt till antal UOM-antal. - | 1.12 23 apr 2020 Douglas Volz Ändrad till flerspråkiga vyer för artikeln - | master, artikelkategorier och driftenheter. - | Lagt till projektnummer. - + ================================================== ================================ + * / TR CAC WIP Account Summary Devam Eden Çalışma muhasebesi dağıtımlarını özet olarak, Devam Eden Çalışma işi, kaynak, genel gider ve Devam Eden Çalışma maliyet güncellemesine göre rapor edin. Ve satın alma siparişi numarası, satır ve sürüm numarası dahil olmak üzere harici işlemler için. / * + ============================================= ============================ + - | Telif Hakkı 2009-2020 Douglas Volz Consulting, Inc. | - | Her hakkı saklıdır. | - | 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_wip_dist_xla_sum_rept.sql - | - | Parametreler: - | p_trx_date_from - Devam Eden Çalışma muhasebe işlemleri için işlem başlangıç tarihi, - | zorunlu. - | p_trx_date_to - Yarı mamul muhasebe işlemleri için işlem tarihinin sona erdirilmesi, - | zorunlu. - | p_item_number - Bildirmek istediğiniz belirli öğe numarasını girin (isteğe bağlı) - | 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_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: - | Devam Eden Çalışma muhasebesi dağıtımlarının özet olarak WIP işi ile alınabilmesi için rapor, - | kaynak, genel gider ve Devam Eden Çalışma maliyet güncellemesi. Ve dış işleme için, - | satın alma siparişi numarası, satırı ve sürüm numarası dahil. - | - | Açıklamaya Göre Değiştirildiğinde Değiştirilen Sürüm - | ======= =========== ============== ================== ======================= - | 1.0 06 Kas 2009 Douglas Volz İlk Kodlama - | 1.11 05 Tem 2019 Douglas Volz Eklendi: - | a) Maliyete göre işlem bağlantılarının kırılması eklendi - | öğesi. - | b) Kaynak / genel gider saatlerinin toplamı eklendi veya - | tutarları birincil miktar sütunu artı, - | miktar UOM alanını ekledi. - | 1.12 23 Nis 2020 Douglas Volz Öğenin çoklu dil görünümlerine değiştirildi - | ana, ürün kategorileri ve işletim birimleri. - | Proje Numarası eklendi. - + =============================================== ============================ + * / US CAC WIP Account Summary Report to get the WIP accounting distributions, in summary, by WIP job, resource, overhead and WIP cost update. With the Show SLA Accounting parameter you can choose to use the Release 12 Subledger Accounting (Create Accounting) account setups by selecting Yes. And if you have not modified your SLA accounting rules, select No to allow this report to run a bit faster. With parameters to limit the report size, Show Project to display or not display the project number and name, Show WIP Job to display or not display the WIP job (WIP job, description and resource codes) and Show WIP Outside Processing to display or not display the outside processing information (WIP OSP item number, supplier, purchase order, purchase order line and release). For Discrete, Flow and Workorderless WIP (but not Repetitive Schedules). Note that both Flow and Workorderless show up as the WIP Type "Flow schedule". Parameters: =========== Transaction Date From: enter the starting transaction date (mandatory). Transaction Date To: enter the ending transaction date (mandatory). Show SLA Accounting: enter Yes to use the Subledger Accounting rules for your accounting information (mandatory). If you choose No the report uses the pre-Create Accounting entries. Show Projects: display the project number and name. Enter Yes or No, use to limit the report size. (mandatory). Show WIP Jobs: display the WIP job, description, department and resource. Enter Yes or No, use to limit the report size (mandatory). Show WIP Outside Processing: display the WIP OSP item number, supplier, purchase order, purchase order line and release. Enter Yes or No, use to limit the report size (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). Assembly Number: enter the specific assembly 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 2009- 2024 Douglas Volz Consulting, Inc. -- | All rights reserved. -- | Permission to use this code is granted provided the original author is -- | acknowledged. No warranties, express or otherwise is included in this permission. -- +=============================================================================+ -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Initial Coding -- | 1.13 11 Mar 2021 Douglas Volz Added Flow Schedules and Workorderless WIP -- | and removed redundant joins and tables to -- | improve performance. -- | 1.14 22 Mar 2021 Douglas Volz Add WIP Job parameter. -- | 1.15 20 Dec 2021 Douglas Volz Add WIP Department. -- | 1.16 12 Aug 2022 Douglas Volz Combine with WIP Account Summary No SLA report -- | and add Show WIP Job and Show WIP OSP parameters. -- | 1.17 14 Aug 2022 Douglas Volz Screen out zero job close variances for Flow Schedules. -- | 1.18 22 Aug 2022 Douglas Volz Improve performance with outer joins and streamline dynamic SQL. -- | 1.19 26 Feb 2023 Douglas Volz Fix to show job close variances. -- | 1.20 20 Jun 2024 Douglas Volz Remove tabs, reinstall missing parameters and org access controls. -- +=============================================================================+*/ ZHS CAC WIP Account Summary 报表获取WIP核算分配，按WIP作业、资源、管理费和WIP成本更新汇总。 而对于外部加工，包括采购单号、行号和放行号。 /* +=============================================================================+ -- 版权所有 2009-2020 道格拉斯-沃尔兹咨询公司。 | -- 保留所有权利。 | -- 允许使用该代码，但前提是原作者必须是｜。 -- 认可。 不包含任何明示或暗示的保证。 -- 允许。 | -- +=============================================================================+ -- | -- 原作者：Douglas Volz ()Douglas Volz (doug@volzconsulting.com) -- | -- 程序名称：xxx_wip_dist_xla_sum_rept.sql。 -- | -- 参数。 -- p_trx_date_from -- WIP核算交易的起始交易日期。 |--强制性的。 -- p_trx_date_to -- WIP会计交易的结束交易日期。 -- 必须填写。 -- p_item_number -- 输入您想报告的具体项目编号（可选）。 -- -- p_org_code -- -- 您希望报告的具体清单组织（可选）。 -- | p_operating_unit -- 您希望报告的操作单位，所有单位留空。 -- 操作单元(可选) -- p_ledger -- 你想报告的总账，所有的总账留空。 -- 账目（可选） -- p_category_set1 -- 要报告的第一个项目类别，通常是p_category_set1。 -- 成本或产品系列类别集 -- p_category_set2 -- 要报告的第二个项目类别，通常是p_category_set2。 -- 库存类别集 -- | -- 描述。 -- 按WIP作业获取WIP核算分布情况的报告。 -- 资源、间接费用和在制品成本更新。 并用于外部加工。 -- 包括订单号、行号和放行号。 -- | -- | ======= =========== ============== ========================================= | 1.0 2009年11月6日 道格拉斯-沃尔兹初始编码。 -- | 1.11 05 Jul 2019 Douglas Volz 新增。 -- | a) 添加了按成本划分的交易挂载的分类。 -- b) 增加了资源/间接费用小时数的总和，或增加了资源/间接费用小时数的总和。 -- b) 增加了资源/间接费用小时数的总和或 |相当于一个主要数量列，加上。 -- 增加了数量UOM字段。 -- 1.12 2020年4月23日 Douglas Volz 改为多语言浏览项目。 -- 增加了项目编号。 -- -- 增加了项目编号。 -- +=============================================================================+*/ Enginatics R12 only &category_columns &group_by_project &group_by_wip_job &group_by_wip_osp &order_by_project &order_by_wip_job &order_by_wip_osp &osp_wip_table_joins &p_show_project &p_show_wip_job &p_show_wip_job_uom &p_show_wip_osp &project_table_joins &project_tables &segment_columns &segment_columns_grp &wip_non_sla_table_joins &wip_osp_tables &wip_sla_table_joins &wip_sla_tables 1=1 2=2 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 wta.transaction_date >= :p_trx_date_from and wt.transaction_date >= :p_trx_date_from Date select max(oap.period_start_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 From 4 20 2=2 wta.transaction_date < :p_trx_date_to + 1 and wt.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 5 30 &wip_sla_tables xla_distribution_links xdl, xla_ae_headers ah, xla_ae_lines al, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y Y US Show SLA Accounting 6 &wip_non_sla_table_joins and gcc.code_combination_id (+) = acct_dist.reference_account N US Show SLA Accounting 7 &wip_sla_table_joins and ah.ledger_id = gl.ledger_id and ah.application_id = al.application_id and ah.application_id = 707 and ah.ae_header_id = al.ae_header_id and al.ledger_id = ah.ledger_id and al.ae_header_id = xdl.ae_header_id and al.ae_line_num = xdl.ae_line_num and xdl.application_id = 707 and xdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS' and xdl.source_distribution_id_num_1 = acct_dist.wip_sub_ledger_id and gcc.code_combination_id (+) = al.code_combination_id Y US Show SLA Accounting 8 40 &p_show_project pp.segment1 Project_Number, pp.name Project_Name, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y US Show Projects 9 &group_by_project pp.segment1, pp.name, Y US Show Projects 10 &order_by_project ,pp.segment1 ,pp.name Y US Show Projects 11 &project_table_joins and pp.project_id (+) = acct_dist.project_id Y US Show Projects 12 &project_tables pa_projects_all pp, Y US Show Projects 13 50 &p_show_wip_job we.wip_entity_name WIP_Job, we.description Description, bd.department_code WIP_Department, br.resource_code WIP_Resource, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y Y US Show WIP Job 14 &group_by_wip_job we.wip_entity_name, we.description, bd.department_code, br.resource_code, acct_dist.resource_id, Y US Show WIP Job 15 &order_by_wip_job ,we.wip_entity_name ,br.resource_code Y US Show WIP Job 16 &p_show_wip_job_uom (select max(nvl(muomv.uom_code, br.unit_of_measure)) from bom_resources br, mtl_units_of_measure_vl muomv where acct_dist.resource_id = br.resource_id and muomv.uom_code (+) = br.unit_of_measure group by br.resource_id ) UOM_Code, Y US Show WIP Job 17 60 &p_show_wip_osp (select msiv.concatenated_segments from mtl_system_items_vl msiv where pol.item_id = msiv.inventory_item_id and msiv.organization_id = acct_dist.organization_id) Outside_Processing_Item, (select pv.vendor_name from po_vendors pv where poh.vendor_id = pv.vendor_id) Supplier_Name, poh.segment1 PO_Number, pol.line_num PO_Line, (select pr.release_num from po_releases_all pr, rcv_transactions rt where rt.transaction_id = acct_dist.rcv_transaction_id and rt.po_release_id = pr.po_release_id) PO_Release, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y US Show WIP Outside Processing 18 &group_by_wip_osp acct_dist.organization_id, poh.vendor_id, poh.segment1, pol.line_num, pol.item_id, acct_dist.resource_id, acct_dist.rcv_transaction_id, Y US Show WIP Outside Processing 19 &order_by_wip_osp ,poh.segment1 ,pol.line_num ,(select pr.release_num from po_releases_all pr, rcv_transactions rt where rt.transaction_id = acct_dist.rcv_transaction_id and rt.po_release_id = pr.po_release_id (+)) Y US Show WIP Outside Processing 20 &osp_wip_table_joins and poh.po_header_id (+) = acct_dist.po_header_id and pol.po_line_id (+) = acct_dist.po_line_id Y US Show WIP Outside Processing 21 &wip_osp_tables po_headers_all poh, po_lines_all pol, Y US Show WIP Outside Processing 22 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=11)) US Category Set 1 23 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 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 24 90 &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 25 100 1=1 msiv.concatenated_segments = :p_item_number LOV INV Item (master, costing enabled only) 91D022B15B12FFB9E053BB6B63587F0B Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') 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' order by msiv.concatenated_segments US Assembly Number 26 110 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 select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 27 120 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 28 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$.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 8A08AF79AF43D003788A66AA9E24CD9C Pivot by Org Y MFG 18 ACCOUNTING_LINE_TYPE 35 AMOUNT 11 ASSEMBLY_DESCRIPTION 10 ASSEMBLY_NUMBER 7 Account 21 CLASS_TYPE 29 CURRENCY_CODE 16 Class 5 Company 24 DESCRIPTION 6 Department 15 Family 12 ITEM_TYPE 17 Inv.Items Description 1 LEDGER 30 MATERIAL_AMOUNT 31 MATERIAL_OVERHEAD_AMOUNT 2 OPERATING_UNIT 3 ORG_CODE 33 OUTSIDE_PROCESSING_AMOUNT 34 OVERHEAD_AMOUNT 4 PERIOD_NAME 28 PRIMARY_QUANTITY 9 Product 13 Product Cat 14 Product Description 32 RESOURCE_AMOUNT 8 Sub-Account 19 TRANSACTION_TYPE 27 UOM_CODE 20 WIP_CLASS 25 WIP_DEPARTMENT 23 WIP_JOB 26 WIP_RESOURCE 22 WIP_TYPE AMOUNT VALUE 7 SUM LEDGER ROW 1 MATERIAL_AMOUNT VALUE 2 SUM MATERIAL_OVERHEAD_AMOUNT VALUE 3 SUM OPERATING_UNIT ROW 2 ORG_CODE ROW 3 OUTSIDE_PROCESSING_AMOUNT VALUE 5 SUM OVERHEAD_AMOUNT VALUE 6 SUM PRIMARY_QUANTITY VALUE 1 SUM RESOURCE_AMOUNT VALUE 4 SUM S Site 8A08AF79AF43D003788A66AA9E24CD9C