ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB151A9E05362FB09050512 SELECT /*+ leading(cmd) cardinality(cmd,1) */ distinct iim.item_number item_no1, mp.organization_code orgn_code, iim.description item_desc, decode(cmd.cost_level, 0 ,'This Level Cost',1,'Lower Level','None') Cost_level, cmm.cost_cmpntcls_code component_code, cmd.cost_analysis_code analysis_code, cmd.cmpnt_cost * :P_EXCHANGE_RATE component_cost, iim.primary_uom_code uom, cmm.sort_sequence sequence, cmm.cost_cmpntcls_id component_id, cmm.cost_cmpntcls_desc component_desc FROM mtl_item_flexfields iim, cm_cmpt_dtl_vw cmd, mtl_parameters mp, cm_cmpt_mst cmm, mtl_categories_kfv mckfv, mtl_item_categories mic , gmd_org_access_vw oa WHERE cmd.period_id = :period_id AND cmd.cost_type_id = :p_cost_type_id AND iim.inventory_item_id = cmd.inventory_item_id AND cmd.organization_id = iim.organization_id AND iim.organization_id = mp.organization_id AND cmm.cost_cmpntcls_id = cmd.cost_cmpntcls_id AND cmd.delete_mark = 0 AND iim.inventory_item_id = mic.inventory_item_id(+) AND iim.organization_id = mic.organization_id(+) AND mic.category_id = mckfv.category_id(+) and mckfv.structure_id(+) = :p_category_structure_id AND mp.organization_id = oa.organization_id &OrganizationCP &ItemCP &CostCategoryCP ORDER BY iim.item_number, mp.organization_code, cmm.sort_sequence, cmm.cost_cmpntcls_code, cmd.cost_analysis_code Y GMF CMR05USR_XML AR GMF تقرير تفاصيل تكلفة الصنف (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل تكلفة صنف إدارة تكلفة OPM Application: ماليات التصنيع التشغيلي Source: تقرير تفاصيل تكلفة الصنف (تنسيق XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG D GMF Materialkostendetails Imported from BI Publisher Description: Auswertung "Materialkostendetails" in OPM CM Application: Process Manufacturing Financials Source: Materialkostendetails (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG E GMF Detalle de Costes de Artículos Imported from BI Publisher Description: Informe Detalles de Costes de Artículos de CM de OPM Application: Process Manufacturing Financials Source: Detalle de Costes de Artículos (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG F GMF Etat détaillé des coûts article Imported from BI Publisher Description: Etat détaillé des coûts article d'OPM CM Application: Process Manufacturing Financials Source: Etat détaillé des coûts article (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG I GMF Rapporto Dettaglio costo articolo Imported from BI Publisher Description: Rapporto Dettaglio costo articolo di OPM CM Application: Process Manufacturing Financials Source: Rapporto Dettaglio costo articolo (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG JA GMF 品目原価詳細レポート Imported from BI Publisher Description: OPM CM品目原価詳細レポート Application: Process Manufacturing Financials Source: 品目原価詳細レポート(XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG KO GMF 품목 원가 상세 보고서 Imported from BI Publisher Description: OPM CM의 품목 원가 상세 보고서 Application: Process Manufacturing Financials Source: 품목 원가 상세 보고서(XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG PTB GMF Relatório Detalhado de Custo do Item Imported from BI Publisher Description: Relatório Detalhado de Custos do Item do CM do OPM Application: Process Manufacturing Financials Source: Relatório Detalhado de Custo do Item (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG RU GMF Подробный отчет о стоимости позиций Imported from BI Publisher Description: Подробный отчет о стоимостях позиций ЗАТ УНП Application: Финансы УНП Source: Подробный отчет о стоимости позиций (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG S GMF Kostnad för artikel - detaljrapport Imported from BI Publisher Description: Artikelkostnad - detaljrapport i OPM GMC Application: Processtillverkning: Ekonomi Source: Kostnad för artikel - detaljrapport (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG TR GMF Kalem Maliyeti Detay Raporu Imported from BI Publisher Description: OPM CM Kalem Maliyeti Detay Raporu Application: Üretim Prosesi Finansal Yönetim Source: Kalem Maliyeti Detay Raporu (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG US GMF Item Cost Detail Imported from BI Publisher Description: Item Cost Detail Report of OPM CM Application: Process Manufacturing Financials Source: Item Cost Detail Report (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG ZHS GMF 项目成本明细报表 Imported from BI Publisher Description: OPM CM 的物料成本详细资料报表 Application: OPM 财务管理系统 Source: 项目成本明细报表 (XML) Short Name: CMR05USR_XML DB package: GMF_CMR05USR_XMLP_PKG BI Publisher &costcategorycp &itemcp &organizationcp :costcategorycp :from_cost_category :from_item :from_orgn :itemcp :lp_currency_code :lp_exchange_rate :nonblocksql :organizationcp :p_calendar :p_category_structure_id :p_conc_request_id :p_cost_type_id :p_currency_code :p_exchange_rate :p_from_cost_category_id :p_from_item_id :p_from_organization_id :p_legal_entity_id :p_period_code :p_to_cost_category_id :p_to_item_id :p_to_organization_id :period_id :sy_all :to_cost_category :to_item :to_orgn 1 -40 :p_category_structure_id LOV Oracle GMF_SRS_CATEGORY_STRUCTURE_ID Y select mcs.structure_id id, mcs.structure_id value, null description from mtl_default_category_sets mdc,mtl_category_sets mcs where mdc.functional_area_id=19 and mcs.category_set_id=mdc.category_set_id order by value,description SELECT mcs.structure_id FROM mtl_default_category_sets mdc, mtl_category_sets mcs WHERE mdc.functional_area_id = 19 and mcs.category_set_id = mdc.category_set_id AR معرف الهيكل معرف الهيكل الافتراضي D Strukturkennung Dummy-Strukturkennung E Id Estructura Id Estructura Ficticia F ID structure ID structure fictif I Id struttura Id della struttura fittizia JA 体系ID ダミー体系ID KO 구조 ID Dummy 구조 ID PTB Id da Estrutura ID da Estrutura Fictícia RU Идент. структуры Фиктивный идентификатор структуры S Struktur-id Id för dummy-struktur TR Yapı No Sözde Yapı No US Structure Id Dummy Structure ID ZHS 结构标识 虚拟结构标识 2 -30 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 3 -20 :nonblocksql LOV Oracle NONBLOCKSQL Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108473 order by ffvv.flex_value NO AR Sql غير مدرج بالقطعة Sql غير مدرج بالقطعة E SQL No Bloqueante SQL No Bloqueante F SQL hors bloc SQL hors bloc JA 未ブロックSQL 未ブロックSQL KO 비블록 SQL 비블록 SQL PTB Sql de Não Bloqueio Sql de Não Bloqueio RU SQL без блоков SQL без блоков S Icke-blockerande SQL Icke-blockerande SQL TR Blok Dışı Sql Blok Dışı Sql US Non Block Sql Non Block Sql ZHS 非块结构 SQL 非块结构 SQL 4 10 :p_legal_entity_id LOV Oracle GMF_SRS_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gmf_legal_entities where legal_entity_id in (select legal_entity_id from gmf_fiscal_policies) order by legal_entity_name SELECT legal_entity_name FROM gmf_legal_entities where legal_entity_id = :PARAMETER.NUMBER1 Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa Jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity ZHS 法人主体 法人主体 5 20 :p_calendar LOV Oracle GMF_SRS_CALENDAR_CODE Y select cht.calendar_code id, cht.calendar_code value, cht.calendar_desc description from cm_cldr_hdr_tl cht where cht.language=userenv('LANG') and exists (select 'x' from gmf_calendar_assignments gca where gca.legal_entity_id=:$flex$.gmf_srs_legal_entity and gca.calendar_code=cht.calendar_code) order by calendar_code SELECT calendar_code FROM cm_cldr_hdr_tl where calendar_code = :PARAMETER.CHAR1 AND language = userenv('LANG') Y AR CALENDAR_CODE رمز التقويم D CALENDAR_CODE Kalendercode E CALENDAR_CODE Código de Calendario F CALENDAR_CODE Code calendrier I CALENDAR_CODE Codice calendario JA CALENDAR_CODE カレンダ・コード KO CALENDAR_CODE 달력 코드 PTB CALENDAR_CODE Cód. Calendário RU CALENDAR_CODE Код календаря S CALENDAR_CODE Kalenderkod TR CALENDAR_CODE Takvim Kodu US CALENDAR_CODE Calendar Code ZHS CALENDAR_CODE 日历代码 6 30 :p_period_code LOV Oracle PERIOD_CODE Y select period_code id, period_code value, period_desc description from cm_cldr_dtl where calendar_code=:$flex$.calendar_code and delete_mark=0 order by start_date SELECT period_code FROM gmf_period_statuses where period_id = :PARAMETER.NUMBER2 Y AR الفترة رمز الفترة D Periode Periodencode E Período Código de Período F Période Code période I Periodo Codice periodo JA 期間 期間コード KO 기간 기간 코드 PTB Período Código do Período RU Период Код периода S Period Periodkod TR Dönem Dönem Kodu US Period Period Code ZHS 期间 期间代码 7 40 :p_cost_type_id LOV Oracle GMF_SRS_COST_TYPES Y select mthd.cost_type_id id, mthd.cost_mthd_code value, mthd.cost_mthd_desc description from cm_mthd_mst mthd where mthd.delete_mark=0 and exists ( select 'x' from gmf_calendar_assignments gca where gca.legal_entity_id=:$flex$.gmf_srs_legal_entity and gca.cost_type_id=mthd.cost_type_id) order by mthd.cost_mthd_code SELECT distinct cost_mthd_code FROM cm_mthd_mst WHERE cost_type_id = :PARAMETER.NUMBER3 Y AR نوع التكلفة نوع التكلفة D Kostenrechnungsart Kostenrechnungsart E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de Custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet Tipi US Cost Type Cost Type ZHS 成本类型 成本类型 8 50 :p_from_organization_id LOV Oracle GMF_SRS_FROM_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity order by value,description SELECT organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER4 AR من التنظيم من التنظيم D Von Organisation Von Organisation E De Organización De Organización F Organisation d'origine Organisation d'origine I Organizzazione - Da Organizzazione - Da JA 組織:自 組織:自 KO 조직: 부터 조직: 부터 PTB Da Organização Da Organização RU Организация с Организация с S Från organisation Från organisation TR İlk Organizasyon İlk Organizasyon US From Organization From Organization ZHS 起始组织 起始组织 9 60 :p_to_organization_id LOV Oracle GMF_SRS_TO_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity and ood.organization_code>=:$flex$.gmf_srs_from_organization.value order by value,description SELECT organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER4 AR إلى التنظيم إلى التنظيم D Nach Organisation Nach Organisation E A Organización A Organización F Organisation - A Organisation - A I Organizzazione - A Organizzazione - A JA 組織:至 組織:至 KO 조직: 까지 조직: 까지 PTB Organização - Até Organização - Até RU Организация по Организация по S Till organisation Till organisation TR Son Organizasyon Son Organizasyon US To Organization To Organization ZHS 目标组织 目标组织 10 70 :p_from_item_id Char SELECT item_number FROM mtl_item_flexfields where inventory_item_id = :PARAMETER.NUMBER5 AR من الصنف من الصنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US From Item From Item ZHS 起始物料 起始物料 11 80 :p_to_item_id Char SELECT item_number FROM mtl_item_flexfields where inventory_item_id = :PARAMETER.NUMBER5 AR إلى الصنف إلى الصنف D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Son Kalem Son Kalem US To Item To Item ZHS 终止物料 终止物料 12 90 :p_from_cost_category_id Char AR من فئة التكلفة من فئة التكلفة D Von Kostenkategorie Von Kostenkategorie E De Categoría de Coste De Categoría de Coste F Catégorie de coût - De Catégorie de coût - De I Categoria costi - Da Categoria costi - Da JA 原価カテゴリ:自 原価カテゴリ:自 KO 시작 원가 범주 시작 원가 범주 PTB De - Categoria de Custo De - Categoria de Custo RU Категория затрат с Категория затрат с S Från kostnadskategori Från kostnadskategori TR İlk Maliyet Kategorisi İlk Maliyet Kategorisi US From Cost Category From Cost Category ZHS 起始成本类别 起始成本类别 13 100 :p_to_cost_category_id Char AR إلى فئة التكلفة إلى فئة التكلفة D Bis Kostenkategorie Bis Kostenkategorie E A Categoría de Coste A Categoría de Coste F Catégorie de coût - A Catégorie de coût - A I Categoria costi - A Categoria costi - A JA 原価カテゴリ:至 原価カテゴリ:至 KO 종료 원가 범주 종료 원가 범주 PTB Até - Categoria de Custo Até - Categoria de Custo RU Категория затрат по Категория затрат по S Till kostnadskategori Till kostnadskategori TR Son Maliyet Kategorisi Son Maliyet Kategorisi US To Cost Category To Cost Category ZHS 终止成本类别 终止成本类别 14 110 :p_currency_code LOV Oracle GMF_GL_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code SELECT base_currency_code FROM gmf_fiscal_policies where legal_entity_id = :$flex$.legal_entity AR عملة التقرير عملة التقرير D Auswertungswährung Auswertungswährung E Divisa del Informe Divisa del Informe F Devise de reporting Devise de reporting I Divisa rapporto Divisa rapporto JA レポート通貨 レポート通貨 KO 보고서 통화 보고서 통화 PTB Moeda do Relatório Moeda do Relatório RU Валюта отчета Валюта отчета S Rapportvaluta Rapportvaluta TR Rapor Para Birimi Rapor Para Birimi US Report Currency Report Currency ZHS 报表币种 报表币种 15 120 :p_exchange_rate Number 1.000000000000000 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$.calendar_code CALENDAR_CODE Period :$flex$.gmf_srs_from_organization.value From Organization To Organization value :$flex$.gmf_srs_legal_entity Legal Entity CALENDAR_CODE :$flex$.gmf_srs_legal_entity Legal Entity Cost Type :$flex$.gmf_srs_legal_entity Legal Entity From Organization :$flex$.gmf_srs_legal_entity Legal Entity To Organization :$flex$.legal_entity Legal Entity Report Currency