ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F9451A9E05362FB09050512Y select bd.department_code WD_Dept, we.wip_entity_name WD_Work_Order, msi.concatenated_segments WD_Ass_Act, we.description WD_Work_Ord_Desc, to_char(wdj.date_released, 'DD-MON-YYYY') WD_Start_Date, to_char(wdj.date_completed, 'DD-MON-YYYY') WD_Compl_Date, ml.meaning WD_Cost_Category, round(sum(nvl(wepb.system_estimated_mat_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Mat, round(sum(nvl(wepb.actual_mat_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Mat, round(sum(nvl(wepb.system_estimated_lab_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Lab, round(sum(nvl(wepb.actual_lab_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Lab, round(sum(nvl(wepb.system_estimated_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Eqp, round(sum(nvl(wepb.actual_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Eqp, round(sum(nvl(wepb.system_estimated_mat_cost,0) + nvl(wepb.system_estimated_lab_cost,0) + nvl(wepb.system_estimated_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Est_Total, round(sum(nvl(wepb.actual_mat_cost,0) + nvl(wepb.actual_lab_cost,0) + nvl(wepb.actual_eqp_cost,0)) * :P_EXCHANGE_RATE / :P_ROUND_UNIT) * :P_ROUND_UNIT WD_Act_Total from bom_departments bd, wip_eam_period_balances wepb, wip_discrete_jobs wdj, wip_entities we, mtl_system_items_kfv msi, mfg_lookups ml where wdj.organization_id = :P_ORG_ID and bd.department_id = wdj.owning_department &P_DEPT_WHERE and we.wip_entity_id= wdj.wip_entity_id and we.entity_type in (6,7) and wdj.status_type in (3,4,5,12) and wdj.organization_id = msi.organization_id(+) and wdj.primary_item_id = msi.inventory_item_id(+) &P_PERIOD_WEPB_WHERE and ml.lookup_type = 'BOM_EAM_COST_CATEGORY' and ml.lookup_code = wepb.maint_cost_category and wdj.wip_entity_id = wepb.wip_entity_id and wdj.organization_id = wepb.organization_id and wdj.scheduled_completion_date >= wepb.period_start_date group by bd.department_code, we.wip_entity_name, we.description, msi.concatenated_segments, wdj.date_released, wdj.date_completed, ml.meaning order by WD_Dept, WD_Work_Order BOM CSTRWOCR_XML AR CST تقرير تكلفة أمر الشغل (تنسيق XML) Imported from BI Publisher Description: تقرير تكلفة أمر الشغل في EAM Application: شجرة المنتجات Source: تقرير تكلفة أمر الشغل (تنسيق XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG D CST Wartungsauftragskosten Imported from BI Publisher Description: EAM Auswertung "Wartungsauftragskosten" Application: Produktionsdaten Source: Wartungsauftragskosten (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG E CST Coste de Orden de Trabajo Imported from BI Publisher Description: Informe Coste de Orden de Trabajo de EAM Application: Bills of Material Source: Coste de Orden de Trabajo (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG F CST Coût de l'ordre de fabrication Imported from BI Publisher Description: EAM - Coût de l'ordre de travail Application: Bills of Material Source: Coût de l'ordre de fabrication (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG I CST Rapporto Costo ordine di lavorazione Imported from BI Publisher Description: Rapporto Costi ordine di lavorazione EAM Application: Bills of Material Source: Rapporto Costo ordine di lavorazione (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG JA CST 作業指示原価レポート Imported from BI Publisher Description: EAM作業指示原価レポート Application: Bills of Material Source: 作業指示原価レポート(XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG KO CST 작업 지시 원가 보고서 Imported from BI Publisher Description: EAM 작업 지시 원가 보고서 Application: Bills of Material Source: 작업 지시 원가 보고서(XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG PTB CST Relatório de Custo da Ordem de Serviço Imported from BI Publisher Description: EAM - Relatório de Custo da Ordem de Serviço Application: Bills of Material Source: Relatório de Custo da Ordem de Serviço (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG RU CST Отчет о затратах заказа на выполнение работ Imported from BI Publisher Description: Отчет о затратах заказа на выполнение работ УАП Application: Спецификации Source: Отчет о затратах заказа на выполнение работ (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG S CST Kostnadsrapport för tillverkningsorder Imported from BI Publisher Description: EAM: Kostnadsrapport för tillverkningsorder Application: Bills of Material Source: Kostnadsrapport för tillverkningsorder (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG TR CST İş Emri Maliyet Raporu Imported from BI Publisher Description: EAM İş Emri Maliyet Raporu Application: Ürün Ağacı Source: İş Emri Maliyet Raporu (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG US CST Work Order Cost Imported from BI Publisher Description: EAM Work Order Cost Report Application: Bills of Material Source: Work Order Cost Report (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG ZHS CST 工作单成本报表 Imported from BI Publisher Description: EAM 工作单成本报表 Application: 物料清单管理系统 Source: 工作单成本报表 (XML) Short Name: CSTRWOCR_XML DB package: BOM_CSTRWOCR_XMLP_PKG BI Publisher &p_dept_where &p_period_wepb_where :p_conc_request_id :p_cost_ceiling :p_currency_code :p_currency_dsp :p_dept_from :p_dept_to :p_dept_where :p_exchange_rate :p_exchange_rate_char :p_include_osp :p_org_id :p_org_name :p_period_date_from :p_period_date_to :p_period_id_from :p_period_id_to :p_period_wepb_where :p_period_wpb_where :p_report_type :p_round_unit 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F ID organisation ID organisation I Id organizzazione Id dell'organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB ID da Organização ID da Organização RU Идентификатор организации Идентификатор организации S Organisations-id Organisations-id TR Organizasyon No Organizasyon No US Organization ID Organization ID ZHS 组织标识 组织标识 2 -30 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE عرض السعر العكسي D CST_SRS_INVERSE_RATE Gegenkurs anzeigen E CST_SRS_INVERSE_RATE Visualizar Tipo de Cambio Inverso F CST_SRS_INVERSE_RATE Afficher taux inverse I CST_SRS_INVERSE_RATE Visualizza tasso inverso JA CST_SRS_INVERSE_RATE 逆数レートの表示 KO CST_SRS_INVERSE_RATE 역산율 표시 PTB CST_SRS_INVERSE_RATE Exibir Taxa de Inversão RU CST_SRS_INVERSE_RATE Вывод обратного курса S CST_SRS_INVERSE_RATE Visa inverterad kurs TR CST_SRS_INVERSE_RATE Ters Kuru Görüntüle US CST_SRS_INVERSE_RATE Display Inverse Rate ZHS CST_SRS_INVERSE_RATE 显示逆汇率 3 -20 :p_rate_type Number 2 Y AR CST_SRS_RATE_TYPE نوع سعر الصرف D CST_SRS_RATE_TYPE Wechselkursart E CST_SRS_RATE_TYPE Clase de Tipo de Cambio F CST_SRS_RATE_TYPE Type de taux de change I CST_SRS_RATE_TYPE Tipo di tasso di cambio JA CST_SRS_RATE_TYPE 換算レート・タイプ KO CST_SRS_RATE_TYPE 환율 유형 PTB CST_SRS_RATE_TYPE Tipo de Taxa de Câmbio RU CST_SRS_RATE_TYPE Тип обменного курса S CST_SRS_RATE_TYPE Växelkurstyp TR CST_SRS_RATE_TYPE Döviz Kuru Tipi US CST_SRS_RATE_TYPE Exchange Rate Type ZHS CST_SRS_RATE_TYPE 汇率类型 4 10 :p_report_type LOV Oracle CST_EAM_SRS_WOCR_REP_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_EAM_WOCR_REP_TYPE' order by lookup_code select meaning from mfg_lookups where lookup_type = 'CST_EAM_WOCR_REP_TYPE' and lookup_code = 1 Y AR نوع التقرير نوع التقرير D Auswertungsart Art der Auswertung E Tipo de Informe Tipo de Informe F Type d'état Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポートのタイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Raporun Tipi US Report Type Type of Report ZHS 报表类型 报表类型 5 20 :p_dept_from LOV Oracle CST_SRS_DEPT Y select department_code id, department_code value, null description from bom_departments bd 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 Section d'origine Section d'origine I Reparto - Da Reparto - Da JA 部門:自 部門:自 KO 부서 From 부서 From PTB Departamento - De Departamento - De RU Отдел с Отдел-отправитель S Från avdelning Från avdelning TR İlk Departman İlk Departman US Department From From Department ZHS 部门自 自部门 6 30 :p_dept_to LOV Oracle CST_SRS_DEPT Y select department_code id, department_code value, null description from bom_departments bd where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_code AR القسم إلى إلى القسم D Bis Abteilung Bis Abteilung E A Departamento A Departamento F Section de destination Section de destination I Reparto - A Reparto - A JA 部門:至 部門:至 KO 부서 To 부서 To PTB Departamento - Até Departamento - Até RU Отдел по Отдел-получатель S Till avdelning Till avdelning TR Son Departman Son Departman US Department To To Department ZHS 部门至 至部门 7 40 :p_cost_ceiling Number 0 AR الحد الأقصى للتكلفة عرض كل السجلات لهذه التكلفة D AHK-Höchstgrenze Alle Datensätze anzeigen, die diese Kosten überschreiten E Límite de Coste Mostrar todos los registros que superen este coste F Plafond de coût Afficher tous les enregistrements supérieurs à ce coût I Massimale costi Visualizza tutti i record relativi al costo corrente JA 原価限度額 この原価の全レコードを表示 KO 원가 한도 이 원가에 대한 모든 레코드 표시 PTB Teto de Custo Exibir todos os registros acima deste custo RU Потолок стоимости Вывод всех записей для данных затрат S Kostnadstak Visa alla poster över kostnaden TR Maliyet Tavanı Bu maliyet üzerinden tüm kayıtları gösterir US Cost Ceiling Display all records over this cost ZHS 成本最高限额 显示此成本的所有记录 8 50 :p_period_id_from LOV Oracle CST_SRS_PERIOD_FROM Y select acct_period_id id, period_name value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by period_start_date Y AR الفترة من من الفترة D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 기간: 부터 기간: 부터 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem Başlangıcı İlk Dönem US Period From From Period ZHS 起始期间 自期间 9 60 :p_period_id_to LOV Oracle CST_SRS_PERIOD_TO Y select acct_period_id id, period_name value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and acct_period_id>=:$flex$.cst_srs_period_from order by period_start_date Y AR الفترة إلى إلى الفترة D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A JA 期間:至 期間:至 KO 기간: 까지 기간: 까지 PTB Período - Até Período - Até RU Период по Период по S Till period Till period TR Son Dönem Son Dönem US Period To To Period ZHS 终止期间 至期间 10 70 :p_include_osp LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SRS_YES_NO' and lookup_code = 2 Y AR تضمين المعالجة الخارجية تضمين المعالجة الخارجية D Mit Fremdbearbeitung Mit Fremdbearbeitung E Incluir OSP Incluir OSP F Inclure sous-traitance Inclure sous-traitance I Includi lavorazione presso terzi Includi lavorazione presso terzi JA OSPを含む OSPを含む KO OSP 포함 OSP 포함 PTB Incluir OSP Incluir OSP RU Включая ОнС Включая ОнС S Inkludera legotillverkning Inkludera legotillverkning TR OSP'yi Dahil Et OSP'yi Dahil Et US Include OSP Include OSP ZHS 包括 OSP 包括 OSP 11 80 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description select currency_code from gl_sets_of_books sob, org_organization_definitions ood where ood.organization_id = fnd_profile.value('mfg_organization_id') and sob.set_of_books_id = ood.set_of_books_id Y AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 12 90 :p_exchange_rate_char LOV Oracle CST_SRS_EXCHANGE_RATE_C Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=fnd_profile.value('MFG_ORGANIZATION_ID') and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率