ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4712A51A9E05362FB09050512 SELECT trans.code_combination_id, prj.segment1 Project_Number, prj.name Project_Description, sys.project_manufacturing_flag Manufacturing_Related, sys.meaning System_Linkage , SUM(trans.Raw_Cost) Raw_Cost, SUM(nvl(nvl(trans.burdened_cost,0), trans.raw_cost) - trans.raw_cost) Burden_Cost, SUM(decode(nvl(trans.burdened_cost,0), 0, trans.raw_cost,trans.burdened_cost)) Total_Cost, PA_PAXMGSLS_XMLP_PKG.c_account_idformula(trans.code_combination_id) C_Account_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_account_description', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_ACCOUNT_DESCRIPTION, PA_PAXMGSLS_XMLP_PKG.cf_acct_currency_codeformula() CF_ACCT_CURRENCY_CODE, --PA_PAXMGSLS_XMLP_PKG.ca_raw_costformula(:CF_ACCT_CURRENCY_CODE, :A_raw_cost) CA_raw_cost, --PA_PAXMGSLS_XMLP_PKG.ca_burden_costformula(:CF_ACCT_CURRENCY_CODE, :A_burden_cost) CA_burden_cost, --PA_PAXMGSLS_XMLP_PKG.ca_total_costformula(:CF_ACCT_CURRENCY_CODE, :A_total_cost) CA_total_cost, --PA_PAXMGSLS_XMLP_PKG.cp_raw_costformula(:CF_ACCT_CURRENCY_CODE, :P_raw_cost) CP_raw_cost, --PA_PAXMGSLS_XMLP_PKG.cp_burden_costformula(:CF_ACCT_CURRENCY_CODE, :P_burden_cost) CP_burden_cost, --PA_PAXMGSLS_XMLP_PKG.cp_total_costformula(:CF_ACCT_CURRENCY_CODE, :P_total_cost) CP_total_cost, PA_PAXMGSLS_XMLP_PKG.mfg_relatedformula(sys.project_manufacturing_flag) Mfg_related, --PA_PAXMGSLS_XMLP_PKG.cm_raw_costformula(:CF_ACCT_CURRENCY_CODE, :M_raw_cost) CM_raw_cost, --PA_PAXMGSLS_XMLP_PKG.cm_burden_costformula(:CF_ACCT_CURRENCY_CODE, :M_burden_cost) CM_burden_cost, --PA_PAXMGSLS_XMLP_PKG.cm_total_costformula(:CF_ACCT_CURRENCY_CODE, :M_total_cost) CM_total_cost, PA_PAXMGSLS_XMLP_PKG.c_sys_linkageformula(sys.meaning) C_sys_linkage --PA_PAXMGSLS_XMLP_PKG.c_raw_costformula(:CF_ACCT_CURRENCY_CODE, SUM ( Raw_Cost )) C_raw_cost, --PA_PAXMGSLS_XMLP_PKG.c_burden_costformula(:CF_ACCT_CURRENCY_CODE, SUM ( Burden_Cost )) C_burden_cost, --PA_PAXMGSLS_XMLP_PKG.c_total_costformula(:CF_ACCT_CURRENCY_CODE, SUM ( Total_Cost )) C_total_cost FROM pa_expenditure_types et, pa_projects_all prj, pa_tasks task, gl_code_combinations cc, pa_system_linkages sys, ( SELECT cdl.dr_code_combination_id CODE_COMBINATION_ID , ei.system_linkage_function SYSTEM_LINKAGE_FUNCTION , ei.task_id TASK_ID , ei.expenditure_type EXPENDITURE_TYPE , cdl.acct_raw_cost RAW_COST , cdl.acct_burdened_cost BURDENED_COST ,ei.expenditure_item_id expen_item_id ,cdl.line_num FROM pa_expenditure_items_all ei, pa_cost_distribution_lines_all cdl, pa_transaction_Sources ts, pa_implementations_all imp WHERE cdl.expenditure_item_id = ei.expenditure_item_id AND cdl.line_type = 'R' AND cdl.transfer_status_code || '' in ('A','V') AND cdl.acct_event_id is NULL AND (cdl.org_id = imp.org_id OR imp.org_id is null) AND imp.set_of_books_id = :p_ca_set_of_books_id AND trunc(cdl.gl_date) BETWEEN nvl(:cf_from_date, trunc(cdl.gl_date)) AND nvl(:cf_to_date, trunc(cdl.gl_date)) AND nvl(ei.historical_flag,'Y') = decode(nvl(ts.predefined_flag,'Y'),'N',nvl(ei.historical_flag,'Y'),'Y') AND ei.transaction_source = ts.transaction_source(+) UNION SELECT ael.code_combination_id CODE_COMBINATION_ID , ei.system_linkage_function SYSTEM_LINKAGE_FUNCTION , ei.task_id TASK_ID , ei.expenditure_type EXPENDITURE_TYPE , cdl.acct_raw_cost RAW_COST , cdl.acct_burdened_cost BURDENED_COST , ei.expenditure_item_id expen_item_id ,cdl.line_num FROM pa_expenditure_items_all ei, pa_cost_distribution_lines_all cdl, pa_implementations_all imp, pa_transaction_Sources ts, xla_distribution_links xdl, xla_ae_headers aeh, xla_ae_lines ael, xla_acct_class_assgns xaca, xla_assignment_defns_b xad, xla_post_acct_progs_b xpap, gl_ledgers gl WHERE cdl.expenditure_item_id = ei.expenditure_item_id AND ((nvl(ei.historical_flag,'Y') = 'N') or (cdl.acct_event_id is not null)) AND ts.transaction_source (+) = ei.transaction_source AND cdl.line_type = 'R' AND cdl.transfer_status_code || '' in ('A','V') AND (cdl.org_id = imp.org_id OR imp.org_id is null) AND trunc(cdl.gl_date) BETWEEN nvl(:cf_from_date, trunc(cdl.gl_date)) AND nvl(:cf_to_date, trunc(cdl.gl_date)) AND imp.set_of_books_id = :p_ca_set_of_books_id AND xdl.application_id = DECODE(cdl.transfer_status_code,'V',DECODE (ts.Acct_Source_Code,'AP_INV',200, 'AP_PAY' , 200, 'AP_APP' , 200 , 'INV',707, 'WIP',707, 'RCV',707,0), 275 ) AND xdl.source_distribution_id_num_1 = DECODE(cdl.transfer_status_code,'V',DECODE (ts.Acct_Source_Code,'AP_INV', DECODE ( ei.Document_payment_Id ,NULL , ei.Document_Distribution_Id,cdl.System_Reference5) ,'AP_PAY' , cdl.System_Reference5 ,'AP_APP' , cdl.System_Reference5 ,'INV',cdl.System_Reference5,'WIP',cdl.System_Reference5,'RCV',cdl.System_Reference5 ), ei.expenditure_item_id ) AND NVL(xdl.source_distribution_id_num_2, -99) = DECODE(cdl.transfer_status_code,'V',nvl(xdl.source_distribution_id_num_2,-99), cdl.line_num ) AND xdl.source_distribution_type = DECODE(cdl.transfer_status_code,'V',DECODE (ts.acct_source_code,'AP_PAY','AP_PMT_DIST','AP_INV', DECODE ( ei.Document_payment_Id ,NULL , 'AP_INV_DIST','AP_PMT_DIST'),'AP_APP','AP_PREPAY','RCV','RCV_RECEIVING_SUB_LEDGER','INV','MTL_TRANSACTION_ACCOUNTS','WIP','WIP_TRANSACTION_ACCOUNTS'),cdl.line_type) AND xdl.ae_header_id = aeh.ae_header_id AND xdl.ae_line_num = ael.ae_line_num AND xdl.ae_header_id = ael.ae_header_id AND aeh.application_id = ael.application_id AND ael.application_id = xdl.application_id AND aeh.balance_type_code = 'A' AND aeh.accounting_entry_status_code = 'F' AND aeh.ledger_id = imp.set_of_books_id AND ael.accounting_class_code = xaca.accounting_class_code AND xaca.program_code = xad.program_code AND xaca.program_owner_code = xad.program_owner_code AND xad.program_code = xpap.program_code AND xpap.program_owner_code = 'S' AND xaca.assignment_code = xad.assignment_code AND xaca.assignment_owner_code = xad.assignment_owner_code AND (xad.ledger_id IS NULL OR xad.ledger_id = imp.set_of_books_id) AND xad.enabled_flag = 'Y' AND xpap.program_code = 'PA_POSTACCOUNTING_DEBIT' AND xpap.application_id = 275 AND gl.ledger_id = imp.set_of_books_id AND decode ( xaca.accounting_class_code ,'DISCOUNT', decode (gl.sla_ledger_cash_basis_flag , 'Y', 2 , 1) , 1 ) = 1 ) trans WHERE &c_where AND trans.expenditure_type = et.expenditure_type AND task.project_id = prj.project_id AND trans.task_id = task.task_id AND cc.code_combination_id = trans.code_combination_id AND trans.system_linkage_function = sys.function AND prj.segment1 BETWEEN nvl(:p_from_project, prj.segment1) AND nvl(:p_to_project, prj.segment1) GROUP BY trans.code_combination_id, cc.description, prj.segment1, prj.name, sys.project_manufacturing_flag, sys.meaning,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_account_description', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') ORDER BY 2 ASC,1 ASC,4 ASC,3 ASC,5 ASC Y PA PAXMGSLS_XML AR PA إجمالي دفتر الأستاذ الفرعي للمشروع (بتنسيق XML) Imported from BI Publisher Description: AUD: دفتر الأستاذ الفرعي للمشروع: الإجمالي Application: المشروعات Source: AUD: إجمالي دفتر الأستاذ الفرعي للمشروع (بتنسيق XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG D PA Projekt Nebenbuch - Übersicht Imported from BI Publisher Description: PA: Projekt Nebenbuch - Übersicht Application: Projects Source: PA: Projekt Nebenbuch - Übersicht (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG E PA Resumen de Contabilidad Auxiliar de Proyectos Imported from BI Publisher Description: AUD: Contabilidad auxiliar de proyectos: resumen Application: Projects Source: AUD: Resumen de Contabilidad Auxiliar de Proyectos (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG F PA Synthèse du livre auxiliaire des projets Imported from BI Publisher Description: AUD : Livre auxiliaire des projets : Synthèse Application: Projects Source: AUD : Synthèse du livre auxiliaire des projets (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG I PA Sintetico sezionali progetto Imported from BI Publisher Description: AUD: Sezionali progetto: sintetico Application: Projects Source: AUD: Sintetico sezionali progetto (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG JA PA プロジェクト補助元帳要約 Imported from BI Publisher Description: AUD: プロジェクト補助元帳: 要約 Application: Projects Source: AUD: プロジェクト補助元帳要約(XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG KO PA 프로젝트 보조원장: 요약 Imported from BI Publisher Description: AUD: 프로젝트 보조원장: 요약 Application: Projects Source: AUD: 프로젝트 보조원장: 요약(XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG PTB PA Sumário do Sub-razão Geral do Projeto Imported from BI Publisher Description: AUD: Sub-razão geral do Projeto: Sumário Application: Projetos Source: AUD: Sumário do Sub-razão Geral do Projeto (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG RU PA сводка субкниги проекта Imported from BI Publisher Description: АУД: субкнига проекта: сводка Application: Проекты Source: АУД: сводка субкниги проекта (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG S PA Projektreskontra: Översikt Imported from BI Publisher Description: AUD: Projektreskontra: Översikt Application: Projects Source: AUD: Projektreskontra: Översikt (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG TR PA Proje Cari Hesap Özeti Imported from BI Publisher Description: AUD: Proje Cari Hesabı : Özet Application: Proje Yönetimi Source: AUD: Proje Cari Hesap Özeti (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG US PA Project Subledger Summary Imported from BI Publisher Description: AUD: Project Subledger: Summary Application: Projects Source: AUD: Project Subledger Summary (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG ZHS PA AUD：项目子分类帐汇总 Imported from BI Publisher Description: AUD：项目子分类帐：汇总 Application: 项目 Source: AUD：项目子分类帐汇总 (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG BI Publisher &c_where :c_account_desc1 :c_company_name_header :c_dummy_data :c_no_data_found :c_where :cf_from_date :cf_to_date :cp_from_gl_date :cp_to_gl_date :operating_unit :p_ca_set_of_books_id :p_coa_id :p_conc_request_id :p_debug_mode :p_from_account :p_from_gl_date :p_from_project :p_rule_optimizer :p_to_account :p_to_gl_date :p_to_project 1 -40 :p_ca_set_of_books_id LOV Oracle PA_SRS_SET_OF_BOOKS Y select set_of_books_id id, currency value, set_of_books_name description from pa_gl_set_of_books_v order by set_of_books_type select currency from pa_gl_set_of_books_v where set_of_books_type_code = 'P' Y AR عملة دفاتر الحسابات معرف دفاتر الحسابات المستخدم لإجمالي الأستاذ الفرعي للمشروع D Währung Buchungsstruktur Buchungsstrukturkennung für die Auswertung "Projekt Nebenbuch - Übersicht" E Divisa de Juego de Libros Identificador de juego de libros utilizado en Resumen de Contabilidad Auxiliar de Proyectos F Devise de l'entité comptable ID entité comptable utilisé pour la synthèse du livre auxiliaire des projets I Divisa set of books Id del set of books utilizzato per il sintetico del sezionale progetto JA 会計帳簿通貨 プロジェクト補助元帳要約に使用する会計帳簿ID KO 회계장부 통화 프로젝트 보조원장 요약에 사용되는 회계장부 ID PTB Moeda do Conjunto de Livros Id do Conjunto de Livros usado para Sumário do Sub-razão do Projeto RU Валюта набора книг Идентификатор набора книг, используемого для сводки вспомогательного регистра проекта S Räkenskapsvaluta Räkenskaps-id som används för översikt över projektreskontra TR Defter Para Birimi Proje Cari Hesap Özeti için kullanılan Yasal Muhasebe Birimi No US Set of Books Currency Set of Books Id used for Project Subledger Summary ZHS 帐套币种 用于项目子分类帐汇总的帐套标识 2 -30 :p_sob_id Number SELECT set_of_books_id FROM pa_implementations Y AR P_SOB_ID معرف دفاتر الحسابات D P_SOB_ID Kennung Buchungsstruktur E P_SOB_ID Identificador de juego de libros F P_SOB_ID ID entité comptable I P_SOB_ID Id del set of books JA P_SOB_ID 会計帳簿ID KO P_SOB_ID 회계장부 ID PTB P_SOB_ID Id do conjunto de livros RU P_SOB_ID Идентификатор набора книг S P_SOB_ID Räkenskaps-id TR P_SOB_ID Yasal muhasebe birim no US P_SOB_ID Set of books id ZHS P_SOB_ID 帐套标识 3 -20 :p_coa_id LOV Oracle PA_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from pa_implementations_all imp,gl_sets_of_books gl where imp.set_of_books_id=gl.set_of_books_id and imp.org_id=mo_global.get_current_org_id order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books g, pa_implementations p WHERE g.set_of_books_id = p.set_of_books_id Y AR COA_ID معرف جدول تصنيف الحسابات D COA_ID Kennung Kontenplan E COA_ID Identificador de plan de cuentas F COA_ID ID plan de comptes I COA_ID Id del piano dei conti JA COA_ID 勘定体系ID KO COA_ID 계정 코드집 ID PTB COA_ID Id do plano de contas RU COA_ID Идентификатор плана счетов S COA_ID Kontoplans-id TR COA_ID Hesap planı no US COA_ID Chart of accounts id ZHS COA_ID 科目表标识 4 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 5 10 :p_from_account Char AR من حساب الأستاذ العام من الحساب D Von RW-Konto Von Konto E De Cuenta Contable De cuenta F Compte GL - De Compte - De I Conto GL - Da Conto - Da JA GL勘定科目:自 勘定科目:自 KO GL 계정: 부터 계정: 부터 PTB Conta GL - De Conta - De RU Счет ГК с Счет с S Från huvudbokskonto Från konto TR İlk GL Hesabı İlk Hesap US From GL Account From Account ZHS 自 GL 帐户 自账户 6 20 :p_to_account Char AR إلى حساب الأستاذ العام إلى الحساب D Bis RW-Konto Bis Konto E A Cuenta Contable A cuenta F Compte GL - A Compte - A I Conto GL - A Conto - A JA GL勘定科目:至 勘定科目:至 KO GL 계정: 까지 계정: 까지 PTB Conta GL - Até Conta - Até RU Счет ГК с 2 Счет по S Till huvudbokskonto Till konto TR Son GL Hesabı Son Hesap US To GL Account To Account ZHS 至 GL 帐户 至账户 7 30 :p_from_project Char AR من المشروع من المشروع D Von Projekt Von Projekt E De Proyecto De proyecto F Projet - De Projet - De I Progetto - Da Progetto - Da JA プロジェクト:自 プロジェクト:自 KO 프로젝트: 부터 프로젝트: 부터 PTB Projeto - De Projeto - De RU Проект с Проект с S Från projekt Från projekt TR İlk Proje İlk Proje US From Project From Project ZHS 自项目 自项目 8 40 :p_to_project Char AR إلى المشروع إلى المشروع D Bis Projekt Bis Projekt E A Proyecto A proyecto F Projet - A Projet - A I Progetto - A Progetto - A JA プロジェクト:至 プロジェクト:至 KO 프로젝트: 까지 프로젝트: 까지 PTB Projeto - Até Projeto - Até RU Проект по Проект по S Till projekt Till projekt TR Son Proje Son Proje US To Project To Project ZHS 至项目 至项目 9 50 :p_from_gl_date Date Y AR من تاريخ الأستاذ العام من تاريخ الأستاذ العام D Von RW-Datum Von RW-Datum E De Fecha Contable De fecha contable F Date GL - Du Date GL - Du I Data GL - Da Data GL - Da JA GL記帳日:自 GL記帳日:自 KO GL 일자: 부터 GL 일자: 부터 PTB Data GL - De Data GL - De RU Дата ГК с Дата ГК с S Från bokföringsdatum Från bokföringsdatum TR İlk GL Tarihi İlk GL Tarihi US From GL Date From GL Date ZHS 自 GL 日期 自 GL 日期 10 60 :p_to_gl_date Date Y AR إلى تاريخ الأستاذ العام إلى تاريخ الأستاذ العام D Bis RW-Datum Bis RW-Datum E A Fecha Contable A fecha contable F Date GL - Au Date GL - Au I Data GL - A Data GL - A JA GL記帳日:至 GL記帳日:至 KO GL 일자: 까지 GL 일자: 까지 PTB Data GL - Até Data GL - Até RU Дата ГК по Дата ГК по S Till bokföringsdatum Till bokföringsdatum TR Son GL Tarihi Son GL Tarihi US To GL Date To GL Date ZHS 至 GL 日期 至 GL 日期