ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FB351A9E05362FB09050512 SELECT 'Allocations' dtl_ind, m.alloc_code alloc_code, m.alloc_desc alloc_desc , i.account_key_type acct_type, i.line_no line_no, i.account_id, i.amount amount, d.percent_allocation percent_alloc, d.allocated_expense_amt alloc_mp_amt, t.item_number item_no, t.description item_desc, b.balance_type balance_type, b.bas_ytd_ptd bas_ytd, mp.organization_code organization_code, gmf_utilities_grp.get_organization_name(mp.organization_id) organization_name, c.cost_cmpntcls_code cost_cmpt_code, c.cost_cmpntcls_desc cost_cmpt_desc, b.analysis_code analysis_code, a.cost_analysis_desc analysis_desc, typ.description ytd_ptd_desc, typ1.description balance_desc, b.alloc_method mthd, GMF_CMR11USR_XMLP_PKG.account_codeformula(i.account_id) account_code, GMF_CMR11USR_XMLP_PKG.account_descformula(i.account_id) account_desc FROM gl_aloc_inp i, gl_aloc_mst m, gl_aloc_dtl d, gl_aloc_bas b, gmf_period_statuses gps, mtl_item_flexfields t, mtl_parameters mp, cm_cmpt_mst c, cm_alys_mst a , gem_lookups typ, gem_lookups typ1, gmd_org_access_vw oa WHERE m.legal_entity_id = :legal_entity_id1 --m.legal_entity_id = :legal_entity_id AND i.account_key_type = '0' AND i.calendar_code = :cost_calendar --AND i.period_code = :period_code AND i.period_code = :period_code1 AND i.alloc_id = m.alloc_id AND d.period_id = gps.period_id AND gps.calendar_code = i.calendar_code AND gps.period_code = i.period_code AND d.alloc_id = i.alloc_id AND d.line_no = i.line_no AND b.alloc_id = i.alloc_id AND b.line_no = i.line_no AND b.inventory_item_id = t.inventory_item_id AND b.organization_id = t.organization_id AND b.organization_id = mp.organization_id AND b.cmpntcls_id = c.cost_cmpntcls_id AND b.analysis_code = a.cost_analysis_code AND b.bas_ytd_ptd = to_number(typ.lookup_code(+)) AND b.balance_type =to_number(typ1.lookup_code(+)) AND typ.lookup_type(+) = 'BAL_YTD_PTD' AND typ1.lookup_type(+) = 'BALANCE_TYPE' AND b.organization_id = oa.organization_id &AllocationCP ORDER BY 2 asc, 4 desc,5 asc Y GMF CMR11USR_XML AR GMF تقرير تفاصيل تخصيص مصروفات الأستاذ العام (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل تخصيص مصروفات أ/ع لإدارة نقدية OPM Application: ماليات التصنيع التشغيلي Source: تقرير تفاصيل تخصيص مصروفات الأستاذ العام (تنسيق XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG D GMF HB-Aufwandsumlagen - Details Imported from BI Publisher Description: Auswertung "HB-Aufwandsumlagen - Details" in OPM CM Application: Process Manufacturing Financials Source: HB-Aufwandsumlagen - Details (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG E GMF Detalle de Asignación de Gastos Contables Imported from BI Publisher Description: Informe Detalle de Asignación de Gastos Contables de CM de OPM Application: Process Manufacturing Financials Source: Detalle de Asignación de Gastos Contables (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG F GMF Etat détaillé des affectations de dépenses GL Imported from BI Publisher Description: Etat détaillé des affectations de dépenses GL d'OPM CM Application: Process Manufacturing Financials Source: Etat détaillé des affectations de dépenses GL (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG I GMF Rapporto Dettaglio allocazione spese GL Imported from BI Publisher Description: Rapporto Dettaglio allocazione spese contabilità generale di OPM CM Application: Process Manufacturing Financials Source: Rapporto Dettaglio allocazione spese GL (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG JA GMF GL費用配賦詳細レポート Imported from BI Publisher Description: OPM CM GL費用配賦詳細レポート Application: Process Manufacturing Financials Source: GL費用配賦詳細レポート(XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG KO GMF GL 비용 배부 상세 보고서 Imported from BI Publisher Description: OPM CM의 GL 비용 배분 상세 보고서 Application: Process Manufacturing Financials Source: GL 비용 배부 상세 보고서(XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG PTB GMF Relatório Detalhado de Alocação de Despesas do GL Imported from BI Publisher Description: Relatório Detalhado de Alocação de Despesas GL do CM do OPM Application: Process Manufacturing Financials Source: Relatório Detalhado de Alocação de Despesas do GL (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG RU GMF Подробный отчет о размещении расходов из ГК Imported from BI Publisher Description: Подробный отчет о размещении расходов из ГК в ЗАТ УНП Application: Финансы УНП Source: Подробный отчет о размещении расходов из ГК (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG S GMF Utläggsallokeringar - detaljrapport Imported from BI Publisher Description: HB-utläggsallokering - detaljrapport i OPM GMC Application: Processtillverkning: Ekonomi Source: GL: Utläggsallokeringar - detaljrapport (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG TR GMF GL Gider Ayırma Detay Raporu Imported from BI Publisher Description: OPM CM GL Gider Ayırma Detay Raporu Application: Üretim Prosesi Finansal Yönetim Source: GL Gider Ayırma Detay Raporu (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG US GMF GL Expense Allocation Detail Imported from BI Publisher Description: GL Expense Allocation Detail Report of OPM CM Application: Process Manufacturing Financials Source: GL Expense Allocation Detail Report (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG ZHS GMF GL 费用分配明细报表 Imported from BI Publisher Description: OPM CM 的 GL 费用分配明细报表 Application: OPM 财务管理系统 Source: GL 费用分配明细报表 (XML) Short Name: CMR11USR_XML DB package: GMF_CMR11USR_XMLP_PKG BI Publisher &allocationcp :allocationcp :cost_calendar :currency_code :from_alloc_code :from_alloc_code1 :legal_entity_id :legal_entity_id1 :nonblocksql :p_conc_request_id :period_code :period_code1 :sy_all :to_alloc_code :to_alloc_code1 :user_id 1 -50 :user_id Number fnd_profile.value('USER_ID') Y 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 -40 :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 币种代码 币种代码 3 -30 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 4 -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 5 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 法人主体 法人主体 6 20 :cost_calendar 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 Y AR CALENDAR_CODE تقويم التكلفة D CALENDAR_CODE Kostenrechnungskalender E CALENDAR_CODE Calendario de Coste F CALENDAR_CODE Calendrier de valorisation I CALENDAR_CODE Calendario costi JA CALENDAR_CODE 原価カレンダ KO CALENDAR_CODE 원가 달력 PTB CALENDAR_CODE Calendário de Custos RU CALENDAR_CODE Календарь затрат S CALENDAR_CODE Kostnadskalender TR CALENDAR_CODE Maliyet Takvimi US CALENDAR_CODE Cost Calendar ZHS CALENDAR_CODE 成本日历 7 30 :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 期间代码 期间代码 8 40 :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 起始分配代码 起始分配代码 9 50 :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 终止分配代码 终止分配代码 :$flex$.calendar_code CALENDAR_CODE Period Code :$flex$.gmf_srs_legal_entity Legal Entity CALENDAR_CODE :$flex$.legal_entity Legal Entity Currency Code