ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F9C51A9E05362FB09050512Y SELECT ecv.revised_item_sequence_id revised_item_sequence_id2, lu1.meaning Action, ecv.component_item_id component_item_id, null C_RC_FLEXDATA, msi.description Description, msi.primary_uom_code UOM, ecv.component_yield_factor Yield, old.operation_seq_num Old_Op, ecv.operation_seq_num New_Op, ecv.item_num Item_Seq, ecv.disable_date Disable_Date, ROUND(ecv.component_quantity, :P_qty_precision) Quantity, fl.meaning Item_Type, ecv.optional Optional, ecv.planning_factor Planning_Factor, ecv.include_in_cost_rollup Costed, lu5.meaning Supply_Type, ecv.supply_subinventory Supply_Subinventory, ecv.supply_locator_id supply_locator_id, null C_SL_FLEXDATA, ecv.component_remarks Comments, ecv.cancellation_date Cancellation_Date, ecv.cancel_comments Comments, ecv.check_atp Check_ATP, lu9.meaning Basis, ecv.mutually_exclusive_options Mutually_Exclusive_Options, ecv.required_to_ship Required_to_Ship, ecv.required_for_revenue Required_for_Revenue, ecv.include_on_ship_docs Include_on_Shipping_Documents, round(ecv.low_quantity, :p_qty_precision) Min_Qty, round(ecv.high_quantity, :p_qty_precision) Max_Qty, ecv.bill_sequence_id bill_sequence_id, ecv.effectivity_date effectivity_date, ecv.component_sequence_id component_sequence_id, ecv.change_notice change_notice4, ecv.quantity_related, msi.organization_id organization_id4, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_rc_flexfield', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_RC_FLEXFIELD, DECODE(mil.INVENTORY_LOCATION_ID, NULL, NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_sl_flexfield', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_SL_FLEXFIELD, ENG_ENGRCNDR_XMLP_PKG.optional_dispformula(ecv.optional) Optional_disp, ENG_ENGRCNDR_XMLP_PKG.costed_dispformula(ecv.include_in_cost_rollup) Costed_disp, ENG_ENGRCNDR_XMLP_PKG.check_atp_dispformula(ecv.check_atp) Check_ATP_disp, ENG_ENGRCNDR_XMLP_PKG.mutually_exclusive_dispformula(ecv.mutually_exclusive_options) Mutually_Exclusive_disp, ENG_ENGRCNDR_XMLP_PKG.required_to_ship_dispformula(ecv.required_to_ship) Required_to_Ship_disp, ENG_ENGRCNDR_XMLP_PKG.required_for_revenue_dispformu(ecv.required_for_revenue) Required_for_Revenue_disp, ENG_ENGRCNDR_XMLP_PKG.include_on_ship_dispformula(ecv.include_on_ship_docs) Include_on_Ship_disp, ENG_ENGRCNDR_XMLP_PKG.quantity_related_dispformula(ecv.quantity_related) quantity_related_disp FROM mfg_lookups lu1, mfg_lookups lu5, mfg_lookups lu9, fnd_common_lookups fl, eng_component_view ecv, mtl_system_items msi, mtl_item_locations mil, bom_inventory_components old WHERE ecv.component_item_id = msi.inventory_item_id and ecv.supply_locator_id = mil.inventory_location_id(+) and decode(ecv.implementation_date,null,ecv.old_component_sequence_id,ecv.component_sequence_id) = old.component_sequence_id(+) and ecv.acd_type = lu1.lookup_code(+) and lu1.lookup_type(+) = 'ECG_ACTION' and msi.item_type = fl.lookup_code(+) and fl.lookup_type(+) = 'ITEM_TYPE' and ecv.wip_supply_type = lu5.lookup_code(+) and lu5.lookup_type(+) = 'WIP_SUPPLY' and ecv.so_basis = lu9.lookup_code(+) and lu9.lookup_type(+) ='BOM_SO_BASIS' and ecv.revised_item_sequence_id=:revised_item_sequence_id and msi.organization_id=:organization_id1 ORDER BY ecv.operation_seq_num, ecv.old_component_sequence_id ENG ENGRCNDR_XML AR ENG تقرير تفاصيل أوامر التغيير الهندسية (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل أمر التغيير الهندسي Application: الهندسية Source: تقرير تفاصيل أوامر التغيير الهندسية (تنسيق XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG D ENG Technische Änderungsaufträge - Details Imported from BI Publisher Description: Technische Änderungsaufträge - Details Application: Konstruktionsdaten Source: Technische Änderungsaufträge - Details (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG E ENG Informe Detalle de Pedidos de Cambio de Diseño Imported from BI Publisher Description: Detalle de Pedidos de Cambio de Diseño Application: Engineering Source: Informe Detalle de Pedidos de Cambio de Diseño (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG F ENG Edition détaillée d'OMT Imported from BI Publisher Description: Etat Détail des OMT Application: Engineering Source: Edition détaillée d'OMT (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG I ENG Rapporto Dettagli ordine di modifica tecnica Imported from BI Publisher Description: Rapporto Dettagli ordine di modifica tecnica Application: Engineering Source: Rapporto Dettagli ordine di modifica tecnica (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG JA ENG 設計変更詳細レポート Imported from BI Publisher Description: 設計変更詳細レポート Application: Engineering Source: 設計変更詳細レポート(XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG KO ENG ECO 상세내역 보고서 Imported from BI Publisher Description: ECO 상세내역 보고서 Application: Engineering Source: ECO 상세내역 보고서(XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG PTB ENG Relatório Detalhado da Ordem de Alteração de Engenharia Imported from BI Publisher Description: Rel. Detalhado da Ordem Alteração Engenharia Application: Engineering Source: Relatório Detalhado da Ordem de Alteração de Engenharia (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG RU ENG Подробный отчет о заказах на технологические изменения Imported from BI Publisher Description: Подробный отчет о заказах на технологические изменения Application: Технологическое проектирование Source: Подробный отчет о заказах на технологические изменения (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG S ENG Detaljer för konstruktionsändringsorder - rapport Imported from BI Publisher Description: Detaljer för konstruktionsändringsorder - rapport Application: Engineering Source: Detaljer för konstruktionsändringsorder - rapport (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG TR ENG Mühendislik Değişiklik Emri Detay Raporu Imported from BI Publisher Description: Mühendislik Değişiklik Emri Detay Raporu Application: Mühendislik Source: Mühendislik Değişiklik Emri Detay Raporu (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG US ENG Engineering Change Order Detail Imported from BI Publisher Description: Engineering Change Order Detail Report Application: Engineering Source: Engineering Change Order Detail Report (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG ZHS ENG 工程更改单详细信息报表 Imported from BI Publisher Description: 工程更改单明细报表 Application: 工程管理系统 Source: 工程更改单详细信息报表 (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG BI Publisher :c_date_range :c_limit_change_notices :cp_from_date :cp_to_date :dp_all_orgs :organization_id1 :p_additional_code :p_additional_detail :p_all_orgs :p_conc_request_id :p_debug :p_from_date :p_from_notice :p_no :p_nope :p_order_entry_code :p_order_entry_detail :p_org_hierarchy :p_org_id :p_qty_precision :p_rc_flexdata :p_rc_struct_num :p_ri_flexdata :p_ri_struct_num :p_sc_flexdata :p_sc_struct_num :p_sequence_id :p_sl_flexdata :p_sl_struct_num :p_status :p_status_char :p_to_date :p_to_notice :p_uui_flexdata :p_uui_struct_num :p_yep :p_yes :revised_item_sequence_id 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR organization_id معرف التنظيم D organization_id Organisationskennung E organization_id Identificador de organización F organization_id ID org. I organization_id Id org. JA organization_id 組織ID KO organization_id 조직 ID PTB organization_id ID da Org. RU organization_id Идентификатор организации S organization_id Org.-id TR organization_id Organizasyon no US organization_id Org id ZHS organization_id 组织标识 2 -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 Option Nachkommastellen E Opción Precisión Dinámica Opción 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 动态精确度选项 动态精确度选项 3 -20 :p_debug Char fnd_profile.value('MRP_TRACE') Y AR علامة التتبع خاصية التتبع D Trace Trace aktivieren E Indicador de Rastreo Instalación de Rastreo F Indicateur Trace Fonction de trace I Flag Traccia Funzione di traccia JA トレース・フラグ トレース機能 KO 추적 플래그 추적 기능 PTB Indicador de Rastreamento Recurso de Rastro RU Флаг трассировки Программа трассировки S Spårningsflagga Spårningsfunktion TR İzleme İşareti İzleme Olanağı US Trace Flag Trace Facility ZHS 跟踪标志 跟踪设施 4 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 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 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 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 30 :p_from_notice 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 Änderungsauftrag E De Pedido de Cambio de Diseño De pedidos de cambio F Ordres modif. technique - De Ordres de modification - De I Ordini di modifica tecnica - Da Ordini di modifica - Da JA 設計変更:自 設変:自 KO 설계 변경 주문: 부터 ECO: 부터 PTB Ordens de Alteração de Engenharia - De Ordens de alteração - de RU Заказы на технологические изменения с Заказы на изменения с S Ändringsorder från Ändringsorder från TR Mühendislik Değişiklik Emirleri, İlk İlk değişiklik emirleri US Engineering Change Orders From Change orders from ZHS 工程更改单自 更改单自 7 40 :p_to_notice 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 Änderungsauftrag E A A pedidos de cambio F Au Ordres de modification - A I A Ordini di modifica - A JA 至 設変:至 KO 까지 ECO: 까지 PTB Até Ordens de alteração - até RU По Заказы на изменения по S Till Ändringsorder till TR Son Son değişiklik emirleri US To Change orders to ZHS 至 更改单至 8 50 :p_from_date Date AR التواريخ من التواريخ من D Datum von Daten von E De Fecha De Fecha F Dates - Du Dates - Du I Date - Da Date - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Datas - De Datas - de RU Даты с Даты с S Från datum Från datum TR Tarihler: İlk İlk tarihler US Dates From Dates from ZHS 起始日期 起始日期 9 60 :p_to_date Date AR إلى 2 التواريخ إلى D Bis 2 Daten bis E A 2 A Fecha F A Dates - Au I A 2 Date - A JA 至 2 日:至 KO 까지 2 일자: 까지 PTB Até 2 Datas - até RU По 2 Даты по S Till 2 Datum till TR Son 2 Son tarihler US To 2 Dates to ZHS 至 2 终止日期 10 70 :p_status LOV Oracle ENG_SRS_STATUS Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='ECG_ECN_STATUS' order by meaning AR الموقف موقف أمر التغيير الهندسي D Status TÄA-Status E Estado Estado de ECO F Statut Statut OMT I Stato Stato ECO JA ステータス 設変ステータス KO 상태 ECO 상태 PTB Status Status da ECO RU Статус Статусе ЗТИ S Status ÄO-status TR Statü Mühendislik Değişiklik Emir statüsü US Status ECO status ZHS 状态 ECO 状态 11 80 :p_additional_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 zusätzliche Komponente Details zusätzliche Komponente E Detalle del Componente Adicional Detalle del Componente Adicional F Détails compl. composant Détails compl. composant I Ulteriori dettagli componente Ulteriori dettagli componente JA 追加構成部品詳細 追加構成部品詳細 KO 추가 구성품 상세내역 추가 구성품 상세내역 PTB Detalhes Adicionais do Componente Detalhes Adicionais do Componente RU Дополнительные сведения о компоненте Дополнительные сведения о компоненте S Fler komponentdetalj Fler komponentdetalj TR Ek Bileşen Detayı Ek Bileşen Detayı US Additional Component Detail Additional Component Detail ZHS 附加组件详细信息 附加组件详细信息 12 90 :p_order_entry_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 Detail Komponente Auftrag Detail Komponente Auftrag E Detalle del Componente de Order Entry Detalle del Componente de Order Entry F Infos de cde sur composant Infos de cde sur composant I Dettaglio componente inserimento ordini Dettaglio componente inserimento ordini JA 受注入力構成部品の詳細 受注入力構成部品の詳細 KO 수주관리 구성품 상세내역 수주관리 구성품 상세내역 PTB Detalhe do Componente de Entrada da Ordem Detalhe do Componente de Entrada da Ordem RU Сведения о компоненте ввода заказа Сведения о компоненте ввода заказа S Orderreg. komponentdetalj Orderreg. komponentdetalj TR Sipariş Girişi Bileşen Detayı Sipariş Girişi Bileşen Detayı US Order Entry Component Detail Order Entry Component Detail ZHS 订单录入组件详细信息 订单录入组件详细信息