ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB751A9E05362FB09050512 SELECT a.acctg_unit_no Acctg_Unit, a.acctg_unit_desc Description, b.orgn_code Orgn, b.whse_code Whse FROM gl_accu_mst a, gl_accu_map b WHERE a.co_code = :Company and a.acctg_unit_id = b.acctg_unit_id and a.delete_mark = 0 and b.delete_mark = 0 &Acctg_UnitCP &Orgn_CodeCP &Whse_CodeCP ORDER BY a.acctg_unit_no, a.acctg_unit_desc, b.orgn_code Y GMF GLR17USR_XML AR GMF تقرير تخطيط الوحدة المحاسبية (تنسيق XML) Imported from BI Publisher Description: تقرير تخطيط الوحدة المحاسبية لـ أ/ع OPM Application: ماليات التصنيع التشغيلي Source: تقرير تخطيط الوحدة المحاسبية (تنسيق XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG D GMF Bilanzierungseinheiten-Zuordnungen Imported from BI Publisher Description: Auswertung "Bilanzierungseinheiten-Zuordnungen" in OPM GL Application: Process Manufacturing Financials Source: Bilanzierungseinheiten-Zuordnungen (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG E GMF Correspondencias de Unidades Contables Imported from BI Publisher Description: Informe Correspondencias de Unidades Contables de GL de OPM Application: Process Manufacturing Financials Source: Correspondencias de Unidades Contables (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG F GMF Etat des affectations d'unité comptable Imported from BI Publisher Description: Etat des affectations d'unité comptable d'OPM GL Application: Process Manufacturing Financials Source: Etat des affectations d'unité comptable (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG I GMF Rapporto Mapping unità contabile Imported from BI Publisher Description: Rapporto Mappatura unità contabile di OPM GL Application: Process Manufacturing Financials Source: Rapporto Mapping unità contabile (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG JA GMF 会計単位マッピング・レポート Imported from BI Publisher Description: OPM GL会計単位マッピング・レポート Application: Process Manufacturing Financials Source: 会計単位マッピング・レポート(XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG KO GMF 회계 단위 매핑 보고서 Imported from BI Publisher Description: OPM GL의 회계 단위 맵핑 보고서 Application: Process Manufacturing Financials Source: 회계 단위 매핑 보고서(XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG PTB GMF Relatório de Mapeamento de Unidade Contábil Imported from BI Publisher Description: Relatório de Mapeamento de Unidade Contábil do GL do OPM Application: Process Manufacturing Financials Source: Relatório de Mapeamento de Unidade Contábil (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG RU GMF Отчет об отображении учетных единиц Imported from BI Publisher Description: Отчет об отображении учетных единиц ГК УНП Application: Финансы УНП Source: Отчет об отображении учетных единиц (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG S GMF Mappning av redovisningsenhet - rapport Imported from BI Publisher Description: Mappning av redovisningsenhet - rapport i OPM HB Application: Processtillverkning: Ekonomi Source: Mappning av redovisningsenhet - rapport (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG TR GMF Muhasebe Birimi Eşleme Raporu Imported from BI Publisher Description: OPM GL Muhasebeleşme Birimi Eşleme Raporu Application: Üretim Prosesi Finansal Yönetim Source: Muhasebe Birimi Eşleme Raporu (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG US GMF Accounting Unit Mapping Imported from BI Publisher Description: Accounting Unit Mapping Report of OPM GL Application: Process Manufacturing Financials Source: Accounting Unit Mapping Report (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG ZHS GMF 会计单位映射报表 Imported from BI Publisher Description: OPM GL 的会计单位映射报表 Application: OPM 财务管理系统 Source: 会计单位映射报表 (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG BI Publisher &acctg_unitcp &orgn_codecp &whse_codecp :acctg_unitcp :company :from_acctg_unit :from_organization :from_whse :lfrom_acctg_unit :lfrom_organization :lfrom_whse :lto_acctg_unit :lto_organization :lto_whse :nonblocksql :orgn_codecp :p_conc_request_id :sy_all :to_acctg_unit :to_organization :to_whse :whse_codecp 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 :company LOV Oracle GL_FISCAL_COMPANY Y select mst.co_code id, mst.co_code value, mst.orgn_name description from sy_orgn_mst mst,gl_plcy_mst ply where mst.orgn_code=ply.co_code and mst.delete_mark=0 and ply.delete_mark=0 order by mst.co_code fnd_profile.value('GEMMS_DEFAULT_COMPANY') Y AR الشركة الشركة D Firma Firma E Compañía Compañía F Société Société I Società Società JA 会社 会社 KO 회사 회사 PTB Empresa Empresa RU Компания Компания S Företag Företag TR Şirket Şirket US Company Company ZHS 公司 公司 4 20 :from_acctg_unit LOV Oracle GL_FISCAL_ACCTG_UNIT Y select acctg_unit_no id, acctg_unit_no value, acctg_unit_desc description from gl_accu_mst where co_code=:$flex$.gl_fiscal_company order by acctg_unit_no AR من الوحدة المحاسبية من الوحدة المحاسبية D Von Bilanzierungseinheit Von Bilanzierungseinheit E De Unidad Contable De Unidad Contable F Unité comptable - De Unité comptable - De I Unità contabile - Da Unità contabile - Da JA 会計単位:自 会計単位:自 KO 회계 단위: 부터 회계 단위: 부터 PTB Unid. Cont. - De Unid. Cont. - De RU Учетная единица с Учетная единица с S Från redovisningsenhet Från redovisningsenhet TR İlk Muhasebeleşme Birimi İlk Muhasebeleşme Birimi US From Acctg Unit From Acctg Unit ZHS 起始会计单位 起始会计单位 5 30 :to_acctg_unit LOV Oracle GL_FISCAL_ACCTG_UNIT Y select acctg_unit_no id, acctg_unit_no value, acctg_unit_desc description from gl_accu_mst where co_code=:$flex$.gl_fiscal_company order by acctg_unit_no AR إلى الوحدة المحاسبية إلى الوحدة المحاسبية D Bis Bilanzierungseinheit Bis Bilanzierungseinheit E A Unidad Contable A Unidad Contable F Unité comptable - A Unité comptable - A I Unità contabile - A Unità contabile - A JA 会計単位:至 会計単位:至 KO 회계 단위: 까지 회계 단위: 까지 PTB Unid. Cont. - Até Unid. Cont. - Até RU Учетная единица по Учетная единица по S Till redovisningsenhet Till redovisningsenhet TR Son Muhasebeleşme Birimi Son Muhasebeleşme Birimi US To Acctg Unit To Acctg Unit ZHS 终止会计单位 终止会计单位 6 40 :from_organization LOV Oracle GL_ORGANIZATION Y select orgn_code id, orgn_code value, orgn_name description from sy_orgn_mst where delete_mark=0 order by orgn_code AR من التنظيم من التنظيم D Von Organisation Von Organisation E De Organización De Organización F Org. - De Org. - De I Organizzazione - Da Organizzazione - Da JA 組織:自 組織:自 KO 조직: 부터 조직: 부터 PTB Org. - De Org. - De RU Организация с Организация с S Från org. Från org. TR İlk Organizasyon İlk Organizasyon US From Orgn From 0rgn ZHS 起始组织 起始组织 7 50 :to_organization LOV Oracle GL_ORGANIZATION Y select orgn_code id, orgn_code value, orgn_name description from sy_orgn_mst where delete_mark=0 order by orgn_code AR إلى التنظيم إلى التنظيم D Bis Organisation Bis Organisation E A Organización A Organización F Org. - A Org. - A I Organizzazione - A Organizzazione - A JA 組織:至 組織:至 KO 조직: 까지 조직: 까지 PTB Org. - Até Org. - Até RU Организация по Организация по S Till org. Till org. TR Son Organizasyon Son Organizasyon US To Orgn To Orgn ZHS 终止组织 终止组织 8 60 :from_whse LOV Oracle GL_WHSE_LIST Y select whse_code id, whse_code value, whse_name description from ic_whse_mst where delete_mark=0 order by whse_code AR من مستودع من مستودع D Von Lager Von Lager E De Almacén De Almacén F Entrepôt - De Entrepôt - De I Warehouse - Da Warehouse - Da JA 倉庫:自 倉庫:自 KO From 창고 From 창고 PTB Depósito - De Depósito - De RU Склад с Склад с S Från lager Från lager TR Çıkış Deposu Çıkış Deposu US From Whse From Whse ZHS 起始仓库 起始仓库 9 70 :to_whse LOV Oracle GL_WHSE_LIST Y select whse_code id, whse_code value, whse_name description from ic_whse_mst where delete_mark=0 order by whse_code AR إلى مستودع إلى مستودع D Bis Lager Bis Lager E A Almacén A Almacén F Entrepôt - A Entrepôt - A I Warehouse - A Warehouse - A JA 倉庫:至 倉庫:至 KO To 창고 To 창고 PTB Depósito - Até Depósito - Até RU Склад по Склад по S Till lager Till lager TR Varış Deposu Varış Deposu US To Whse To Whse ZHS 终止仓库 终止仓库 :$flex$.gl_fiscal_company Company From Acctg Unit :$flex$.gl_fiscal_company Company To Acctg Unit