ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations B8DD9131FE72F277E0530100007F06F8 INV Item Description (master) Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments US Inventory item descriptions restricted to the accessible inventory organizations only. 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 F447B2AF28432795E05362FB0905CA30 select x.item, x.item_description, x.item_type, :p_item_rev revision, x.orgcode organization, x.p_level bom_level, x.op op_seq, x.parent bom, x.alternate alternate_bom, x.description bom_description, x.parent_item_type, x.effective_date, x.disable_date, x.basis_type basis, x.quantity, x.uom, x.eng_bill, x.status revised_item_status, x.notice revised_item_eco from ( select msi.concatenated_segments item, msi.description item_description, xxen_util.meaning(msi.item_type,'ITEM_TYPE',3) item_type, bv.display_plan_level p_level, bv.component_op_seq_num op, bv.parent, bv.parent_alternate_designator alternate, bv.parent_description description, xxen_util.meaning(f.item_type,'ITEM_TYPE',3) parent_item_type, msi.inventory_item_status_code item_status, bv.component_effective_date effective_date, bv.component_disable_date disable_date, bv.basis_type basis_type, bv.component_quantity quantity, bv.parent_uom uom, xxen_util.meaning(bv.parent_engineering_bill,'BOM_NO_YES',700) eng_bill, bv.change_notice notice, bv.implemented_flag implemented_flag, bv.lowest_item_id, bv.sort_code, bv.organization_id, bv.revised_item_sequence_id, bom_bomrwuit_xmlp_pkg.get_orgcode(bv.organization_id) orgcode, bom_bomrwuit_xmlp_pkg.get_status(bv.revised_item_sequence_id, bv.implemented_flag, bv.change_notice) status from mtl_system_items_vl msi, mtl_item_flexfields f, bom_implosion_view bv where bv.lowest_item_id = msi.inventory_item_id and msi.organization_id = bv.organization_id and bv.parent_item_id = f.item_id and bv.organization_id = f.organization_id and bv.parent is not null and bv.sequence_id = :p_sequence_id and bv.current_level != 0 and nvl(xxen_util.lookup_code(:p_top_assly_flg,'SYS_YES_NO',700), 2) = 2 &lp_top_assemblies_only_qry ) x where 1=1 order by x.item, x.orgcode, x.lowest_item_id, x.sort_code Y XXEN_BOM AR BOM واجهة المستخدم الرسومية لتقرير محل استخدام الصنف (تنسيق XML) Imported from BI Publisher Description: تقرير محل استخدام الصنف Application: شجرة المنتجات Source: واجهة المستخدم الرسومية لتقرير محل استخدام الصنف (تنسيق XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG D BOM Artikel - Verwendungsnachweis (SC) - XML Imported from BI Publisher Description: Artikel - Verwendungsnachweis Application: Produktionsdaten Source: Artikel - Verwendungsnachweis (SC) - XML Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG E BOM Uso de Artículos - GUI Imported from BI Publisher Description: Informe de uso de artículos Application: Bills of Material Source: Uso de Artículos - GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG F BOM Etat Cas d'emploi des articles - GUI Imported from BI Publisher Description: Etat Cas d'emploi des articles Application: Bills of Material Source: Etat Cas d'emploi des articles - GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG I BOM GUI rapporto Sede impiego articolo Imported from BI Publisher Description: Rapporto Sede impiego articolo Application: Bills of Material Source: GUI rapporto Sede impiego articolo (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG JA BOM 品目使用箇所レポート GUI Imported from BI Publisher Description: 品目使用箇所レポート Application: Bills of Material Source: 品目使用箇所レポート GUI(XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG KO BOM 품목 사용처 보고서 GUI Imported from BI Publisher Description: 품목 사용처 보고서 Application: Bills of Material Source: 품목 사용처 보고서 GUI(XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG PTB BOM Relatório de Utilização de Item GUI Imported from BI Publisher Description: Relat. Utilização Item Application: Bills of Material Source: Relatório de Utilização de Item GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG RU BOM ГИП ведомости использования позиций Imported from BI Publisher Description: Ведомость использования позиций Application: Спецификации Source: ГИП ведомости использования позиций (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG S BOM Artikel ingår i - rapport GUI Imported from BI Publisher Description: Artikel ingår i - rapport Application: Bills of Material Source: Artikel ingår i - rapport GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG TR BOM Kalem Kullanım Yeri Raporu Imported from BI Publisher Description: Kalem Kullanım Yeri Raporu Application: Ürün Ağacı Source: Kalem Kullanım Yeri Raporu (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG US BOM Item Where Used GUI Description: Item Where Used GUI Report Provides equivalent functionality to the the following standard reports: - Item Where Used Report GUI Application: Bills of Material Source: Item Where Used Report GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG ZHS BOM 物料使用处报表 GUI Imported from BI Publisher Description: 物料使用处报表 Application: 物料清单管理系统 Source: 物料使用处报表 GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG Enginatics R12 only &lp_top_assemblies_only_qry 1=1 :p_all_orgs :p_cat_from :p_cat_to :p_category_set :p_conc_request_id :p_date :p_date_option :p_eng_bill_flag :p_implemented :p_item :p_item_from :p_item_rev :p_item_to :p_level :p_master_org_id :p_org_code :p_org_hierarchy :p_org_id :p_qty_precision :p_report_code :p_sequence_id :p_top_assly_flg 1 -10 :p_report_code Char BOMRWUITG US Report Code 2 10 :p_eng_bill_flag LOV custom Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav where fav.application_short_name in ('BOM','ENG') order by value BOM Y AR علامة شجرة المنتج الهندسية علامة فاتورة هندسية D Konstruktionsstückliste Konstruktionsstückliste E Lista de Diseño Lista de Diseño F Indicateur Nomenclature d'étude Indicateur Nomenclature étude I Flag Distinta tecnica Flag Distinta tecnica JA 設計構成表フラグ 設計構成表フラグ KO 설계 BOM 플래그 설계 BOM 플래그 PTB Indicador de Lista de Eng. Indicador de Lista de Engenharia RU Флаг технологической спецификации Флаг технологической спецификации S Konstr.strukt.flagga Konstruktionsstruktur-flagga TR Mühendislik Faturası İşareti Mühendislik faturası işareti US Application Engineering bill flag ZHS 工程清单标志 工程清单标志 3 20 :p_org_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select organization_code from mtl_parameters where organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR BOM_SRS_ORG_ID معرف تنظيم D BOM_SRS_ORG_ID Organisationskennung E BOM_SRS_ORG_ID Id Organización F BOM_SRS_ORG_ID ID org. I BOM_SRS_ORG_ID ID dell'organizzazione JA BOM_SRS_ORG_ID 組織ID KO BOM_SRS_ORG_ID 조직 ID PTB BOM_SRS_ORG_ID Id da Org. RU BOM_SRS_ORG_ID Идентификатор организации S BOM_SRS_ORG_ID Org.-id TR BOM_SRS_ORG_ID Org no US Organization Code Organization ZHS BOM_SRS_ORG_ID 组织标识 4 30 :p_all_orgs LOV custom Y select meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR كل التنظيمات كل التنظيمات D Alle Organisationen Alle Organisationen E Todas las Organizaciones Todas las Organizaciones F Toutes les organisations Toutes les organisations I Tutte le organizzazioni Tutte le organizzazioni JA 全組織 全組織 KO 모든 조직 모든 조직 PTB Todas as Organizações Todas as Organizações RU Все организации Все организации S Alla organisationer Alla organisationer TR Tüm Organizasyonlar Tüm Organizasyonlar US All Organizations All Organizations ZHS 所有组织 所有组织 5 40 :p_org_hierarchy LOV custom Y select pos.name value, null description from mtl_parameters mp, per_organization_structures pos where mp.organization_code = :$flex$.organization_code and pos.business_group_id=fnd_global.per_business_group_id and inv_orghierarchy_pvt.org_hierarchy_access(pos.name)='Y' and inv_orghierarchy_pvt.org_hierarchy_level_access(pos.name,mp.organization_id)='Y' and xxen_util.lookup_code(:$flex$.all_organizations,'SYS_YES_NO',700) = 2 order by pos.name AR تدرج التنظيم تدرج التنظيم D Organisationshierarchie Organisationshierarchie E Jerarquía de Organizaciones Jerarquía de Organizaciones F Hiérarchie des organisations Hiérarchie des organisations I Gerarchia organizzazione Gerarchia organizzazione JA 組織階層 組織階層 KO 조직 계층 조직 계층 PTB Hierarquia da Organização Hierarquia da Organização RU Иерархия организаций Иерархия организаций S Organisationshierarki Organisationshierarki TR Organizasyon Hiyerarşisi Organizasyon Hiyerarşisi US Organization Hierarchy Organization Hierarchy ZHS 组织层次结构 组织层次结构 6 50 1=1 x.item = :p_item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Item 7 60 1=1 upper(x.item_description) like upper(:item_descr) LOV INV Item Description (master) B8DD9131FE72F277E0530100007F06F8 Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments US Item Description 8 70 1=1 x.item_type=:p_item_type LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Item Type 9 80 1=1 x.item_type!=:p_item_type_exclude LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Exclude Item Type 10 90 :p_item_rev LOV custom Y select birv.revision value, null description from mtl_parameters mp, mtl_system_items_vl msiv, bom_item_revisions_view birv where msiv.organization_id = mp.organization_id and birv.organization_id = msiv.organization_id and birv.inventory_item_id = msiv.inventory_item_id and mp.organization_code = :$flex$.organization_code and msiv.concatenated_segments = :$flex$.item order by fnd_date.canonical_to_date(birv.effectivity_date), birv.revision select bicrv.current_revision from mtl_parameters mp, mtl_system_items_vl msiv, bom_item_current_rev_view bicrv where msiv.organization_id = mp.organization_id and bicrv.organization_id = msiv.organization_id and bicrv.inventory_item_id = msiv.inventory_item_id and mp.organization_code = :$flex$.organization_code and msiv.concatenated_segments = :$flex$.item AR المراجعة مراجعة الصنف D Version Artikelversion E Revisión Revisión de Artículo F Version Version article I Revisione Revisione articolo JA 改訂 品目改訂 KO 개정 품목 개정 PTB Revisão Revisão de item RU Версия Версия позиции S Revision artikelrevision TR Revizyon kalem revizyonu US Revision item revision ZHS 版本 物料版本 11 100 :p_item_from LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments AR أصناف من صنف من D Von Artikel Von Artikel E De Artículo de artículo F Articles - De Article - De I Articoli da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De item - de RU Позиция с Начальная позиция S Artiklar från artikel från TR Kalemler: İlk kalem: ilk US Item From item from ZHS 物料自 物料自 12 110 :p_item_to LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments AR إلى صنف إلى D Bis Bis Artikel E A a artículo F A Article - A I A Articoli - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Item - Até RU По Конечная позиция S Till artikel till TR Son kalem: son US Item To item to ZHS 至 物料至 13 120 :p_category_set 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 select category_set_name from mtl_default_sets_view where functional_area_id = 1 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주세트 범주 세트 PTB Conjunto de Categorias conjunto de categorias RU Набор категорий Набор категорий S Kategoriserie kategoriserie TR Kategori Kümesi kategori kümesi US Category Set category set ZHS 分类集 分类集 14 130 :p_cat_from LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs AR الفئات من الفئات من D Ab Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De categorias - de RU Категория с Категория с S Kategorier från kategorier från TR Kategoriler: İlk kategoriler: ilk US Category From categories from ZHS 分类自 分类自 15 140 :p_cat_to LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs AR إلى 2 الفئات إلى D Bis 2 Bis Kategorie E A 2 A categoría F A 2 Catégories - A I A 2 Categorie - A JA 至 2 カテゴリ:至 KO 까지 2 범주: 까지 PTB Até 2 categorias - até RU По 2 Категория по S Till 2 kategorier till TR Son 2 kategoriler: son US Category To categories to ZHS 至 2 分类至 16 150 :p_level Number select bp.maximum_bom_level from mtl_parameters mp, bom_parameters bp where mp.organization_id = bp.organization_id and mp.organization_code = :$flex$.organization_code Y AR BOM_SRS_LEVELS مستوى الانفجار الداخلي D BOM_SRS_LEVELS Verdichtete Ebene E BOM_SRS_LEVELS nivel de implosión F BOM_SRS_LEVELS Niveau de consolidation I BOM_SRS_LEVELS Livelli da implodere JA BOM_SRS_LEVELS 逆展開レベル KO BOM_SRS_LEVELS 부품사용처 결정 레벨 PTB BOM_SRS_LEVELS níveis para implosão RU BOM_SRS_LEVELS Уровень свертывания S BOM_SRS_LEVELS Ingår i-analys TR BOM_SRS_LEVELS kullanım yeri saptama düzeyi US Levels To Implode implosion level ZHS BOM_SRS_LEVELS 展开层 17 160 :p_implemented LOV custom Y select meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 1 Y AR المنفذ فقط تنفيذ فقط D Nur implementiert Nur implementiert E Sólo Implementados implantar sólo F Appliqué seulement Appliquer seulement I Solo implementati Solo implementati JA 実施済のみ 実施のみ KO 이행 완료만 이행전용 PTB Apenas Implementados apenas implementação RU Только внедренные Только внедрение S Endast införda endast implementering TR Salt Uygulanan salt uygula US Implemented Only implement only ZHS 仅限于已实施 仅限于实施 18 170 :p_date_option LOV custom Y select meaning value, null description from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' and ((:$flex$.levels_to_implode=1) or (:$flex$.levels_to_implode != 1 and (lookup_code=2 or lookup_code=3)) ) order by value select meaning from mfg_lookups where lookup_type = 'BOM_INQUIRY_DISPLAY_TYPE' and lookup_code = 2 Y AR خيارات العرض آجل أو حالي أو كلاهما D Anzeigeoption Zukünftige oder aktuelle oder beide E Opción de Visualización Futuro o actual o ambos F Option d'affichage Futur, actuel ou les deux I Opzione Visualizza Futuro, corrente o entrambi JA 表示オプション 将来または現行または両方 KO 옵션 표시 미래나 현재 또는 두 가지 모두 PTB Opção de Exibição Futuro, atual ou ambos RU Режим просмотра Будущие, текущие или оба варианта S Visa Senare, aktuell eller båda TR Görüntü Seçeneği Gelecekteki veya şimdiki veya her ikisi US Display Option Future or current or both ZHS 显示选项 将来、当前或两者兼有 19 180 :p_date DateTime select nvl( (select fnd_date.canonical_to_date(birv.high_date) from mtl_parameters mp, mtl_system_items_vl msiv, bom_item_revisions_view birv where msiv.organization_id = mp.organization_id and birv.organization_id = msiv.organization_id and birv.inventory_item_id = msiv.inventory_item_id and mp.organization_code = :$flex$.organization_code and msiv.concatenated_segments = :$flex$.item and birv.revision = :$flex$.revision ), sysdate ) from dual AR التاريخ وقت وتاريخ سريان المفعول D Datum Gültigkeitsdatum und -zeit E Fecha Fecha y Hora en Vigor F Date Date et heure de validité I Data Data e ora validità JA 日付 有効日時 KO 일자 유효 일자 및 시간 PTB Data Data e Hora de Efetivação RU Дата Дата и время действия S Datum Giltighetsdatum och -tid TR Tarih Geçerlilik Tarihi ve Saati US Date Effective Date and Time ZHS 日期 有效日期和时间 20 190 :p_top_assly_flg LOV custom Y select meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' and ( lookup_code = 2 or exists (select null from dba_source where name = 'BOM_BOMRWUIT_XMLP_PKG' and type = 'PACKAGE' and lower(text) like '%p_top_assly_flg%' ) ) order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR أعلى المنتجات فقط أعلى المنتجات فقط D Nur Baugruppen höchster Ebene Nur Baugruppen höchster Ebene E Solo Conjuntos Principales Solo Conjuntos Principales F Produits finis seulement Produits finis seulement I Solo assiemi principali Solo assiemi principali JA 上位組立のみ 上位組立のみ KO 최상위 조립품만 최상위 조립품만 PTB Somente Montagens Superiores Somente Montagens Superiores RU Только главные сборки Только главные сборки S Endast de bästa produkterna Endast de bästa produkterna TR Sadece En Üst Ürünler Sadece En Üst Ürünler US Top Assemblies Only Top Assemblies Only ZHS 仅顶层装配件 仅顶层装配件 21 &lp_top_assemblies_only_qry union all select msi.concatenated_segments l_item, msi.description l_description, xxen_util.meaning(msi.item_type,'ITEM_TYPE',3) item_type, bv.display_plan_level p_level, bv.component_op_seq_num op, bv.parent, bv.parent_alternate_designator alternate, bv.parent_description description, xxen_util.meaning(f.item_type,'ITEM_TYPE',3) parent_item_type, msi.inventory_item_status_code item_status, bv.component_effective_date effective_date, bv.component_disable_date disable_date, bv.basis_type basis_type, bv.component_quantity quantity, bv.parent_uom uom, xxen_util.meaning(bv.parent_engineering_bill,'BOM_NO_YES',700) eng_bill, bv.change_notice notice, bv.implemented_flag implemented_flag, bv.lowest_item_id, bv.sort_code, bv.organization_id, bv.revised_item_sequence_id, bom_bomrwuit_xmlp_pkg.get_orgcode(bv.organization_id) c_orgcode, bom_bomrwuit_xmlp_pkg.get_status(bv.revised_item_sequence_id, bv.implemented_flag, bv.change_notice) c_status from mtl_system_items_vl msi, mtl_item_flexfields f, bom_implosion_view bv where bv.lowest_item_id = msi.inventory_item_id and msi.organization_id = bv.organization_id and bv.parent_item_id = f.item_id and bv.organization_id = f.organization_id and bv.parent is not null and bv.sequence_id = :p_sequence_id and bv.current_level != 0 and nvl(xxen_util.lookup_code(:p_top_assly_flg,'SYS_YES_NO',700), 2) = 1 and bv.parent_item_id not in (select /*+ push_subq no_unnest */ bv1.current_item_id from bom_implosion_temp bv1 where bv1.sequence_id = :p_sequence_id and bv1.lowest_item_id = bv.lowest_item_id ) xxen_util.meaning(1,'SYS_YES_NO',700) US Top Assemblies Only 22 &lp_top_assemblies_only_qry and 'Y'='Y' xxen_util.meaning(2,'SYS_YES_NO',700) US Top Assemblies Only :$flex$.all_organizations All Organizations Organization Hierarchy :$flex$.category_set Category Set Category From :$flex$.category_set Category Set Category To :$flex$.item Item Date :$flex$.item Item Revision :$flex$.levels_to_implode Levels To Implode Display Option :$flex$.organization_code Organization Code Category Set :$flex$.organization_code Organization Code Date :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Item From :$flex$.organization_code Organization Code Item To :$flex$.organization_code Organization Code Levels To Implode :$flex$.organization_code Organization Code Organization Hierarchy :$flex$.organization_code Organization Code Revision :$flex$.revision Revision Date