ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB251A9E05362FB09050512 SELECT 'Allocation Definition' dtl_ind, m.alloc_code alloc_code, m.alloc_desc alloc_desc, b.line_no line_no, b.organization_id, gmf_utilities_grp.get_organization_code(b.organization_id) organization_code, gmf_utilities_grp.get_organization_name(b.organization_id) organization_name, i.item_number item_no, i.description item_desc, b.basis_account_id, b.balance_type bal_type, b.bas_ytd_ptd bas_ytd, b.fixed_percent percent, c.cost_cmpntcls_code cmpt_code, c.cost_cmpntcls_desc cmpt_desc, b.analysis_code anly_code, a.cost_analysis_desc anyl_desc, typ.description ytd_ptd_desc, typ1.description balance_desc, GMF_CMR10USR_XMLP_PKG.basis_account_codeformula(b.basis_account_id) basis_account_code, GMF_CMR10USR_XMLP_PKG.basis_account_descformula(b.basis_account_id) basis_account_desc FROM gl_aloc_mst m, gl_aloc_bas b, cm_cmpt_mst c, cm_alys_mst a, gem_lookups typ, gem_lookups typ1, mtl_item_flexfields i, gmd_org_access_vw oa WHERE m.legal_entity_id = :LEGAL_ENTITY_ID AND b.alloc_id = m.alloc_id AND b.inventory_item_id = i.inventory_item_id AND b.organization_id = i.organization_id AND b.cmpntcls_id = c.cost_cmpntcls_id AND b.analysis_code = a.cost_analysis_code AND b.delete_mark = 0 AND c.delete_mark = 0 AND a.delete_mark = 0 AND nvl(b.bas_ytd_ptd,0) = decode(b.bas_ytd_ptd,null,0,to_number(typ.lookup_code)) AND typ.lookup_type (+) = decode(b.bas_ytd_ptd,null,null,'BAL_YTD_PTD') AND nvl(b.balance_type,0) = decode(b.balance_type,null,0,to_number(typ1.lookup_code)) AND typ1.lookup_type(+) = decode(b.balance_type,null,null,'BALANCE_TYPE' ) AND oa.organization_id = b.organization_id &AllocationCP ORDER BY alloc_code, dtl_ind, line_no asc Y GMF CMR10USR_XML AR GMF تقرير تحديد تخصيص مصروفات الأستاذ العام (تنسيق XML) Imported from BI Publisher Description: تقرير تحديد تخصيص مصروفات أ/ع لإدارة نقدية OPM Application: ماليات التصنيع التشغيلي Source: تقرير تحديد تخصيص مصروفات الأستاذ العام (تنسيق XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG D GMF HB-Aufwandsumlagen - Definition Imported from BI Publisher Description: Auswertung "HB-Aufwandsumlagen - Definition" in OPM CM Application: Process Manufacturing Financials Source: HB-Aufwandsumlagen - Definition (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG E GMF Definición de Asignación de Gastos Contables Imported from BI Publisher Description: Informe Definición de Asignación de Gastos Contables de CM de OPM Application: Process Manufacturing Financials Source: Definición de Asignación de Gastos Contables (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG F GMF Etat des définitions d'affectations de dépenses GL Imported from BI Publisher Description: Etat des définitions d'affectations de dépenses GL d'OPM CM Application: Process Manufacturing Financials Source: Etat des définitions d'affectations de dépenses GL (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG I GMF Rapporto Definizione allocazione spese GL Imported from BI Publisher Description: Rapporto Definizione allocazione spese contabilità generale di OPM CM Application: Process Manufacturing Financials Source: Rapporto Definizione allocazione spese GL (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG JA GMF GL費用配賦定義レポート Imported from BI Publisher Description: OPM CM GL費用配賦定義レポート Application: Process Manufacturing Financials Source: GL費用配賦定義レポート(XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG KO GMF GL 비용 배부 정의 보고서 Imported from BI Publisher Description: OPM CM의 GL 비용 배분 정의 보고서 Application: Process Manufacturing Financials Source: GL 비용 배부 정의 보고서(XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG PTB GMF Relatório de Definição de Alocação de Despesas do GL Imported from BI Publisher Description: Relatório de Definição de Alocação de Despesas GL do CM do OPM Application: Process Manufacturing Financials Source: Relatório de Definição de Alocação de Despesas do GL (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG RU GMF Отчет об определениях размещаемых расходов из ГК Imported from BI Publisher Description: Отчет об определениях размещаемых расходов из ГК в ЗАТ УНП Application: Финансы УНП Source: Отчет об определениях размещаемых расходов из ГК (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG S GMF Def. av utläggsallokeringar - rapport Imported from BI Publisher Description: Definition av HB-utläggsallokering - rapport i OPM GMC Application: Processtillverkning: Ekonomi Source: GL: Def. av utläggsallokeringar - rapport (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG TR GMF GL Gider Ayırma Tanımı Raporu Imported from BI Publisher Description: OPM CM GL Gider Ayırma Tanımı Raporu Application: Üretim Prosesi Finansal Yönetim Source: GL Gider Ayırma Tanımı Raporu (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG US GMF GL Expense Allocation Definition Imported from BI Publisher Description: GL Expense Allocation Definition Report of OPM CM Application: Process Manufacturing Financials Source: GL Expense Allocation Definition Report (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG ZHS GMF GL 费用分配定义报表 Imported from BI Publisher Description: OPM CM 的 GL 费用分配定义报表 Application: OPM 财务管理系统 Source: GL 费用分配定义报表 (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG BI Publisher &allocationcp :allocationcp :from_alloc_code :legal_entity_id :nonblocksql :p_conc_request_id :p_from_alloc_code :p_to_alloc_code :sy_all :to_alloc_code :user_id 1 -40 :user_id Number fnd_profile.value('USER_ID') AR معرف المستخدم معرف المستخدم D Benutzerkennung Benutzerkennung E Id Usuario Id Usuario F ID utilisateur ID utilisateur I ID utente ID utente JA ユーザーID ユーザーID KO 사용자 ID 사용자 ID PTB Id do Usuário Id do Usuário RU Идентификатор пользователя Идентификатор пользователя S Användar-id Användar-id TR Kullanıcı No Kullanıcı No US User Id User 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 :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 法人主体 法人主体 5 20 :from_alloc_code LOV Oracle ALLOCATION_LIST Y select alloc_code id, alloc_code value, alloc_desc description from gl_aloc_mst where delete_mark=0 order by alloc_code AR من رمز التخصيص من رمز التخصيص D Von Umlagecode Von Umlagecode E De Código de Asignación De Código de Asignación F Code affectation - De Code affectation - De I Codice allocazione - Da Codice allocazione - Da JA 配賦コード:自 配賦コード:自 KO 시작 배부 코드 시작 배부 코드 PTB Código de Alocação - De Código de Alocação - De RU Код размещения с Код размещения с S Från allokeringskod Från allokeringskod TR İlk Ayırma Kodu İlk Ayırma Kodu US From Allocation Code From Allocation Code ZHS 起始分配代码 起始分配代码 6 30 :to_alloc_code LOV Oracle ALLOCATION_LIST Y select alloc_code id, alloc_code value, alloc_desc description from gl_aloc_mst where delete_mark=0 order by alloc_code AR إلى رمز التخصيص إلى رمز التخصيص D Bis Umlagecode Bis Umlagecode E A Código de Asignación A Código de Asignación F Code affectation - A Code affectation - A I Codice allocazione - A Codice allocazione - A JA 配賦コード:至 配賦コード:至 KO 종료 배부 코드 종료 배부 코드 PTB Código de Alocação - Até Código de Alocação - Até RU Код размещения по Код размещения по S Till allokeringskod Till allokeringskod TR Son Ayırma Kodu Son Ayırma Kodu US To Allocation Code To Allocation Code ZHS 终止分配代码 终止分配代码