ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F5D51A9E05362FB09050512Y with q_assemblies as ( select (select mp.organization_code from mtl_parameters mp where bbom.organization_id=mp.organization_id) assembly_organization_code, (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, msiv.inventory_item_status_code assembly_item_status, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) assembly_item_type, 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(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 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, bev.supply_subinventory comp_supply_subinventory, milk.concatenated_segments comp_locator, xxen_util.meaning(msiv.wip_supply_type,'WIP_SUPPLY',700) comp_item_supply_type, msiv.wip_supply_subinventory comp_item_supply_subinventory, (select milk2.concatenated_segments from mtl_item_locations_kfv milk2 where msiv.wip_supply_locator_id=milk2.inventory_location_id and msiv.organization_id=milk2.organization_id) comp_item_supply_locator, xxen_util.yes(case when decode(bev.wip_supply_type,msiv.wip_supply_type,0,1)+decode(bev.supply_subinventory,msiv.wip_supply_subinventory,0,1)+decode(bev.supply_locator_id,msiv.wip_supply_locator_id,0,1)>0 then 'Y' end) comp_supply_attributes_differ, 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, 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(bev.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, &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 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 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_code, qa.assembly_organization, qa.assembly, qa.assembly_description, qa.assembly_long_description, qa.assembly_item_status, qa.assembly_item_type, 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, &assembly_category_columns 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, &component_category_columns 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.comp_item_supply_type org_item_supply_type, qc.comp_item_supply_subinventory org_item_supply_subinventory, qc.comp_item_supply_locator org_item_supply_locator, qc.comp_supply_attributes_differ supply_attributes_differ, 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 Added the component's organization item Work In Process supply attributes (Org Item Supply Type, Org Item Supply Subinventory, Org Item Supply Locator) next to the existing BOM Material Control ones, plus a Supply Attributes Differ column and matching parameter, so BOM and item level supply setup can be audited in one run. Supply Type and Supply Subinventory now always report the bill's own component values. For a commoned bill they previously reported the assembly item's Work In Process attributes, which described neither the bill nor the component, and disagreed with Supply Locator on the same row. Added the assembly organization code, assembly item status and assembly item type columns, and a BOM Vs Org Item Supply Attributes template presenting parent, component and both supply attribute sets side by side. 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 &assbly_dff_attributes1 &assbly_dff_attributes2 &assbly_item_dff_attributes1 &assbly_item_dff_attributes2 &assembly_category_columns &comp_dff_attributes1 &comp_dff_attributes2 &comp_item_dff_attributes1 &comp_item_dff_attributes2 &component_category_columns 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 -80 :p_category_set_id Number select mcsv.category_set_id from mtl_category_sets_vl mcsv where mcsv.category_set_name=nvl(:$flex$.category_set_1,(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet F Ensemble de la catégorie Jeu de catégories I Serie categorie Serie di categorie US Category Set Id ZHS 类别集 类别集 2 -70 :p_report_code Char BOMRBOMSG US Report Code 3 -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 排序依据 按物料工序序号或工序物料序号排序 4 -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 工程清单标志 5 -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 提前期和其它详细资料 打印提前期详细资料 6 -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 组织标识 7 -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 组标识 组标识 8 -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 动态精确度选项 动态精确度 9 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 所有组织 所有组织 10 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 组织层次结构 组织层次结构 11 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. 12 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 13 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 14 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 替代选择 替代选择 15 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 替代项 替代指示符 16 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 版本 物料版本 17 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 日期 有效日期和时间 18 100 &assembly_category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'qa', p_item_id_column=>'assembly_item_id', p_org_id_column=>'assembly_organization_id', p_column_name_prefix=>'Assembly: ') 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=1)) AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet F Ensemble de la catégorie Jeu de catégories I Serie categorie Serie di categorie US Category Set 1 ZHS 类别集 类别集 19 &component_category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'qc', p_item_id_column=>'component_item_id', p_org_id_column=>'comp_org_id', p_column_name_prefix=>'Component: ') sql_text from dual US Category Set 1 20 110 &assembly_category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'qa', p_item_id_column=>'assembly_item_id', p_org_id_column=>'assembly_organization_id', p_column_name_prefix=>'Assembly: ') 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=2)) US Category Set 2 21 &component_category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'qc', p_item_id_column=>'component_item_id', p_org_id_column=>'comp_org_id', p_column_name_prefix=>'Component: ') sql_text from dual US Category Set 2 22 120 &assembly_category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'qa', p_item_id_column=>'assembly_item_id', p_org_id_column=>'assembly_organization_id', p_column_name_prefix=>'Assembly: ') 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 23 &component_category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'qc', p_item_id_column=>'component_item_id', p_org_id_column=>'comp_org_id', p_column_name_prefix=>'Component: ') sql_text from dual US Category Set 3 24 130 :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_name=:$flex$.category_set_1 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 类别自 分类自 25 140 :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_name=:$flex$.category_set_1 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 分类至 26 150 :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 展开层 展开层 27 160 :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 仅限于已实施的 仅限于已实施的 28 170 :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 显示选项 展开选项 29 180 :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 展开数量 展开数量 30 190 :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 替代组件 打印替代组件 31 200 :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 使用计划百分比 使用计划系数 32 210 :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 核实标志 核实标志 33 215 1=1 qc.comp_supply_attributes_differ is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Supply Attributes Differ 34 220 &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: ', p_display_mode=>:assembly_dff_display) sql_text from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US Assembly DFF Display 35 &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: ', p_display_mode=>:assembly_dff_display) from dual US Assembly DFF Display 36 230 &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: ', p_display_mode=>:assembly_item_dff_display) sql_text from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US Assembly Item DFF Display 37 &assbly_dff_attributes2 select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_prefix=>'qa.',p_column_name_prefix=>'Assb Item: ', p_display_mode=>:assembly_item_dff_display) sql_text from dual US Assembly Item DFF Display 38 240 &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: ', p_display_mode=>:component_dff_display) sql_text from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US Component DFF Display 39 &comp_dff_attributes2 select xxen_util.dff_columns(p_table_name=>'bom_components_b',p_prefix=>'qc.',p_column_name_prefix=>'Comp: ', p_display_mode=>:component_dff_display) from dual US Component DFF Display 40 250 &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: ', p_display_mode=>:component_item_dff_display) sql_text from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US Component Item DFF Display 41 &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: ', p_display_mode=>:component_item_dff_display) sql_text from dual US Component Item DFF Display DBF6288D5B8B468496EB56387EA71D6A BOM vs Org Item Supply Attributes SYSADMIN 2 ASSEMBLY 2 4 ASSEMBLY_DESCRIPTION 3 ASSEMBLY_ITEM_STATUS 5 ASSEMBLY_ITEM_TYPE 1 ASSEMBLY_ORGANIZATION_CODE 1 6 COMPONENT 3 7 COMPONENT_DESCRIPTION 10 EFFECTIVITY_DATE 12 ITEM_STATUS 11 ITEM_TYPE 18 ORG_ITEM_SUPPLY_LOCATOR 17 ORG_ITEM_SUPPLY_SUBINVENTORY 16 ORG_ITEM_SUPPLY_TYPE 9 QUANTITY 19 SUPPLY_ATTRIBUTES_DIFFER 15 SUPPLY_LOCATOR 14 SUPPLY_SUBINVENTORY 13 SUPPLY_TYPE 8 UOM S Site B52B6CC693F89BA595A945024257CA86 Bill of Material Structure Report Y SYSADMIN 51 ALTERNATE 6 ALT_BOM_DESIGNATOR 3 7 ALT_BOM_DESIGNATOR_DESC 91 ALT_SORT_ORDER 2 1 ASSEMBLY 1 2 ASSEMBLY_DESCRIPTION 89 ASSEMBLY_HAS_LOOP 4 ASSEMBLY_ITEM_STATUS 5 ASSEMBLY_ITEM_TYPE 3 ASSEMBLY_LONG_DESCRIPTION 8 ASSEMBLY_ORGANIZATION 4 9 ASSEMBLY_ORGANIZATION_CODE 13 ASSEMBLY_REVISION 14 ASSEMBLY_REVISION_DATE 12 ASSEMBLY_UOM 29 Assb Item: Charge Description Master 24 Assb Item: DFF Context 27 Assb Item: Graphical Link for Web Reqs 26 Assb Item: Invoice UOM 30 Assb Item: Item Model 25 Assb Item: Late Demands Penalty 28 Assb Item: Material Over-Capacity Penalty 31 Assb Item: Tax Denomination 23 Assb: Cost of Using a BOM/Routing 22 Assb: DFF Context 16 Assembly: Class 19 Assembly: Commodity 15 Assembly: Family 17 Assembly: Inv.Items Description 18 Assembly: Item Category 20 Assembly: Purchasing Description 10 BOM_ITEM_TYPE 74 CHANGE_NOTICE 65 CHECK_ATP 35 COMPONENT 36 COMPONENT_DESCRIPTION 90 COMPONENT_HAS_LOOP 37 COMPONENT_LONG_DESCRIPTION 92 COMP_SORT_ORDER 5 60 CUMULATIVE_MFG_LEAD_TIME 61 CUMULATIVE_TOTAL_LEAD_TIME 81 Comp Item: Charge Description Master 76 Comp Item: DFF Context 79 Comp Item: Graphical Link for Web Reqs 78 Comp Item: Invoice UOM 82 Comp Item: Item Model 77 Comp Item: Late Demands Penalty 80 Comp Item: Material Over-Capacity Penalty 83 Comp Item: Tax Denomination 45 Component: Class 48 Component: Commodity 44 Component: Family 46 Component: Inv.Items Description 47 Component: Item Category 49 Component: Purchasing Description 21 DESCRIPTIVE_ELEMENTS 73 DISABLE_DATE 72 EFFECTIVITY_DATE 11 ENGINEERING_BILL 50 ENGINEERING_ITEM 42 EXTENDED_QUANTITY 69 INCLUDE_ON_SHIP_DOCS 33 ITEM_SEQ 43 ITEM_STATUS 62 ITEM_TYPE 71 MAX_QTY 57 MFG_LEAD_TIME 70 MIN_QTY 64 MUTUALLY_EXCLUSIVE 59 OPERATION_LEAD_TIME_PERCENT 58 OPERATION_OFFSET 63 OPTIONAL 34 OP_SEQ ORG_ITEM_SUPPLY_LOCATOR ORG_ITEM_SUPPLY_SUBINVENTORY ORG_ITEM_SUPPLY_TYPE 52 PLANNING_PERCENT 41 QUANTITY 75 REFERENCE_DESIGNATORS 68 REQUIRED_FOR_REVENUE 67 REQUIRED_TO_SHIP 38 REVISION 39 REVISION_DESCRIPTION 66 SO_BASIS 84 SUBSTITUTE_COMPONENT 6 85 SUBSTITUTE_DESCRIPTION 86 SUBSTITUTE_LONG_DESCRIPTION 87 SUBSTITUTE_QUANTITY 88 SUBSTITUTE_UOM SUPPLY_ATTRIBUTES_DIFFER 56 SUPPLY_LOCATOR 55 SUPPLY_SUBINVENTORY 54 SUPPLY_TYPE 40 UOM 53 YIELD 32 level S Site 48708AA58AEDE3D71F5C10C7B49D588E Consolidated Bill of Material Report SYSADMIN 25 ALTERNATE 4 ALT_BOM_DESIGNATOR 3 5 ALT_BOM_DESIGNATOR_DESC 56 ALT_SORT_ORDER 2 1 ASSEMBLY 1 2 ASSEMBLY_DESCRIPTION 54 ASSEMBLY_HAS_LOOP 6 ASSEMBLY_ORGANIZATION 4 7 ASSEMBLY_ORGANIZATION_CODE 10 ASSEMBLY_REVISION 11 ASSEMBLY_REVISION_DATE 9 ASSEMBLY_UOM 3 BOM_ITEM_TYPE 48 CHANGE_NOTICE 39 CHECK_ATP 16 COMPONENT 5 17 COMPONENT_DESCRIPTION 55 COMPONENT_HAS_LOOP 57 COMP_SORT_ORDER 34 CUMULATIVE_MFG_LEAD_TIME 35 CUMULATIVE_TOTAL_LEAD_TIME 12 DESCRIPTIVE_ELEMENTS 47 DISABLE_DATE 46 EFFECTIVITY_DATE 8 ENGINEERING_BILL 24 ENGINEERING_ITEM 22 EXTENDED_QUANTITY SUM 43 INCLUDE_ON_SHIP_DOCS 14 ITEM_SEQ 23 ITEM_STATUS 36 ITEM_TYPE 45 MAX_QTY 31 MFG_LEAD_TIME 44 MIN_QTY 38 MUTUALLY_EXCLUSIVE 33 OPERATION_LEAD_TIME_PERCENT 32 OPERATION_OFFSET 37 OPTIONAL 15 OP_SEQ 26 PLANNING_PERCENT 21 QUANTITY SUM 49 REFERENCE_DESIGNATORS 42 REQUIRED_FOR_REVENUE 41 REQUIRED_TO_SHIP 18 REVISION 19 REVISION_DESCRIPTION 40 SO_BASIS 50 SUBSTITUTE_COMPONENT 51 SUBSTITUTE_DESCRIPTION 52 SUBSTITUTE_QUANTITY 53 SUBSTITUTE_UOM 30 SUPPLY_LOCATOR 29 SUPPLY_SUBINVENTORY 28 SUPPLY_TYPE 20 UOM 27 YIELD 13 level S Site ERIC.CLEGG DBF6288D5B8B468496EB56387EA71D6A B52B6CC693F89BA595A945024257CA86