ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F7C51A9E05362FB09050512 select bd.department_code Det_Dept, nvl(nvl(wdj.rebuild_serial_number, wdj.asset_number), 'Not Applicable') Asset_Num, we.wip_entity_name Work_Order, we.description Work_Ord_Desc, to_char(wdj.date_released, 'DD-MON-YYYY') Start_Date, to_char(wdj.date_completed, 'DD-MON-YYYY') Comp_Date, round(sum(nvl(wepb.actual_mat_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Material, round(sum(nvl(wepb.actual_lab_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Labor, round(sum(nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT),2) * (:P_ROUND_UNIT) Det_Equip, 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),2) * (:P_ROUND_UNIT) Det_Total from bom_departments bd, wip_eam_period_balances wepb, wip_discrete_jobs wdj, wip_entities we where wdj.organization_id = :P_ORG_ID and bd.department_id = wdj.owning_department &P_DEPT_WHERE and wdj.status_type in (3,4,5,12) and we.wip_entity_id= wdj.wip_entity_id and we.entity_type in (6,7) and wdj.wip_entity_id = wepb.wip_entity_id and wdj.organization_id = wepb.organization_id &P_PERIOD_WEPB_WHERE group by bd.department_code, nvl(nvl(wdj.rebuild_serial_number,wdj.asset_number),'Not Applicable'), we.wip_entity_name, we.description, wdj.date_released, wdj.date_completed order by Det_Dept, Asset_Num, Work_Order Y BOM CSTRDACR_XML AR CST تقرير التكلفة الفعلية للقسم (تنسيق XML) Imported from BI Publisher Description: تقرير التكلفة الفعلية للقسم في EAM Application: شجرة المنتجات Source: تقرير التكلفة الفعلية للقسم (تنسيق XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG D CST Istkosten nach Abteilung Imported from BI Publisher Description: EAM Auswertung "Istkosten nach Abteilung" Application: Produktionsdaten Source: Istkosten nach Abteilung (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG E CST Coste Real de Departamento Imported from BI Publisher Description: Informe coste real de departamento EAM Application: Bills of Material Source: Coste Real de Departamento (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG F CST Coût réel de la section Imported from BI Publisher Description: EAM - Coût réel de la section Application: Bills of Material Source: Coût réel de la section (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG I CST Rapporto Costi effettivi reparto Imported from BI Publisher Description: Rapporto Costi effettivi reparto EAM Application: Bills of Material Source: Rapporto Costi effettivi reparto (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG JA CST 部門実績原価レポート Imported from BI Publisher Description: EAM部門実績原価レポート Application: Bills of Material Source: 部門実績原価レポート(XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG KO CST 부서 실제 원가 보고서 Imported from BI Publisher Description: EAM 부서 실제 원가 보고서 Application: Bills of Material Source: 부서 실제 원가 보고서(XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG PTB CST Relatório de Custo Real do Departamento Imported from BI Publisher Description: EAM - Relatório de Custo Real do Departamento Application: Bills of Material Source: Relatório de Custo Real do Departamento (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG RU CST Отчет о фактических затратах отдела Imported from BI Publisher Description: Отчет о фактических затратах отдела УАП Application: Спецификации Source: Отчет о фактических затратах отдела (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG S CST Rapport om faktiska kostnader för avdelning Imported from BI Publisher Description: EAM: Rapport om faktiska kostnader för avdelning Application: Bills of Material Source: Rapport om faktiska kostnader för avdelning (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG TR CST Departman Fiili Maliyet Raporu Imported from BI Publisher Description: EAM Departmanı Fiili Maliyet Raporu Application: Ürün Ağacı Source: Departman Fiili Maliyet Raporu (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG US CST Department Actual Cost Imported from BI Publisher Description: EAM Department Actual Cost Report Application: Bills of Material Source: Department Actual Cost Report (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG ZHS CST 部门实际成本报表 Imported from BI Publisher Description: EAM 部门实际成本报表 Application: 物料清单管理系统 Source: 部门实际成本报表 (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG BI Publisher &p_dept_where &p_period_wepb_where :p_conc_request_id :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_round_unit :p_rpt_type 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_rpt_type LOV Oracle CST_EAM_SRS_DACR_REP_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_EAM_DACR_REP_TYPE' order by lookup_code select meaning from mfg_lookups where lookup_type = 'CST_EAM_DACR_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_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 起始期间 自期间 8 50 :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 终止期间 至期间 9 60 :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 10 70 :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 币种 币种 11 80 :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 汇率 汇率 :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_period_from Period From Period To :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate