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）限制的操作单元。 5070FB75A9650778E06362FB0905853AY select x.ledger, x.operating_unit, nvl(x.concatenated_segments,:account_string) account_string, x.description, x.start_date_active, x.end_date_active, x.enabled_flag, x.summary_flag, x.detail_posting_allowed, x.gl_security, x.code_combination_id, nvl( substr( case when x.concatenated_segments is null then chr(10) || 'Account does not exist in the Ledgers COA' end || case when x.concatenated_segments is not null and not nvl(x.gl_security,'FALSE') = 'TRUE' then chr(10) || 'GL Security is preventing the Account from being selected from this responsibility' end || case when not trunc(sysdate) between nvl(x.start_date_active,trunc(sysdate)) and nvl(x.end_date_active,trunc(sysdate)) then chr(10) || 'The Account is not active' end || case when not x.enabled_flag='Y' then chr(10) || 'The account is disabled' end || case when not x.summary_flag='N' then chr(10) || 'The account is a summary account' end || case when not x.detail_posting_allowed='Y' then chr(10) || 'Detailed Posting is not permitted to this account' end ,2,4000), 'Good') lov_status from ( select gl.name ledger, hou.name operating_unit, gcck.concatenated_segments, xxen_util.segments_description(gcck.code_combination_id) || ' (' || flvv.description || ')' description, gcck.start_date_active, gcck.end_date_active, gcck.enabled_flag, gcck.summary_flag, gcck.detail_posting_allowed, (select gl_security_pkg.validate_segval(fifsgv.segment_num,null,gcck.segment1) from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.id_flex_num=gl.chart_of_accounts_id ) gl_security, gcck.code_combination_id from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where hou.name=:operating_unit and gcck.concatenated_segments(+)=:account_string and to_number(hou.set_of_books_id)=gl.ledger_id and gl.chart_of_accounts_id=gcck.chart_of_accounts_id(+) and flvv.lookup_type(+)='ACCOUNT TYPE' and flvv.view_application_id(+)=101 and flvv.lookup_code(+)=gcck.gl_account_type ) x US AP Invoice Distribution Account LOV Check For a given Operating Unit and concatenated GL Account String, this Blitz Report will show the attributes used in restricting the account in the AP Invoice Upload Distribution Account LOV. :account_string :operating_unit 1 10 :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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Operating Unit 2 20 :account_string Char Y US GL Account String