ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729F51A9E05362FB09050512Y select wdj.wip_entity_id ovr_res_entity_id, wdj.organization_id ovr_res_org_id, wor.operation_seq_num oper_seq_num, bd.department_code department, bro.resource_code res_code, brr.resource_code resource_code, ml_basis.meaning basis, cdo.rate_or_amount std_rate, round(sum(decode(cdo.basis_type, 3, wor.USAGE_RATE_OR_AMOUNT * decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, wdj.start_quantity, 3, wdj.quantity_completed, 0), 1), 4, wor.USAGE_RATE_OR_AMOUNT * decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, wdj.start_quantity, 3, wdj.quantity_completed, 0), 1) * decode(brr.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0)), 0)), :P_qty_precision) std_bas_fctr, round(sum(decode(cdo.basis_type, 3, wor.applied_resource_units, 4, wor.applied_resource_value, 0)), :P_qty_precision) app_bas_fctr, round(sum(cdo.rate_or_amount * decode(cdo.basis_type, 3, wor.USAGE_RATE_OR_AMOUNT * decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, wdj.start_quantity, 3, wdj.quantity_completed, 0), 1), 4, wor.USAGE_RATE_OR_AMOUNT * decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, wdj.start_quantity, 3, wdj.quantity_completed, 0), 1) * decode(brr.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0)), 0)), :precision) res_ovr_std_cost, round(sum(cdo.rate_or_amount * decode(cdo.basis_type, 3, wor.applied_resource_units, 4, wor.applied_resource_value, 0)), :precision) res_ovr_app_cost, round(sum(cdo.rate_or_amount * decode(cdo.basis_type, 3, wor.applied_resource_units, 4, wor.applied_resource_value, 0) - (cdo.rate_or_amount * decode(cdo.basis_type, 3, wor.USAGE_RATE_OR_AMOUNT * decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, wdj.start_quantity, 3, wdj.quantity_completed, 0), 1), 4, wor.USAGE_RATE_OR_AMOUNT * decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, wdj.start_quantity, 3, wdj.quantity_completed, 0), 1) * decode(brr.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0)), 0))), :precision) res_ovr_eff_var from cst_department_overheads cdo, cst_resource_overheads cro, bom_departments bd, cst_resource_costs crc, bom_resources bro, bom_resources brr, mfg_lookups ml_basis, wip_operation_resources wor, wip_operations wo, wip_discrete_jobs wdj where wo.wip_entity_id = wdj.wip_entity_id and wor.organization_id = :org_id and wo.wip_entity_id = wor.wip_entity_id and wo.organization_id = :org_id and wo.operation_seq_num = wor.operation_seq_num and &P_PROJECT_WHERE and bd.department_id = nvl(wor.department_id, wo.department_id) and brr.resource_id = wor.resource_id and crc.resource_id(+) = wor.resource_id and crc.cost_type_id(+) = 1 and cro.resource_id = wor.resource_id and cro.cost_type_id = 1 and cro.overhead_id = cdo.overhead_id and cdo.department_id = bd.department_id and cdo.cost_type_id = 1 and cdo.basis_type in (3, 4) and bro.resource_id = cdo.overhead_id and ml_basis.lookup_code = cdo.basis_type and ml_basis.lookup_type = 'CST_BASIS_SHORT' and wdj.wip_entity_id=:parent_entity_id and wdj.organization_id=:parent_org_id group by wor.OPERATION_SEQ_NUM, wor.STANDARD_RATE_FLAG, wdj.wip_entity_id, wdj.organization_id, bd.department_code, bro.resource_code, bro.unit_of_measure, cdo.basis_type, cdo.rate_or_amount, brr.resource_code, ml_basis.meaning, wor.USAGE_RATE_OR_AMOUNT, wor.BASIS_TYPE, wdj.START_QUANTITY, wdj.quantity_completed, brr.functional_currency_flag, crc.resource_rate, wor.applied_resource_units, wor.applied_resource_value WIP WIPRDJVR_XML AR WIP تقرير قيم أوامر الشغل المنفصلة - تكلفة قياسية (بتنسيق XML) Imported from BI Publisher Description: تقرير قيمة أمر الشغل المنفصل - تكلفة قياسية Application: العمل في الإنجاز Source: تقرير قيم أوامر الشغل المنفصلة - تكلفة قياسية (بتنسيق XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG D WIP Diskrete Aufträge - Auftragswerte Imported from BI Publisher Description: Standardkostenrechnung: Diskrete Aufträge - Auftragswerte Application: Fertigung Source: Standardkostenrechnung: Diskrete Aufträge - Auftragswerte (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG E WIP Valores de Órdenes de Fabricación Discretas - Coste Estándar Imported from BI Publisher Description: Valores de Órdenes de Fabricación Discretas - Coste Estándar Application: Work in Process Source: Valores de Órdenes de Fabricación Discretas - Coste Estándar (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG F WIP Etat Valeurs des OF - Valorisation au coût standard Imported from BI Publisher Description: Etat Valeurs des OF - Valorisation au coût standard Application: Work In Process Source: Etat Valeurs des OF - Valorisation au coût standard (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG I WIP Rapporto Valori OdL discreti - Determinazione costi standard Imported from BI Publisher Description: Rapporto Valori OdL discreti - Determinazione costi standard Application: Work in Process Source: Rapporto Valori OdL discreti - Determinazione costi standard (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG JA WIP ショップ型製造オーダー・レポート - 標準原価計算 Imported from BI Publisher Description: ショップ型製造オーダー・レポート - 標準原価計算 Application: Work in Process Source: ショップ型製造オーダー・レポート - 標準原価計算(XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG KO WIP 단속 작업 값 보고서 - 표준 원가 Imported from BI Publisher Description: 단속 작업 값 보고서 - 표준 원가 Application: Work in Process Source: 단속 작업 값 보고서 - 표준 원가(XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG PTB WIP Relatório de Valor de Ordem de Produção Discreta - Custo Padrão Imported from BI Publisher Description: Relatório de Valor de Ordem de Produção Discreta - Custo Padrão Application: Work in Process Source: Relatório de Valor de Ordem de Produção Discreta - Custo Padrão (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG RU WIP Отчет о стоимости отдельных заданий - стандартная калькуляция Imported from BI Publisher Description: Отчет о стоимости отдельных заданий - стандартная калькуляция Application: Незавершенное производство Source: Отчет о стоимости отдельных заданий - стандартная калькуляция (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG S WIP Rapport över värde för diskreta TO - standardkostnad Imported from BI Publisher Description: TO-värde - rapport: standardkostnad Application: Work in Process Source: Rapport över värde för diskreta TO - standardkostnad (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG TR WIP Kesikli İş Emri Değer Raporu - Standart Maliyetlendirme Imported from BI Publisher Description: Kesikli İş Emri Değer Raporu - Standart Maliyetlendirme Application: Üretim İzleme Source: Kesikli İş Emri Değer Raporu - Standart Maliyetlendirme (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG US WIP Discrete Job Value Report - Standard Costing Imported from BI Publisher Description: Discrete Job Value Report - Standard Costing Application: Work in Process Source: Discrete Job Value Report - Standard Costing (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG ZHS WIP 离散任务值报表 - 标准成本计算 Imported from BI Publisher Description: 离散任务值报表 - 标准成本计算 Application: 在制品管理系统 Source: 离散任务值报表 - 标准成本计算 (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG BI Publisher &p_project_where :acct_period_id :c_include_bulk :c_include_vendor :class_from :class_to :class_type :class_type_name :currency_code :ext_precision :group_id :item_id_flex_num :job_from :job_to :org_id :org_name :p_conc_request_id :p_debug :p_display_inverse_rate :p_exchange_rate :p_exchange_rate_type :p_flexdata_acct :p_flexdata_item :p_from_item :p_include_bulk :p_include_vendor :p_order_flex :p_outer :p_proj_where :p_project_dummy :p_project_id :p_project_where :p_qty_precision :p_struct_num :p_submission_type :p_to_item :p_where_item :parent_entity_id :parent_org_id :precision :report_option :report_run_opt :report_sort :report_sort_by_aft :report_sort_by_bef :report_sort_opt :status_type :status_type_name :submitted_by :where_class :where_job 1 -90 :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 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 -80 :p_struct_num Number SELECT CHART_OF_ACCOUNTS_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR هيكل الحساب هيكل الحساب D Kontenstruktur Kontenstruktur E Estructura de Cuenta Estructura de cuenta F Structure comptable Structure comptable I Struttura conto Struttura conto JA 勘定科目体系 勘定科目体系 KO 계정구조 계정 구조 PTB Estrutura de Conta Estrutura contábil RU Структура счетов Структура счетов S Kontostruktur Kontostruktur TR Hesap Yapısı Hesap yapısı US Account Structure Account structure ZHS 帐户结构 帐户结构 3 -70 :acct_period_id Number SELECT ACCT_PERIOD_ID FROM ORG_ACCT_PERIODS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND SYSDATE BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE AR معرف فترة الحساب معرف فترة الحساب D Buchungsperiode Buchungsperiode E Id Período Contable Id período contable F ID période comptable ID période comptable I ID periodo contabile ID periodo contabile JA 会計期間ID 会計期間ID KO 회계 기간 ID 계정 기간 ID PTB Id do período contábil Id do período contábil RU Идент. учетного периода Идент. периода счета S Bokföringsperiod-id Redovisningsperiod-id TR Hesap Dönemi No Hesap dönemi No US Account Period Id Account period id ZHS 帐户期间标识 帐户期间标识 4 -60 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점이하 자리수 수량 소수점이하 자리수 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar Duyarlılığı US Quantity Precision Quantity Precision ZHS 数量精确度 数量精确度 5 -50 :submitted_by Char SRS Y AR مقدم بواسطة مقدم بواسطة D Gestartet von Gestartet von E Ejecutado por Ejecutado por F Soumis par Soumis par I Sottomesso da Sottomesso da JA 発行者 発行者 KO 실행자 실행자 PTB Submetido por Submetido por RU Отправлено Отправлено S Beställd av Beställd av TR Gönderen Gönderen US Submitted by Submitted by ZHS 提交者 提交者 6 -40 :p_display_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 Mostrar Tasa Inversa 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 oranı görüntüler US CST_SRS_INVERSE_RATE Display inverse rate ZHS CST_SRS_INVERSE_RATE 显示逆向汇率 7 -30 :p_exchange_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 cambial 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 汇率类型 8 -20 :p_project_dummy Number select organization_id from mtl_parameters where organization_id=:$flex$.organization_id AND project_reference_enabled=1 and cost_group_accounting=1 AR Project_Dummy مشروع افتراضي D Project_Dummy Projekt-Dummy E Project_Dummy Proyecto Ficticio F Project_Dummy Projet fictif I Project_Dummy Progetto fittizio JA Project_Dummy プロジェクト・ダミー KO Project_Dummy 프로젝트 Dummy PTB Project_Dummy Projeto Fictício RU Project_Dummy Фиктивный проект S Project_Dummy Dummy-projekt TR Project_Dummy Sözde Proje US Project_Dummy Project Dummy ZHS Project_Dummy 虚拟项目 9 10 :report_sort_opt LOV Oracle WIP_SRS_DISC_VALUE_SORT_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_WIP_REPORT_SORT' and lookup_code in (1,2,3) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_WIP_REPORT_SORT' AND LOOKUP_CODE = 1 Y AR فرز بواسطة خيار فرز التقرير D Sortieren nach Sortieroption E Ordenar por Opción de Clasificación del Informe F Tri par Option de tri d'état I Ordina per Opzione di ordinamento rapporto JA ソート・キー レポート・ソート・オプション KO 정렬 기준 보고서 정렬 옵션 PTB Classificar por Opção de classificação de relatório RU Сортировка Параметр сортировки отчета S Sortera efter Rapportalternativ TR Sıralama Ölçütü Rapor sıralama seçeneği US Sort By Report sort option ZHS 排序依据 报表排序选项 10 20 :report_run_opt LOV Oracle WIP_SRS_DISC_VALUE_TYPE_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_WIP_VALUE_REPORT_TYPE' and lookup_code in (1,2,3) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_WIP_VALUE_REPORT_TYPE' AND LOOKUP_CODE = 1 Y AR نوع التقرير خيار تشغيل التقرير D Auswertungsart Startoption E Tipo de Informe Opción de ejecución de informe F Type d'état Option d'exécution d'état I Tipo di rapporto Opzione di esecuzione rapporto JA レポート・タイプ レポート実行オプション KO 보고서 유형 보고서 실행 옵션 PTB Tipo de relatório Opção de execução de relatório RU Тип отчета Параметр выполнения отчета S Rapporttyp Rapportera körningsalternativ TR Rapor Tipi Rapor çalıştırma seçeneği US Report Type Report run option ZHS 报表类型 报表运行选项 11 30 :class_type LOV Oracle WIP_SRS_DISC_CLASS_TYPE_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_CLASS_TYPE' and lookup_code in (1,3,5,6,7) order by meaning Select MEANING from MFG_LOOKUPS where LOOKUP_TYPE = 'WIP_CLASS_TYPE' and LOOKUP_CODE = 1 Y AR نوع الطبقة نوع الطبقة D Klassenart Klassenart E Tipo Clase Tipo de clase F Type de classe Type classe I Tipo classe Tipo di classe JA 区分タイプ 区分タイプ KO 분류 유형 분류 유형 PTB Tipo de Classe Tipo de Classe RU Тип класса Тип класса S Klasstyp Klasstyp TR Sınıf Tipi Sınıf tipi US Class Type Class type ZHS 分类类型 分类类型 12 40 :p_include_bulk LOV Oracle WIP_SRS_YES_NO_MAND 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 Mit Massengut Mit Massengut E Incluir a Granel Incluir Necesidades a Granel F Inclure dotation Inclure besoins de dotation atelier I Includi fabbisogni di consumo Includi fabbisogni di consumo JA バルクを含む バルク所要量を含む KO Bulk 포함 Bulk 소요량 포함 PTB Incluir Granel Incluir Necessidades a Granel RU Включение масс-потребностей Включение масс-потребностей S Inkludera bulk Inkludera bulkbehov TR Yığını Dahil Et Toplu Gereksinimleri Dahil Eder US Include Bulk Include Bulk Requirements ZHS 包括批量 包括批量需求 13 50 :p_include_vendor LOV Oracle WIP_SRS_YES_NO_MAND 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 Mit Lieferantenbedarf Mit Lieferantenbedarf E Incluir Proveedor Incluir Requisitos de Proveedor F Inclure fournisseur Inclure besoins fournisseur I Includi fornitore Includi fabbisogni fornitore JA 仕入先を含む 仕入先所要量を含む KO 공급자 포함 공급자 소요량 포함 PTB Incluir Fornecedor Incluir Necessidades do Fornecedor RU Включение поставщика Включение потребностей поставщика S Inkludera leverantör Inkludera leverantörsbehov TR Tedarikçiyi Dahil Et Tedarikçi Gereksinimlerini Dahil Et US Include Supplier Include Vendor Requirements ZHS 包括供应商 包括供应商需求 14 60 :class_from LOV Oracle WIP_SRS_DISC_CLASSES_OPT Y select class_code id, class_code value, null description from wip_accounting_classes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and class_type!=2 order by class_code AR الطبقات من الطبقة من D Von Klasse Von Klasse E De Clase De Clase F Classes - De Classe - De I Classi - Da Classi - Da JA 区分:自 区分:自 KO 분류: 부터 분류: 부터 PTB Classes De Classes - De RU Классы с Классы с S Från klasser Klass från TR Sınıflar, İlk İlk sınıf US Classes From Class from ZHS 分类自 分类自 15 70 :class_to LOV Oracle WIP_SRS_DISC_CLASSES_OPT Y select class_code id, class_code value, null description from wip_accounting_classes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and class_type!=2 order by class_code AR إلى الطبقة إلى D Bis Bis Klasse E A A Clase F A Classe - A I A Classi - A JA 至 区分:至 KO 까지 분류: 까지 PTB Até Classes - até RU По Классы по S Till Klass till TR Son Sınıf: Son US To Class to ZHS 至 分类至 16 80 :job_from LOV Oracle WIP_SRS_DISCRETE_JOBS_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type not in (2,9,10) order by wip_entity_name AR أوامر الشغل من أوامر شغل من D Von Fertigungsauftrag Von Fertigungsauftrag E De Orden de Fabricación De Orden de Fabricación F Ordres de fabrication - De OF - De I OdL - Da OdL - Da JA 製造オーダー:自 製造オーダー:自 KO 작업: 부터 작업: 부터 PTB Ordens de Produção - De Ordens de Produção - De RU Задания с Задания с S Från TO TO från TR İş Emirleri, İlk İş Emirleri: İlk US Jobs From Jobs from ZHS 任务自 任务自 17 90 :job_to LOV Oracle WIP_SRS_DISCRETE_JOBS_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type not in (2,9,10) order by wip_entity_name AR إلى 2 أوامر شغل إلى D Bis 2 Bis Fertigungsauftrag E A 2 A Orden de Fabricación F A 2 OF - A I A 2 OdL - A JA 至 2 製造オーダー:至 KO 까지 2 작업: 까지 PTB Até 2 Ordens de Produção - até RU По 2 Задания по S Till 2 TO till TR Son 2 İş Emirleri: Son US To 2 Jobs to ZHS 至 2 任务至 18 100 :status_type LOV Oracle WIP_SRS_JOB_STATUS_DJVAL_OPT Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where lookup_type='WIP_JOB_STATUS' and lookup_code in (1,3,4,5,6,7,12,14,15) order by lookup_code AR الموقف الموقف E Estado Estado F Statut Statut I Stato Stato JA ステータス ステータス KO 상태 상태 RU Статус Статус S Status Status TR Statü Statü US Status Status ZHS 状态 状态 19 110 :p_from_item Char AR المنتجات من الصنف من D Von Baugruppe Von Artikel E De Conjunto De Artículo F Produits - De Article - De I Assiemi - Da Articolo - Da JA 組立:自 品目 自 KO 조립품: 부터 품목: 부터 PTB Montagens - De Item - De RU Сборки с Позиция с S Från produkter Från artikel TR Ürünler: İlk Kalem: İlk US Assemblies From Item from ZHS 装配件自 物料自 20 120 :p_to_item Char AR إلى 3 الصنف إلى D Bis 3 Bis Artikel E A 3 A Artículo F A 3 Article - A I A 3 Articolo - A JA 至 3 品目:至 KO 까지 3 품목: 까지 PTB Até 3 Item - até RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Kalem: Son US To 3 Item to ZHS 至 3 物料至 21 130 :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 gsob, org_organization_definitions ood WHERE gsob.set_of_books_id = ood.set_of_books_id AND ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de Divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Código da moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para birimi kodu US Currency Currency code ZHS 币种 币种代码 22 140 :p_exchange_rate 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 Cambial Taxa cambial RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz kuru US Exchange Rate Exchange rate ZHS 汇率 汇率 23 150 :p_cg_from_id LOV Oracle CST_SRS_COST_GROUP Y select cg.cost_group_id id, cg.cost_group value, cg.description description from cst_cost_groups cg where nvl(cg.organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(cg.disable_date,sysdate+1)>sysdate order by cost_group AR مجموعة التكلفة من مجموعة التكلفة من D Von Kostengruppe Von Kostengruppe E De Grupo de Costes De Grupo de Costes F Groupe de coûts - De Groupe de coûts - De I Gruppo di costi - Da Gruppo di costi - Da JA 原価グループ:自 原価グループ:自 KO 원가 그룹: 부터 원가 그룹: 부터 PTB Grupo de Custos - De Grupo de Custos - De RU Группа затрат с Группа затрат с S Från kostnadsgrupp Från kostnadsgrupp TR Kaynak Maliyet Grubu Kaynak Maliyet Grubu US Cost Group From Cost Group From ZHS 成本组自 成本组自 24 160 :p_cg_to_id LOV Oracle CST_SRS_COST_GROUP Y select cg.cost_group_id id, cg.cost_group value, cg.description description from cst_cost_groups cg where nvl(cg.organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(cg.disable_date,sysdate+1)>sysdate order by cost_group AR مجموعة التكلفة إلى مجموعة التكلفة إلى D Bis Kostengruppe Bis Kostengruppe E A Grupo de Costes A Grupo de Costes F Groupe de coûts - A Groupe de coûts - A I Gruppo di costi - A Gruppo di costi - A JA 原価グループ:至 原価グループ:至 KO 원가 그룹: 까지 원가 그룹: 까지 PTB Grupo de Custos - Até Grupo de Custos - Até RU Группа затрат по Группа затрат по S Till kostnadsgrupp Till kostnadsgrupp TR Hedef Maliyet Grubu Hedef Maliyet Grubu US Cost Group To Cost Group To ZHS 成本组至 成本组至 25 170 :p_project_id LOV Oracle CST_SRS_PROJECTID Y select project_id id, name value, segment1 description from pa_projects_all where project_id in( select ppp.project_id from pjm_project_parameters ppp where ppp.organization_id=:$flex$.project_dummy ) order by value,description AR معرف المشروع معرف المشروع D Projektkennung Projektkennung E Id Proyecto Id Proyecto F ID projet ID projet I Id progetto Id progetto JA プロジェクトID プロジェクトID KO 프로젝트 ID 프로젝트 ID PTB Id do Projeto Id do Projeto RU Идент. проекта Идент. проекта S Projekt-id Projekt-id TR Proje No Proje No US Project Id Project Id ZHS 项目标识 项目标识