ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB451A9E05362FB09050512 SELECT itm.item_number item_no, itm.description item_desc1, mtl.organization_code , cpt.cost_cmpntcls_code, cpt.cost_cmpntcls_desc, adj.cost_analysis_code, adj.adjust_qty, adj.adjust_qty_uom, adj.adjust_cost, adj.reason_code, rsn.reason_desc FROM cm_adjs_dtl adj, mtl_item_flexfields itm , cm_cmpt_mst cpt, cm_reas_cds rsn, mtl_parameters mtl, gmd_org_access_vw oa WHERE adj.inventory_item_id = itm.inventory_item_id AND adj.organization_id = itm.organization_id AND adj.cost_cmpntcls_id = cpt.cost_cmpntcls_id AND adj.reason_code = rsn.reason_code --AND adj.period_id = :period_id AND adj.period_id = :period_id1 AND adj.cost_type_id = :p_cost_type_id AND adj.delete_mark = 0 AND adj.organization_id = mtl.organization_id AND adj.organization_id = oa.organization_id &ItemCP &OrganizationCP ORDER BY itm.item_number, itm.organization_id asc Y GMF CMR12USR_XML AR GMF تقرير تعديلات التكلفة الفعلية (تنسيق XML) Imported from BI Publisher Description: تقرير تعديلات تكلفة استحقاق إدارة نقدية OPM Application: ماليات التصنيع التشغيلي Source: تقرير تعديلات التكلفة الفعلية (تنسيق XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG D GMF Istkostenanpassungen Imported from BI Publisher Description: Auswertung "Istkostenanpassungen" in OPM CM Application: Process Manufacturing Financials Source: Istkostenanpassungen (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG E GMF Ajustes de Costes Reales Imported from BI Publisher Description: Informe Ajustes de Costes Reales de CM de OPM Application: Process Manufacturing Financials Source: Ajustes de Costes Reales (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG F GMF Ajustements des coûts réels Imported from BI Publisher Description: Etat des ajustements des coûts réels d'OPM CM Application: Process Manufacturing Financials Source: Ajustements des coûts réels (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG I GMF Rapporto Adeguamenti costi effettivi Imported from BI Publisher Description: Rapporto Adeguamenti costi effettivi di OPM CM Application: Process Manufacturing Financials Source: Rapporto Adeguamenti costi effettivi (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG JA GMF 実際原価調整レポート Imported from BI Publisher Description: OPM CM実際原価調整レポート Application: Process Manufacturing Financials Source: 実際原価調整レポート(XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG KO GMF 실제 원가 조정 보고서 Imported from BI Publisher Description: OPM CM의 실제 원가 조정 보고서 Application: Process Manufacturing Financials Source: 실제 원가 조정 보고서(XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG PTB GMF Relatório de Ajustes de Custo Real Imported from BI Publisher Description: Relatório de Ajustes de Custo Real do CM do OPM Application: Process Manufacturing Financials Source: Relatório de Ajustes de Custo Real (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG RU GMF Отчет о корректировках фактических затрат Imported from BI Publisher Description: Отчет о корректировках фактических затрат ЗАТ УНП Application: Финансы УНП Source: Отчет о корректировках фактических затрат (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG S GMF Justeringar av faktisk kostnad - rapport Imported from BI Publisher Description: Justeringar av faktiska kostnader - rapport i OPM GMC Application: Processtillverkning: Ekonomi Source: Justeringar av faktisk kostnad - rapport (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG TR GMF Gerçekleşen Maliyet Düzeltmeleri Raporu Imported from BI Publisher Description: OPM CM Gerçekleşen Maliyet Düzeltmeleri Raporu Application: Üretim Prosesi Finansal Yönetim Source: Gerçekleşen Maliyet Düzeltmeleri Raporu (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG US GMF Actual Cost Adjustments Imported from BI Publisher Description: Actual Cost Adjustments Report of OPM CM Application: Process Manufacturing Financials Source: Actual Cost Adjustments Report (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG ZHS GMF 实际成本调整报表 Imported from BI Publisher Description: OPM CM 的实际成本调整报表 Application: OPM 财务管理系统 Source: 实际成本调整报表 (XML) Short Name: CMR12USR_XML DB package: GMF_CMR12USR_XMLP_PKG BI Publisher &itemcp &organizationcp :cp_period_status :from_item :from_org :itemcp :nonblocksql :organizationcp :p_calendar_code :p_conc_request_id :p_cost_type_id :p_from_item_id :p_from_organization_id :p_legal_entity_id :p_period_code :p_to_item_id :p_to_organization_id :period_id1 :sy_all :to_item :to_org 1 -30 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 2 -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 3 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 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 法人主体 法人主体 4 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 :$flex$.gmf_srs_legal_entity from dual 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 日历代码 5 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 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 期间代码 期间代码 6 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 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 成本类型 成本类型 7 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 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 起始组织 起始组织 8 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 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 目标组织 目标组织 9 70 :p_from_item_id Char 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 起始物料 起始物料 10 80 :p_to_item_id Char 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 终止物料 终止物料 :$flex$.calendar_code CALENDAR_CODE Period Code :$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