ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8951A9E05362FB09050512 SELECT CPCS.subinventory_code sub_code, DECODE(CPCS.subinventory_code, NULL, :P_NULLSUB, SUB.description) sub_description, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_seg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') sub_item, round(SUM(CPCS.accounted_value) * (:P_EXCHANGE_RATE) / :P_ROUND_UNIT) * :P_ROUND_UNIT sub_acc_val, round(SUM(CPCS.rollback_value) * (:P_EXCHANGE_RATE) / :P_ROUND_UNIT) * :P_ROUND_UNIT sub_onh_val, round(SUM(CPCS.rollback_value - CPCS.accounted_value) * (:P_EXCHANGE_RATE) / :P_ROUND_UNIT) * :P_ROUND_UNIT sub_adj_val FROM mtl_system_items_b_kfv MSI, mtl_secondary_inventories SUB, &P_SOURCE_TABLE CPCS WHERE MSI.organization_id = :p_org_id AND SUB.organization_id(+) = :p_org_id AND CPCS.inventory_item_id = MSI.inventory_item_id AND CPCS.subinventory_code = SUB.secondary_inventory_name(+) AND MSI.concatenated_segments BETWEEN NVL(:P_ITEM_FROM, MSI.concatenated_segments) AND NVL(:P_ITEM_TO, MSI.concatenated_segments) AND NVL(CPCS.subinventory_code,-1) BETWEEN NVL(:P_SUB_FROM, NVL(CPCS.subinventory_code,-1)) AND NVL(:P_SUB_TO, NVL(CPCS.subinventory_code,-1)) AND &P_CPCS_WHERE GROUP BY CPCS.subinventory_code, DECODE(CPCS.subinventory_code, NULL, :P_NULLSUB, SUB.description), fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_seg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') &P_SUB_SORT_TEXT Y BOM CSTRPCRE_XML AR CST تقرير تسوية إقفال الفترة (تنسيق XML) Imported from BI Publisher Description: تقرير تسوية إقفال الفترة Application: شجرة المنتجات Source: تقرير تسوية إقفال الفترة (تنسيق XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG D CST Periodenabschluss - Abstimmung Imported from BI Publisher Description: Periodenabschluss - Abstimmung Application: Produktionsdaten Source: Periodenabschluss - Abstimmung (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG E CST Conciliación de Cierres de Períodos Imported from BI Publisher Description: Informe de conciliación de cierres de períodos Application: Bills of Material Source: Conciliación de Cierres de Períodos (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG F CST Etat du rapprochement des clôtures de période Imported from BI Publisher Description: Etat du rapprochement des clôtures de période Application: Bills of Material Source: Etat du rapprochement des clôtures de période (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG I CST Rapporto Quadratura chiusura periodo Imported from BI Publisher Description: Rapporto Quadratura chiusura periodo Application: Bills of Material Source: Rapporto Quadratura chiusura periodo (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG JA CST 期間クローズ調整レポート Imported from BI Publisher Description: 期間クローズ調整レポート Application: Bills of Material Source: 期間クローズ調整レポート(XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG KO CST 기간 마감 대사 보고서 Imported from BI Publisher Description: 기간 마감 대사 보고서 Application: Bills of Material Source: 기간 마감 대사 보고서(XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG PTB CST Relatório de Reconciliação do Fechamento do Período Imported from BI Publisher Description: Relatório de Reconciliação do Fechamento do Período Application: Bills of Material Source: Relatório de Reconciliação do Fechamento do Período (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG RU CST Отчет о выверке при закрытии периода Imported from BI Publisher Description: Отчет о выверке при закрытии периода Application: Спецификации Source: Отчет о выверке при закрытии периода (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG S CST Periodstängning - avstämningsrapport Imported from BI Publisher Description: Periodstängning - avstämningsrapport Application: Bills of Material Source: Periodstängning - avstämningsrapport (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG TR CST Dönem Kapanışı Mutabakat Raporu Imported from BI Publisher Description: Dönem Kapanışı Mutabakat Raporu Application: Ürün Ağacı Source: Dönem Kapanışı Mutabakat Raporu (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG US CST Period Close Reconciliation Imported from BI Publisher Description: Period Close Reconciliation Report Application: Bills of Material Source: Period Close Reconciliation Report (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG ZHS CST 期间关闭调节报表 Imported from BI Publisher Description: 期间关闭调节报表 Application: 物料清单管理系统 Source: 期间关闭调节报表 (XML) Short Name: CSTRPCRE_XML DB package: BOM_CSTRPCRE_XMLP_PKG BI Publisher &p_cpcs_where &p_source_table &p_sub_sort_text :p_cg_from :p_cg_sort_text :p_cg_to :p_conc_request_id :p_cpcs_where :p_currency_code :p_currency_dsp :p_exchange_rate :p_exchange_rate_char :p_from_date :p_gl_num :p_item_from :p_item_seg :p_item_to :p_nullsub :p_org_id :p_org_name :p_period_id :p_period_name :p_rate_type :p_report_type :p_round_unit :p_simulation :p_sort_option :p_sort_text :p_source_table :p_sub_from :p_sub_sort_text :p_sub_to :p_to_date :p_to_date1 :p_trace :pv_report_type :pv_sort_option 1 -60 :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 -50 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I ID piano dei conti ID piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB ID do Plano de Contas ID do Plano de Contas RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts ID Chart of Accounts ID ZHS 科目表标识 科目表标识 3 -40 :p_report_type LOV Oracle CST_PER_CLOSE_REP_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_PER_CLOSE_REP_TYPE' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS, MTL_PARAMETERS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND LOOKUP_TYPE = 'CST_PER_CLOSE_REP_TYPE' AND LOOKUP_CODE = DECODE(primary_cost_method,1,DECODE(WMS_ENABLED_FLAG, 'Y',1,DECODE(COST_GROUP_ACCOUNTING,1,DECODE(PROJECT_REFERENCE_ENABLED,1,1,2),2)),1) Y AR نوع التقرير نوع عرض التقرير D Auswertungsart Anzeigeart Auswertung E Tipo de Informe Tipo de Presentación del Informe F Type d'état Type d'affichage de l'état I Tipo di rapporto Tipo di visualizzazione del rapporto JA レポート・タイプ レポートの表示タイプ KO 보고서 유형 보고서의 표시 유형입니다. PTB Tipo de Relatório Tipo de exibição do relatório RU Тип отчета Тип вывода отчета S Rapporttyp Rapportens visningstyp TR Rapor Tipi Raporun görünüm tipi US Report Type Report's display type ZHS 报表类型 报表的显示类型 4 -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 显示逆汇率 5 -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 汇率类型 6 10 :p_sort_option LOV Oracle CST_PER_CLOSE_SORT_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_PER_CLOSE_SORT_OPTION' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_PER_CLOSE_SORT_OPTION' AND LOOKUP_CODE = 1 Y AR خيار الفرز ترتيب الأعمدة المراد الفرز حسبه D Sortieroption Reihenfolge der Spalten, nach denen sortiert wird E Opción de Clasificación Orden de Clasificación de las Columnas F Option de tri Ordre des colonnes pour le tri I Opzione di ordinamento Opzione per l'ordinamento delle colonne JA ソート・オプション ソートに使用する列の順序 KO 정렬 옵션 정렬할 컬럼 순서입니다. PTB Opção de Classificação Ordem de colunas para classificação RU Параметр сортировки Порядок столбцов, по которым выполняется сортировка S Sorteringsalternativ Kolumnordning att sortera utifrån TR Sıralama Seçeneği Sıralanacak sütun düzeni US Sort Option Order of columns to sort by ZHS 排序选项 排序所依据的列顺序 7 20 :p_period_id LOV Oracle CST_PER_CLOSE_PERIODS Y select oap.acct_period_id id, oap.period_name value, null description from org_acct_periods oap,org_acct_periods_v oapv where oap.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and (((select count(*) from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and summarized_flag='Y')=0 and ( (oap.open_flag='N' and oap.summarized_flag='N') or (oap.acct_period_id= (select min(acct_period_id) from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and open_flag='Y' and summarized_flag is null) ) )) or ((select count(*) from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and summarized_flag='Y')>0 and oap.acct_period_id between (select min(acct_period_id) from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and summarized_flag='Y') and (select min(acct_period_id) from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and acct_period_id> (select max(acct_period_id) from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and summarized_flag='Y') ))) and oapv.acct_period_id=oap.acct_period_id order by period_start_date desc Y AR الفترة الفترة المراد تشغيل التقرير لها D Periode Periode, für die die Auswertung gestartet wird E Período Período en que se Va a Ejecutar el Informe F Période Période pour laquelle éditer l'état I Periodo Periodo di esecuzione del rapporto JA 期間 レポートを実行する期間 KO 기간 보고서 실행 기간입니다. PTB Período Período para execução do relatório RU Период Период, за который выполняется отчет S Period Period som rapporten ska köras för TR Dönem Raporun çalıştırılacağı dönem US Period Period to run report for ZHS 期间 运行报表的期间 8 30 :p_to_date Date AR تشغيل لتاريخه التاريخ المطلوب الإجمالي إليه D Ausführen bis Datum Bis zu diesem Datum wird die Übersicht erstellt. E A Fecha de Ejecución Fecha de Finalización de Resumen F Exécuter jusqu'à la date Date jusqu'à laquelle doit porter la synthèse I Progressivo esecuzione Data limite di esecuzione del sintetico JA 実行日付:至 要約期間の終了日 KO 실행 종료 일자 요약을 종료하는 일자입니다. PTB Data da Execução - Até Até que data sumariar RU Конечная дата выполнения Дата, до которой выполняется сведение S Kör fram till den Fram till vilket datum som summering ska genomföras TR Bugüne Kadarki Çalıştırma Hangi tarihe kadar özetleneceği US Run To Date What date to summarize until ZHS 运行截止日期 汇总终止日期 9 40 :p_cg_from LOV Oracle CST_SRS_COST_GROUP_NAMES Y select ccg.cost_group id, ccg.cost_group value, ccg.description description from cst_cost_groups ccg,((select cost_group_id,organization_id from cst_cost_group_accounts) union (select default_cost_group_id cost_group_id,organization_id from mtl_parameters)) ccga where ccg.cost_group_id=ccga.cost_group_id and ccga.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(ccg.disable_date,sysdate+1)>sysdate order by cost_group AR مجموعة التكلفة من من أي مجموعة تكلفة D Von Kostengruppe Ab dieser Kostengruppe wird die Auswertung erstellt. E De Grupo de Costes Grupo de Costes Inicial F Groupe de coûts - De Groupe de coûts de début I Gruppo di costi - Da Gruppo di costi di origine JA 原価グループ:自 原価グループの始まり KO 원가 그룹: 부터 출처 원가 그룹입니다. PTB Grupo de Custos - De De que Grupo de Custos RU Группа затрат с Исходная группа затрат S Från kostnadsgrupp Från vilken kostnadsgrupp TR İlk Maliyet Grubu Hangi Maliyet Grubundan başlanacağı US Cost Group From From what Cost Group ZHS 成本组自 起始成本组 10 50 :p_cg_to LOV Oracle CST_SRS_COST_GROUP_NAMES Y select ccg.cost_group id, ccg.cost_group value, ccg.description description from cst_cost_groups ccg,((select cost_group_id,organization_id from cst_cost_group_accounts) union (select default_cost_group_id cost_group_id,organization_id from mtl_parameters)) ccga where ccg.cost_group_id=ccga.cost_group_id and ccga.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(ccg.disable_date,sysdate+1)>sysdate order by cost_group AR مجموعة التكلفة إلى إلى أي مجموعة تكلفة D Bis Kostengruppe Bis zu dieser Kostengruppe wird die Auswertung erstellt. E A Grupo de Costes Grupo de Costes Final F Groupe de coûts - A Groupe de coûts de fin I Gruppo di costi - A Gruppo di costi di destinazione JA 原価グループ:至 原価グループの終わり KO 원가 그룹: 까지 대상 원가 그룹입니다. PTB Grupo de Custos - Até Até que Grupo de Custos RU Группа затрат по Конечная группа затрат S Till kostnadsgrupp Till vilken kostnadsgrupp TR Son Maliyet Grubu Hangi Maliyet Grubuna kadar olduğu US Cost Group To To what Cost Group ZHS 成本组至 终止成本组 11 60 :p_sub_from LOV Oracle CST_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR مخزن من من أي مخزن D Von Lager Ab diesem Lager wird die Auswertung erstellt. E De Subalmacén Subalmacén Inicial F Magasin - De Magasin de début I Sottomagazzino - Da Sottomagazzino di origine JA 保管場所:自 保管場所の始まり KO 창고: 부터 출처 창고입니다. PTB Subinventário - De De que Subinventário RU Складское подразделение с Исходное складское подразделение S Från lagerställe Från vilket lagerställe TR Stok Yeri: İlk Hangi Stok Yerinden başlanacağı US Subinventory From From what Subinventory ZHS 子库存自 起始子库存 12 70 :p_sub_to LOV Oracle CST_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR مخزن إلى إلى أي مخزن D Bis Lager Bis zu diesem Lager wird die Auswertung erstellt. E A Subalmacén Subalmacén Final F Magasin - A Magasin de fin I Sottomagazzino - A Sottomagazzino di destinazione JA 保管場所:至 保管場所の終わり KO 창고: 까지 대상 창고입니다. PTB Subinventário - Até Até que Subinventário RU Складское подразделение по Конечное складское подразделение S Till lagerställe Till vilket lagerställe TR Stok Yeri: Son Hangi Stok Yerine kadar olduğu US Subinventory To To what Subinventory ZHS 子库存至 终止子库存 13 80 :p_item_from Char AR الصنف من من أي صنف D Von Artikel Ab diesem Artikel wird die Auswertung erstellt. E De Artículo Artículo Inicial F Article - De Article de début I Articolo - Da Articolo di origine JA 品目:自 品目の始まり KO 품목: 부터 출처 품목입니다. PTB Item - De De que Item RU Позиция с Исходная позиция S Från artikel Från vilken artikel TR Kalem, İlk Hangi Kalemden başlanacağı US Item From From what Item ZHS 物料自 起始物料 14 90 :p_item_to Char AR الصنف إلى إلى أي صنف D Bis Artikel Bis zu diesem Artikel wird die Auswertung erstellt. E A Artículo Artículo Final F Article - A Article de fin I Articolo - A Articolo di destinazione JA 品目:至 品目の終わり KO 품목: 까지 대상 품목입니다. PTB Item - Até Até que Item RU Позиция по Конечная позиция S Till artikel Till vilken artikel TR Kalem, Son Hangi Kaleme kadar olduğu US Item To To what Item ZHS 物料至 终止物料 15 100 :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 币种 币种 16 110 :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_rate_type CST_SRS_RATE_TYPE Exchange Rate