ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 92C63F4C20A21E85E053BB6B63585CC8 CST Cost Type Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.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) ) order by cct.cost_type US 8E2FF36EDEC579D2E0530100007F1FF2 GL Chart of Accounts (inv org restricted) 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)>=sysdate) and fifsv.id_flex_num in (select oav.chart_of_accounts_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) order by fifsv.id_flex_structure_name AR مخطط الحسابات المتعلق بمؤسسات المخزون المعينة لمسؤولية تسجيل الدخول الحالية D Kontenplan für Inventarorganisationen, die der aktuellen Anmeldeverantwortung zugeordnet sind E Plan de cuentas relacionado con las organizaciones de inventario asignadas a la responsabilidad de inicio de sesión actual F Plan comptable relatif aux organismes d'inventaire affectés à la responsabilité de la connexion actuelle I Piano dei conti relativo alle organizzazioni di inventario assegnate alla responsabilità di login corrente JA 現在のログイン責任者に割り当てられた在庫組織に関連する勘定科目一覧表 KO 현재 로그인 권한에 지정된 재고 조직과 관련된 계정과 목표 PTB Plano de contas relacionado às organizações de inventário atribuídas à responsabilidade de login atual RU План счетов, относящихся к инвентаризационным организациям, на которые возложена ответственность за текущий вход в систему S Kontokarta relaterade till lagerorganisationer som tilldelats det nuvarande inloggningsansvaret TR Mevcut oturum açma sorumluluğuna atanan envanter organizasyonlarıyla ilgili hesap planı US Chart of accounts related to inventory organizations assigned to the current login responsibility 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 8E2FF36EDEF379D2E0530100007F1FF2 INV Item (master) 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) ) order by msiv.concatenated_segments US Any item from item master org, including non costing enabled 8E2FF36EDE9C79D2E0530100007F1FF2 INV Item Status Y select misv.inventory_item_status_code_tl value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code_tl 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 所有现行清单组织代码，不包括主组织 92C63F4C209B1E85E053BB6B63585CC8 select nvl(gl.short_name, gl.name) Ledger, -- =================================================================== -- First get the items which are costing enabled -- =================================================================== haou2.name Operating_Unit, mp.organization_code Org_Code, cct.cost_type Cost_Type, msiv.concatenated_segments Item_Number, msiv.description Item_Description, -- Revision for version 1.7 muomv.uom_code UOM_Code, fcl.meaning Item_Type, misv.inventory_item_status_code Item_Status, -- End revision for version 1.7 ml1.meaning Make_Buy_Code, -- Revision for version 1.10 msiv.std_lot_size Std_Lot_Size, -- Revision for version 1.4 &category_columns fl1.meaning Allow_Costs, ml2.meaning Inventory_Asset, -- Revision for version 1.10 ml4.meaning Use_Default_Controls, ml3.meaning Based_on_Rollup, -- Revision for version 1.10 cic.lot_size Costing_Lot_Size, cic.shrinkage_rate Shrinkage_Rate, gl.currency_code Currency_Code, -- Revision for version 1.8 msiv.market_price Market_Price, msiv.list_price_per_unit Target_or_PO_List_Price, -- End revision for version 1.8 nvl(cic.material_cost,0) Material_Cost, nvl(cic.material_overhead_cost,0) Material_Overhead_Cost, nvl(cic.resource_cost,0) Resource_Cost, nvl(cic.outside_processing_cost,0) Outside_Processing_Cost, nvl(cic.overhead_cost,0) Overhead_Cost, nvl(cic.item_cost,0) Item_Cost, -- Fix for version 1.3 &segment_columns -- End fix for version 1.3 cic.creation_date Cost_Creation_Date, cic.last_update_date Last_Cost_Update_Date, -- Revision for version 1.9 msiv.creation_date Item_Creation_Date, msiv.last_update_date Item_Last_Update_Date from cst_item_costs cic, cst_cost_types cct, mtl_system_items_vl msiv, -- Revision for version 1.7 mtl_item_status_vl misv, mtl_units_of_measure_vl muomv, -- End revision for version 1.7 mtl_parameters mp, mfg_lookups ml1, -- planning make/buy code, MTL_PLANNING_MAKE_BUY mfg_lookups ml2, -- inventory_asset_flag, SYS_YES_NO mfg_lookups ml3, -- based on rollup, CST_BONROLLUP_VAL -- Revision for version 1.10 mfg_lookups ml4, -- defaulted_flag, SYS_YES_NO fnd_lookups fl1, -- allow costs, YES_NO fnd_common_lookups fcl, -- Item Type hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl, -- Fix for version 1.3 gl_code_combinations gcc1, gl_code_combinations gcc2 -- End fix for version 1.3 -- =================================================================== -- Item master, organization and item master to cost joins -- =================================================================== where mp.organization_id = msiv.organization_id and msiv.inventory_item_id = cic.inventory_item_id and msiv.organization_id = cic.organization_id -- Revision for version 1.7 and msiv.primary_uom_code = muomv.uom_code and msiv.inventory_item_status_code = misv.inventory_item_status_code -- End revision for version 1.7 and cic.cost_type_id = cct.cost_type_id -- Revision for version 1.10 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) -- Revision for version 1.11 and 1.12 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 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 1=1 -- p_item_status_to_exclude, p_item_number, p_org_code, p_operating_unit, p_ledger and 2=2 -- p_cost_type -- =================================================================== -- Don't report the unused inventory organizations -- =================================================================== and mp.organization_id <> mp.master_organization_id -- remove the global master org -- =================================================================== -- Lookup codes -- =================================================================== and ml1.lookup_type = 'MTL_PLANNING_MAKE_BUY' and ml1.lookup_code = msiv.planning_make_buy_code and ml2.lookup_type = 'SYS_YES_NO' and ml2.lookup_code = to_char(cic.inventory_asset_flag) and ml3.lookup_type = 'CST_BONROLLUP_VAL' and ml3.lookup_code = cic.based_on_rollup_flag -- Revision for version 1.10 and ml4.lookup_type = 'SYS_YES_NO' and ml4.lookup_code = cic.defaulted_flag -- End revision for version 1.10 and fl1.lookup_type = 'YES_NO' and fl1.lookup_code = msiv.costing_enabled_flag and fcl.lookup_type (+) = 'ITEM_TYPE' and fcl.lookup_code (+) = msiv.item_type -- =================================================================== -- 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 = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- get the ledger_id -- avoid selecting disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate + 1) -- =================================================================== -- Fix for version 1.3 -- joins to get the COGS and revenue accounts -- =================================================================== and gcc1.code_combination_id (+) = msiv.cost_of_sales_account and gcc2.code_combination_id (+) = msiv.sales_account -- End fix for version 1.3 union all -- =================================================================== -- Now get the items which are not costing enabled -- =================================================================== select nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, mp.organization_code Org_Code, null Cost_Type, msiv.concatenated_segments Item_Number, msiv.description Item_Description, -- Revision for version 1.7 muomv.uom_code UOM_Code, fcl.meaning Item_Type, -- Revision for version 1.7 misv.inventory_item_status_code Item_Status, ml1.meaning Make_Buy_Code, -- Revision for version 1.10 msiv.std_lot_size Std_Lot_Size, -- Revision for version 1.4 &category_columns fl1.meaning Allow_Costs, fl2.meaning Inventory_Asset, -- Revision for version 1.10 null Use_Default_Controls, null Based_on_Rollup, -- Revision for version 1.10 null Costing_Lot_Size, null Shrinkage_Rate, gl.currency_code Currency_Code, -- Revision for version 1.8 msiv.market_price Market_Price, msiv.list_price_per_unit Target_or_PO_List_Price, -- End revision for version 1.8 null Material_Cost, null Material_Overhead_Cost, null Resource_Cost, null Outside_Processing_Cost, null Overhead_Cost, null Item_Cost, -- Fix for version 1.3 &segment_columns null Cost_Creation_Date, null Last_Cost_Update_Date, -- Revision for version 1.9 msiv.creation_date Item_Creation_Date, msiv.last_update_date Item_Last_Update_Date from mtl_system_items_vl msiv, -- Revision for version 1.7 mtl_item_status_vl misv, mtl_units_of_measure_vl muomv, -- End revision for version 1.7 mtl_parameters mp, mfg_lookups ml1, -- planning make/buy code, MTL_PLANNING_MAKE_BUY fnd_lookups fl1, -- allow costs, YES_NO fnd_lookups fl2, -- inventory_asset_flag, YES_NO fnd_common_lookups fcl, -- Item Type hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl, -- Fix for version 1.3 gl_code_combinations gcc1, gl_code_combinations gcc2 -- End fix for version 1.3 -- =================================================================== -- Item master, organization and item master to cost joins -- =================================================================== where mp.organization_id = msiv.organization_id -- Revision for version 1.7 and msiv.primary_uom_code = muomv.uom_code and msiv.inventory_item_status_code = misv.inventory_item_status_code -- End revision for version 1.7 -- Revision for version 1.10 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) -- Revision for version 1.11 and 1.12 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 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 1=1 -- p_item_status_to_exclude, p_item_number, p_org_code, p_operating_unit, p_ledger -- Include or exclude uncosted items and 3=3 -- p_include_uncosted_items -- =================================================================== -- Find items where the item has no cost information -- =================================================================== and msiv.costing_enabled_flag = 'N' -- =================================================================== -- Don't report the unused inventory organizations -- =================================================================== and mp.organization_id <> mp.master_organization_id -- remove the global master org -- =================================================================== -- Lookup codes -- =================================================================== and ml1.lookup_type = 'MTL_PLANNING_MAKE_BUY' and ml1.lookup_code = msiv.planning_make_buy_code and fl1.lookup_type = 'YES_NO' and fl1.lookup_code = msiv.costing_enabled_flag and fl2.lookup_type = 'YES_NO' and fl2.lookup_code = msiv.inventory_asset_flag and fcl.lookup_type (+) = 'ITEM_TYPE' and fcl.lookup_code (+) = msiv.item_type -- =================================================================== -- 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 = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- get the ledger_id -- avoid selecting disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate + 1) -- =================================================================== -- Fix for version 1.3 -- joins to get the COGS and revenue accounts -- =================================================================== and gcc1.code_combination_id (+) = msiv.cost_of_sales_account and gcc2.code_combination_id (+) = msiv.sales_account -- End fix for version 1.3 -- order by Ledger, Operating Unit, Org Code, Item and Cost Type order by 1,2,3,4,5 1.12 19 Jun 2025 Douglas Volz Fixed Item Number LOV and reinstalled missing parameter for Include Uncosted Items, and commented out G/L and Operating Unit security restrictions. Y #,##0.00000;[Red](#,##0.00000) AR CAC Item Cost Summary تقرير لإظهار تكاليف العناصر في أي نوع تكلفة. لواحدة أو أكثر من منظمات المخزون. / * + ================================================ =============================== + - | حقوق النشر 2009-2020 Douglas Volz Consulting، Inc. | - | كل الحقوق محفوظة. | - | يتم منح الإذن باستخدام هذا الرمز بشرط أن يكون المؤلف الأصلي هو | - | اعترف. لا توجد ضمانات ، صريحة أو غير مضمنة في هذا | - | الإذن. | - + ================================================ =============================== + - | - | المؤلف الأصلي: دوغلاس فولز (doug@volzconsulting.com) - | - | اسم البرنامج: xxx_item_cost_rept.sql - | - | العوامل: - | p_cost_type - نوع التكلفة الذي تريد الإبلاغ عنه - | p_ledger - دفتر الأستاذ العام الذي ترغب في الإبلاغ عنه ، ويعمل معه - | أسماء دفتر الأستاذ فارغة أو صالحة - | p_item_number - أدخل رقم العنصر المحدد الذي ترغب في الإبلاغ عنه - | p_org_code - رمز منظمة محدد ، يعمل مع - | رموز منظمة فارغة أو صالحة - | p_include_uncosted_items - علامة نعم / لا لتضمين أو عدم تضمين الموارد غير المحسوبة - | - | وصف: - | تقرير لإظهار تكاليف العناصر في أي نوع تكلفة - | - | تم تعديل الإصدار حسب الوصف - | ======= =========== =============== ================== ======================== - | 1.0 06 أكتوبر 2009 الترميز المبدئي لدوجلاس فولز - | 1.1 16 آذار (مارس) 2010 تحديث دوغلاس فولز بأعلام صنع / شراء - | 1.2 08 نوفمبر 2010 تم تحديث Douglas Volz بأعمدة ومعلمات إضافية - | 1.3 07 فبراير 2011 أضاف دوجلاس فولز تكلفة السلع المُباعة وحسابات الإيرادات الافتراضية - | 1.4 15 نوفمبر 2016 Douglas Volz تمت إضافة معلومات الفئة - | 1.5 27 يناير 2020 أضاف دوجلاس فولز كود المؤسسة ومعلمات وحدة التشغيل - | 1.6 27 أبريل 2020 تم تغيير Douglas Volz إلى طرق عرض متعددة اللغات للعنصر - | الرئيسية ، منظمات المخزون ووحدات التشغيل. - | 1.7 21 حزيران (يونيو) 2020 تم تغيير Douglas Volz إلى عروض متعددة اللغات للعنصر - | المركز و UOM. - | 1.8 24 سبتمبر 2020 Douglas Volz المضافة في قائمة الأسعار للتقرير - | 1.9 29 يناير 2021 تمت إضافة التواريخ الرئيسية للعناصر ومعلمة العناصر غير النشطة لدوغلاس فولز + ================================================== ============================= + * / D CAC Item Cost Summary Bericht zur Anzeige von Artikelkosten in einem beliebigen Kostentyp. Für eine oder mehrere Bestandsorganisationen. /* +=============================================================================+ -- | 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_item_cost_rept.sql -- | -- | Parameter: -- | p_cost_type -- Die Kostenart, die Sie berichten möchten -- | p_ledger -- Das Hauptbuch, über das Sie berichten möchten, arbeitet mit -- | null oder gültigen Ledgernamen -- | p_item_number -- Geben Sie die spezifische Positionsnummer ein, die Sie berichten möchten -- | p_org_code -- spezifischer Organisationscode, funktioniert mit -- | null oder gültigen Organisationscodes -- | p_include_uncosted_items -- Ja/Nein-Flag zum Einschließen oder Nicht-Einschließen von nicht gebuchten Ressourcen -- | -- | Beschreibung: -- | Bericht zur Anzeige von Artikelkosten in jedem Kostentyp -- | -- | | Version Geändert am Geändert von Beschreibung -- | ======= =========== ============== ========================================= -- | 1.0 06. Oktober 2009 Douglas Volz Erstkodierung -- | 1.1 16 Mar 2010 Douglas Volz Aktualisiert mit Make/Buy-Flags -- | 1.2 08 Nov 2010 Douglas Volz Aktualisiert mit zusätzlichen Spalten und Parametern -- | 1.3 07 Feb 2011 Douglas Volz Standardkonten für COGS und Revenue hinzugefügt -- | 1.4 15 Nov 2016 Douglas Volz Kategorie-Informationen hinzugefügt -- | 1.5 27 Jan 2020 Douglas Volz Parameter Org Code und Operating Unit hinzugefügt -- | 1.6 27 Apr 2020 Douglas Volz Umstellung auf mehrsprachige Ansichten für den Artikel -- | Master, Inventar-Orgs und Operating Units. -- | 1.7 21 Jun 2020 Douglas Volz Geändert zu mehrsprachigen Ansichten für Artikel -- | Status und UOM. -- | 1.8 24 Sep 2020 Douglas Volz Listenpreis zum Bericht hinzugefügt -- | 1.9 29 Jan 2021 Douglas Volz Artikelstammdaten und Parameter für inaktive Artikel hinzugefügt +=============================================================================+*/ E CAC Item Cost Summary Informe para mostrar los costes de los artículos en cualquier tipo de coste. Para una o más organizaciones de inventario. /* +=============================================================================+ | 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_item_cost_rept.sql -- | -- -- Parámetros: -- | p_cost_type -- El tipo de coste que desea informar -- | p_ledger -- El libro mayor que desea reportar, trabaja con -- | null o nombres de libros mayores válidos -- | p_item_number -- Introduzca el número de artículo específico que desea reportar -- | p_org_code -- código de organización específico, funciona con -- | códigos de organización nulos o válidos -- | p_include_uncosted_items -- Bandera sí/no para incluir o no los recursos no contabilizados -- | -- | Descripción: -- | Informe para mostrar los costes de los artículos en cualquier tipo de coste -- | -- | Versión Modificada en Modificada por Descripción -- | ======= =========== ============== ========================================= -- | 1.0 06 oct 2009 Douglas Volz Codificación inicial -- | 1.1 16 mar 2010 Douglas Volz Actualizado con banderas de Hacer/Comprar -- | 1.2 08 Nov 2010 Douglas Volz Actualizado con columnas y parámetros adicionales -- | 1.3 07 Feb 2011 Douglas Volz Añadido cuentas por defecto de COGS y Revenue -- | 1.4 15 Nov 2016 Douglas Volz Añadida la información de la categoría -- | 1.5 27 Ene 2020 Douglas Volz Añadido parámetros de Código Org y Unidad Operativa -- | 1.6 27 Abr 2020 Douglas Volz Cambió a vistas multi-idioma para el artículo -- | maestro, orgs de inventario y unidades operativas. -- | 1.7 21 Jun 2020 Douglas Volz Cambió a vistas multi-idioma para el ítem -- | estado y UOM. -- | 1.8 24 Sep 2020 Douglas Volz Añadido el precio de lista al informe -- | 1.9 29 Ene 2021 Douglas Volz Añadidas las fechas maestras de los artículos y el parámetro de Artículos Inactivos +=============================================================================+*/ F CAC Item Cost Summary Rapport pour indiquer les coûts des articles dans n'importe quel type de coût. Pour un ou plusieurs organismes d'inventaire. /* +=============================================================================+ | 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_item_cost_rept.sql -- | -- | Paramètres : -- | p_cost_type -- Le type de coût que vous souhaitez déclarer | p_ledger -- grand livre général que vous souhaitez déclarer, travaille avec -- | noms nuls ou valides du grand livre | p_item_number -- Entrez le numéro de l'article que vous souhaitez signaler | p_org_code -- code d'organisation spécifique, fonctionne avec -- | codes d'organisation nuls ou valides -- | p_include_uncosted_items -- Oui/Non flag pour inclure ou non les ressources non chiffrées -- | -- | Description : -- | Rapport indiquant les coûts des articles dans tout type de coût -- | -- | Version modifiée le Modifié par la description -- | ======= =========== ============== ========================================= -- | 1.0 06 Oct 2009 Codage initial de Douglas Volz -- | 1.1 16 Mar 2010 Douglas Volz mis à jour avec les drapeaux "Make/Buy | 1.2 08 Nov 2010 Douglas Volz Mise à jour avec des colonnes et des paramètres supplémentaires | 1.3 07 Feb 2011 Douglas Volz a ajouté le COGS et les comptes par défaut des recettes | 1.4 15 nov 2016 Douglas Volz Informations sur les catégories ajoutées | 1.5 27 Jan 2020 Douglas Volz a ajouté le code Org et les paramètres de l'unité opérationnelle | 1.6 27 avr 2020 Douglas Volz passe au plurilinguisme pour le sujet -- | maître, orgs d'inventaire et unités opérationnelles. | 1.7 21 juin 2020 Douglas Volz Passage aux vues multilingues pour l'article -- | statut et UOM. | 1,8 24 sept. 2020 Douglas Volz a ajouté le prix de liste au rapport | 1.9 29 jan 2021 Douglas Volz Ajout des dates de référence des articles et du paramètre "Articles inactifs +=============================================================================+*/ I CAC Item Cost Summary Rapporto per mostrare i costi degli articoli in qualsiasi tipo di costo. Per una o più organizzazioni di inventario. /* +=============================================================================+ -- | 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_item_cost_rept.sql -- | -- | Parametri: -- | p_cost_type -- Il tipo di costo che vuoi riportare -- | p_ledger -- il libro mastro generale che vuoi riportare, funziona con -- | null o nomi di libro mastro validi -- | p_item_number -- Inserisci il numero di articolo specifico che vuoi riportare -- | p_org_code -- codice dell'organizzazione specifica, funziona con -- | null o codici di organizzazione validi -- | p_include_uncosted_items -- Sì/No flag per includere o non includere le risorse non-costituite -- | -- | Descrizione: -- | Report per mostrare i costi delle voci in qualsiasi tipo di costo -- | -- | | Versione Modificata il Modificato da Descrizione -- | ======= =========== ============== ========================================= -- | 1.0 06 Oct 2009 Douglas Volz Codifica iniziale -- | 1.1 16 Mar 2010 Douglas Volz Aggiornato con i flag di Make/Buy -- | 1.2 08 Nov 2010 Douglas Volz Aggiornato con colonne e parametri aggiuntivi -- 1.3 07 Feb 2011 Douglas Volz Aggiunto conti predefiniti COGS e Revenue -- | 1.4 15 Nov 2016 Douglas Volz Aggiunte informazioni sulle categorie -- | 1.5 27 Jan 2020 Douglas Volz Aggiunti i parametri Org Code e Operating Unit -- | 1.6 27 Apr 2020 Douglas Volz Modificate le viste multilingue per l'articolo -- | master, org di inventario e unità operative. -- | 1.7 21 giu 2020 Douglas Volz Cambiate le viste multilingue per l'articolo -- | stato e UOM. -- | 1.8 24 set 2020 Douglas Volz Aggiunto List Price al report -- | 1.9 29 Jan 2021 Douglas Volz Aggiunte date anagrafiche articoli e parametro Articoli inattivi +=============================================================================+*/ JA CAC Item Cost Summary 任意のコストタイプの項目コストを表示するためのレポート。 1つ以上のインベントリ組織の場合 /* +=============================================================================+ --｜著作権 2009-2020 Douglas Volz Consulting, Inc. | | --｜このコードの使用を許可するには、原著作者が｜原著作者であることが条件となります。 -- : - - 認められています。本製品には、明示的であるか否かにかかわらず、いかなる保証も含まれていません。 -- --｜permission. | -- +=============================================================================+ -- | -- --｜原著者。ダグラス・ヴォルツ (doug@volzconsulting.com) -- | --｜プログラム名: xxx_item_cost_rept.sql -- | -- | パラメータ。 -- | p_cost_type -- レポートしたいコストタイプ -- | p_ledger -- 報告したい総勘定元帳。 --｜ヌルまたは有効な元帳名 -- | p_item_number -- 報告したい特定の項目番号を入力します。 -- | p_org_code -- 特定の組織コード、との連携 --｜ヌルまたは有効な組織コード -- | p_include_uncosted_items -- 非コステッドリソースを含めるかどうかのフラグを指定します。 -- | -- -- | 説明. -- | 任意のコストタイプの項目コストを表示するレポート -- | -- 説明文で変更されています。 -- | ======= =========== ============== ========================================= -- 1.0 2009年10月06日 ダグラス・ボルツ初期コーディング -- | 1.1 2010年3月16日 Douglas Volz Make/Buyフラグを使って更新しました。 -- 1.2 2010年11月08日 Douglas Volz カラムとパラメータを追加して更新しました。 -- 1.3 2011年2月07日 Douglas Volz COGSと収益のデフォルトアカウントを追加しました。 --｜1.4 2016年11月15日 ダグラス・ヴォルツ カテゴリー情報を追加しました。 -- 1.5 2020年1月27日 Douglas Volz Org CodeとOperating Unitのパラメータを追加しました。 -- 1.6 1.6 27 Apr 2020 Douglas Volz アイテムの多言語表示に変更しました。 --｜マスター、インベントリ、オペレーションユニット。 --｜1.7 21 Jun 2020 Douglas Volz 項目の多言語表示に変更。 --｜ステータスとUOM。 --｜1.8 2020年9月24日 Douglas Volz レポートにリストプライスを追加しました。 -- 1.9 2021年1月29日 Douglas Volz アイテムマスターの日付と非アクティブアイテムのパラメータを追加した。 +=============================================================================+*/ KO CAC Item Cost Summary 모든 비용 유형의 품목 비용을 표시하는 보고서. 하나 이상의 재고 조직 용. / * + ============================================= ============================= + -| 저작권 2009-2020 Douglas Volz Consulting, Inc. | -| 판권 소유. | -| 이 코드를 사용할 수있는 권한은 원래 작성자가 | -| 인정. 여기에는 명시 적 또는 기타 어떠한 보증도 포함되지 않습니다. -| 허가. | -+ ============================================= ============================= + -| -| 원저자 : Douglas Volz (doug@volzconsulting.com) -| -| 프로그램 이름 : xxx_item_cost_rept.sql -| -| 매개 변수 : -| p_cost_type-보고 할 비용 유형 -| p_ledger-보고하려는 총계정 원장, 함께 작동 -| 널 또는 유효한 원장 이름 -| p_item_number-보고 할 특정 품목 번호를 입력합니다. -| p_org_code-특정 조직 코드, 작업 -| null 또는 유효한 조직 코드 -| p_include_uncosted_items-비용이 부과되지 않는 리소스를 포함하거나 포함하지 않는 Yes / No 플래그 -| -| 기술: -| 모든 비용 유형의 품목 비용을 표시하는 보고서 -| -| 수정 한 날짜 설명에 의해 수정 된 버전 -| ======= =========== =============================== ======================= -| 1.0 2009 년 10 월 6 일 Douglas Volz 초기 코딩 -| 1.1 2010 년 3 월 16 일 Douglas Volz Make / Buy 플래그로 업데이트 됨 -| 1.2 2010 년 11 월 8 일 Douglas Volz 추가 열 및 매개 변수로 업데이트 됨 -| 1.3 2011 년 2 월 7 일 Douglas Volz는 COGS 및 수익 기본 계정 추가 -| 1.4 2016 년 11 월 15 일 Douglas Volz 카테고리 정보 추가 -| 1.5 27 Jan 2020 Douglas Volz는 조직 코드 및 운영 단위 매개 변수를 추가했습니다. -| 1.6 2020 년 4 월 27 일 Douglas Volz 항목에 대한 다국어보기로 변경됨 -| 마스터, 재고 조직 및 운영 단위. -| 1.7 21 Jun 2020 Douglas Volz 항목에 대한 다국어보기로 변경됨 -| 상태 및 UOM. -| 1.8 2020 년 9 월 24 일 Douglas Volz가보고에 정가 추가 -| 1.9 2021 년 1 월 29 일 Douglas Volz 추가 된 아이템 마스터 날짜 및 비활성 아이템 매개 변수 + =============================================== =========================== + * / PTB CAC Item Cost Summary Relatório para mostrar os custos dos itens em qualquer tipo de custo. Para uma ou mais organizações de inventário. /* +=============================================================================+ | 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_item_cost_rept.sql | Parâmetros: | p_cost_type -- O tipo de custo que você deseja relatar | p_ledger -- livro razão geral que você deseja relatar, trabalha com | nomes de ledger nulos ou válidos | p_item_number -- Digite o número do item específico que você deseja relatar | p_org_code -- código de organização específico, trabalha com | códigos de organização nulos ou válidos | p_include_uncosted_items -- Sim/Não bandeira para incluir ou não incluir recursos não-custados -- | Descrição: | Relatório para mostrar os custos do item em qualquer tipo de custo | Versão Modificada em Modificada por Descrição -- | ======= =========== ============== ========================================= | 1.0 06 Out 2009 Douglas Volz Codificação Inicial | 1.1 16 Mar 2010 Douglas Volz Atualizado com bandeiras Make/Buy | 1.2 08 Nov 2010 Douglas Volz Atualizado com colunas e parâmetros adicionais | 1.3 07 Fev 2011 Douglas Volz Adicionado COGS e contas default de receita | 1.4 15 Nov 2016 Douglas Volz Informações adicionais da categoria | 1,5 27 jan 2020 Douglas Volz Adicionado Código Org e parâmetros da Unidade Operacional | 1.6 27 Abr 2020 Douglas Volz Mudou para visualizações em vários idiomas para o item | master, orgs de inventário e unidades operacionais. | 1.7 21 Jun 2020 Douglas Volz Mudou para visualizações em vários idiomas para o item | status e UOM. | 1.8 24 set 2020 Douglas Volz Adicionado Preço de Lista para relatar | 1.9 29 Jan 2021 Douglas Volz Adicionado o parâmetro Datas mestras de itens e Itens inativos +=============================================================================+*/ RU CAC Item Cost Summary Отчет для отображения расходов по статьям в любом типе расходов. Для одной или нескольких организаций, занимающихся инвентаризацией. /* +=============================================================================+ -- | Copyright 2009-2020 Douglas Volz Consulting, Inc. | -- | Все права защищены. | -- | Разрешение на использование этого кода предоставляется при условии, что оригинальным автором является |. -- | подтверждено. Никакие гарантии, явные или иные, не включены в настоящий документ |. -- | разрешение. | -- +=============================================================================+ -- | -- | Оригинальный автор: Дуглас Вольц (doug@volzconsulting.com) -- | -- | Название программы: xxx_item_cost_rept.sql -- | -- | Параметры: -- | p_cost_type -- Тип стоимости, о котором вы хотите сообщить. -- | p_ledger -- главная книга, с которой вы хотите отчитаться, работает с -- | нулевые или действительные имена в бухгалтерской книге -- | p_item_number -- Введите номер конкретного пункта, о котором вы хотите сообщить. -- | p_org_code -- определенный организационный код, работает с -- | нулевой или действительный код организации -- | p_include_uncosted_items -- Да/Флаг включения или невключения ресурсов, не связанных с затратами -- | -- | Описание: -- | Отчет для отображения стоимости позиций в любом типе расходов. -- | -- | Версия, модифицированная по описанию. -- | ======= =========== ============== ========================================= -- | 1.0 06 октября 2009 г. Дуглас Вольц Начальное кодирование -- | 1.1 16 марта 2010 г. Дуглас Вольц обновился флагами Make/Buy. -- | 1.2 08 ноября 2010 г. Дуглас Вольц Обновление с дополнительными колонками и параметрами -- | 1.3 07 Feb 2011 Douglas Volz Added COGS and Revenue Profenue default accounts -- | 1.4 15 ноября 2016 г. Дуглас Вольц Добавленная информация о категории -- | 1.5 27 января 2020 г. Дуглас Вольц добавил организационный код и параметры операционного блока -- | 1.6 27 Apr 2020 Douglas Volz Изменен на несколько языков для данного пункта. -- | мастер, инвентаризационные организации и операционные подразделения. -- | 1.7 21 июня 2020 г. Дуглас Вольц Изменен для пункта на несколько языков. -- | статус и UOM. -- | 1.8 24 сентября 2020 г. Дуглас Вольц Добавленный лист Цена для отчета -- | 1.9 29 января 2021 г. Дуглас Вольц Добавил основные даты и параметр "Неактивные элементы". +=============================================================================+*/ S CAC Item Cost Summary Rapportera för att visa artikelkostnader i valfri kostnadstyp. För en eller flera inventeringsorganisationer. / * + ================================================== ================================ + - | Copyright 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_item_cost_rept.sql - | - | Parametrar: - | p_cost_type - Kostnadstypen du vill rapportera - | p_ledger - huvudbok du vill rapportera, arbetar med - | ogiltiga eller giltiga bokföringsnamn - | p_item_number - Ange det specifika artikelnummer du vill rapportera - | p_org_code - specifik organisationskod, fungerar med - | null eller giltiga organisationskoder - | p_include_uncosted_items - Ja / Nej flagga för att inkludera eller inte inkludera icke-kostnad resurser - | - | Beskrivning: - | Rapportera för att visa artikelkostnader i valfri kostnadstyp - | - | Version modifierad på modifierad av beskrivning - | ===================================================== ========================= - | 1.0 06 okt 2009 Douglas Volz inledande kodning - | 1.1 16 mars 2010 Douglas Volz Uppdaterad med Make / Buy-flaggor - | 1.2 08 nov 2010 Douglas Volz Uppdaterad med ytterligare kolumner och parametrar - | 1.3 07 feb 2011 Douglas Volz lade till COGS- och intäktsstandardkonton - | 1.4 15 nov 2016 Douglas Volz Lade till kategoriinformation - | 1.5 27 jan 2020 Douglas Volz har lagt till organisationskod och parametrar för operativ enhet - | 1.6 27 apr 2020 Douglas Volz Ändrad till flerspråkiga vyer för artikeln - | befälhavare, lagerorganisationer och driftsenheter. - | 1.7 21 juni 2020 Douglas Volz Ändrad till flerspråkiga vyer för artikel - | status och UOM. - | 1.8 24 sep 2020 Douglas Volz Tillagt listpris att rapportera - | 1.9 29 jan 2021 Douglas Volz Lade till artikelmasterdatum och parameter för inaktiva artiklar + ==================================================== =============================== + * / TR CAC Item Cost Summary Herhangi bir maliyet türünde kalem maliyetlerini göstermek için rapor. Bir veya daha fazla envanter organizasyonu 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_item_cost_rept.sql - | - | Parametreler: - | p_cost_type - Raporlamak istediğiniz maliyet türü - | p_ledger - rapor etmek istediğiniz genel muhasebe ile çalışır - | boş veya geçerli defter adları - | p_item_number - Bildirmek istediğiniz belirli öğe numarasını girin - | p_org_code - özel organizasyon kodu ile çalışır - | boş veya geçerli organizasyon kodları - | p_include_uncosted_items - Maliyetsiz kaynakları dahil etmek veya içermemek için Evet / Hayır işareti - | - | Açıklama: - | Herhangi bir maliyet türünde ürün maliyetlerini göstermek için rapor - | - | Açıklamaya Göre Değiştirildiğinde Değiştirilen Sürüm - | ======= =========== ============== ================== ======================= - | 1.0 06 Ekim 2009 Douglas Volz İlk Kodlama - | 1.1 16 Mart 2010 Douglas Volz Yap / Satın Al işaretleriyle güncellendi - | 1.2 08 Kasım 2010 Douglas Volz Ek sütunlar ve parametrelerle güncellendi - | 1.3 07 Şubat 2011 Douglas Volz COGS ve Revenue varsayılan hesaplarını ekledi - | 1.4 15 Kas 2016 Douglas Volz Kategori bilgileri eklendi - | 1.5 27 Ocak 2020 Douglas Volz Kuruluş Kodu ve İşletim Birimi parametreleri eklendi - | 1.6 27 Nis 2020 Douglas Volz Öğenin çoklu dil görünümlerine değiştirildi - | ana, envanter kuruluşları ve işletim birimleri. - | 1.7 21 Haz 2020 Douglas Volz Öğenin çoklu dil görünümlerine değiştirildi - | durum ve UOM. - | 1.8 24 Eyl 2020 Douglas Volz Rapora Liste Fiyatı Eklendi - | 1.9 29 Oca 2021 Douglas Volz Eklenen öğe ana tarihleri ve Etkin Olmayan Öğeler parametresi + =============================================== ============================ + * / US CAC Item Cost Summary Report to show item costs in any cost type. For one or more inventory organizations. Parameters: =========== Cost Type: enter the cost type(s) you wish to report (mandatory). Include Uncosted Items: enter Yes to include non-costed items, enter No to exclude them (mandatory). Item Status to Exclude: enter the item status you wish to exclude, defaulted to Inactive (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). 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 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. -- +=============================================================================+ -- | -- | Original Author: Douglas Volz (doug@volzconsulting.com) -- | -- | Description: -- | Report to show item costs in any cost type -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 06 Oct 2009 Douglas Volz Initial Coding -- | 1.1 16 Mar 2010 Douglas Volz Updated with Make/Buy flags -- | 1.2 08 Nov 2010 Douglas Volz Updated with additional columns and parameters -- | 1.3 07 Feb 2011 Douglas Volz Added COGS and Revenue default accounts -- | 1.4 15 Nov 2016 Douglas Volz Added category information -- | 1.5 27 Jan 2020 Douglas Volz Added Org Code and Operating Unit parameters -- | 1.6 27 Apr 2020 Douglas Volz Changed to multi-language views for the item -- | master, inventory orgs and operating units -- | 1.7 21 Jun 2020 Douglas Volz Changed to multi-language views for item -- | status and UOM -- | 1.8 24 Sep 2020 Douglas Volz Added List Price and Market Price to report -- | 1.9 29 Jan 2021 Douglas Volz Added item master dates and Inactive Items parameter -- | 1.10 22 Nov 2023 Douglas Volz Add item master std lot size, costing lot size, -- | remove tabs and add org access controls -- | 1.11 05 Dec 2023 Douglas Volz Added G/L and Operating Unit security restrictions. -- | 1.12 30 Jun 2024 Douglas Volz Reinstalled missing parameter for Item Status to Exclude -- | and commented out G/L and Operating Unit security restrictions. -- +=============================================================================+*/ ZHS CAC Item Cost Summary 报告显示任何成本类型的项目成本。 对于一个或多个库存组织。 /* +=============================================================================+ -- 2009-2020年道格拉斯-沃尔兹咨询公司版权所有。 | -- 保留所有权利。 | -- 允许使用该代码，但前提是原作者必须是｜。 -- 认可。不包含任何明示或暗示的保证。 -- 允许。 | -- +=============================================================================+ -- | -- 原作者：Douglas Volz ()Douglas Volz (doug@volzconsulting.com) -- | -- 程序名称：xxx_item_cost_rept.sql。 -- | -- 参数。 参数： -- p_cost_type -- 你想报告的成本类型。 -- p_ledger -- 你想报告的总账，与 -- null或有效的分类账名称 -- | p_item_number -- 输入您想报告的具体项目编号。 -- p_org_code -- 具体的组织代码，可与下列机构合作 -- null或有效的组织代码 -- -- p_include_uncosted_items -- -- 是/否标志，以包括或不包括未计算费用的资源。 -- | -- 描述。 -- 显示任何成本类型的项目成本的报告。 -- | -- | ======= =========== ============== ========================================= | 1.0 2009年10月6日 道格拉斯-沃尔兹初始编码。 -- | 1.1 16 Mar 2010 Douglas Volz 更新了购买标志。 -- | 1.2 2010年11月08日 Douglas Volz 更新了额外的列和参数。 | 1.3 2011年2月7日 Douglas Volz 增加了COGS和收入的默认账户。 -- | 1.4 15 Nov 2016 Douglas Volz 添加了类别信息。 -- -- 1.5 2020年1月27日 Douglas Volz增加了组织机构代码和业务单位参数。 -- 1.6 2020年4月27日 Douglas Volz 改为多语言浏览。 -- 1.7 2020年6月21日 Douglas Volz 将项目改为多语言视图。 | 状态和UOM。 -- | 1.8 2020年9月24日 Douglas Volz 增加了报告的列表价格。 -- 1.9 1月29日 Douglas Volz 增加了项目主日期和无效项目参数。 +=============================================================================+*/ Enginatics R12 only &category_columns &segment_columns 1=1 2=2 3=3 1 -10 &segment_columns with x as ( select fifsv.application_column_name, fifsv.form_left_prompt 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 ) select 'gcc1.'||lower(x.application_column_name)||' "COGS '||substr(x.form_left_prompt,1,21)||'",' text from x union all select 'gcc2.'||lower(x.application_column_name)||' "Rev '||substr(x.form_left_prompt,1,21)||'",' text from x LOV GL Chart of Accounts (inv org restricted) 8E2FF36EDEC579D2E0530100007F1FF2 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)>=sysdate) and fifsv.id_flex_num in (select oav.chart_of_accounts_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and fifsv.id_flex_num in (select oav.chart_of_accounts_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 fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id = nvl(fnd_profile.value('MFG_ORGANIZATION_ID'),ood.organization_id)) Y US Chart of Accounts 2 10 2=2 cct.cost_type = :p_cost_type LOV CST Cost Type 92C63F4C20A21E85E053BB6B63585CC8 Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.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) ) order by cct.cost_type Y US Cost Type 3 20 3=3 :p_include_uncosted_items = 'Y' 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 N Y US Include Uncosted Items 4 30 1=1 msiv.inventory_item_status_code != (select misv.inventory_item_status_code from mtl_item_status_vl misv where misv.inventory_item_status_code_tl = :p_item_status_to_exclude) LOV INV Item Status 8E2FF36EDE9C79D2E0530100007F1FF2 Y select misv.inventory_item_status_code_tl value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code_tl Inactive US Item Status to Exclude 5 40 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=11)) US Category Set 1 6 50 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=5)) US Category Set 2 7 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 xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 8 70 1=1 msiv.concatenated_segments = :p_item_number LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 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) ) order by msiv.concatenated_segments US Item Number 9 80 1=1 mp.organization_code = :p_org_code LOV INV Organization Code (excluding master) 91D3167A33531204E053BB6B63585EE3 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 10 90 1=1 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 11 100 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$.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 Count by Org Y MFG 17 ALLOW_COSTS 20 BASED_ON_ROLLUP 34 COGS Account 32 COGS Company 33 COGS Department 36 COGS Product 35 COGS Sub-Account 21 COSTING_LOT_SIZE 42 COST_CREATION_DATE 4 COST_TYPE 23 CURRENCY_CODE 15 Class 14 Family 18 INVENTORY_ASSET 31 ITEM_COST 44 ITEM_CREATION_DATE 6 ITEM_DESCRIPTION 45 ITEM_LAST_UPDATE_DATE 5 ITEM_NUMBER 9 ITEM_STATUS 8 ITEM_TYPE 16 Inv.Items Description 43 LAST_COST_UPDATE_DATE 1 LEDGER 10 MAKE_BUY_CODE 24 MARKET_PRICE 26 MATERIAL_COST 27 MATERIAL_OVERHEAD_COST 2 OPERATING_UNIT 3 ORG_CODE 29 OUTSIDE_PROCESSING_COST 30 OVERHEAD_COST 12 Product Cat 13 Product Description 28 RESOURCE_COST 39 Rev Account 37 Rev Company 38 Rev Department 41 Rev Product 40 Rev Sub-Account 22 SHRINKAGE_RATE 11 STD_LOT_SIZE 25 TARGET_OR_PO_LIST_PRICE 7 UOM_CODE 19 USE_DEFAULT_CONTROLS COST_TYPE ROW 4 ITEM_NUMBER VALUE 1 COUNT LEDGER ROW 1 OPERATING_UNIT ROW 2 ORG_CODE ROW 3 S Site Count by Org by Item Y MFG 17 ALLOW_COSTS 20 BASED_ON_ROLLUP 34 COGS Account 32 COGS Company 33 COGS Department 36 COGS Product 35 COGS Sub-Account 21 COSTING_LOT_SIZE 42 COST_CREATION_DATE 4 COST_TYPE 23 CURRENCY_CODE 15 Class 14 Family 18 INVENTORY_ASSET 31 ITEM_COST 44 ITEM_CREATION_DATE 6 ITEM_DESCRIPTION 45 ITEM_LAST_UPDATE_DATE 5 ITEM_NUMBER 9 ITEM_STATUS 8 ITEM_TYPE 16 Inv.Items Description 43 LAST_COST_UPDATE_DATE 1 LEDGER 10 MAKE_BUY_CODE 24 MARKET_PRICE 26 MATERIAL_COST 27 MATERIAL_OVERHEAD_COST 2 OPERATING_UNIT 3 ORG_CODE 29 OUTSIDE_PROCESSING_COST 30 OVERHEAD_COST 12 Product Cat 13 Product Description 28 RESOURCE_COST 39 Rev Account 37 Rev Company 38 Rev Department 41 Rev Product 40 Rev Sub-Account 22 SHRINKAGE_RATE 11 STD_LOT_SIZE 25 TARGET_OR_PO_LIST_PRICE 7 UOM_CODE 19 USE_DEFAULT_CONTROLS COST_TYPE ROW 4 ITEM_NUMBER VALUE 1 COUNT LEDGER ROW 1 OPERATING_UNIT ROW 2 ORG_CODE ROW 3 S Site DVOLZ Count by Org by Item Count by Org by Item