ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB551A9E05362FB09050512Y SELECT gle.legal_entity_name, cwa.cost_organization_id, --cmp.organization_code cost_organization_code, cmp.organization_code cost_organization_code2, chaou.name cost_organization_name, gle.legal_entity_id cost_organization_le, cwa.organization_id, imp.organization_code inv_organization_code, haou.name inv_organization_name, fnd_date.displaydt_to_date(cwa.eff_start_date) eff_start_date, fnd_date.displaydt_to_date(cwa.eff_end_date) eff_end_date FROM cm_whse_Asc cwa, hr_all_organization_units chaou, hr_organization_information choi, mtl_parameters cmp, hr_all_organization_units haou, mtl_parameters imp, gmf_legal_entities_vw2 gle, gmd_org_access_vw oa WHERE cwa.cost_organization_id = chaou.organization_id AND cwa.cost_organization_id = cmp.organization_id AND chaou.organization_id = choi.organization_id AND chaou.organization_id = cmp.organization_id AND choi.org_information_context = 'Accounting Information' AND gle.legal_entity_id = choi.org_information2 AND cmp.process_enabled_flag = 'Y' AND cwa.organization_id = haou.organization_id AND cwa.organization_id = imp.organization_id AND haou.organization_id = imp.organization_id AND imp.process_enabled_flag = 'Y' AND cwa.delete_mark = 0 AND oa.organization_id = cwa.organization_id &Cost_OrgnCF &Inv_OrgnCF ORDER BY cmp.organization_code, cwa.eff_start_date, imp.organization_code GMF CMRCWA_XML AR GMF تقرير ارتباط تنظيم التكلفة (تنسيق XML) Imported from BI Publisher Description: تقرير ارتباط تنظيم التكلفة لإشعار دائن في OPM Application: ماليات التصنيع التشغيلي Source: تقرير ارتباط تنظيم التكلفة (تنسيق XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG D GMF Kostenorganisation - Zuordnungen Imported from BI Publisher Description: Kostenorganisation - Zuordnungen in OPM CM Application: Process Manufacturing Financials Source: Kostenorganisation - Zuordnungen (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG E GMF Asociación de Organizaciones de Costes Imported from BI Publisher Description: Informe de asociación de organizaciones de costes de CM de OPM Application: Process Manufacturing Financials Source: Asociación de Organizaciones de Costes (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG F GMF Association d'organisations de coûts Imported from BI Publisher Description: Etat des associations d'organisations de coûts d'OPM CM Application: Process Manufacturing Financials Source: Association d'organisations de coûts (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG I GMF Rapporto Associazione organizzazione costi Imported from BI Publisher Description: Rapporto Associazione organizzazione/costo di OPM CM Application: Process Manufacturing Financials Source: Rapporto Associazione organizzazione costi (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG JA GMF 原価組織関連レポート Imported from BI Publisher Description: OPM CM原価組織関連レポート Application: Process Manufacturing Financials Source: 原価組織関連レポート(XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG KO GMF 원가 조직 연계 보고서 Imported from BI Publisher Description: OPM CM의 원가 조직 연계 보고서 Application: Process Manufacturing Financials Source: 원가 조직 연계 보고서(XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG PTB GMF Relatório de Associação de Organizações de Custo Imported from BI Publisher Description: Relatório de Associação de Organização de Custos do OPM CM Application: Process Manufacturing Financials Source: Relatório de Associação de Organizações de Custo (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG RU GMF Отчет о связанных организациях, выполняющих калькуляцию затрат Imported from BI Publisher Description: Отчет о связанных организациях, выполняющих калькуляцию затрат ЗАТ УНП Application: Финансы УНП Source: Отчет о связанных организациях, выполняющих калькуляцию затрат (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG S GMF Association av kostnadsorganisation - rapport Imported from BI Publisher Description: Association av kostnadsorganisation - rapport i OPM GMC Application: Processtillverkning: Ekonomi Source: Association av kostnadsorganisation - rapport (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG TR GMF Maliyet Organizasyonu İlişkilendirme Raporu Imported from BI Publisher Description: OPM CM Maliyet Organizasyonu İlişki Raporu Application: Üretim Prosesi Finansal Yönetim Source: Maliyet Organizasyonu İlişkilendirme Raporu (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG US GMF Cost Organization Association Imported from BI Publisher Description: Cost Organization Association Report of OPM CM Application: Process Manufacturing Financials Source: Cost Organization Association Report (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG ZHS GMF 成本组织关联报表 Imported from BI Publisher Description: OPM CM 的成本组织关联报表 Application: OPM 财务管理系统 Source: 成本组织关联报表 (XML) Short Name: CMRCWA_XML DB package: GMF_CMRCWA_XMLP_PKG BI Publisher &cost_orgncf &inv_orgncf :cost_orgncp :from_cost_orgn :from_cost_orgn_p :from_inv_orgn :from_inv_orgn_p :inv_orgncp :nonblocksql :p_conc_request_id :p_from_cost_orgn_id :p_from_inv_orgn_id :p_to_cost_orgn_id :p_to_inv_orgn_id :sort_by :sy_all :to_cost_orgn :to_cost_orgn_p :to_inv_orgn :to_inv_orgn_p 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_from_cost_orgn_id LOV Oracle GMF_SRS_FROM_COST_ORGANIZATION Y select mp.organization_id id, mp.organization_code value, hou.name description from hr_organization_units hou,mtl_parameters mp where hou.organization_id=mp.organization_id and mp.organization_id in (select cost_organization_id from cm_whse_asc where delete_mark=0) order by mp.organization_code AR من تنظيم التكلفة من تنظيم التكلفة D Von Kostenorganisation Von Kostenorganisation E De Organización de Costes De Organización de Costes F Organisation de coûts - De Organisation de coûts - De I Organizzazione costi - Da Organizzazione costi - Da JA 原価組織:自 原価組織:自 KO 시작 원가 조직 시작 원가 조직 PTB De - Organização de Custo De - Organização de Custo RU Организация, выполн. калькуляцию затрат, с Организация, выполняющая калькуляцию затрат, с S Från kostnadsorganisation Från kostnadsorganisation TR İlk Maliyet Organizasyonu İlk Maliyet Organizasyonu US From Cost Organization From Cost Organization ZHS 起始成本组织 起始成本组织 4 20 :p_to_cost_orgn_id LOV Oracle GMF_SRS_TO_COST_ORGANIZATION Y select mp.organization_id id, mp.organization_code value, hou.name description from hr_organization_units hou,mtl_parameters mp where hou.organization_id=mp.organization_id and mp.organization_code>=:$flex$.gmf_srs_from_cost_organization.value and mp.organization_id in (select cost_organization_id from cm_whse_asc where delete_mark=0) order by mp.organization_code AR إلى تنظيم التكلفة إلى تنظيم التكلفة D Bis Kostenorganisation Bis Kostenorganisation E A Organización de Costes A Organización de Costes F Organisation de coûts - A Organisation de coûts - A I Organizzazione costi - A Organizzazione costi - A JA 原価組織:至 原価組織:至 KO 종료 원가 조직 종료 원가 조직 PTB Até - Organização de Custo Até - Organização de Custo RU Организация, выполн. калькуляцию затрат, по Организация, выполняющая калькуляцию затрат, по S Till kostnadsorganisation Till kostnadsorganisation TR Son Maliyet Organizasyonu Son Maliyet Organizasyonu US To Cost Organization To Cost Organization ZHS 终止成本组织 终止成本组织 5 30 :p_from_inv_orgn_id LOV Oracle GMF_SRS_FROM_INV_COST_ORG Y select mp.organization_id id, mp.organization_code value, hou.name description from hr_organization_units hou,mtl_parameters mp where hou.organization_id=mp.organization_id and mp.organization_id in (select organization_id from cm_whse_asc where delete_mark=0) order by mp.organization_code AR من تنظيم المخازن من تنظيم المخازن D Von Lagerorganisation Von Lagerorganisation E De Organización de Inventario De Organización de Inventario F Organisation logistique - De Organisation logistique - De I Organizzazione magazzino - Da Organizzazione magazzino - Da JA 在庫組織:自 在庫組織:自 KO 시작 재고 조직 시작 재고 조직 PTB De - Organização de Inventário De - Organização de Inventário RU Складская организация с Складская организация с S Från lagerorganisation Från lagerorganisation TR İlk Envanter Organizasyonu İlk Envanter Organizasyonu US From Inventory Organization From Inventory Organization ZHS 起始库存组织 起始库存组织 6 40 :p_to_inv_orgn_id LOV Oracle GMF_SRS_TO_INV_COST_ORG Y select mp.organization_id id, mp.organization_code value, hou.name description from hr_organization_units hou,mtl_parameters mp where hou.organization_id=mp.organization_id and mp.organization_code>=:$flex$.gmf_srs_from_inv_cost_org.value and mp.organization_id in (select organization_id from cm_whse_asc where delete_mark=0) order by mp.organization_code AR إلى تنظيم المخازن إلى تنظيم المخازن D Bis Lagerorganisation Bis Lagerorganisation E A Organización de Inventario A Organización de Inventario F Organisation logistique - A Organisation logistique - A I Organizzazione magazzino - A Organizzazione magazzino - A JA 在庫組織:至 在庫組織:至 KO 종료 재고 조직 종료 재고 조직 PTB Até - Organização de Inventário Até - Organização de Inventário RU Складская организация по Складская организация по S Till lagerorganisation Till lagerorganisation TR Son Envanter Organizasyonu Son Envanter Organizasyonu US To Inventory Organization To Inventory Organization ZHS 终止库存组织 终止库存组织 7 50 :sort_by LOV Oracle SORT_BY 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=108421 order by ffvv.flex_value Cost Organization 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 排序依据 排序依据