ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472A151A9E05362FB09050512Y select wpb.wip_entity_id cum_entity_id, wpb.organization_id cum_organization_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), :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), :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), :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), :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), :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 wpb.acct_period_id IN (select oap.acct_period_id from org_acct_periods oap where trunc(oap.period_start_date) >= :PER_START_DATE and trunc(oap.schedule_close_date) <= :PER_SCHD_CLS_DATE and oap.organization_id = wdj.organization_id) and wdj.wip_entity_id = wpb.wip_entity_id and wdj.organization_id = wpb.organization_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 wpb.wip_entity_id=:parent_entity_id and wpb.organization_id=:parent_org_id group by wpb.wip_entity_id, wpb.organization_id, ml_elem_type.meaning, &P_FLEXDATA_ACCT, ml_elem_type.lookup_code,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') order by ml_elem_type.lookup_code WIP WIPREJVR_XML AR WIP تقرير قيم أوامر شغل المصروفات (بتنسيق XML) Imported from BI Publisher Description: تقرير قيمة أمر شغل المصروفات Application: العمل في الإنجاز Source: تقرير قيم أوامر شغل المصروفات (بتنسيق XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG D WIP Sonderaufträge (Aufwand) - Auftragswerte Imported from BI Publisher Description: Auswertung "Sonderaufträge (Aufwand) - Auftragswerte" Application: Fertigung Source: Sonderaufträge (Aufwand) - Auftragswerte (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG E WIP Valor de Orden de Fabricación de Gasto Imported from BI Publisher Description: Informe de valor de orden de fabricación de gasto Application: Work in Process Source: Valor de Orden de Fabricación de Gasto (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG F WIP Etat Valeurs des OF passés en charges Imported from BI Publisher Description: Etat Valeurs des OF passés en charges Application: Work In Process Source: Etat Valeurs des OF passés en charges (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG I WIP Rapporto Valori OdL di spesa Imported from BI Publisher Description: Rapporto Valore OdL di spesa Application: Work in Process Source: Rapporto Valori OdL di spesa (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG JA WIP 費用製造オーダー価額レポート Imported from BI Publisher Description: 費用製造オーダー価額レポート Application: Work in Process Source: 費用製造オーダー価額レポート(XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG KO WIP 비용 작업 원가 보고서 Imported from BI Publisher Description: 비용 작업 원가 보고서 Application: Work in Process Source: 비용 작업 원가 보고서(XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG PTB WIP Relatório Valores Ordem Produção de Despesas Imported from BI Publisher Description: Rel.Val. Ord. Prod.Desp. Application: Work in Process Source: Relatório Valores Ordem Produção de Despesas (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG RU WIP Отчет о стоимости заданий-пассивов Imported from BI Publisher Description: Отчет о стоимости заданий-пассивов Application: Незавершенное производство Source: Отчет о стоимости заданий-пассивов (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG S WIP TO-förbrukningsvärde - rapport Imported from BI Publisher Description: TO-förbrukningsvärde - rapport Application: Work in Process Source: TO-förbrukningsvärde - rapport (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG TR WIP Gider İş Emri Değer Raporu Imported from BI Publisher Description: Gider İş Emri Değer Raporu Application: Üretim İzleme Source: Gider İş Emri Değer Raporu (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG US WIP Expense Job Value Imported from BI Publisher Description: Expense Job Value Report Application: Work in Process Source: Expense Job Value Report (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG ZHS WIP 费用任务值报表 Imported from BI Publisher Description: 费用任务值报表 Application: 在制品管理系统 Source: 费用任务值报表 (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG BI Publisher &p_flexdata_acct :class_from :class_to :class_type_name :currency_code :ext_precision :group_id :job_from :job_to :lper_schd_cls_date :lper_start_date :org_id :org_name :p_conc_request_id :p_debug :p_flexdata_acct :p_flexdata_item :p_from_item :p_item_flex_num :p_order_flex :p_outer :p_qty_precision :p_struct_num :p_subselect :p_to_item :p_where_item :parent_entity_id :parent_org_id :per_schd_cls_date :per_start_date :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 -50 :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 -40 :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 -30 :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 数量精确度 数量精确度 4 -20 :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 提交者 提交者 5 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 排序依据 报表排序选项 6 20 :report_run_opt LOV Oracle WIP_SRS_EXP_VALUE_TYPE_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_BICR_DETAIL_OPTION' and lookup_code in (1,2) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_BICR_DETAIL_OPTION' 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 报表类型 报表运行选项 7 30 :per_start_date LOV Oracle WIP_SRS_PERIODS_START_DATE_OPT_STANDARD Y select period_start_date id, period_start_date value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by period_start_date Y AR تاريخ بداية الفترة الفترات من D Datum von Datum von E Fecha Inicio Período De Período F Date de début de période Périodes - De I Data inizio periodo Periodi - Da JA 期間開始日 期間:自 KO 기간 시작 일자 기간: 부터 PTB Data Inicial do Período Períodos - De RU Начало периода Периоды с S Startdatum för period Perioder från TR Dönem Başlangıç Tarihi Dönemler: İlk US Period Start Date Periods from ZHS 期间起始日期 期间自 8 40 :per_schd_cls_date LOV Oracle WIP_SRS_SCHD_CLOSE_DATE_OPT_STANDARD Y select schedule_close_date id, schedule_close_date value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_close_date Y AR تاريخ إقفال الفترة الفترات إلى D Periodenabschlussdatum Bis E Fecha de Cierre del Período A Período F Date de clôture de période Périodes - A I Data chiusura periodo Periodi - A JA 期間クローズ日 期間:自 KO 기간 마감 일자 기간: 까지 PTB Data de Fechamento do Período Períodos - até RU Дата закрытия периода Периоды по S Stängningsdatum för period Perioder till TR Dönem Kapanış Tarihi Dönemler: Son US Period Close Date Periods to ZHS 期间关闭日期 期间至 9 50 :class_from LOV Oracle WIP_SRS_EXP_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=4 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 分类自 分类自 10 60 :class_to LOV Oracle WIP_SRS_EXP_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=4 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 至 分类至 11 70 :job_from LOV Oracle WIP_SRS_EXPENSE_JOBS_OPT Y select we.wip_entity_name id, we.wip_entity_name value, null description from wip_entities we,wip_discrete_jobs dj where we.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and we.organization_id=dj.organization_id and we.wip_entity_id=dj.wip_entity_id and we.entity_type not in (2,9,10) and dj.job_type=3 order by value,description 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 任务自 任务自 12 80 :job_to LOV Oracle WIP_SRS_EXPENSE_JOBS_OPT Y select we.wip_entity_name id, we.wip_entity_name value, null description from wip_entities we,wip_discrete_jobs dj where we.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and we.organization_id=dj.organization_id and we.wip_entity_id=dj.wip_entity_id and we.entity_type not in (2,9,10) and dj.job_type=3 order by value,description 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 任务至 13 90 :status_type LOV Oracle WIP_SRS_JOB_STATUS_EXPVAL_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 (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 状态 状态 14 100 :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 装配件自 物料自 15 110 :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 物料至