ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F6551A9E05362FB09050512Y select bdg.DELETE_GROUP_NAME group_name1, bdg.DESCRIPTION description1, ml1.meaning delete_type, ml2.meaning action_type, to_char(bdg.DATE_LAST_SUBMITTED,'DD-MON-RR HH24:MI') date_sub, ml3.MEANING entity, bdse.COMPONENT_CONCAT_SEGMENTS Component, bdse.DESCRIPTION description4, bdse.OPERATION_SEQ_NUM op, bdse.ITEM_NUM seq, bde.ITEM_CONCAT_SEGMENTS bill, bde.ALTERNATE_DESIGNATOR alternate, to_char(bdse.EFFECTIVITY_DATE,'DD-MON-RR HH24:MI') effectivity, to_char(bdse.DISABLE_DATE,'DD-MON-RR HH24:MI') disable, ml4.MEANING status, bde.DELETE_DATE del_dat, bdse.DELETE_ENTITY_SEQUENCE_ID, bdse.COMPONENT_SEQUENCE_ID, ood.organization_code org_code_comp from BOM_DELETE_GROUPS bdg, BOM_DELETE_ENTITIES bde, BOM_DELETE_SUB_ENTITIES bdse, MFG_LOOKUPS ml1, MFG_LOOKUPS ml2, MFG_LOOKUPS ml3, MFG_LOOKUPS ml4, ORG_ORGANIZATION_DEFINITIONS ood where ml1.LOOKUP_CODE = bdg.DELETE_TYPE and ml1.LOOKUP_TYPE = 'BOM_DELETE_TYPE' and ml2.LOOKUP_CODE = bdg.ACTION_TYPE and ml2.LOOKUP_TYPE = 'BOM_DELETE_ACTION_TYPE' and ml3.LOOKUP_TYPE = 'BOM_DELETE_ENTITY_TYPE' and ml3.LOOKUP_CODE = DECODE(bdse.COMPONENT_SEQUENCE_ID, '', 5,4) and 'BOM_DELETE_STATUS_TYPE' = ml4.lookup_type and bdse.DELETE_STATUS_TYPE = ml4.lookup_code and bdse.DELETE_STATUS_TYPE in (1,2,3,4) and bdse.DELETE_ENTITY_SEQUENCE_ID = bde.DELETE_ENTITY_SEQUENCE_ID and bde.DELETE_GROUP_SEQUENCE_ID = bdg.DELETE_GROUP_SEQUENCE_ID and bdg.ORGANIZATION_ID = :P_ORGANIZATION_ID and ood.organization_id = bdg.organization_id &C_where_type &C_where_delete_type &C_where_group &C_where_entity_status &C_where_sub_entity_status &C_eng_flag_where and bdg.DELETE_TYPE = 4 ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,19 ASC , bdg.DELETE_GROUP_NAME , bdse.COMPONENT_CONCAT_SEGMENTS , bde.ITEM_CONCAT_SEGMENTS , bde.ALTERNATE_DESIGNATOR , bdse.OPERATION_SEQ_NUM BOM BOMRDDEL_XML AR BOM تقرير حذف الأصناف (تنسيق XML) Imported from BI Publisher Description: تقرير حذف الأصناف Application: شجرة المنتجات Source: تقرير حذف الأصناف (تنسيق XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG D BOM Artikel - Löschhistorie Imported from BI Publisher Description: Artikel - Löschhistorie Application: Produktionsdaten Source: Artikel - Löschhistorie (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG E BOM Supresión de Artículos Imported from BI Publisher Description: Informe de supresión de artículos Application: Bills of Material Source: Supresión de Artículos (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG F BOM Etat des articles supprimés Imported from BI Publisher Description: Etat des articles supprimés Application: Bills of Material Source: Etat des articles supprimés (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG I BOM Rapporto Eliminazione articoli Imported from BI Publisher Description: Rapporto Eliminazione articoli Application: Bills of Material Source: Rapporto Eliminazione articoli (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG JA BOM 削除品目レポート Imported from BI Publisher Description: 削除品目レポート Application: Bills of Material Source: 削除品目レポート(XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG KO BOM 품목 삭제 보고서 Imported from BI Publisher Description: 품목삭제 보고서 Application: Bills of Material Source: 품목 삭제 보고서(XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG PTB BOM Excluir Relatório de Itens Imported from BI Publisher Description: Excluir Relatório de Itens Application: Bills of Material Source: Excluir Relatório de Itens (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG RU BOM Отчет об удалении позиций Imported from BI Publisher Description: Отчет об удалении позиций Application: Спецификации Source: Отчет об удалении позиций (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG S BOM Borttagna artiklar - rapport Imported from BI Publisher Description: Borttagna artiklar - rapport Application: Bills of Material Source: Borttagna artiklar - rapport (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG TR BOM Kalemleri Silme Raporu Imported from BI Publisher Description: Kalemleri Silme Raporu Application: Ürün Ağacı Source: Kalemleri Silme Raporu (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG US BOM Delete Items Imported from BI Publisher Description: Delete Items Report Application: Bills of Material Source: Delete Items Report (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG ZHS BOM 删除物料报表 Imported from BI Publisher Description: 删除物料报表 Application: 物料清单管理系统 Source: 删除物料报表 (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG BI Publisher &c_eng_flag_where &c_where_delete_type &c_where_entity_status &c_where_group &c_where_sub_entity_status &c_where_type :p_bill_flag :p_bom_or_eng :p_br_flag :p_check_status_flag :p_comp_flag :p_comp_msg :p_conc_request_id :p_debug :p_del_status_flag :p_ent_msg :p_error_status_flag :p_group_from :p_group_to :p_ibr_flag :p_item_flag :p_language :p_op_msg :p_oper_flag :p_optimizer_code :p_organization_id :p_pend_status_flag :p_rout_flag :p_trace_flag 1 -40 :p_bom_or_eng Char fnd_profile.value('BOM_OR_ENG') AR BOM_SRS_NONE_CHAR علامة هندسية D BOM_SRS_NONE_CHAR Konstruktion Kennzeichen E BOM_SRS_NONE_CHAR Diseño F BOM_SRS_NONE_CHAR Indicateur Etude I BOM_SRS_NONE_CHAR Flag Tecnico JA BOM_SRS_NONE_CHAR 設計フラグ KO BOM_SRS_NONE_CHAR 설계 플래그 PTB BOM_SRS_NONE_CHAR Indicador de Engenharia RU BOM_SRS_NONE_CHAR Флаг технологического проектирования S BOM_SRS_NONE_CHAR Konstruktionsflagga TR BOM_SRS_NONE_CHAR Mühendislik işareti US BOM_SRS_NONE_CHAR Engineering flag ZHS BOM_SRS_NONE_CHAR 工程标志 2 -30 :p_organization_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 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 组织标识 3 -20 :p_debug Char fnd_profile.value('MRP_TRACE') Y AR علامة التتبع تمكين خاصية التتبع D Trace Trace aktivieren E Rastreo Activar Instalación de Rastreo F Indicateur Trace Activer la fonction de trace I Flag Traccia Abilita funzione di traccia JA トレース・フラグ トレース機能を使用可にする KO 추적 플래그 추적 기능 사용가능 PTB Indicador de Rastreamento Ativar o Recurso de Rastro RU Флаг трассировки Включение трассировки S Spårningsflagga Aktivera spårningsfunktion TR İzleme İşareti İzleme olanağını etkinleştir US Trace Flag Enable trace facility ZHS 跟踪标志 启用跟踪设施 4 10 :p_group_from LOV Oracle BOM_SRS_DELETE_GROUP Y select delete_group_name id, delete_group_name value, null description from bom_delete_groups where organization_id=:$flex$.bom_srs_org_id and ((:$flex$.bom_srs_none_char='ENG' and engineering_flag=2) or (:$flex$.bom_srs_none_char='BOM' and engineering_flag=1) or (:$flex$.bom_srs_none_char is null and engineering_flag=1)) order by value,description AR حذف مجموعة من حذف مجموعة من D Von Löschgruppe Von Löschgruppe E De Grupo de Borrado De Grupo de Borrado F Suppr. groupe - De Supprimer groupe - De I Elimina gruppo da Gruppo di eliminazioni - Da JA 削除グループ:自 削除グループ:自 KO 삭제 그룹: 부터 삭제 그룹: 부터 PTB Excluir Grupo De Excluir Grupo De RU Группа удаления с Группа удаления с S Ta bort grupp från Ta bort grupp från TR Silme Grubu: İlk Silme Grubu: İlk US Delete Group From Delete group from ZHS 删除组自 删除组自 5 20 :p_group_to LOV Oracle BOM_SRS_DELETE_GROUP Y select delete_group_name id, delete_group_name value, null description from bom_delete_groups where organization_id=:$flex$.bom_srs_org_id and ((:$flex$.bom_srs_none_char='ENG' and engineering_flag=2) or (:$flex$.bom_srs_none_char='BOM' and engineering_flag=1) or (:$flex$.bom_srs_none_char is null and engineering_flag=1)) order by value,description select :$flex$.delete_group_from from dual AR إلى حذف مجموعة إلى D Bis Bis Löschgruppe E A A Grupo de Borrado F A Supprimer groupe - A I A Gruppo di eliminazioni - A JA 至 削除グループ:至 KO 까지 삭제 그룹: 까지 PTB Até Excluir Grupo Até RU По Группа удаления по S Till Ta bort grupp till TR Son Silme Grubu: Son US To Delete group to ZHS 至 删除组至 6 30 :p_item_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR الصنف الصنف D Artikel Artikel E Artículo Artículo F Article Article I Articolo Articolo JA 品目 品目 KO 품목 품목 RU Позиция Позиция S Artikel Artikel TR Kalem Kalem US Item Item ZHS 物料 物料 7 40 :p_bill_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR شجرة المنتج شجرة المنتج D Stückliste Stückliste E Lista de Materiales Lista de Materiales F Nomenclature Nomenclature I Distinta base Distinta base JA 部品構成表 部品構成表 KO BOM BOM PTB Lista de Materiais Lista de Materiais RU Спецификация Спецификация S Produktstruktur Produktstruktur TR Ürün Ağacı Ürün Ağacı US Bill of Material Bill of Material ZHS 物料清单 物料清单 8 50 :p_rout_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR التوجيه التوجيه D Arbeitsplan Arbeitsplan E Ruta Ruta F Gamme Gamme I Ciclo Ciclo JA 工順 工順 KO 공정순서 공정순서 PTB Roteamento Roteamento RU Техкарта Техкарта S Operationsföljd Operationsföljd TR Rota Rota US Routing Routing ZHS 工艺路线 工艺路线 9 60 :p_br_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR فاتورة وتوجيه فاتورة وتوجيه D Stückliste und Arbeitsplan Stückliste und Arbeitsplan E Lista y Ruta Lista y Ruta F Nomenclature et gamme Nomenclature et gamme I Distinta e ciclo Distinta e ciclo JA 構成表および工順 構成表および工順 KO BOM과 공정순서 BOM 및 공정순서 PTB Lista e Roteiro Lista e roteiro RU Спецификация и техкарта Спецификация и техкарта S Struktur och op.följd Struktur och op.följd TR Ağaç ve Rota Ağaç ve rota US Bill and Routing Bill and routing ZHS 清单和工艺路线 清单和工艺路线 10 70 :p_ibr_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR صنف وفاتورة وتوجيه صنف وفاتورة وتوجيه D Artikel, Stückliste und Arbeitsplan Artikel, Stückliste und Arbeitsplan E Artículo, Lista y Ruta Artículo, Lista y Ruta F Article, nomenclature et gamme Article, nomenclature et gamme I Articolo, distinta e ciclo Articolo, distinta e ciclo JA 品目, 構成表および工順 品目, 構成表および工順 KO 품목,BOM,공정순서 품목,BOM,공정순서 PTB Item, Lista e Roteiro Item, Lista e Roteiro RU Позиция, спецификация и техкарта Позиция, спецификация и техкарта S Artikel, struktur och op.följd Artikel, struktur och op.följd TR Kalem, Ağaç ve Rota Kalem, Ağaç ve Rota US Item, Bill and Routing Item, Bill and Routing ZHS 物料、清单和工艺路线 物料、清单和工艺路线 11 80 :p_comp_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR المكون المكون D Komponente Komponente E Componente Componente F Composant Composant I Componente Componente JA 構成部品 構成部品 KO 구성품 구성품 PTB Componente Componente RU Компонент Компонент S Komponent Komponent TR Bileşen Bileşen US Component Component ZHS 组件 组件 12 90 :p_oper_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR العملية العملية D Arbeitsvorgang Arbeitsvorgang E Operación Operación F Opération Opération I Operazione Operazione JA 工程 工程 KO 공정 공정 PTB Operação Operação RU Операция Операция TR Operasyon Operasyon US Operation Operation ZHS 工序 工序 13 100 :p_pend_status_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR موقف معلق موقف معلق D Wartestatus Wartestatus E Estado Pendiente Estado Pendiente F Statut En attente Statut En attente I Stato in sospeso Stato In sospeso JA 保留ステータス 保留ステータス KO 대기중 상태 보류 상태 PTB Status Pendente Status Pendente RU Статус "Ожидание" Статус "Ожидание" S Status: Avvaktande Status: Avvaktande TR Bekleme Statüsü Bekleme Statüsü US Pending Status Pending status ZHS 待定状态 待定状态 14 110 :p_check_status_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR اختر موقف موافق اختر موقف موافق D Status "Prüfung OK" Status "Prüfung OK" E Comprobar el Estado Correcto Comprobar el Estado Correcto F Statut Vérif OK Statut Vérif OK I Controllo stato OK Controllo stato OK JA チェックOKステータス チェックOKステータス KO 체크 확인 상태 체크 확인 상태 PTB Checar Status OK Checar Status OK RU Статус "Проверка выполнена" Статус "Проверка выполнена" S Kontr. OK-status Kontr. OK-status TR Kontrol Tamam Statüsü Kontrol Tamam Statüsü US Check Ok Status Check Ok Status ZHS 检查确定状态 检查确定状态 15 120 :p_error_status_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR موقف الخطأ موقف الخطأ D Fehlerstatus Fehlerstatus E Estado Error Estado Error F Statut Erreur Statut Erreur I Stato Errore Stato Errore JA エラー・ステータス エラー・ステータス KO 오류 상태 오류 상태 PTB Status Erro Status Erro RU Статус "Ошибка" Статус "Ошибка" S Felstatus Felstatus TR Hata Statüsü Hata Statüsü US Error Status Error Status ZHS 错误状态 错误状态 16 130 :p_del_status_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 select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR موقف الحذف موقف الحذف D Löschstatus Löschstatus E Estado Suprimido Estado Suprimido F Statut Supprimé Statut Supprimé I Stato Eliminato Stato Eliminato JA 削除済ステータス 削除済ステータス KO 삭제된 상태 삭제된 상태 PTB Status Excluído Status Excluído RU Статус "Удалено" Статус "Удалено" S Status för borttag Status för borttag TR Silinme Statüsü Silinme Statüsü US Deleted Status Deleted Status ZHS 已删除状态 已删除状态