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）限制的操作单元。 C6E085D470B551A9E05362FB09050512 SELECT e.process_id e_conc_id, e.message_text error, e.je_header_id, e.je_line_num, e.identifier, gs.user_je_source_name jsource, gh.name jname FROM GL_JE_SOURCES gs, JL_CO_GL_CONC_ERRS e, GL_JE_HEADERS gh WHERE e.process_id = :P_CONC_ID AND e.je_header_id = gh.je_header_id AND gs.je_source_name = gh.je_source and e.process_id=:m_conc_id ORDER BY 3, 4 Y JL JLCOGLNE_XML US JL Colombian Third Party Balances Error Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Colombian Third Party Balances Error Report Application: Latin America Localizations Source: Colombian Third Party Balances Error Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOGLNE_XML DB package: JL_JLCOGLNE_XMLP_PKG BI Publisher :cp_period_name :cp_sob_name :m_conc_id :operating_unit :p_conc_id :p_conc_request_id :p_end_of_report :p_no_data_found :p_sob_id 1 -20 :p_sob_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y US Ledger Id Ledger Id 2 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 3 10 :p_conc_id LOV Oracle JLCO_GL_NIT_CONCID Y select jcc.process_id id, jcc.process_id value, jcc.period_name description from jl_co_gl_conc_ctrl jcc,gl_periods gp,gl_sets_of_books sob where jcc.period_name=gp.period_name and jcc.status<>'R' and jcc.set_of_books_id=fnd_profile.value('gl_set_of_bks_id') and sob.set_of_books_id=jcc.set_of_books_id and sob.period_set_name=gp.period_set_name and sob.accounted_period_type=gp.period_type and jcc.process_id is not null and exists (select 'Y' from jl_co_gl_trx e where e.process_id=jcc.process_id) and gp.period_year not in (select d.reported_year from jl_co_gl_mg_headers d where d.set_of_books_id=sob.set_of_books_id and d.status='Y') order by gp.period_num desc,gp.period_year Y US Process Id Process Id