ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB651A9E05362FB09050512 SELECT distinct ic.item_number , substr(ic.description,1, 30) item_desc1, mp.organization_code orgn_code, nvl(cst.acctg_cost * :P_EXCHANGE_RATE,0) acctg_cost, ''||'/'||ic.primary_uom_code uom, cst.fmeff_id frm_id, /* Bug 14395061 In RTF template only four columns are displayed. As category_id is not shown, records are shown as duplicate entries*/ cst.final_flag final_flag, /*mic.category_id,*/ /* Bug 7591198 */ GMF_CMRGLR_XMLP_PKG.sum_formulacfformula(cst.fmeff_id) Sum_FormulaCF, GMF_CMRGLR_XMLP_PKG.Formula_noCP_p Formula_noCP, GMF_CMRGLR_XMLP_PKG.Formula_verCP_p Formula_verCP, GMF_CMRGLR_XMLP_PKG.Routing_noCP_p Routing_noCP, GMF_CMRGLR_XMLP_PKG.Routing_verCP_p Routing_verCP FROM gl_item_cst cst, mtl_item_flexfields ic, mtl_parameters mp, mtl_categories_kfv mckfv, mtl_item_categories mic , gmd_org_access_vw oa /* Bug 14395061 One category_id has multiple category_set_id.*/ -- mtl_default_category_sets mdcs, -- Bug 22745020 - comment out. mozheng -- mtl_category_sets mcs -- Bug 22745020 - comment out. mozheng WHERE cst.period_id = :period_id AND cst.cost_type_id = :p_cost_type_id AND cst.inventory_item_id = ic.inventory_item_id AND ic.organization_id = mp.organization_id AND cst.organization_id = ic.organization_id AND ic.inventory_item_id = mic.inventory_item_id(+) AND ic.organization_id = mic.organization_id(+) /* Bug 14395061 One category_id has multiple category_set_id.*/ -- AND mdcs.functional_area_id = 19 -- Bug 22745020 - comment out. mozheng -- AND mdcs.category_set_id = mcs.category_set_id(+) -- Bug 22745020 - comment out. mozheng /* Bug 21020253 missed join condition */ -- AND mcs.category_set_id = mic.category_set_id -- Bug 22745020 - comment out. mozheng AND mic.category_id = mckfv.category_id(+) and mckfv.structure_id(+) = :p_category_structure_id AND cst.delete_mark = 0 AND ic.organization_id = oa.organization_id &Report_TypeCP &CostCategoryCP &ItemCP &OrganizationCP &DatesCP GROUP BY ic.item_number, ic.primary_uom_code , ic.description, mp.organization_code, cst.fmeff_id, cst.final_flag, mic.category_id, cst.acctg_cost /* Bug 7591198 */ ORDER BY &orderCP Y GMF CMRGLR_XML AR GMF تقرير تفاصيل تكلفة صنف الأستاذ العام (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل تكاليف صنف أ/ع لإدارة نقدية OPM Application: ماليات التصنيع التشغيلي Source: تقرير تفاصيل تكلفة صنف الأستاذ العام (تنسيق XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG D GMF HB-Materialkosten - Details Imported from BI Publisher Description: Auswertung "HB-Materialkosten - Details" in OPM CM Application: Process Manufacturing Financials Source: HB-Materialkosten - Details (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG E GMF Detalles de Costes Contables de Artículos Imported from BI Publisher Description: Informe Detalles de Costes Contables de Artículos de CM de OPM Application: Process Manufacturing Financials Source: Detalles de Costes Contables de Artículos (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG F GMF Etat détaillé des coûts article GL Imported from BI Publisher Description: Etat détaillé des coûts article GL d'OPM CM Application: Process Manufacturing Financials Source: Etat détaillé des coûts article GL (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG I GMF Rapporto Dettaglio costo articolo GL Imported from BI Publisher Description: Rapporto Dettaglio costo articolo contabilità generale di OPM CM Application: Process Manufacturing Financials Source: Rapporto Dettaglio costo articolo GL (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG JA GMF GL品目原価詳細レポート Imported from BI Publisher Description: OPM CM GL品目原価詳細レポート Application: Process Manufacturing Financials Source: GL品目原価詳細レポート(XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG KO GMF GL 품목 원가 상세 보고서 Imported from BI Publisher Description: OPM CM의 GL 품목 원가 상세 보고서 Application: Process Manufacturing Financials Source: GL 품목 원가 상세 보고서(XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG PTB GMF Relat. Detalhado de Custos do Item do GL Imported from BI Publisher Description: Relatório Detalhado de Custos de Item GL do CM do OPM Application: Process Manufacturing Financials Source: Relat. Detalhado de Custos do Item do GL (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG RU GMF Подробный отчет о стоимости позиций ГК Imported from BI Publisher Description: Подробный отчет о стоимостях позиций ГК в ЗАТ УНП Application: Финансы УНП Source: Подробный отчет о стоимости позиций ГК (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG S GMF Kostnad för HB-artikel - detaljrapport Imported from BI Publisher Description: HB-artikelkostnad - detaljrapport i OPM GMC Application: Processtillverkning: Ekonomi Source: Kostnad för HB-artikel - detaljrapport (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG TR GMF GL Kalem Maliyeti Detay Raporu Imported from BI Publisher Description: OPM CM GL Kalem Maliyeti Detay Raporu Application: Üretim Prosesi Finansal Yönetim Source: GL Kalem Maliyeti Detay Raporu (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG US GMF GL Item Cost Detail Imported from BI Publisher Description: GL Item Cost Detail Report of OPM CM Application: Process Manufacturing Financials Source: GL Item Cost Detail Report (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG ZHS GMF GL 项目成本明细报表 Imported from BI Publisher Description: OPM CM 的 GL 物料成本详细资料报表 Application: OPM 财务管理系统 Source: GL 项目成本明细报表 (XML) Short Name: CMRGLR_XML DB package: GMF_CMRGLR_XMLP_PKG BI Publisher &costcategorycp &datescp &itemcp &ordercp &organizationcp &report_typecp :costcategorycp :datescp :formula_no1cp :formula_nocp :formula_ver1cp :formula_vercp :from_cost_category :from_item :from_orgn :itemcp :nonblocksql :order1cp :orderby :ordercp :organizationcp :p_calendar_code :p_category_structure_id :p_conc_request_id :p_cost_type_id :p_currency_code :p_end_date :p_exchange_rate :p_from_cost_category_id :p_from_item_id :p_from_organization_id :p_l_end_date :p_l_start_date :p_legal_entity_id :p_period_code :p_report_currency :p_start_date :p_to_cost_category_id :p_to_item_id :p_to_organization_id :period_id :period_status :report_type :report_typecp :routing_no1cp :routing_nocp :routing_ver1cp :routing_vercp :sy_all :to_cost_category :to_item :to_orgn 1 -70 :p_currency_code Char SELECT base_currency_code FROM gmf_fiscal_policies where legal_entity_id = :$flex$.legal_entity AR رمز العملة رمز العملة D Währung Währung E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 2 -60 :p_start_date DateTime SELECT FND_DATE.DATE_TO_CHARDT(start_date) FROM gmf_period_statuses WHERE legal_entity_id = :$flex$.legal_entity AND calendar_code=:$FLEX$.CALENDAR_CODE AND period_code=:$flex$.period_code AND cost_type_id = :$flex$.cost_type AR تاريخ البداية تاريخ البداية D Startdatum Startdatum E Fecha de Inicio Fecha de Inicio F Date de début Date de début I Data avvio Data avvio JA 開始日 開始日 KO 시작 일자 시작 일자 PTB Data Inicial Data Inicial RU Начальная дата Начальная дата S Startdatum Startdatum TR Başlangıç Tarihi Başlangıç Tarihi US Start Date Start Date ZHS 起始日期 起始日期 3 -50 :p_end_date DateTime SELECT FND_DATE.DATE_TO_CHARDT(end_date) FROM gmf_period_statuses WHERE legal_entity_id = :$flex$.legal_entity AND calendar_code=:$FLEX$.CALENDAR_CODE AND period_code=:$flex$.period_code AND cost_type_id = :$flex$.cost_type AR تاريخ النهاية تاريخ النهاية D Enddatum Enddatum E Fecha de Finalización Fecha de Finalización F Date de fin Date de fin I Data fine Data fine JA 終了日 終了日 KO 종료 일자 종료 일자 PTB Data Final Data Final RU Конечная дата Конечная дата S Slutdatum Slutdatum TR Bitiş Tarihi Bitiş Tarihi US End Date End Date ZHS 终止日期 终止日期 4 -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 Dummy-Strukturkennung Dummy-Strukturkennung E Id Estructura Ficticia Id Estructura Ficticia F ID structure fictive ID structure fictive I Id struttura fittizia Id della struttura fittizia JA ダミー体系ID ダミー体系ID KO Dummy 구조 ID Dummy 구조 ID PTB Id da Estrutura Fictícia Id da Estrutura Fictícia RU Фиктивный идентификатор структуры Фиктивный идентификатор структуры S Id för dummy-struktur Id för dummy-struktur TR Sözde Yapı No Sözde Yapı No US Dummy Structure Id Dummy Structure Id ZHS 虚拟结构标识 虚拟结构标识 5 -30 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 6 -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 7 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 法人主体 法人主体 8 20 :p_calendar_code 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 日历代码 9 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 Periodencode Periodencode E Código de Período Código de Período F Code période Code période I Codice periodo Codice periodo JA 期間コード 期間コード KO 기간 코드 기간 코드 PTB Código do Período Código do Período RU Код периода Код периода S Periodkod Periodkod TR Dönem Kodu Dönem Kodu US Period Code Period Code ZHS 期间代码 期间代码 10 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 成本类型 成本类型 11 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 起始组织 起始组织 12 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 目标组织 目标组织 13 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 起始物料 起始物料 14 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 终止物料 终止物料 15 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 起始成本类别 起始成本类别 16 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 终止成本类别 终止成本类别 17 110 :report_type LOV Oracle CM_CMRGLR_REPORT_TYPE Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='CM_CMRGLR_REPORT_TYPE' order by value,description Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de Informe F Type d'état Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type ZHS 报表类型 报表类型 18 120 :orderby LOV Oracle CM_CMRGLR_SORT_BY Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='CM_CMRGLR_SORT_BY' and enabled_flag='Y' order by value,description Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Ölçütü Sıralama Ölçütü US Sort By Sort By ZHS 排序依据 排序依据 19 130 :p_report_currency 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 报表币种 报表币种 20 140 :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 End Date :$FLEX$.CALENDAR_CODE CALENDAR_CODE Start Date :$flex$.calendar_code CALENDAR_CODE Period Code :$flex$.cost_type Cost Type End Date :$flex$.cost_type Cost Type Start Date :$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 Currency Code :$flex$.legal_entity Legal Entity End Date :$flex$.legal_entity Legal Entity Report Currency :$flex$.legal_entity Legal Entity Start Date :$flex$.period_code Period Code End Date :$flex$.period_code Period Code Start Date