ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F6751A9E05362FB09050512Y SELECT dept_res.department_id department_id2, dept_res.resource_id resource_id1, nvl(dept_res.share_from_dept_id,dept_res.department_id) linking_dept, res.resource_code Name, res.description Description, res.unit_of_measure UOM, lu1.meaning Allow_Sharing, dept.department_code Share_From_Department, ROUND(dept_res.capacity_units, :P_qty_precision) Capacity_Units, lu3.meaning Available_24_Hours, dept_res.resource_group_name resource_group_name FROM bom_department_resources dept_res, bom_resources res, mfg_lookups lu1, bom_departments dept, mfg_lookups lu3 WHERE dept_res.resource_id = res.resource_id and dept_res.share_capacity_flag = lu1.lookup_code and lu1.lookup_type = 'SYS_YES_NO' and dept_res.share_from_dept_id = dept.department_id(+) and dept_res.available_24_hours_flag = lu3.lookup_code and lu3.lookup_type = 'SYS_YES_NO' and dept_res.department_id = :department_id_01 ORDER BY res.resource_code BOM BOMRDODP_XML AR BOM تقرير القسم (تنسيق XML) Imported from BI Publisher Description: تقرير القسم Application: شجرة المنتجات Source: تقرير القسم (تنسيق XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG D BOM Abteilungen Imported from BI Publisher Description: Abteilungen Application: Produktionsdaten Source: Abteilungen (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG E BOM Departamentos Imported from BI Publisher Description: Informe de departamentos Application: Bills of Material Source: Departamentos (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG F BOM Etat Sections Imported from BI Publisher Description: Etat Sections Application: Bills of Material Source: Etat Sections (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG I BOM Rapporto Reparto Imported from BI Publisher Description: Rapporto Reparto Application: Bills of Material Source: Rapporto Reparto (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG JA BOM 部門レポート Imported from BI Publisher Description: 部門レポート Application: Bills of Material Source: 部門レポート(XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG KO BOM 부서 보고서 Imported from BI Publisher Description: 부서 보고서 Application: Bills of Material Source: 부서 보고서(XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG PTB BOM Relatório de Departamento Imported from BI Publisher Description: Relatório de Departamento Application: Bills of Material Source: Relatório de Departamento (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG RU BOM Отчет об отделах Imported from BI Publisher Description: Отчет об отделах Application: Спецификации Source: Отчет об отделах (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG S BOM Avdelning - rapport Imported from BI Publisher Description: Avdelning - rapport Application: Bills of Material Source: Avdelning - rapport (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG TR BOM Departman Raporu Imported from BI Publisher Description: Departman Raporu Application: Ürün Ağacı Source: Departman Raporu (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG US BOM Department Imported from BI Publisher Description: Department Report Application: Bills of Material Source: Department Report (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG ZHS BOM 部门报表 Imported from BI Publisher Description: 部门报表 Application: 物料清单管理系统 Source: 部门报表 (XML) Short Name: BOMRDODP_XML DB package: BOM_BOMRDODP_XMLP_PKG BI Publisher :department_id_01 :p_class :p_conc_request_id :p_debug :p_ext_precision :p_from :p_org_id :p_overhead_flag :p_prv_cap_cnt :p_prv_shift_cnt :p_qty_precision :p_resource_flag :p_std_precision :p_to :round_amount 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR organization_id معرف التنظيم D organization_id Organisation E organization_id Id Organización F organization_id ID organisation 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 org 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 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_overhead_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 Details Gemeinkosten Details Gemeinkosten E Detalles de Costes Generales Detalles de Costes Generales F Détails frais généraux Détails frais généraux I Dettagli costi comuni Dettagli costi comuni JA 間接費詳細 間接費詳細 KO 간접비 상세내역 간접비 상세내역 PTB Detalhes dos Custos Indiretos Detalhes dos Custos Indiretos RU Сведения о накладных расходах Сведения о накладных расходах S Omkostnadsdetaljer Omkostnadsdetaljer TR Genel Gider Detayları Genel Gider Detayları US Overhead Details Overhead details ZHS 制造费用详细信息 制造费用详细资料 5 20 :p_resource_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 Ressourcendetails Details Ressourcen E Detalles de Recursos Detalles de Recursos F Détails ressources Détails ressources I Dettagli risorsa Dettagli risorsa JA 生産資源費詳細 生産資源費詳細 KO 자원 상세내역 자원 상세내역 PTB Detalhes dos Custos Indiretos 2 Detalhes do Recurso RU Сведения о ресурсе Сведения о ресурсе S Resursdetaljer Resursdetaljer TR Kaynak Detayları Kaynak Detayları US Resource Details Resource details ZHS 资源详细信息 资源详细资料 6 30 :p_class LOV Oracle BOM_SRS_DEPARTMENT_CLASS Y select department_class_code id, department_class_code value, description description from bom_department_classes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_class_code AR طبقة القسم طبقة القسم D Abteilungsklasse Abteilungsklasse E Clase de Departamento Clase de departamento F Classe de sections Classe de sections I Classe di reparto Classe di reparto JA 部門区分 部門区分 KO 부서 분류 부서 분류 PTB Classe de Depto Classe do departamento RU Класс отдела Класс отдела S Avdelningsklass Avdelningsklass TR Departman Sınıfı Departman Sınıfı US Department Class Department class ZHS 部门分类 部门分类 7 40 :p_from LOV Oracle BOM_SRS_DEPARTMENT Y select department_code id, department_code value, description description from bom_departments where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_code AR أقسام من أقسام من D Von Abteilung Von Abteilung E De Departamento De Departamento F Sections - De Sections - De I Reparti - Da Reparti - Da JA 部門:自 部門:自 KO 부서: 부터 부서: 부터 PTB Deptos. - De Departamentos - De RU Отделы с Отделы с S Från avdelning Avdelningar från TR Departmanlar: İlk Departmanlar: İlk US Departments From Departments from ZHS 部门自 部门自 8 50 :p_to LOV Oracle BOM_SRS_DEPARTMENT Y select department_code id, department_code value, description description from bom_departments where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_code select :$flex$.departments_from from dual AR إلى معرف القسم D Bis Bis Abteilung E A A Departamento F A Section - A I A Reparto - A JA 至 部門:至 KO 까지 부서: 까지 PTB Até Departamento - Até RU По Отделы по S Till Avdelning till TR Son Departman: Son US To Department to ZHS 至 部门至