ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US C6E085D46F5D51A9E05362FB09050512 with q_assemblies as ( select (select haouv.name from hr_all_organization_units_vl haouv where bbom.organization_id=haouv.organization_id) assembly_organization, msiv.concatenated_segments assembly, msiv.description assembly_description, msiv.long_description assembly_long_description, xxen_util.meaning(msiv.bom_item_type,'BOM_ITEM_TYPE',700) bom_item_type, mlu.meaning engineering_bill, msiv.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 distinct 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 distinct listagg(bdde.element_name || nvl2(bom_bomrboms_xmlp_pkg.get_ele_desc(msiv.bom_item_type, bdde.element_name, msiv.item_catalog_group_id),': ' || bom_bomrboms_xmlp_pkg.get_ele_desc(msiv.bom_item_type, bdde.element_name, msiv.item_catalog_group_id),null),', ') within group (order by bdde.element_name) from bom_dependent_desc_elements bdde where bdde.bill_sequence_id=bet.top_bill_sequence_id and rownum <= 40 -- cap to ensure listagg doesnt exceed 4K ) 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, msiv.inventory_item_id assembly_item_id, bbom.organization_id assembly_organization_id, msiv.item_catalog_group_id assembly_item_catalog_group_id, -- &assbly_dff_attributes1 &assbly_item_dff_attributes1 bbom.rowid assembly_row_id, msiv.row_id assembly_item_row_id from bom_explosion_temp bet, bom_bill_of_materials bbom, bom_lists blist, mtl_system_items_vl msiv, 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 = msiv.inventory_item_id and bbom.organization_id = msiv.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))) ), q_components as ( select /*+ push_pred(mic) */ bev.sort_order comp_sort_order, lpad(to_char(bev.plan_level), least(9,bev.plan_level),'.') plan_level, bev.item_num comp_item_seq_num, bev.operation_seq_num comp_operation_seq_num, bev.item_number comp_number, bev.unit_of_measure comp_item_uom, bev.effectivity_date comp_effectivity_date, to_char(bev.effectivity_date, 'HH24:MI') comp_effectivity_time, bev.disable_date comp_disable_date, to_char(bev.disable_date, 'HH24:MI') comp_disable_time, round(bev.component_quantity,:p_qty_precision) comp_quantity, round(bev.extended_quantity,:p_qty_precision) comp_extended_quantity, bev.change_notice comp_change_notice, xxen_util.meaning(bev.eng_item_flag,'YES_NO',3) comp_eng_item_flag, bev.parent_alternate comp_alternate, xxen_util.meaning(bev.item_type,'ITEM_TYPE',3) comp_item_type, bev.planning_factor comp_planning_factor, round(bev.component_yield_factor,:p_qty_precision) comp_yield_factor, decode(bom.common_bill_sequence_id, bom.bill_sequence_id, bev.supply_subinventory, msib_a.wip_supply_subinventory) comp_supply_subinventory, milk.concatenated_segments comp_locator, round(bev.manufacturing_lead_time,:p_qty_precision) mfg_lead_time, bev.operation_lead_time_percent operation_lead_time_percent, round((1-(bev.operation_lead_time_percent/100))*msib_a.full_lead_time,:p_qty_precision) operation_offset, round(bev.cum_manufacturing_lead_time,:p_qty_precision) cumulative_mfg_lead_time, round(bev.cumulative_total_lead_time,:p_qty_precision) cumulative_total_lead_time, round(bev.minimum_quantity,:p_qty_precision) comp_minimum_quantity, round(bev.maximum_quantity,:p_qty_precision) comp_maximum_quantity, mck.concatenated_segments comp_category, msiv.inventory_item_status_code comp_item_status, msiv.description comp_description, msiv.long_description comp_long_description, bom_bomrboms_xmlp_pkg.get_rev(bev.organization_id, bev.component_item_id) comp_revision, bom_bomrboms_xmlp_pkg.cf_revision_descformula(bev.component_item_id, bom_bomrboms_xmlp_pkg.get_rev(bev.organization_id, bev.component_item_id)) comp_revision_desc, bom_bomrboms_xmlp_pkg.supply_type_dispformula(decode (bom.common_bill_sequence_id , bom.bill_sequence_id , bev.wip_supply_type , msib_a.wip_supply_type)) comp_supply_type, bev.so_basis so_basis, bom_bomrboms_xmlp_pkg.eng_bill_dispformula(bev.eng_bill) eng_bill, bom_bomrboms_xmlp_pkg.optional_dispformula(bev.optional) optional, bom_bomrboms_xmlp_pkg.mutually_dispformula(bev.mutually_exclusive_options) mutually_excl_options, bom_bomrboms_xmlp_pkg.check_atp_dispformula(bev.check_atp) check_atp, bom_bomrboms_xmlp_pkg.required_to_ship_dispformula(bev.required_to_ship) required_to_ship, bom_bomrboms_xmlp_pkg.required_for_revenue_dispformu(bev.required_for_revenue) required_for_revenue, bom_bomrboms_xmlp_pkg.include_on_ship_docs_dispformu(bev.include_on_ship_docs) include_on_ship_docs, (select distinct listagg(brd.component_reference_designator||nvl2(brd.ref_designator_comment,': '||brd.ref_designator_comment,null),', ') within group (order by brd.component_reference_designator) from bom_ref_designators_view brd where brd.component_sequence_id=bev.component_sequence_id and rownum <= 15 -- cap to ensure listagg doesnt exceed 4K ) reference_designators, xxen_util.meaning(bev.loop_flag,'SYS_YES_NO',700) component_has_loop, msib_a.organization_id assembly_organization_id, bev.parent_item_id assembly_item_id, bev.organization_id comp_org_id, bev.top_bill_sequence_id top_bill_sequence_id, bev.component_sequence_id, bev.component_item_id, decode(bom.common_bill_sequence_id, bom.bill_sequence_id, bev.supply_locator_id, msib_a.wip_supply_locator_id) supply_locator_id, &comp_dff_attributes1 &comp_item_dff_attributes1 bcb.rowid component_row_id, msiv.rowid component_item_row_id from bom_explosion_view bev, mtl_item_locations_kfv milk, bom_bill_of_materials bom, bom_components_b bcb, mtl_system_items_b msib_a, mtl_system_items_vl msiv, (select mic.* from mtl_default_category_sets mdcs, mtl_item_categories mic where mdcs.functional_area_id = 1 and mdcs.category_set_id = mic.category_set_id ) mic, mtl_categories_b_kfv mck where bev.group_id = :p_group_id and bev.plan_level > 0 and bev.supply_locator_id = milk.inventory_location_id(+) and milk.organization_id(+) = bev.organization_id and bev.parent_item_id = msib_a.inventory_item_id and bev.organization_id = msib_a.organization_id and bev.component_item_id = msiv.inventory_item_id and bev.organization_id = msiv.organization_id and msiv.inventory_item_id = mic.inventory_item_id (+) and msiv.organization_id = mic.organization_id (+) and mic.category_id = mck.category_id (+) and bom.bill_sequence_id = bev.bill_sequence_id and bcb.component_sequence_id = bev.component_sequence_id and ( ( (:p_verify_flag is null) or (:p_verify_flag <> 1) ) or ( (:p_verify_flag = 1) and (bev.loop_flag = 1) ) ) ), q_subst_comp as (select /*+ inline */ msiv.concatenated_segments substitute_component, msiv.description substitute_description, msiv.long_description substitute_long_description, bsc.substitute_item_quantity substitute_quantity, msiv.primary_uom_code substitute_uom, bsc.component_sequence_id, msiv.organization_id organization_id, msiv.inventory_item_id item_id from bom_sub_components_view bsc, mtl_system_items_vl msiv where msiv.inventory_item_id = bsc.substitute_component_id and :p_print_option5_flag = 1 ) -- -- Main Query Starts Here -- select qa.assembly_organization, qa.assembly, qa.assembly_description, qa.assembly_long_description, qa.bom_item_type, qa.engineering_bill, qa.assembly_uom, qa.alt_bom_designator, qa.alt_bom_designator_desc, qa.assembly_revision, qa.assembly_revision_date, qa.category, qa.descriptive_elements, &assbly_dff_attributes2 &assbly_item_dff_attributes2 qc.plan_level "level", qc.comp_item_seq_num item_seq, qc.comp_operation_seq_num op_seq, qc.comp_number component, qc.comp_description component_description, qc.comp_long_description component_long_description, qc.comp_revision revision, qc.comp_revision_desc revision_description, qc.comp_item_uom uom, qc.comp_quantity quantity, qc.comp_extended_quantity extended_quantity, qc.comp_item_status item_status, qc.comp_category item_category, qc.comp_eng_item_flag engineering_item, qc.comp_alternate alternate, qc.comp_planning_factor planning_percent, qc.comp_yield_factor yield, qc.comp_supply_type supply_type, qc.comp_supply_subinventory supply_subinventory, qc.comp_locator supply_locator, qc.mfg_lead_time, qc.operation_offset, qc.operation_lead_time_percent, qc.cumulative_mfg_lead_time, qc.cumulative_total_lead_time, qc.comp_item_type item_type, qc.optional, qc.mutually_excl_options mutually_exclusive, qc.check_atp, qc.so_basis, qc.required_to_ship, qc.required_for_revenue, qc.include_on_ship_docs, qc.comp_minimum_quantity min_qty, qc.comp_maximum_quantity max_qty, qc.comp_effectivity_date effectivity_date, qc.comp_disable_time disable_date, qc.comp_change_notice change_notice, qc.reference_designators, &comp_dff_attributes2 &comp_item_dff_attributes2 qsc.substitute_component, qsc.substitute_description, qsc.substitute_long_description, qsc.substitute_quantity, qsc.substitute_uom, qa.assembly_has_loop, qc.component_has_loop, nvl2(qa.alt_bom_designator,2,1) alt_sort_order, qc.comp_sort_order from q_assemblies qa, q_components qc, q_subst_comp qsc where 1=1 and qa.top_bill_sequence_id = qc.top_bill_sequence_id and qa.assembly_organization_id = qc.assembly_organization_id and qc.component_sequence_id = qsc.component_sequence_id (+) and qc.comp_org_id = qsc.organization_id (+) order by qa.assembly, nvl2(qa.alt_bom_designator,1,2), qa.alt_bom_designator, qa.assembly_organization, qc.comp_sort_order Y BOM BOMRBOMSG_XML XXEN_BOM AR BOM واجهة المستخدم الرسومية لتقرير هيكل شجرة المنتجات (تنسيق XML) 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 D BOM Strukturstücklisten (SC) - XML 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 E BOM Estructura de Listas de Materiales - GUI 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 F BOM Etat Structure de nomenclature - GUI 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 I BOM Rapporto Struttura distinta base - GUI 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 JA BOM 部品構成表構成レポート GUI 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 KO BOM BOM 구조 보고서 GUI 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 PTB BOM Relatório de Estrutura da Lista de Materiais GUI 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 RU BOM ГИП отчета о структуре спецификации 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 S BOM Produktstruktur - rapport, GUI 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 TR BOM Ürün Ağacı Yapı Raporu GUI 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 US 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 ZHS BOM 物料清单结构报表 GUI 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 Enginatics R12 only &assbly_dff_attributes1 &assbly_dff_attributes2 &assbly_item_dff_attributes1 &assbly_item_dff_attributes2 &comp_dff_attributes1 &comp_dff_attributes2 &comp_item_dff_attributes1 &comp_item_dff_attributes2 1=1 :lp_organization_id :lp_revision_date :p_all_orgs :p_alt_option_type :p_alternate_desg :p_assembly_item :p_bom_or_eng :p_cat_from :p_cat_to :p_category_from :p_category_set :p_category_set_id :p_category_to :p_conc_request_id :p_date :p_date_option :p_eng_bill_flag :p_explode_option_type :p_explosion_level :p_explosion_quantity :p_group_id :p_impl_flag :p_implemented :p_item :p_item_from :p_item_to :p_level :p_master_org_id :p_order_by_type :p_org_code :p_org_hierarchy :p_org_id :p_organization_id :p_plan_factor_flag :p_print_option3_flag :p_print_option5_flag :p_qty_precision :p_report_code :p_revision :p_revision_date :p_sequence_id :p_sequence_id1 :p_top_assly_flg :p_verify_flag 1 -70 :p_report_code Char BOMRBOMSG US Report Code 2 -60 :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 排序依据 按物料工序序号或工序物料序号排序 3 -50 :p_bom_or_eng Char select nvl(upper(substr(fnd_profile.value('BOM_OR_ENG'),1,3)), '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 工程清单标志 4 -40 :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 提前期和其它详细资料 打印提前期详细资料 5 -30 :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 组织标识 6 -20 :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 组标识 组标识 7 -10 :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 动态精确度选项 动态精确度 8 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 所有组织 所有组织 9 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 组织层次结构 组织层次结构 10 30 1=1 qa.assembly = :p_assembly_item 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 US Assembly Item Select one or more assembly items to explode. Leave blank to use Item From/To range. 11 40 :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 US Assembly Item From Item From 12 50 :p_item_to LOV custom 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$.assembly_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$.Assembly_Item_From US Assembly Item To Item To 13 60 :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 替代选择 替代选择 14 70 :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 替代项 替代指示符 15 80 :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 版本 物料版本 16 90 :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 日期 有效日期和时间 17 100 :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 类别集 类别集 18 110 :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 类别自 分类自 19 120 :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 分类至 20 130 :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 展开层 展开层 21 140 :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 仅限于已实施的 仅限于已实施的 22 150 :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 显示选项 展开选项 23 160 :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 展开数量 展开数量 24 170 :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 替代组件 打印替代组件 25 180 :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 使用计划百分比 使用计划系数 26 190 :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 核实标志 核实标志 27 195 &assbly_dff_attributes1 select xxen_util.dff_columns(p_table_name=>'bom_structures_b',p_table_alias=>'bbom', p_row_id=>'rowid',p_column_name_prefix=>'Assb: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Assembly DFF 28 &assbly_dff_attributes2 select xxen_util.dff_columns(p_table_name=>'bom_structures_b',p_table_alias=>'bbom',p_prefix=>'qa.',p_column_name_prefix=>'Assb: ') from dual US Show Assembly DFF 29 200 &assbly_dff_attributes1 select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_table_alias=>'msiv', p_row_id=>'row_id',p_column_name_prefix=>'Assb Item: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Assembly Item DFF 30 &assbly_dff_attributes2 select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_prefix=>'qa.',p_column_name_prefix=>'Assb Item: ') sql_text from dual US Show Assembly Item DFF 31 205 &comp_dff_attributes1 select xxen_util.dff_columns(p_table_name=>'bom_components_b',p_table_alias=>'bcb', p_row_id=>'rowid',p_column_name_prefix=>'Comp: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Component DFF 32 &comp_dff_attributes2 select xxen_util.dff_columns(p_table_name=>'bom_components_b',p_prefix=>'qc.',p_column_name_prefix=>'Comp: ') from dual US Show Component DFF 33 210 &comp_item_dff_attributes1 select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_table_alias=>'msiv', p_row_id=>'row_id',p_column_name_prefix=>'Comp Item: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Component Item DFF 34 &comp_item_dff_attributes2 select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_prefix=>'qc.',p_column_name_prefix=>'Comp Item: ') sql_text from dual US Show Component Item DFF :$flex$.Alternate_Selection Alternate Selection Alternate :$flex$.Assembly_Item_From Assembly Item From Assembly Item To :$flex$.alternate Alternate Alternate Selection :$flex$.assembly_item_from Assembly Item From Assembly Item To :$flex$.bom_or_eng BOM or ENG Alternate :$flex$.bom_or_eng BOM or ENG Assembly Item :$flex$.bom_or_eng BOM or ENG Assembly Item From :$flex$.bom_or_eng BOM or ENG Assembly Item To :$flex$.bom_srs_yes_no2 All Organizations Organization Hierarchy :$flex$.categories_from Categories From Categories To :$flex$.category_set Category Set Categories From :$flex$.category_set Category Set Categories To :$flex$.organization Organization Alternate :$flex$.organization Organization Assembly Item :$flex$.organization Organization Assembly Item From :$flex$.organization Organization Assembly Item To :$flex$.organization Organization Date :$flex$.organization Organization Revision :$flex$.revision Revision Date Bill of Material Structure Report Y SYSADMIN 26 ALTERNATE 3 ALT_BOM_DESIGNATOR 3 4 ALT_BOM_DESIGNATOR_DESC 57 ALT_SORT_ORDER 2 1 ASSEMBLY 1 2 ASSEMBLY_DESCRIPTION 55 ASSEMBLY_HAS_LOOP 5 ASSEMBLY_ORGANIZATION 4 9 ASSEMBLY_REVISION 10 ASSEMBLY_REVISION_DATE 8 ASSEMBLY_UOM 6 BOM_ITEM_TYPE 11 CATEGORY 49 CHANGE_NOTICE 40 CHECK_ATP 16 COMPONENT 17 COMPONENT_DESCRIPTION 56 COMPONENT_HAS_LOOP 58 COMP_SORT_ORDER 5 35 CUMULATIVE_MFG_LEAD_TIME 36 CUMULATIVE_TOTAL_LEAD_TIME 12 DESCRIPTIVE_ELEMENTS 48 DISABLE_DATE 47 EFFECTIVITY_DATE 7 ENGINEERING_BILL 25 ENGINEERING_ITEM 22 EXTENDED_QUANTITY 44 INCLUDE_ON_SHIP_DOCS 24 ITEM_CATEGORY 14 ITEM_SEQ 23 ITEM_STATUS 37 ITEM_TYPE 46 MAX_QTY 32 MFG_LEAD_TIME 45 MIN_QTY 39 MUTUALLY_EXCLUSIVE 34 OPERATION_LEAD_TIME_PERCENT 33 OPERATION_OFFSET 38 OPTIONAL 15 OP_SEQ 27 PLANNING_PERCENT 21 QUANTITY 50 REFERENCE_DESIGNATORS 43 REQUIRED_FOR_REVENUE 42 REQUIRED_TO_SHIP 18 REVISION 19 REVISION_DESCRIPTION 41 SO_BASIS 51 SUBSTITUTE_COMPONENT 6 52 SUBSTITUTE_DESCRIPTION 53 SUBSTITUTE_QUANTITY 54 SUBSTITUTE_UOM 31 SUPPLY_LOCATOR 30 SUPPLY_SUBINVENTORY 29 SUPPLY_TYPE 20 UOM 28 YIELD 13 level S Site Consolidated Bill of Material Report SYSADMIN 26 ALTERNATE 4 ALT_BOM_DESIGNATOR 3 5 ALT_BOM_DESIGNATOR_DESC 57 ALT_SORT_ORDER 2 1 ASSEMBLY 1 2 ASSEMBLY_DESCRIPTION 55 ASSEMBLY_HAS_LOOP 6 ASSEMBLY_ORGANIZATION 4 9 ASSEMBLY_REVISION 10 ASSEMBLY_REVISION_DATE 8 ASSEMBLY_UOM 3 BOM_ITEM_TYPE 11 CATEGORY 49 CHANGE_NOTICE 40 CHECK_ATP 16 COMPONENT 5 17 COMPONENT_DESCRIPTION 56 COMPONENT_HAS_LOOP 58 COMP_SORT_ORDER 35 CUMULATIVE_MFG_LEAD_TIME 36 CUMULATIVE_TOTAL_LEAD_TIME 12 DESCRIPTIVE_ELEMENTS 48 DISABLE_DATE 47 EFFECTIVITY_DATE 7 ENGINEERING_BILL 25 ENGINEERING_ITEM 22 EXTENDED_QUANTITY SUM 44 INCLUDE_ON_SHIP_DOCS 24 ITEM_CATEGORY 14 ITEM_SEQ 23 ITEM_STATUS 37 ITEM_TYPE 46 MAX_QTY 32 MFG_LEAD_TIME 45 MIN_QTY 39 MUTUALLY_EXCLUSIVE 34 OPERATION_LEAD_TIME_PERCENT 33 OPERATION_OFFSET 38 OPTIONAL 15 OP_SEQ 27 PLANNING_PERCENT 21 QUANTITY SUM 50 REFERENCE_DESIGNATORS 43 REQUIRED_FOR_REVENUE 42 REQUIRED_TO_SHIP 18 REVISION 19 REVISION_DESCRIPTION 41 SO_BASIS 51 SUBSTITUTE_COMPONENT 52 SUBSTITUTE_DESCRIPTION 53 SUBSTITUTE_QUANTITY 54 SUBSTITUTE_UOM 31 SUPPLY_LOCATOR 30 SUPPLY_SUBINVENTORY 29 SUPPLY_TYPE 20 UOM 28 YIELD 13 level S Site Bill of Material Structure Report