ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F7D51A9E05362FB09050512 select wdj.wip_entity_id cum_entity_id, wdj.organization_id cum_org_id, ml_elem_type.meaning elem_var_type, null acct_no, sum(round(decode(ml_elem_type.lookup_code, 1, nvl(wpb.pl_material_in,0), 2, nvl(wpb.pl_material_overhead_in,0), 3, (nvl(wpb.pl_resource_in,0) + nvl(wpb.tl_resource_in,0)), 4, (nvl(wpb.pl_outside_processing_in,0) + nvl(wpb.tl_outside_processing_in,0)), 5, (nvl(wpb.pl_overhead_in,0) + nvl(wpb.tl_overhead_in,0)), NULL)*:lp_exchange_rate, :PRECISION)) costs_in, sum(round(decode(ml_elem_type.lookup_code, 1, (nvl(wpb.pl_material_out,0) + nvl(wpb.tl_material_out,0)), 2, (nvl(wpb.pl_material_overhead_out,0) + nvl(wpb.tl_material_overhead_out,0)), 3, (nvl(wpb.pl_resource_out,0) + nvl(wpb.tl_resource_out,0)), 4, (nvl(wpb.pl_outside_processing_out,0) + nvl(wpb.tl_outside_processing_out,0)), 5, (nvl(wpb.pl_overhead_out,0) + nvl(wpb.tl_overhead_out,0)), NULL)*:lp_exchange_rate, :PRECISION)) costs_out, sum(round(decode(ml_elem_type.lookup_code, 1, (nvl(wpb.pl_material_var,0) + nvl(wpb.tl_material_var,0)), 2, (nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.tl_material_overhead_var,0)), 3, (nvl(wpb.pl_resource_var,0) + nvl(wpb.tl_resource_var,0)), 4, (nvl(wpb.pl_outside_processing_var,0) + nvl(wpb.tl_outside_processing_var,0)), 5, (nvl(wpb.pl_overhead_var,0) + nvl(wpb.tl_overhead_var,0)), NULL)*:lp_exchange_rate, :PRECISION)) costs_var, sum(round(decode(ml_elem_type.lookup_code, 1, (nvl(wpb.pl_material_in,0) - nvl(wpb.pl_material_out,0) - nvl(wpb.tl_material_out,0)), 2, (nvl(wpb.pl_material_overhead_in,0) - nvl(wpb.pl_material_overhead_out,0) - nvl(wpb.tl_material_overhead_out,0)), 3, (nvl(wpb.pl_resource_in,0) + nvl(wpb.tl_resource_in,0) - nvl(wpb.pl_resource_out,0) - nvl(wpb.tl_resource_out,0)), 4, (nvl(wpb.pl_outside_processing_in,0) + nvl(wpb.tl_outside_processing_in,0) - nvl(wpb.pl_outside_processing_out,0) - nvl(wpb.tl_outside_processing_out,0)), 5, (nvl(wpb.pl_overhead_in,0) + nvl(wpb.tl_overhead_in,0) - nvl(wpb.pl_overhead_out,0) - nvl(wpb.tl_overhead_out,0)), NULL)*:lp_exchange_rate, :PRECISION)) period_act, sum(round(decode(ml_elem_type.lookup_code, 6, nvl(wpb.tl_material_var,0) + nvl(wpb.tl_material_overhead_var,0) + nvl(wpb.pl_material_var,0) + nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.pl_resource_var,0) + nvl(wpb.pl_overhead_var,0) + nvl(wpb.pl_outside_processing_var,0), 7, nvl(wpb.tl_resource_var,0), 8, nvl(wpb.tl_outside_processing_var,0), 9, nvl(wpb.tl_overhead_var,0), NULL)*:lp_exchange_rate, :PRECISION)) single_level, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_ACCT1 from wip_period_balances wpb, wip_discrete_jobs wdj, gl_code_combinations gcc, mfg_lookups ml_elem_type where wdj.wip_entity_id = wpb.wip_entity_id and wpb.organization_id = :org_id and ml_elem_type.lookup_type = 'WIP_ELEMENT_VAR_TYPE' and decode(ml_elem_type.lookup_code, 1, wdj.material_account, 2, wdj.material_overhead_account, 3, wdj.resource_account, 4, wdj.outside_processing_account, 5, wdj.overhead_account, 6, wdj.material_variance_account, 7, wdj.resource_variance_account, 8, wdj.outside_proc_variance_account, 9, wdj.overhead_variance_account) = gcc.code_combination_id and wdj.wip_entity_id=:parent_entity_id and wdj.organization_id=:parent_org_id group by wdj.wip_entity_id, wdj.organization_id , ml_elem_type.meaning, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), ml_elem_type.lookup_code order by ml_elem_type.lookup_code Y BOM CSTRDJVA_XML AR CST تقرير قيمة أمر شغل منفصل - تحديد متوسط التكلفة/تكلفة الوارد أولاً يصرف أولاً (FIFO)/الوارد أخيرًا يصرف أولاً (LIFO) (تنسيق XML) Imported from BI Publisher Description: تقرير قيمة أمر شغل ما تحت التنفيذ منفصل - تحديد متوسط التكلفة/تكلفة الوارد أولاً يصرف أولاً (FIFO)/الوارد أخيراً يصرف أولاً (LIFO) Application: شجرة المنتجات Source: تقرير قيمة أمر شغل منفصل - تحديد متوسط التكلفة/تكلفة الوارد أولاً يصرف أولاً (FIFO)/الوارد أخيرًا يصرف أولاً (LIFO) (تنسيق XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG D CST Diskrete Aufträge - Auftragswerte - Durchschnittskostenrechnung/Fifo-/Lifo-Verfahren Imported from BI Publisher Description: Diskrete Aufträge - Auftragswerte - Durchschnittskostenrechnung/Fifo-/Lifo-Verfahren Application: Produktionsdaten Source: Diskrete Aufträge - Auftragswerte - Durchschnittskostenrechnung/Fifo-/Lifo-Verfahren (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG E CST Valores de Órdenes de Fabricación Discretas de Obra en Curso: Coste Medio/FIFO/LIFO Imported from BI Publisher Description: Informe valores de órdenes de fabricación discretas de obra en curso (WIP): Coste medio/FIFO/LIFO Application: Bills of Material Source: Valores de Órdenes de Fabricación Discretas de Obra en Curso: Coste Medio/FIFO/LIFO (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG F CST Etat Valeurs des OF - Coût moyen/FIFO/LIFO Imported from BI Publisher Description: Etat Valeurs des OF - Coût moyen/FIFO/LIFO Application: Bills of Material Source: Etat Valeurs des OF - Coût moyen/FIFO/LIFO (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG I CST Rapporto Valore OdL discreto - determinazione costi medi/FIFO/LIFO Imported from BI Publisher Description: Rapporto Valore OdL discreto WIP - determinazione dei costi medi/FIFO/LIFO Application: Bills of Material Source: Rapporto Valore OdL discreto - determinazione costi medi/FIFO/LIFO (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG JA CST ショップ型製造オーダー・レポート - 平均/FIFO/LIFO原価計算 Imported from BI Publisher Description: WIPショップ型製造オーダー・レポート - 平均/FIFO/LIFO原価計算 Application: Bills of Material Source: ショップ型製造オーダー・レポート - 平均/FIFO/LIFO原価計算(XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG KO CST 단속 작업 금액 보고서 - 평균/FIFO/LIFO 원가 계산 Imported from BI Publisher Description: WIP 단속 작업 값 보고서 - 평균/FIFO/LIFO 원가 계산 Application: Bills of Material Source: 단속 작업 금액 보고서 - 평균/FIFO/LIFO 원가 계산(XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG PTB CST Relatório de Valor da Ordem de Produção Discreta - Custo Médio FIFO/LIFO Imported from BI Publisher Description: Relatório de Valor da Ordem de Produção Discreta WIP - Custo Médio FIFO/LIFO Application: Bills of Material Source: Relatório de Valor da Ordem de Produção Discreta - Custo Médio FIFO/LIFO (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG RU CST Отчет о стоимости отдельных заданий - калькуляция средних затрат/ФИФО/ЛИФО Imported from BI Publisher Description: Отчет о стоимости отдельных заданий НзП - калькуляция средних затрат/ФИФО/ЛИФО Application: Спецификации Source: Отчет о стоимости отдельных заданий - калькуляция средних затрат/ФИФО/ЛИФО (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG S CST Rapport över TO-värde - genomsnittskostnad för FIFU/SIFU Imported from BI Publisher Description: Rapport över TO-värde i PIA - genomsnittskostnad för FIFU/SIFU Application: Bills of Material Source: Rapport över TO-värde - genomsnittskostnad för FIFU/SIFU (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG TR CST Kesikli İş Emri Değer Raporu - Ortalama/FIFO/LIFO Maliyetlendirme Imported from BI Publisher Description: WIP Kesikli İş Emri Değer Raporu - Ortalama/FIFO/LIFO Maliyetlendirme Application: Ürün Ağacı Source: Kesikli İş Emri Değer Raporu - Ortalama/FIFO/LIFO Maliyetlendirme (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG US CST Discrete Job Value Report - Average/FIFO/LIFO Costing Imported from BI Publisher Description: WIP Discrete Job Value Report - Average/FIFO/LIFO Costing Application: Bills of Material Source: Discrete Job Value Report - Average/FIFO/LIFO Costing (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG ZHS CST 离散任务值报表 - 平均/FIFO/LIFO 成本计算 Imported from BI Publisher Description: WIP 离散任务值报表 - 平均/先进先出/后进先出成本计算 Application: 物料清单管理系统 Source: 离散任务值报表 - 平均/FIFO/LIFO 成本计算 (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG BI Publisher :acct_period_id :c_include_bulk :c_include_vendor :class_from :class_to :class_type :class_type_name :currency_code :ext_precision :group_id :job_from :job_to :lp_currency_code :lp_exchange_rate :org_id :org_name :p_conc_request_id :p_cost_group_id :p_currency_code :p_debug :p_exchange_rate :p_flexdata_acct :p_flexdata_item :p_from_item :p_include_bulk :p_include_vendor :p_item_flex_num :p_job_selection :p_order_flex :p_outer :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 :selected_cost_group :status_type :status_type_name :submitted_by :where_class :where_job 1 -100 :p_proj_enabled Number SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND PROJECT_REFERENCE_ENABLED = 1 AR CST_SRS_JOB_SEL_DUMMY اختيار أمر شغل افتراضي D CST_SRS_JOB_SEL_DUMMY Auftragsauswahl Dummy E CST_SRS_JOB_SEL_DUMMY Selección de Órdenes de Fabricación Ficticia F CST_SRS_JOB_SEL_DUMMY Sélection ordre de fabrication fictive I CST_SRS_JOB_SEL_DUMMY Selezione OdL fittizia JA CST_SRS_JOB_SEL_DUMMY 製造オーダー選択ダミー KO CST_SRS_JOB_SEL_DUMMY 작업 선택 Dummy PTB CST_SRS_JOB_SEL_DUMMY Seleção de Ord. de Prod. Fictícia RU CST_SRS_JOB_SEL_DUMMY Фиктивный выбор задания S CST_SRS_JOB_SEL_DUMMY Dummy för jobburval TR CST_SRS_JOB_SEL_DUMMY Sözde İş Seçimi US CST_SRS_JOB_SEL_DUMMY Job Selection Dummy ZHS CST_SRS_JOB_SEL_DUMMY 任务选择虚拟 2 -90 :p_cost_group_dummy Number SELECT 1 FROM DUAL WHERE :$flex$.job_selection = 1 AR CST_SRS_COST_GROUP_DUMMY مجموعة التكاليف الافتراضية D CST_SRS_COST_GROUP_DUMMY Kostengruppe Dummy E CST_SRS_COST_GROUP_DUMMY Grupo de Costes Ficticio F CST_SRS_COST_GROUP_DUMMY Groupe de coûts fictif I CST_SRS_COST_GROUP_DUMMY Gruppo di costi fittizio JA CST_SRS_COST_GROUP_DUMMY 原価グループ・ダミー KO CST_SRS_COST_GROUP_DUMMY 원가 그룹 Dummy PTB CST_SRS_COST_GROUP_DUMMY Grupo de Custos Fictício RU CST_SRS_COST_GROUP_DUMMY Фиктивная группа затрат S CST_SRS_COST_GROUP_DUMMY Dummy-kostnadsgrupp TR CST_SRS_COST_GROUP_DUMMY Sözde Maliyet Grubu US CST_SRS_COST_GROUP_DUMMY Cost Group Dummy ZHS CST_SRS_COST_GROUP_DUMMY 虚拟成本组 3 -80 :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 组织标识 组织标识 4 -70 :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 de Conta RU Структура счетов Структура счетов S Kontostruktur Kontostruktur TR Hesap Yapısı Hesap Yapısı US Account Structure Account Structure ZHS 帐户结构 帐户结构 5 -60 :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 Bokföringsperiod-id TR Hesap Dönemi No Hesap Dönemi No US Account Period Id Account Period Id ZHS 帐户期间标识 帐户期间标识 6 -50 :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 数量精确度 数量精确度 7 -40 :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 提交者 提交者 8 -30 :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 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 显示逆汇率 9 -20 :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 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 汇率类型 10 10 :p_job_selection LOV Oracle CST_SRS_JOB_SELECTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_JOB_SELECTION_CRITERIA' and :$flex$.cst_srs_job_sel_dummy=1 order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_JOB_SELECTION_CRITERIA' AND LOOKUP_CODE = 1 AND :$FLEX$.CST_SRS_JOB_SEL_DUMMY = 1 AR اختيار أمر الشغل اختيار أمر الشغل D Auftragsauswahl Auftragsauswahl E Selección de Órdenes de Fabricación Selección de Órdenes de Fabricación F Sélection ordre de fabrication Sélection ordre de fabrication I Selezione OdL Selezione OdL JA 製造オーダー選択 製造オーダー選択 KO 작업 선택 작업 선택 PTB Seleção de Ordem de Produção Seleção de Ordem de Produção RU Выбор задания Выбор задания S Jobburval Jobburval TR İş Seçimi İş Seçimi US Job Selection Job Selection ZHS 任务选择 任务选择 11 20 :p_cost_group_id LOV Oracle CST_SRS_COST_GROUP2 Y select cg.cost_group_id id, cg.cost_group value, null 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 and :$flex$.cst_srs_cost_group_dummy=1 order by cost_group SELECT CG.COST_GROUP, CG.DESCRIPTION FROM CST_COST_GROUPS CG WHERE :$FLEX$.CST_SRS_COST_GROUP_DUMMY = 1 AND NVL(CG.ORGANIZATION_ID,fnd_profile.value('MFG_ORGANIZATION_ID'))= fnd_profile.value('MFG_ORGANIZATION_ID') AR مجموعة التكاليف مجموعة التكاليف D Kostengruppe Kostengruppe E Grupo de Costes Grupo de Costes F Groupe de coûts Groupe de coûts I Gruppo di costi Gruppo di costi JA 原価グループ 原価グループ KO 원가 그룹 원가 그룹 PTB Grupo de Custos Grupo de Custos RU Группа затрат Группа затрат S Kostnadsgrupp Kostnadsgrupp TR Maliyet Grubu Maliyet Grubu US Cost Group Cost Group ZHS 成本组 成本组 12 30 :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 Sortieren nach E Ordenar por Opción de Clasificación del Informe F Tri par Option tri état I Ordina per Opzione di ordinamento rapporto JA ソート・キー レポート・ソート・オプション KO 정렬 기준 보고서 정렬 옵션 PTB Classificar por Opção de Classificação do Relatório RU Сортировка Параметр сортировки отчета S Sortera efter Sorteringsalternativ för rapport TR Sıralama Bazı Rapor Sıralama Seçeneği US Sort By Report Sort Option ZHS 排序依据 报表排序选项 13 40 :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 Option Auswertungsart E Tipo de Informe Opción de Ejecución de Informes F Type d'état Option d'édition é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 Rapportkörningsalternativ TR Rapor Tipi Rapor Çalıştırma Seçeneği US Report Type Report Run Option ZHS 报表类型 报表运行选项 14 50 :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 Clase F Type de classe Type de 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 分类类型 分类类型 15 60 :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 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 包括批量 包括批量需求 16 70 :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 Lieferant Mit Lieferantenbedarf E Incluir Proveedor Incluir necesidades 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 Vendor Include Vendor Requirements ZHS 包括供应商 包括供应商需求 17 80 :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 Classe - Da JA 区分:自 区分:自 KO From 분류 분류: 부터 PTB Classes De Classe - De RU Классы с Класс с S Från klasser Klass från TR Sınıflar: İlk Sınıflar: İlk US Classes From Class From ZHS 分类自 分类自 18 90 :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 Classe - A JA 至 区分:至 KO 까지 분류: 까지 PTB Até Classe - Até RU По Класс по S Till Klass till TR Son Sınıflar: Son US To Class To ZHS 至 分类至 19 100 :job_from LOV Oracle WIP_SRS_DISCRETE_JOBS_OPT3 Y select we.wip_entity_name id, we.wip_entity_name value, null description from wip_entities we where we.entity_type!=2 and we.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and ((nvl(:$flex$.cst_srs_job_selection:null,3)=2 and (we.wip_entity_id,we.organization_id) in (select wdj.wip_entity_id,wdj.organization_id from wip_discrete_jobs wdj where wdj.project_id is null)) or (nvl(:$flex$.cst_srs_job_selection:null,3)=3) or (nvl(:$flex$.cst_srs_job_selection:null,3)=1 and (we.wip_entity_id,we.organization_id) in (select wdj.wip_entity_id,wdj.organization_id from mrp_project_parameters mpp,wip_discrete_jobs wdj where mpp.organization_id=wdj.organization_id and wdj.project_id=mpp.project_id and mpp.costing_group_id=nvl(:$flex$.cst_srs_cost_group2:null,-999)))) 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 Ordres de fabrication - De I OdL - Da OdL - Da JA 製造オーダー:自 製造オーダー:自 KO From 작업 From 작업 PTB Ordens de Produção - De Ordens de Produção - De RU Задания с Задания с S Från TO Från TO TR İş Emirleri: İlk İş Emirleri: İlk US Jobs From Jobs From ZHS 任务自 任务自 20 110 :job_to LOV Oracle WIP_SRS_DISCRETE_JOBS_OPT3 Y select we.wip_entity_name id, we.wip_entity_name value, null description from wip_entities we where we.entity_type!=2 and we.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and ((nvl(:$flex$.cst_srs_job_selection:null,3)=2 and (we.wip_entity_id,we.organization_id) in (select wdj.wip_entity_id,wdj.organization_id from wip_discrete_jobs wdj where wdj.project_id is null)) or (nvl(:$flex$.cst_srs_job_selection:null,3)=3) or (nvl(:$flex$.cst_srs_job_selection:null,3)=1 and (we.wip_entity_id,we.organization_id) in (select wdj.wip_entity_id,wdj.organization_id from mrp_project_parameters mpp,wip_discrete_jobs wdj where mpp.organization_id=wdj.organization_id and wdj.project_id=mpp.project_id and mpp.costing_group_id=nvl(:$flex$.cst_srs_cost_group2:null,-999)))) order by wip_entity_name AR إلى 2 أوامر شغل إلى D Bis 2 Bis Fertigungsauftrag E A 2 A Orden de Fabricación F A 2 Ordres de fabrication - A I A 2 OdL - A JA 至 2 製造オーダー:至 KO 까지 2 단속작업:까지 PTB Até 2 Ordens de Produção - Até RU По 2 Задания по S Till 2 Till TO TR Son 2 İş Emirleri: Son US To 2 Jobs To ZHS 至 2 任务至 21 120 :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 状态 状态 22 130 :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 装配件自 物料自 23 140 :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 物料至 24 150 :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ód. da Moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi Kodu US Currency Currency Code ZHS 币种 币种代码 25 160 :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 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_COST_GROUP_DUMMY CST_SRS_COST_GROUP_DUMMY Cost Group :$FLEX$.CST_SRS_JOB_SEL_DUMMY CST_SRS_JOB_SEL_DUMMY Job Selection :$flex$.cst_srs_cost_group_dummy CST_SRS_COST_GROUP_DUMMY Cost Group :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_job_sel_dummy CST_SRS_JOB_SEL_DUMMY Job Selection :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate :$flex$.job_selection Job Selection CST_SRS_COST_GROUP_DUMMY