ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 22F415FE9CF7872BE06362FB0905BDA5 select -- bom_bomrboms_xmlp_pkg.cf_org_nameformula(bbom.organization_id) assembly_organization, mif.item_number assembly, -- bom_bomrboms_xmlp_pkg.cf_item_descformula(mif.item_id, bbom.organization_id) assembly_description, xxen_util.meaning(mif.bom_item_type,'BOM_ITEM_TYPE',700) bom_item_type, mlu.meaning engineering_bill, mif.primary_uom_code assembly_uom, bbom.alternate_bom_designator alt_bom_designator, bad.description alt_bom_designator_desc, rev.revision assembly_revision, -- fnd_date.date_to_displaydt(:lp_revision_date) assembly_revision_date, (select listagg(mck.concatenated_segments,', ') within group (order by mck.concatenated_segments) from mtl_item_categories mic, mtl_categories_b_kfv mck where mic.category_set_id = :p_category_set_id and mic.organization_id = bbom.organization_id and mic.inventory_item_id = bbom.assembly_item_id and mck.category_id = mic.category_id ) category, /* (select substr(rtrim(xmlagg( xmlelement(name delem,bdde.element_name || nvl2(bom_bomrboms_xmlp_pkg.get_ele_desc(mif.bom_item_type, bdde.element_name, mif.item_catalog_group_id),': ' || bom_bomrboms_xmlp_pkg.get_ele_desc(mif.bom_item_type, bdde.element_name, mif.item_catalog_group_id),null) ,', ').extract('//text()') order by bdde.element_name).GetClobVal(),', '),1,4000) from bom_dependent_desc_elements bdde where bdde.bill_sequence_id=bet.top_bill_sequence_id ) descriptive_elements,*/ xxen_util.meaning(bet.loop_flag,'SYS_YES_NO',700) assembly_has_loop, -- to_char(bet.top_bill_sequence_id ) top_bill_sequence_id, mif.item_id assembly_item_id, bbom.organization_id assembly_organization_id, mif.item_catalog_group_id assembly_item_catalog_group_id from bom_explosion_temp bet, bom_bill_of_materials bbom, bom_lists blist, mtl_item_flexfields mif, mtl_item_revisions_b rev, mfg_lookups mlu, bom_alternate_designators bad where bet.group_id = :p_group_id and bet.plan_level = 0 and bet.top_bill_sequence_id = bbom.bill_sequence_id and blist.sequence_id = :p_sequence_id1 and blist.organization_id = bbom.organization_id and bbom.assembly_item_id = mif.item_id and mif.organization_id = blist.organization_id and ( (bbom.alternate_bom_designator is null and bad.organization_id = -1) or (bbom.alternate_bom_designator is not null and bbom.alternate_bom_designator = bad.alternate_designator_code and bad.organization_id = blist.organization_id) ) and mlu.lookup_type = 'BOM_NO_YES' and mlu.lookup_code = bbom.assembly_type and rev.organization_id = blist.organization_id and rev.inventory_item_id = bbom.assembly_item_id and rev.effectivity_date <= :lp_revision_date and not exists (select 'MAX REV DATE' from mtl_item_revisions_b rev2 where rev2.inventory_item_id = bbom.assembly_item_id and rev2.organization_id = bbom.organization_id and rev2.effectivity_date > rev.effectivity_date and rev2.effectivity_date <= :lp_revision_date) and not exists (select 'MAX REV' from mtl_item_revisions_b rev3 where rev3.inventory_item_id = bbom.assembly_item_id and rev3.organization_id = bbom.organization_id and rev3.effectivity_date = rev.effectivity_date and rev3.revision > rev.revision) and (((:p_verify_flag is null) or (:p_verify_flag <> 1)) or ((:p_verify_flag = 1) and (bet.loop_flag = 1))) Y BOM BOMRBOMSG_XML C6E085D46F5D51A9E05362FB09050512 US COPY OF: BOM Bill of Material Structure Description: Bill of Material Structure Report Provides equivalent functionality to the the following standard reports: - Bill of Material Structure Report (Template 'Bill of Material Structure Report' with parameter 'Bills with Loop Errors Only' = No) - Bill of Material Loop Report (Template Bill of Material Structure Report with parameter 'Bills with Loop Errors Only' = Yes) - Consolidated Bills of Material Report (Template 'Consolidated Bill of Material Report') Application: Bills of Material Source: Bill of Material Structure Report GUI (XML) Short Name: BOMRBOMSG_XML DB package: BOM_BOMRBOMS_XMLP_PKG :dummy :lp_all_orgs :lp_organization_id :lp_revision_date :p_all_orgs :p_alt_option :p_alt_option_type :p_alternate_desg :p_bom_or_eng :p_cat_between :p_category_from :p_category_set :p_category_set_id :p_category_structure_id :p_category_to :p_compo_flexdata :p_conc_request_id :p_debug :p_err_msg :p_explode_option :p_explode_option_type :p_explosion_level :p_explosion_quantity :p_full_desc_choice :p_full_description :p_group_id :p_impl :p_impl_flag :p_item_from :p_item_id :p_item_structure_id :p_item_to :p_locator_flexdata :p_locator_structure_id :p_msg_buf :p_no :p_order_by :p_order_by_type :p_org_hierarchy :p_organization_id :p_organization_name :p_plan_factor :p_plan_factor_flag :p_print_option1 :p_print_option1_flag :p_print_option2 :p_print_option2_flag :p_print_option3 :p_print_option3_flag :p_print_option4 :p_print_option4_flag :p_print_option5 :p_print_option5_flag :p_print_option6 :p_print_option6_flag :p_prvd31_cnt :p_prvd32_cnt :p_qty_precision :p_range_option :p_range_option_type :p_revision :p_revision_date :p_sequence_id :p_sequence_id1 :p_specific_item :p_verify_flag :p_yes 1 -130 :p_order_by_type LOV Oracle BOM_SRS_BILL_SORT_ORDER Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='BOM_BILL_SORT_ORDER_TYPE' order by meaning 1 Y AR ترتيب بواسطة ترتيب بواسطة مسلسل عملية الصنف أو مسلسل صنف العملية D Sortieren nach Sortieren nach Pos.-/AVO-Nr. oder AVO-/Pos.-Nr. F Commander par Tri par article-op. ou op.-article I Ordina per Ordina per sequenza art.-op. oppure op.-art. US Order By Order by item-op seq or op-item seq ZHS 排序依据 按物料工序序号或工序物料序号排序 2 -120 :p_bom_or_eng Char select nvl(fnd_profile.value('BOM_OR_ENG'), 'BOM') from dual Y AR BOM_SRS_NONE_CHAR علامة فاتورة هندسية D BOM_SRS_NONE_CHAR Konstruktionsstückliste F BOM ou ENG Indicateur Nomenclature étude I BOM_SRS_NONE_CHAR Flag Distinta tecnica US BOM or ENG Engineering bill flag ZHS BOM_SRS_NONE_CHAR 工程清单标志 3 -110 :p_print_option3_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 1 Y AR فترة التسليم وتفاصيل أخرى طباعة تفاصيل فترة التسليم D Durchlaufzeit und Detail Durchlaufzeiten drucken F Délai de livraison et autres détails Imprimer détails délai I Lead time e altri dettagli Stampa dettagli lead time US Leadtime and Other Detail Print lead time details ZHS 提前期和其它详细资料 打印提前期详细资料 4 -100 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR BOM_SRS_ORG_ID معرف التنظيم D BOM_SRS_ORG_ID Organisation F Organisation ID organisation I BOM_SRS_ORG_ID ID org. US Organization org id ZHS BOM_SRS_ORG_ID 组织标识 5 -90 :p_item_id Number select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id = :$flex$.organization and msiv.concatenated_segments = :$flex$.Item_from and msiv.concatenated_segments = :$flex$.Item_to AR BOM_SRS_SPECIFIC_BILL فاتورة محددة D BOM_SRS_SPECIFIC_BILL Bestimmte Stückliste F ID de l'article spécifique Nomenclature spécifique I BOM_SRS_SPECIFIC_BILL Distinta specifica US Specific Item Id specific bill ZHS BOM_SRS_SPECIFIC_BILL 特定清单 6 -80 :p_range_option_type LOV Oracle BOM_SRS_ITEM_RANGE_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='BOM_SELECTION_TYPE' order by meaning select nvl((select 1 from mtl_system_items_vl msiv where msiv.organization_id = :$flex$.organization and msiv.concatenated_segments = :$flex$.Item_from and msiv.concatenated_segments = :$flex$.Item_to ),2) from dual F Article Gamme Option US Item Range Option 7 -70 :p_category_structure_id Number select structure_id from mtl_category_sets where category_set_id = :$flex$.category_set AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur F Structure de la catégorie Structure de catégorie I Struttura categoria Struttura categoria US Category Structure category structure ZHS 类别结构 类别结构 8 -60 :p_cat_between Char select case when :$flex$.categories_from is not null and :$flex$.categories_to is not null then 'fnd_flex_xml_publisher_apis.process_kff_combination_1(''item_cat'',''INV'',''MCAT'',mc.structure_id,null,mc.category_id,''ALL'',''Y'',''VALUE'') between ''' || :$flex$.categories_from || ''' and ''' || :$flex$.categories_to || '''' when :$flex$.categories_from is not null then 'fnd_flex_xml_publisher_apis.process_kff_combination_1(''item_cat'',''INV'',''MCAT'',mc.structure_id,null,mc.category_id,''ALL'',''Y'',''VALUE'') >= ''' || :$flex$.categories_from || '''' when :$flex$.categories_to is not null then 'fnd_flex_xml_publisher_apis.process_kff_combination_1(''item_cat'',''INV'',''MCAT'',mc.structure_id,null,mc.category_id,''ALL'',''Y'',''VALUE'') <= ''' || :$flex$.categories_to || '''' else '1=1' end from dual F Gamme de catégories US Category Range 9 -50 :p_group_id Number select BOM_EXPLOSION_TEMP_S.NEXTVAL from dual Y AR معرف المجموعة معرف المجموعة D Gruppenkennung Gruppenkennung F Identifiant du groupe ID groupe I Id gruppo Id gruppo US Group id Group id ZHS 组标识 组标识 10 -40 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') AR خيار الدقة الديناميكية الدقة الديناميكية D Option Nachkommastellen Nachkommastellen F Option de précision dynamique Précision dynamique I Opzione precisione dinamica Precisione dinamica US Dynamic Precision Option Dynamic Precision ZHS 动态精确度选项 动态精确度 11 10 :p_all_orgs LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 2 Y AR كل التنظيمات كل التنظيمات D Alle Organisationen Alle Organisationen F Toutes les organisations Toutes les organisations I Tutte le organizzazioni Tutte le organizzazioni US All Organizations All Organizations ZHS 所有组织 所有组织 12 20 :p_org_hierarchy LOV Oracle BOM_HIERARCHYVALIDORG Y select name id, name value, null description from per_organization_structures where business_group_id=fnd_global.per_business_group_id and inv_orghierarchy_pvt.org_hierarchy_access(name)='Y' and inv_orghierarchy_pvt.org_hierarchy_level_access(name, fnd_profile.value('MFG_ORGANIZATION_ID'))='Y' and :$flex$.bom_srs_yes_no2=2 order by name AR تدرج التنظيم تدرج التنظيم D Organisationshierarchie Organisationshierarchie F Hiérarchie de l'organisation Hiérarchie des organisations I Gerarchia organizzazione Gerarchia organizzazione US Organization Hierarchy Organization Hierarchy ZHS 组织层次结构 组织层次结构 13 30 :p_item_from LOV custom Y Y select x.value, x.description from ( select distinct msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv where msiv.organization_id = :$flex$.organization and exists (select null from bom_bill_of_materials bbom where msiv.organization_id = bbom.organization_id and msiv.inventory_item_id = bbom.assembly_item_id and msiv.bom_enabled_flag = 'Y' and ( (:$flex$.bom_or_eng = 'BOM' and bbom.assembly_type = 1) or (:$flex$.bom_or_eng = 'ENG') ) ) ) x order by x.value AR الأصناف من الصنف من D Von Artikel Von Artikel F Article de Article - De I Articoli - Da Articolo - Da US Item From Item from ZHS 物料自 物料自 14 40 :p_item_to LOV custom Y Y select x.value, x.description from ( select distinct msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv where msiv.organization_id = :$flex$.organization and msiv.concatenated_segments >= :$flex$.item_from and exists (select null from bom_bill_of_materials bbom where msiv.organization_id = bbom.organization_id and msiv.inventory_item_id = bbom.assembly_item_id and msiv.bom_enabled_flag = 'Y' and ( (:$flex$.bom_or_eng = 'BOM' and bbom.assembly_type = 1) or (:$flex$.bom_or_eng = 'ENG') ) ) ) x order by x.value :$flex$.Item_From AR إلى أصناف إلى D Bis Bis Artikel F Objet à Articles - A I A Articoli - A US Item To Item to ZHS 至 物料至 15 50 :p_alt_option_type LOV Oracle BOM_SRS_ALT_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MCG_AUTOLOAD_OPTION' order by meaning nvl2(:$flex$.alternate,3,1) Y AR اختيار بديل اختيار بديل D Alternative Auswahl Alternative Auswahl F Sélection alternée Sélection remplact I Selezione alternativa Selezione alternativa US Alternate Selection Alternate selection ZHS 替代选择 替代选择 16 60 :p_alternate_desg LOV custom Y select bad.alternate_designator_code value, bad.description description from bom_alternate_designators bad where bad.organization_id=:$flex$.organization and :$flex$.Alternate_Selection=3 and bad.alternate_designator_code in (select bbom.alternate_bom_designator from bom_bill_of_materials bbom where ((:$flex$.bom_or_eng='BOM' and bbom.assembly_type=1) or (:$flex$.bom_or_eng='ENG') ) and bbom.organization_id=:$flex$.organization and bbom.assembly_item_id = nvl(:$flex$.specific_item_id,bbom.assembly_item_id) ) order by bad.alternate_designator_code AR البديل مؤشر بديل D Alternative Alternativer Designator F Produit de remplacement Repère de remplacement I Alternativa Indicatore alternativa US Alternate Alternate designator ZHS 替代项 替代指示符 17 70 :p_revision LOV custom Y select revision value, null description from bom_item_revisions_view where organization_id=:$flex$.organization and inventory_item_id=:$flex$.specific_item_id order by fnd_date.canonical_to_date(effectivity_date),revision select current_revision from bom_item_current_rev_view where organization_id = :$FLEX$.BOM_SRS_ORG_ID and inventory_item_id = :$FLEX$.BOM_SRS_SPECIFIC_BILL AR المراجعة مراجعة الصنف D Version Artikelversion F Révision Version d'article I Revisione Revisione articolo US Revision Item revision ZHS 版本 物料版本 18 80 :p_revision_date DateTime select fnd_date.date_to_displaydt(fnd_date.canonical_to_date(high_date)) from bom_item_revisions_view where organization_id=:$flex$.organization and inventory_item_id=:$flex$.Specific_Item_ID and revision=:$flex$.revision AR التاريخ وقت وتاريخ سريان المفعول D Datum Gültigkeitsdatum und -zeit F Date Date et heure de validité I Data Data e ora validità US Date Effective Date and Time ZHS 日期 有效日期和时间 19 110 :p_category_set_id LOV Oracle BOM_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, null description from mtl_category_sets order by value,description select CATEGORY_SET_id from MTL_DEFAULT_SETS_VIEW where FUNCTIONAL_AREA_ID = 1 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet F Ensemble de la catégorie Jeu de catégories I Serie categorie Serie di categorie US Category Set Category set ZHS 类别集 类别集 20 120 :p_category_from LOV custom Y select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_id=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments AR الفئات من الفئات من D Von Kategorie Von Kategorie F Catégories de Catégories - De I Categorie - Da Categorie - Da US Categories From categories from ZHS 类别自 分类自 21 130 :p_category_to LOV custom Y select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_id=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments :$flex$.categories_from AR إلى 2 الفئات إلى D Bis 2 Bis Kategorie F Catégories à Catégories - A I A 2 Categorie - A US Categories To categories to ZHS 至 2 分类至 22 140 :p_explosion_level Number fnd_profile.value('BOM:DEFAULT_BOM_LEVELS') Y AR مستويات الانفجار مستويات التفجير D Aufzulösende Ebenen Aufzulösende Ebenen F Niveaux à exploser Niveaux à exploser I Livelli da esplodere livelli da esplodere US Levels to Explode levels to explode ZHS 展开层 展开层 23 150 :p_impl_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 1 Y AR المنفذ فقط المنفذ فقط D Nur implementiert Nur implementiert F Mis en œuvre uniquement Appliqué seulement I Solo implementati Solo implementati US Implemented Only Implemented only ZHS 仅限于已实施的 仅限于已实施的 24 160 :p_explode_option_type LOV Oracle BOM_SRS_INDENTED_BILL_DISPLAY_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' order by value,description 2 Y AR خيارات العرض خيار الانفجار D Anzeigeoption Auflösungsoption F Option d'affichage Option Explosion I Opzione di visualizzazione Opzione di esplosione US Display Option explosion option ZHS 显示选项 展开选项 25 170 :p_explosion_quantity Number 1 Y AR كمية الانفجار كمية الانفجار D Menge auflösen Auflösungsmenge F Quantité d'explosions Quantité à exploser I Quantità di esplosione Quantità di esplosione US Explosion Quantity Explosion quantity ZHS 展开数量 展开数量 26 180 :p_print_option5_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 2 Y AR إبدال مكونات طباعة المكونات البديلة D Substitutkomponenten Substitute drucken F Afficher les composants de substitution Imprimer composants de substitution I Componenti sostitutivi Stampa componenti sostitutivi US Show Substitute Components Print substitute components ZHS 替代组件 打印替代组件 27 190 :p_plan_factor_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 2 Y AR استخدام نسبة التخطيط استخدام معامل التخطيط D Planungsfaktor verwenden Planungsfaktor verwenden F Utilisation Planification Pourcentage Prendre facteur planif. I Usa percentuale di pianificazione Usa fattore di pianificazione US Use Planning Percent Use Planning Factor ZHS 使用计划百分比 使用计划系数 28 200 :p_verify_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 2 Y AR علامة التحقيق علامة التحقيق D Prüfen Prüfen F Factures avec erreurs de boucle uniquement Indicateur Vérifier I Flag Verifica Flag Verifica US Bills with Loop Errors Only Verify flag ZHS 核实标志 核实标志 :$flex$.Alternate_Selection Alternate Selection Alternate :$flex$.Item_From Item From Item To :$flex$.Item_from Item From Item Range Option :$flex$.Item_from Item From Specific Item Id :$flex$.Item_to Item To Item Range Option :$flex$.Item_to Item To Specific Item Id :$flex$.Specific_Item_ID Specific Item Id Date :$flex$.alternate Alternate Alternate Selection :$flex$.bom_or_eng BOM or ENG Alternate :$flex$.bom_or_eng BOM or ENG Item From :$flex$.bom_or_eng BOM or ENG Item To :$flex$.bom_srs_yes_no2 All Organizations Organization Hierarchy :$flex$.categories_from Categories From Categories To :$flex$.categories_from Categories From Category Range :$flex$.categories_to Categories To Category Range :$flex$.category_set Category Set Categories From :$flex$.category_set Category Set Categories To :$flex$.category_set Category Set Category Structure :$flex$.item_from Item From Item To :$flex$.organization Organization Alternate :$flex$.organization Organization Date :$flex$.organization Organization Item From :$flex$.organization Organization Item Range Option :$flex$.organization Organization Item To :$flex$.organization Organization Revision :$flex$.organization Organization Specific Item Id :$flex$.revision Revision Date :$flex$.specific_item_id Specific Item Id Alternate :$flex$.specific_item_id Specific Item Id Revision