ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F6B51A9E05362FB09050512Y select rtg.common_routing_sequence_id common_sequence_id, rtg.routing_sequence_id routing_sequence_id, rtg.alternate_routing_designator alternate_designator, rtg.assembly_item_id assembly_item_id, INV_MEANING_SEL.C_ITEM_DESCRIPTION(item1.inventory_item_id,item1.organization_id) assembly_desc, item1.primary_uom_code routing_uom, INV_MEANING_SEL.C_ITEM_DESCRIPTION(item2.inventory_item_id,item2.organization_id) common_desc, alt.description alt_desc, rtg.common_assembly_item_id common_assembly_item_id, rtg.routing_comment routing_comment, rtg.completion_subinventory completion_subinventory, rtg.completion_locator_id completion_locator_id, null assembly_flex_values, null common_flex_values, null locator_flex_values, rev.process_revision, ROUND(item1.full_lead_time,:P_qty_precision) full_lead_time, ROUND(item1.fixed_lead_time,:P_qty_precision) fixed_lead_time, ROUND(item1.variable_lead_time,:P_qty_precision) variable_lead_time, lu1.meaning eng_routing, fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly_flex_format', 'INV', 'MSTK', 101, item1.ORGANIZATION_ID, item1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') assembly_flex_format, fnd_flex_xml_publisher_apis.process_kff_combination_1('common_flex_format', 'INV', 'MSTK', 101, item2.ORGANIZATION_ID, item2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') common_flex_format, fnd_flex_xml_publisher_apis.process_kff_combination_1('locator_flex_format', 'INV', 'MTLL', 101, locator.ORGANIZATION_ID, locator.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') locator_flex_format from bom_operational_routings rtg, mtl_system_items item1, mtl_system_items item2, mtl_item_locations locator, mtl_rtg_item_revisions rev, mtl_item_categories icat, mtl_categories cat, bom_alternate_designators alt, mfg_lookups lu1 where rtg.organization_id = :P_ORG_ID and ((rtg.routing_type = 1 and :P_BOM_OR_ENG = 'BOM') or (:P_BOM_OR_ENG = 'ENG')) and rtg.assembly_item_id = item1.inventory_item_id and rtg.organization_id = item1.organization_id and item1.bom_enabled_flag = 'Y' and rtg.common_assembly_item_id = item2.inventory_item_id (+) and rtg.organization_id = item2.organization_id (+) and rtg.completion_locator_id = locator.inventory_location_id (+) and rtg.organization_id = locator.organization_id (+) and nvl(rtg.alternate_routing_designator,'NONE') = nvl(alt.alternate_designator_code,'NONE') and (rtg.organization_id = alt.organization_id or alt.organization_id = -1) and nvl(rtg.common_assembly_item_id,rtg.assembly_item_id) = rev.inventory_item_id and rtg.organization_id = rev.organization_id and rev.effectivity_date = (select max(rev2.effectivity_date) from mtl_rtg_item_revisions rev2 where rev2.effectivity_date <= :P_EFF_DATE1 and rev2.implementation_date is not null and rev2.inventory_item_id = nvl(rtg.common_assembly_item_id,rtg.assembly_item_id) and rev2.organization_id = rtg.organization_id) and rev.process_revision = (select max(rev3.process_revision) from mtl_rtg_item_revisions rev3 where rev3.implementation_date is not null and rev3.inventory_item_id = nvl(rtg.common_assembly_item_id,rtg.assembly_item_id) and rev3.organization_id = rtg.organization_id and rev3.effectivity_date = rev.effectivity_date) and ((:P_ALT_OPTION = 1) or (:P_ALT_OPTION = 2 and rtg.alternate_routing_designator is null) or (:P_ALT_OPTION = 3 and rtg.alternate_routing_designator = :P_ALTERNATE)) and ((:P_RPT_SELECTION = 1 and rtg.assembly_item_id = :P_ITEM) or (:P_RPT_SELECTION = 2 and &P_ASSY_BETWEEN)) and :P_CAT_SET = icat.category_set_id and rtg.assembly_item_id = icat.inventory_item_id and rtg.organization_id = icat.organization_id and cat.category_id = icat.category_id and &P_CAT_BETWEEN and lu1.lookup_code = rtg.routing_type and lu1.lookup_type = 'BOM_NO_YES' ORDER by &P_ASSY_ORDER, nvl(rtg.alternate_routing_designator,' ') BOM BOMRDRTGS_XML AR BOM تقرير التوجيه لفترة تسليم التصنيع (تنسيق XML) Imported from BI Publisher Description: تقرير التوجيه لفترة تسليم التصنيع Application: شجرة المنتجات Source: تقرير التوجيه لفترة تسليم التصنيع (تنسيق XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG D BOM Arbeitspläne - Fertigungsdurchlaufzeiten Imported from BI Publisher Description: Arbeitspläne - Fertigungsdurchlaufzeiten Application: Produktionsdaten Source: Arbeitspläne - Fertigungsdurchlaufzeiten (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG E BOM Rutas para Plazo de Fabricación Imported from BI Publisher Description: Rutas para Plazo de Fabricación Application: Bills of Material Source: Rutas para Plazo de Fabricación (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG F BOM Etat des gammes pour calcul des délais de fabrication Imported from BI Publisher Description: Etat des gammes pour calcul des délais de fabrication Application: Bills of Material Source: Etat des gammes pour calcul des délais de fabrication (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG I BOM Rapporto Ciclo per lead time di produzione Imported from BI Publisher Description: Rapporto Ciclo per lead time di produzione Application: Bills of Material Source: Rapporto Ciclo per lead time di produzione (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG JA BOM 製造リード・タイム用工順レポート Imported from BI Publisher Description: 製造リード・タイム用工順レポート Application: Bills of Material Source: 製造リード・タイム用工順レポート(XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG KO BOM 제조 리드타임용 공정순서 보고서 Imported from BI Publisher Description: 제조 리드타임용 공정순서 보고서 Application: Bills of Material Source: 제조 리드타임용 공정순서 보고서(XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG PTB BOM Relatório de Roteiro para Lead Time de Fabricação Imported from BI Publisher Description: Relatório de Roteiro para Lead Time de Fabricação Application: Bills of Material Source: Relatório de Roteiro para Lead Time de Fabricação (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG RU BOM Отчет о техкартах для времени производства Imported from BI Publisher Description: Отчет о техкартах для времени производства Application: Спецификации Source: Отчет о техкартах для времени производства (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG S BOM Operationsföljdsrapport för tillverkningsledtid Imported from BI Publisher Description: Operationsföljdsrapport för tillverkningsledtid Application: Bills of Material Source: Operationsföljdsrapport för tillverkningsledtid (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG TR BOM Üretim Bekleme Süresi için Rota Raporu Imported from BI Publisher Description: Üretim Bekleme Süresi için Rota Raporu Application: Ürün Ağacı Source: Üretim Bekleme Süresi için Rota Raporu (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG US BOM Routing Report for Manufacturing Lead Time Imported from BI Publisher Description: Routing Report for Manufacturing Lead Time Application: Bills of Material Source: Routing Report for Manufacturing Lead Time (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG ZHS BOM 制造提前期的工艺路线报表 Imported from BI Publisher Description: 制造提前期的工艺路线报表 Application: 物料清单管理系统 Source: 制造提前期的工艺路线报表 (XML) Short Name: BOMRDRTGS_XML DB package: BOM_BOMRDRTG_XMLP_PKG BI Publisher &p_assy_between &p_assy_order &p_cat_between :p_alt_option :p_alt_option_char :p_alternate :p_assembly :p_assy_between :p_assy_order :p_bom_or_eng :p_cat_between :p_cat_from :p_cat_set :p_cat_set_name :p_cat_struct :p_cat_to :p_common :p_conc_request_id :p_currency_code :p_debug :p_detail :p_detail_char :p_display_option :p_display_option_char :p_dtl_sum_char :p_eff_date :p_eff_date1 :p_item :p_item_from :p_item_to :p_locator :p_msg_buf :p_org_id :p_org_name :p_prv_inst_cnt :p_prv_rsc_cnt :p_qty_precision :p_revision :p_rpt_selection :p_rpt_selection_char :p_specific_item_flex :p_struct_assy :p_struct_common :p_struct_locator 1 -70 :p_alt_option 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 select MEANING from MFG_LOOKUPS where LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION' and LOOKUP_CODE = 2 Y AR BOM_SRS_ALT_OPTION الكل أو الأساسي أو المحدد D BOM_SRS_ALT_OPTION Alle, primäre oder bestimmte E BOM_SRS_ALT_OPTION Todo, Primario o Específico F BOM_SRS_ALT_OPTION Tout, principal ou spécifique I BOM_SRS_ALT_OPTION Tutto, principale o specifico JA BOM_SRS_ALT_OPTION 全て、プライマリまたは指定 KO BOM_SRS_ALT_OPTION 전체, 주요 또는 특정 PTB BOM_SRS_ALT_OPTION Todos, primário ou específico RU BOM_SRS_ALT_OPTION Все, первичный или конкретный S BOM_SRS_ALT_OPTION Alla, primära eller specifika TR BOM_SRS_ALT_OPTION Tümü, birincil veya özel US BOM_SRS_ALT_OPTION All, primary or specific ZHS BOM_SRS_ALT_OPTION 全部、主要或特定 2 -60 :p_display_option LOV Oracle BOM_SRS_DISPLAY_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' order by meaning select MEANING from MFG_LOOKUPS where LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE' and LOOKUP_CODE = 2 Y AR خيارات العرض خيار عرض العملية D Anzeigeoption Anzeigeoption Arbeitsvorgang E Opción de Visualización Opción de Visualización de Operación F Option d'affichage Option affich. opération I Opzione di visualizzazione Opzione di visualizzazione operazione JA 表示オプション 工程表示オプション KO 표시 옵션 공정 표시 옵션 PTB Opção de Exibição Opção de exibição da operação RU Режим просмотра Режим просмотра производственной операции S Visningsalternativ Alternativ för operationsvisning TR Görüntüleme Seçeneği Operasyon görüntüleme seçeneği US Display Option Operation display option ZHS 显示选项 工序显示选项 3 -50 :p_detail 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 select MEANING from MFG_LOOKUPS where LOOKUP_TYPE = 'SYS_YES_NO' and LOOKUP_CODE = 1 Y AR تفاصيل العملية تفاصيل العملية نعم/لا D Details Arbeitsvorgang Details Arbeitsvorgang Ja/Nein E Detalle de Operación Detalle de Operación Sí/No F Détail opération Détail opération oui/non I Dettagli operazione Dettagli operazione Sì/No JA 工程詳細 工程詳細 Yes/No KO 공정 상세내역 공정 상세내역 yes/no PTB Detal. Operação Detalhe da operação sim/não RU Сведения о производственной операции Сведения о производственной операции ("Да" или "Нет") S Operationsdetalj Operationsdetalj, ja/nej TR Operasyon Detayı Operasyon detayı evet/hayır US Operation Detail Operation detail yes/no ZHS 工序详细信息 工序详细资料是/否 4 -40 :p_cat_struct Number select structure_id from mtl_category_sets where category_set_id = :$flex$.category_set Y AR هيكل الفئة هيكل حقل الفئة المرن D Kategoriestruktur Kategorie-FlexFeld-Struktur E Estructura de Categoría Tipo de Estructura de Categoría F Structure de catégorie Structure de clé flexible Catégorie I Struttura categoria Struttura flexfield Categoria JA カテゴリ体系 カテゴリ・フレックスフィールド体系 KO 범주 구조 범주 가변필드 구조 PTB Estrutura da Categoria Estrutura de flexfield da categoria RU Структура категорий Структура гибких полей категорий S Kategoristruktur Flexfältsstruktur för kategori TR Kategori Yapısı Kategori esnekalan yapısı US Category Structure Category flexfield structure ZHS 类别结构 类别弹性结构 5 -30 :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') Y AR دقة الكمية الدقة المستخدمة للكميات D Nachkommastellen Nachkommastellen bei Mengen E Precisión de Cantidad Precisión para utilizar con las cantidades F Précision des quantités Précision à utiliser pour les quantités I Precisione quantità Precisione da utilizzare per quantità JA 数量精度 数量に使用する精度 KO 수량 소수점 이하 자리수 수량에 대해 사용할 소수점자리 PTB Precisão da Quantidade Precisão a ser utilizada para quantidades RU Точность количества Точность измерения количества S Kvantitetsprecision Precision för kvantiteter TR Miktar Duyarlılığı Miktarlar için kullanılacak duyarlılık US Quantity Precision Precision to use for quantities ZHS 数量精确度 数量精确度 6 -10 :p_dummy Number SELECT 1 FROM DUAL WHERE (:$flex$.item_selection <> '1' OR :$FLEX$.BOM_SRS_SPECIFIC_ROUTING:NULL IS NOT NULL) Y AR الصنف 2 الحقل الافتراضي لفرض القيمة الشرطية مطلوب D Artikel 2 Dummy-Feld für die Vorgabe von "Bedingt erforderlich" E Artículo 2 Campo ficticio para aplicar valores necesarios de forma condicional F Article 2 Champ fictif pour l'application de Obligatoire selon contexte I Articolo 2 Campo fittizio per applicazione condizionale obbligatorio JA 品目 2 条件必須を使用するためのダミー・フィールド KO 품목 2 조건부 집행을 위한 Dummy 필드 필수 PTB Item 2 Campo Fictício para Impor Condicional Obrigatório RU Позиция 2 Фиктивное поле для использования обязательных при определенных условиях S Artikel 2 Dummy-fält för att genomföra villkorsberoende TR Kalem 2 Gerekli Koşulu Uygulamak için Sözde Alan US Item 2 Dummy Field for Enforcing Conditional Required ZHS 物料 2 用来实施“有条件”/“必备”条件的虚拟字段 7 10 :p_org_id Number 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 organisation 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 Organização RU BOM_SRS_ORG_ID Идентификатор организации S BOM_SRS_ORG_ID Organisations-id TR BOM_SRS_ORG_ID Organizasyon No US BOM_SRS_ORG_ID Organization Id ZHS BOM_SRS_ORG_ID 组织标识 8 20 :p_bom_or_eng Char fnd_profile.value('BOM_OR_ENG') Y AR BOM_SRS_NONE_CHAR BOM أو هندسي D BOM_SRS_NONE_CHAR PD oder KON E BOM_SRS_NONE_CHAR BOM o ENG F BOM_SRS_NONE_CHAR BOM ou ENG I BOM_SRS_NONE_CHAR BOM o ENG JA BOM_SRS_NONE_CHAR BOMまたはENG KO BOM_SRS_NONE_CHAR BOM 혹은 ENG PTB BOM_SRS_NONE_CHAR BOM ou ENG RU BOM_SRS_NONE_CHAR СП или ТПП S BOM_SRS_NONE_CHAR BOM eller ENG TR BOM_SRS_NONE_CHAR Ürün Ağacı veya Mühendislik US BOM_SRS_NONE_CHAR BOM or ENG ZHS BOM_SRS_NONE_CHAR BOM 或 ENG 9 30 :p_rpt_selection LOV Oracle BOM_SRS_ITEM_RANGE_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='BOM_SELECTION_TYPE' order by meaning select MEANING from MFG_LOOKUPS where LOOKUP_TYPE = 'BOM_SELECTION_TYPE' and LOOKUP_CODE = 1 Y AR اختيار الصنف محدد أو مدى D Artikelauswahl Einzeln oder Bereich E Selección de Artículos Específico o Rango F Sélection d'articles Spécifique ou fourchette I Selezione articolo Specifico o intervallo JA 品目選択 指定または範囲 KO 품목 선택 특정 또는 범위 PTB Seleção de Item Específico ou faixa RU Отбор позиций Значение или диапазон S Artikelurval Specifik eller intervall TR Kalem Seçimi Özel veya sıra US Item Selection Specific or range ZHS 物料选择 特定或范围 10 40 :p_item Char AR BOM_SRS_SPECIFIC_ROUTING الصنف المحدد D BOM_SRS_SPECIFIC_ROUTING Bestimmter Artikel E BOM_SRS_SPECIFIC_ROUTING Artículo Específico F BOM_SRS_SPECIFIC_ROUTING Article spécifique I BOM_SRS_SPECIFIC_ROUTING Articolo specifico JA BOM_SRS_SPECIFIC_ROUTING 特定品目 KO BOM_SRS_SPECIFIC_ROUTING 특정 품목 PTB BOM_SRS_SPECIFIC_ROUTING Item Específico RU BOM_SRS_SPECIFIC_ROUTING Конкретная позиция S BOM_SRS_SPECIFIC_ROUTING Specifik artikel TR BOM_SRS_SPECIFIC_ROUTING Özel Kalem US BOM_SRS_SPECIFIC_ROUTING Specific Item ZHS BOM_SRS_SPECIFIC_ROUTING 特定物料 11 50 :p_revision LOV Oracle BOM_SRS_ROUTING_REVISION Y select process_revision id, process_revision value, null description from bom_routing_revisions_view where :$flex$.bom_srs_specific_routing is not null and organization_id=:$flex$.bom_srs_org_id and inventory_item_id=(select nvl(common_assembly_item_id,assembly_item_id) from bom_operational_routings where organization_id= :$flex$.bom_srs_org_id and assembly_item_id= :$flex$.bom_srs_specific_routing and nvl(alternate_routing_designator,'NONE')= nvl(:$flex$.bom_srs_routing_alternate:null,'NONE')) order by fnd_date.canonical_to_date(effectivity_date), process_revision AR المراجعة المراجعة D Version Version E Revisión Revisión F Version Version I Revisione Revisione JA 改訂 改訂 KO 개정 개정 PTB Revisão Revisão RU Версия Версия TR Revizyon Revizyon US Revision Revision ZHS 版本 版本 12 60 :p_eff_date DateTime sysdate Y AR التاريخ تاريخ الفعالية D Datum Gültigkeitsdatum E Fecha Fecha en Vigor F Date Date validité I Data Data validità JA 日付 有効日 KO 일자 유효 일자 PTB Data Data de efetivação RU Дата Дата действия S Datum Giltighetsdatum TR Tarih Geçerlilik tarihi US Date Effective date ZHS 日期 有效日期 13 70 :p_item_from Char AR الأصناف من مدى الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Fourchette d'articles - De I Articoli - Da Intervallo articoli - Da JA 品目:自 品目範囲:自 KO 품목: 부터 품목 범위: 부터 PTB Itens - De Itens - De RU Позиции с Нижняя граница диапазона позиций S Från artiklar Artikelintervall från TR Kalemler, İlk Kalem aralığı: İlk US Items From Item range from ZHS 物料自 物料起始范围 14 80 :p_item_to Char AR الأصناف إلى مدى الصنف إلى D Bis Artikel Bis Artikel E A Artículo A Artículo F Articles - A Fourchette d'articles - A I Articoli - A Intervallo articoli - A JA 品目:至 品目範囲:至 KO 품목: 까지 품목 범위: 까지 PTB Itens - Até Itens - Até RU Позиции по Верхняя граница диапазона позиций S Till artiklar Artikelintervall till TR Kalemler, Son Kalem aralığı: Son US Items To Item range to ZHS 物料至 物料截止范围 15 90 :p_cat_set 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_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 Conj. Categorias Conj. Categorias RU Набор категорий Набор категорий S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 16 100 :p_cat_from Char AR الفئات من مدى الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Fourchette de catégories - De I Categorie - Da Intervallo categorie - Da JA カテゴリ:自 カテゴリ範囲:自 KO 범주: 부터 범주 범위: 부터 PTB Categorias - De Categorias - De RU Категории с Нижняя граница диапазона категорий S Från kategorier Kategoriintervall från TR Kategoriler, İlk Kategori aralığı: İlk US Categories From Category range from ZHS 类别自 类别起始范围 17 110 :p_cat_to Char AR الفئات إلى مدى الفئة إلى D Bis Kategorie Bis Kategorie E A Categoría A Categoría F Catégories - A Fourchette de catégories - A I Categorie - A Intervallo categorie - A JA カテゴリ:至 カテゴリ範囲:至 KO 범주: 까지 범주 범위: 까지 PTB Categorias - Até Categorias - Até RU Категории по Верхняя граница диапазона категорий S Till kategorier Kategoriintervall till TR Kategoriler: Son Kategori aralığı: Son US Categories To Category range to ZHS 类别至 类别终止范围