ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F9D51A9E05362FB09050512 SELECT C.CHANGE_NOTICE CHANGE_NOTICE10, T.TYPE_NAME CHANGE_ORDER_TYPE, C.REASON_CODE, C.PRIORITY_CODE, C.INITIATION_DATE, F.ITEM_NUMBER, F.DESCRIPTION, B.ALTERNATE_BOM_DESIGNATOR, R.NEW_ITEM_REVISION, R.SCHEDULED_DATE, R.NEW_ROUTING_REVISION, R.FROM_CUM_QTY, R.LOT_NUMBER, DECODE(R.ECO_FOR_PRODUCTION,1,:P_YES,:P_NO) ECO_FOR_PRODUCTION, WI1.WIP_ENTITY_NAME, WI2.WIP_ENTITY_NAME, L.MEANING, DECODE(R.IMPLEMENTATION_DATE, NULL, DECODE(R.CANCELLATION_DATE, NULL, (TRUNC(R.SCHEDULED_DATE) - TRUNC(SYSDATE)), NULL), NULL), R.BILL_SEQUENCE_ID, DECODE(:ORDER_BY1, 1, C.CHANGE_NOTICE, 2, F.PADDED_ITEM_NUMBER, 3, TO_CHAR(R.SCHEDULED_DATE,'YYYYMMDD')) O1, DECODE(:ORDER_BY2, 1, C.CHANGE_NOTICE, 2, F.PADDED_ITEM_NUMBER, 3, TO_CHAR(R.SCHEDULED_DATE,'YYYYMMDD')) O2, DECODE(:ORDER_BY3, 1, C.CHANGE_NOTICE, 2, F.PADDED_ITEM_NUMBER, 3, TO_CHAR(R.SCHEDULED_DATE,'YYYYMMDD')) O3, R.REVISED_ITEM_SEQUENCE_ID REVISED_ITEM_SEQUENCE_ID10 FROM ENG_ENGINEERING_CHANGES C, ENG_REVISED_ITEMS R, MTL_ITEM_FLEXFIELDS F, BOM_BILL_OF_MATERIALS B, ENG_CHANGE_ORDER_TYPES_VL T, WIP_ENTITIES WI1, WIP_ENTITIES WI2, MFG_LOOKUPS L WHERE C.ORGANIZATION_ID = :ORG_ID AND R.ORGANIZATION_ID = :ORG_ID AND R.CHANGE_NOTICE = C.CHANGE_NOTICE AND R.STATUS_TYPE = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'ECG_ECN_STATUS' AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID (+) AND WI1.WIP_ENTITY_ID (+) = R.FROM_WIP_ENTITY_ID AND WI1.ORGANIZATION_ID (+) = R.ORGANIZATION_ID AND WI2.WIP_ENTITY_ID (+) = R.TO_WIP_ENTITY_ID AND WI2.ORGANIZATION_ID (+) = R.ORGANIZATION_ID AND C.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID AND R.REVISED_ITEM_ID = F.ITEM_ID AND F.ORGANIZATION_ID = :ORG_ID AND C.CHANGE_NOTICE BETWEEN NVL(:ECN_FROM,' 0') AND NVL(:ECN_TO, 'zzzzzzzzzz') AND C.CHANGE_ORDER_TYPE_ID = NVL(:CHANGE_ORDER_TYPE_ID, C.CHANGE_ORDER_TYPE_ID) AND R.SCHEDULED_DATE BETWEEN NVL(:C_DATE_FROM, TO_DATE('1901/01/01','YYYY/MM/DD')) AND NVL(:C_DATE_TO, TO_DATE('4000/12/31','YYYY/MM/DD')) AND R.STATUS_TYPE = NVL(:REVISED_ITEM_STATUS, R.STATUS_TYPE) AND ((:HISTORY_CODE = 1 AND R.IMPLEMENTATION_DATE IS NULL AND R.CANCELLATION_DATE IS NULL) OR (:HISTORY_CODE = 2 AND (R.IMPLEMENTATION_DATE IS NOT NULL OR R.CANCELLATION_DATE IS NOT NULL)) OR (:HISTORY_CODE = 3)) AND ((:P_REVISED_ITEM_ID IS NULL AND :P_REVISED_COMPONENT_ITEM_ID IS NULL) OR (:P_REVISED_ITEM_ID IS NOT NULL AND :P_REVISED_COMPONENT_ITEM_ID IS NULL AND R.REVISED_ITEM_ID = :P_REVISED_ITEM_ID) OR (:P_REVISED_COMPONENT_ITEM_ID IS NOT NULL AND :P_REVISED_ITEM_ID IS NULL AND EXISTS (SELECT NULL FROM ENG_COMPONENT_VIEW V WHERE V.CHANGE_NOTICE = C.CHANGE_NOTICE AND V.COMPONENT_ITEM_ID = :P_REVISED_COMPONENT_ITEM_ID AND V.REVISED_ITEM_SEQUENCE_ID = R.REVISED_ITEM_SEQUENCE_ID)) OR (:P_REVISED_COMPONENT_ITEM_ID IS NOT NULL AND :P_REVISED_ITEM_ID IS NOT NULL AND (R.REVISED_ITEM_ID = :P_REVISED_ITEM_ID OR EXISTS (SELECT NULL FROM ENG_COMPONENT_VIEW V WHERE V.CHANGE_NOTICE = C.CHANGE_NOTICE AND V.COMPONENT_ITEM_ID = :P_REVISED_COMPONENT_ITEM_ID AND V.REVISED_ITEM_SEQUENCE_ID = R.REVISED_ITEM_SEQUENCE_ID))) ) ORDER BY 20, 21, 22 Y ENG ENGRCNSR_XML AR ENG تقرير جدول أمر التغيير الهندسي (تنسيق XML) Imported from BI Publisher Description: تقرير جدول أمر التغيير الهندسي Application: الهندسية Source: تقرير جدول أمر التغيير الهندسي (تنسيق XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG D ENG Technischer Änderungsauftrag - Planung Imported from BI Publisher Description: TÄA - Planung Application: Konstruktionsdaten Source: Technischer Änderungsauftrag - Planung (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG E ENG Informe Programa de Pedidos de Cambio de Diseño Imported from BI Publisher Description: Programa de Pedidos de Cambio de Diseño Application: Engineering Source: Informe Programa de Pedidos de Cambio de Diseño (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG F ENG Planification des OMT Imported from BI Publisher Description: Etat Planification des OMT Application: Engineering Source: Planification des OMT (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG I ENG Rapporto Programma ordini di modifica tecnica Imported from BI Publisher Description: Rapporto Programma ordini di modifica tecnica Application: Engineering Source: Rapporto Programma ordini di modifica tecnica (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG JA ENG 設計変更計画レポート Imported from BI Publisher Description: 設計変更計画レポート Application: Engineering Source: 設計変更計画レポート(XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG KO ENG ECO 스케줄 보고서 Imported from BI Publisher Description: ECO 스케줄 보고서 Application: Engineering Source: ECO 스케줄 보고서(XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG PTB ENG Relatório de Programação da Ordem de Alteração de Engenharia Imported from BI Publisher Description: Rel. Program. Ordem Alteração Engenharia Application: Engineering Source: Relatório de Programação da Ordem de Alteração de Engenharia (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG RU ENG Отчет о графике заказов на технологические изменения Imported from BI Publisher Description: Отчет о графике заказов на технологические изменения Application: Технологическое проектирование Source: Отчет о графике заказов на технологические изменения (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG S ENG Plan för konstruktionsändringsorder - rapport Imported from BI Publisher Description: Plan för konstruktionsändringsorder - rapport Application: Engineering Source: Plan för konstruktionsändringsorder - rapport (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG TR ENG Mühendislik Değişiklik Emri Çizelge Raporu Imported from BI Publisher Description: Mühendislik Değişiklik Emri Çizelge Raporu Application: Mühendislik Source: Mühendislik Değişiklik Emri Çizelge Raporu (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG US ENG Engineering Change Order Schedule Imported from BI Publisher Description: Engineering Change Order Schedule Report Application: Engineering Source: Engineering Change Order Schedule Report (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG ZHS ENG 工程更改单计划报表 Imported from BI Publisher Description: 工程更改单计划报表 Application: 工程管理系统 Source: 工程更改单计划报表 (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG BI Publisher :c_date_from :c_date_to :change_order_type_id :date_from :date_to :ecn_from :ecn_to :history_code :order_by1 :order_by2 :order_by3 :org_id :p_debug :p_delete_code :p_no :p_qty_precision :p_revised_component_item_id :p_revised_item_id :p_yes :print_components :revised_item_status 1 -50 :org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR ORG_ID معرف التنظيم D ORG_ID Organisationskennung E ORG_ID Id Organización F ORG_ID ID organisation I ORG_ID Id organizzazione JA ORG_ID 組織ID KO ORG_ID 조직 ID PTB ORG_ID ID da Organização RU ORG_ID Идент. организации S ORG_ID Organisations-id TR ORG_ID Organizasyon No US ORG_ID Organization ID ZHS ORG_ID 组织标识 2 -40 :p_delete_code 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=2 AR حذف أمر التغيير الهندسي حذف أمر التغيير الهندسي بعد طباعة تقرير D TÄA löschen Nach Drucken der Auswertung TÄA löschen E Suprimir Pedido de Cambio de Diseño Suprimir Pedido de Cambio de Diseño tras imprimir el Informe F Supprimer OMT Supprimer OMT après édition état I Elimina ECO Elimina ECO dopo stampa rapporto JA 設変の削除 レポート印刷後、設変の削除 KO ECO 삭제 보고서 인쇄 후 ECO 삭제 PTB Excluir ECO Excluir ECO após impressão da geração do relatório RU Удаление ЗТИ Удаление ЗТИ после печати отчета S Ta bort ändringsorder Ta bort ändringsorder när rapporten skrivits ut TR Mühendislik Değişiklik Emrini Sil Rapor yazdırıldıktan sonra Mühendislik Değişiklik Emirini siler US Delete ECO Delete ECO after report is printed ZHS 删除ECO 打印报表之后删除 ECO 3 -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') AR خيار الدقة الديناميكية خيار الدقة الديناميكية D Option Nachkommastellen Nachkommastellen E Opción Precisión Dinámica Opción de precisión dinámica F Option précision dynamique Option précision dynamique I Opzione precisione dinamica Opzione Precisione dinamica JA 動的演算精度オプション 動的精度オプション KO 동적 소수점자리 옵션 동적 소수점자리 옵션 PTB Opção de Precisão Dinâmica Opção de precisão dinâmica RU Динамическая точность Параметр динамической точности S Alternativ för dynamisk precision Alternativ för dynamisk precision TR Dinamik Duyarlılık Seçeneği Dinamik duyarlılık seçeneği US Dynamic Precision Option Dynamic precision option ZHS 动态精确度选项 动态精确度选项 4 -20 :p_debug Char fnd_profile.value('MRP_TRACE') Y AR علامة التتبع تمكين خاصية التتبع D Trace Trace aktivieren E Indicador de 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 Recurso de Rastreamento RU Флаг трассировки Включение трассировки S Spårningsflagga Aktivera spårningsfunktion TR İzleme İşareti İzleme Olanağını Etkinleştirir. US Trace Flag Enable Trace Facility ZHS 跟踪标志 启用跟踪功能 5 10 :print_components 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 Komponenten drucken Komponenten drucken E Imprimir Componentes Imprimir Componentes F Impr. composants Imprimer les composants I Stampa componenti Stampa i componenti JA 構成部品の印刷 構成部品の印刷 KO 구성품 인쇄 구성품 인쇄 PTB Componentes (Impressão) Imprimir componentes RU Печать компонентов Печать компонентов S Skrivkomponenter Skrivkomponenter TR Bileşenleri Yazdır Bileşenleri yazdırır US Print Components Print components ZHS 打印组件 打印组件 6 20 :change_order_type_id LOV Oracle BOM_SRS_CHANGE_ORDER_TYPE Y select change_order_type_id id, change_order_type value, description description from eng_change_order_types_val_v where (not (nvl(fnd_profile.value('ENG:ENG_ITEM_ECN_ACCESS'),1)=2 or assembly_type=1)) and change_mgmt_type_code='CHANGE_ORDER' and type_classification='HEADER' order by change_order_type AR نوع أمر التغيير الهندسي نوع أمر التغيير الهندسي D Änderungsauftragsart Art TÄA E Tipo de Pedido de Cambio de Diseño Tipo de Pedido de Cambio de Diseño F Type d'OMT Type d'OMT I Tipo di ordine di modifica tecnica Tipo di ECO JA 設計変更タイプ 設変タイプ KO ECO 유형 ECO 유형 PTB Tipo Ordem Alter. Engenharia Tipo da ECO RU Заказы на технологические изменения Тип ЗТИ S Konstruktionsändringsordertyp ÄO-typ TR Mühendislik Değişiklik Emri Tipi Mühendislik Değişiklik Emir tipi US Engineering Change Order Type ECO type ZHS 工程更改单类型 ECO 类型 7 30 :ecn_from LOV Oracle ENG_SRS_CHANGE_ORDER Y select change_notice id, change_notice value, substr(eng_engineering_changes.description,1,999) description from eng_engineering_changes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by change_notice AR أوامر التغيير الهندسية من أمر التغيير الهندسي من D Von Änderungsauftrag Von TÄA E De Pedido de Cambio de Diseño De Pedido de Cambio de Diseño F Ordres modif. technique - De OMT - De I Ordini di modifica tecnica - Da ECO - Da JA 設計変更:自 設変:自 KO 설계 변경 주문: 부터 ECO: 부터 PTB Ordens de Alteração de Engenharia - De ECO - de RU Заказы на технологические изменения с ЗТИ с S Ändringsorder från Ändr.ord. från TR Mühendislik Değişiklik Emirleri, İlk İlk Mühendislik Değişiklik Emri US Engineering Change Orders From ECO from ZHS 工程更改单自 ECO 自 8 40 :ecn_to LOV Oracle ENG_SRS_CHANGE_ORDER Y select change_notice id, change_notice value, substr(eng_engineering_changes.description,1,999) description from eng_engineering_changes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by change_notice SELECT :$flex$.engineering_change_orders_from from dual AR إلى أمر التغيير الهندسي إلى D Bis Bis TÄA E A A Pedido de Cambio de Diseño F A OMT - A I A ECO - A JA 至 設変:至 KO 까지 ECO: 까지 PTB Até ECO - até RU По ЗТИ по S Till Ändr.ord. till TR Son Son Mühendislik Değişiklik Emri US To ECO to ZHS 至 ECO 至 9 50 :date_from Date AR تواريخ سريان المفعول من تاريخ الفعالية من D GültigkZeitraum von Gültig von E De Fecha en Vigor De Fecha en Vigor F Dates de validité - Du Date de validité - Du I Date validità - Da Data validità - Da JA 有効日:自 有効日:自 KO 적용 일자: 부터 유효 일자: 부터 PTB Datas de Efetivação - De Data de efetivação - de RU Срок действия с Дата действия с S Från giltighetsdatum Från giltighetsdatum TR Geçerli Tarih, İlk Geçerlilik tarihleri: ilk US Effective Dates From Effective date from ZHS 有效日期自 有效起始日期 10 60 :date_to Date AR إلى 2 تاريخ الفعالية إلى D Bis 2 Gültig bis E A 2 A Fecha en Vigor F Au Date de validité - Au I A 2 Data validità - A JA 至 2 有効日:至 KO 까지 2 유효 일자: 까지 PTB Até 2 Data de efetivação - até RU По 2 Дата действия по S Till 2 Till giltighetsdatum TR Son 2 Son geçerlilik tarihi US To 2 Effective date to ZHS 至 2 有效终止日期 11 70 :revised_item_status LOV Oracle BOM_SRS_REVISED_ITEM_STATUS Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='ECG_ECN_STATUS' order by meaning AR موقف الصنف المراجع موقف الصنف الذي تمت مراجعته D Status geänderter Artikel Status geänderter Artikel E Estado del Artículo Revisado Estado del Artículo Revisado F Statut article modifié Statut de l'article modifié I Stato articolo revisionato Stato dell'articolo revisionato JA 改訂品目ステータス 改訂品目ステータス KO 개정 품목 상태 개정 품목 상태 PTB Status Item Revisado Status do item revisado RU Статус пересмотренной позиции Статус пересмотренной позиции S Reviderad artikelstatus Status för reviderad artikel TR Değiştirilen Kalem Statüsü Gözden geçirilmiş kalem statüsü US Revised Item Status Revised item status ZHS 修订物料状态 修订物料状态 12 80 :history_code LOV Oracle BOM_SRS_HISTORY Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='ECG_HISTORY' order by meaning select meaning from mfg_lookups where lookup_type = 'ECG_HISTORY' and lookup_code = 1 Y AR خيارات العرض خيار العرض D Anzeigeoption Anzeigeoption E Opción de Visualización Opción de Visualización F Option d'affichage Option d'affichage I Opzione di visualizzazione Opzione di visualizzazione JA 表示オプション 表示オプション KO 표시 옵션 표시 옵션 PTB Opção de Exibição Opção de exibição RU Режим просмотра Режим просмотра S Visningsalternativ Visningsalternativ TR Görüntüleme Seçeneği Görüntü seçeneği US Display Option Display option ZHS 显示选项 显示选项 13 90 :p_revised_item_id Char AR صنف تمت مراجعته صنف تمت مراجعته D Geänderter Artikel Geänderter Artikel E Artículo Revisado Artículo Revisado F Article modifié Article modifié I Articolo revisionato Articolo revisionato JA 改訂品目 改訂品目 KO 개정 품목 개정 품목 PTB Item Revisado Item revisado RU Пересмотренная позиция Пересмотренная позиция S Reviderad artikel Reviderad artikel TR Değiştirilen Kalem Değiştirilen kalem US Revised Item Revised item ZHS 修订物料 修订物料 14 100 :p_revised_component_item_id Char AR مكون تمت مراجعته مكون تمت مراجعته D Geänderte Komponente Geänderte Komponente E Componente Revisado Componente Revisado F Composant modifié Composant modifié I Componente revisionato Componente revisionato JA 改訂構成部品 改訂構成部品 KO Revised 구성품 개정 구성품 PTB Componente Revisado Componente revisado RU Пересмотренный компонент Пересмотренный компонент S Reviderad komponent Reviderad komponent TR Değiştirilen Bileşen Değiştirilmiş bileşen US Revised Component Revised component ZHS 修订组件 修订组件 15 110 :order_by1 LOV Oracle BOM_SRS_CO_SORT_ORDER Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='ENG_CO_ORDER' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_CODE = 1 AND LOOKUP_TYPE = 'ENG_CO_ORDER' Y AR معيار الفرز رقم 1 معيار الفرز رقم 1 D 1. Sortierkriterium 1. Sortierkriterium E Criterio 1 de Clasificación Criterio 1 de Clasificación F Critère tri 1 Critère de tri 1 I Criterio di ordinamento 1 Criterio di ordinamento 1 JA ソート基準1 ソート基準1 KO 정렬 기준 1 정렬 기준 1 PTB Critérios de Classificação 1 Critérios de classificação 1 RU Условие сортировки 1 Условие сортировки 1 S Sorteringsvillkor 1 Sorteringskriterier 1 TR Sıralama Ölçütü 1 Sıralama ölçütleri 1 US Sort Criteria 1 Sort criteria 1 ZHS 排序标准 1 排序标准 1 16 120 :order_by2 LOV Oracle BOM_SRS_CO_SORT_ORDER Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='ENG_CO_ORDER' order by meaning select meaning from mfg_lookups where lookup_code = 2 and lookup_type = 'ENG_CO_ORDER' Y AR 2 معيار الفرز رقم 2 D 2 2. Sortierkriterium E 2 Criterio 2 de Clasificación F 2 Critère de tri 2 I 2 Criterio di ordinamento 2 JA 2 ソート基準2 KO 2 정렬 기준 2 PTB 2 Critérios de classificação 2 RU 2 Условие сортировки 2 S 2 Sorteringskriterier 2 TR 2 Sıralama ölçütleri 2 US 2 Sort criteria 2 ZHS 2 排序标准 2 17 130 :order_by3 LOV Oracle BOM_SRS_CO_SORT_ORDER Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='ENG_CO_ORDER' order by meaning select meaning from mfg_lookups where lookup_type = 'ENG_CO_ORDER' and lookup_code = 3 Y AR 3 معيار الفرز رقم 3 D 3 3. Sortierkriterium E 3 Criterio 3 de Clasificación F 3 Critère de tri 3 I 3 Criterio di ordinamento 3 JA 3 ソート基準3 KO 3 정렬 기준 3 PTB 3 Critérios de classificação 3 RU 3 Условие сортировки 3 S 3 Sorteringskriterier 3 TR 3 Sıralama ölçütleri 3 US 3 Sort criteria 3 ZHS 3 排序标准 3 :$flex$.engineering_change_orders_from Engineering Change Orders From To