ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US B9847D20A0D6742FE0538931640A6379 CE Bank Account Y select cba.bank_account_name value, hp.party_name||' ('||cba.currency_code||')' description from ce_bank_accounts cba, hz_parties hp where cba.bank_id=hp.party_id order by hp.party_name, cba.currency_code, cba.bank_account_name US B52C6BB09E788499E0530100007F4F38 FND Flex Hierarchy Y select distinct ffvnh.parent_flex_value value, (select ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end from fnd_flex_values_vl ffvv where ffvnh.flex_value_set_id=ffvv.flex_value_set_id and ffvv.parent_flex_value_low is null and ffvnh.parent_flex_value=ffvv.flex_value)||' ('||nvl2(ffvnh.is_child,null,xxen_util.meaning('TOP','TOP_BOTTOM_PERF',283)||' ')||xxen_util.meaning('CCONTAIN','ICX_CONDITIONS',0)||' '||xxen_util.meaning(ffvnh.max_range_attribute,'RANGE_ATTRIBUTE',0)||')' description, ffvnh.is_child, ffvnh.max_range_attribute from ( select distinct ffvnh.flex_value_set_id, ffvnh.parent_flex_value, (select 'Y' from gl_seg_val_norm_hierarchy gsvnh where ffvnh.parent_flex_value=gsvnh.child_flex_value and ffvnh.flex_value_set_id=gsvnh.flex_value_set_id and rownum=1) is_child, max(ffvnh.range_attribute) over (partition by ffvnh.parent_flex_value) max_range_attribute from fnd_flex_value_norm_hierarchy ffvnh where ffvnh.flex_value_set_id in ( select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set union all select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) ) ) ffvnh order by ffvnh.is_child desc, ffvnh.max_range_attribute desc, length(ffvnh.parent_flex_value), ffvnh.parent_flex_value US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. C428002B0F22099BE0530100007FE0E4 GL Segment Y select distinct fifsv.form_left_prompt value, lower(fifsv.application_column_name) description, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.flex_value_set_id in (select ffvnh.flex_value_set_id from fnd_flex_value_norm_hierarchy ffvnh) and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where ( xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) order by min_id_flex_num, min_segment_num US 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）限制的操作单元。 1DF0849953A80EF1E0630100007F1E10 IBY Payment Process Request Status Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_REQUEST_STATUSES' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value US 1E1B6241E3B0CDA3E0630100007F5FB2 IBY Payment Status Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_PAYMENT_STATUSES' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B67276DF07344941E0530100007F1494Y with dist_hierarchy as ( select /*+ materialize */ &dist_hierarchy_levels x.flex_value_set_id, x.child_flex_value_low, x.child_flex_value_high from ( select substr(sys_connect_by_path(ffvnh.parent_flex_value,'|'),2) path, ffvnh.child_flex_value_low, ffvnh.child_flex_value_high, ffvnh.flex_value_set_id from (select ffvnh.* from fnd_flex_value_norm_hierarchy ffvnh where ffvnh.flex_value_set_id=:dist_flex_value_set_id) ffvnh where connect_by_isleaf=1 and ffvnh.range_attribute='C' connect by nocycle ffvnh.parent_flex_value between prior ffvnh.child_flex_value_low and prior ffvnh.child_flex_value_high and ffvnh.flex_value_set_id=prior ffvnh.flex_value_set_id and prior ffvnh.range_attribute='P' start with ffvnh.parent_flex_value=:dist_parent_flex_value ) x ) select xep.name legal_entity, hou.name operating_unit, ipsr.call_app_pay_service_req_code payment_process_request, xxen_util.client_time(aisca.creation_date) creation_date, trunc(sysdate)-trunc(aisca.creation_date) age, trunc(aisca.check_date) check_date, aisca.pay_from_date, aisca.pay_thru_date, (select count(*) from iby_payments_all ipa where ipsr.payment_service_request_id=ipa.payment_service_request_id and ipa.payment_status not in ('REMOVED','REMOVED_DOCUMENT_SPOILED','REMOVED_INSTRUCTION_TERMINATED','REMOVED_REQUEST_TERMINATED','REMOVED_PAYMENT_STOPPED','FAILED_BY_REJECTION_LEVEL','FAILED_BY_CALLING_APP','REJECTED')) payments, (select count(distinct ipa.payment_instruction_id) from iby_payments_all ipa where ipsr.payment_service_request_id=ipa.payment_service_request_id) payment_instructions, ap_payment_util_pkg.get_selected_ps_count(aisca.checkrun_id, ipsr.payment_service_request_id) selected_scheduled_payments, ap_payment_util_pkg.get_rejected_ps_count(ipsr.payment_service_request_id) rejected_scheduled_payments, xxen_util.meaning(ap_payment_util_pkg.get_payment_status_flag(ipsr.payment_service_request_id),'PSR_PAYMENTS_RECORDED',200) payments_recorded, nvl2(ipsr.payment_service_request_id,xxen_util.meaning(ap_payment_util_pkg.get_psr_status(ipsr.payment_service_request_id,ipsr.payment_service_request_status),'IBY_REQUEST_STATUSES',0),xxen_util.meaning(aisca.status,'CHECK BATCH STATUS',200)) payment_process_request_status, xxen_util.meaning(ipsr.payment_rejection_level_code,'IBY_PAYMENT_REJECTION_LEVELS',0) payment_rejection_level, xxen_util.meaning(ipsr.process_type,'IBY_PROCESS_TYPES',0) process_type, ipia.payment_instruction_id payment_instruction_reference, ipia.pay_admin_assigned_ref_code pay_admin_assigned_reference, xxen_util.meaning(ipia.payment_instruction_status,'IBY_PAY_INSTRUCTION_STATUSES',0) payment_instruction_status, ipa.payment_reference_number, ipa.paper_document_number, ipa.payment_amount, case when aca.check_id is not null then nvl(aca.base_amount,aca.amount) when ipa.payment_currency_code=gl.currency_code then ipa.payment_amount when ipa.payment_currency_code=gl.currency_code and :p_pay_inv_exch_rate_type is not null then round(ipa.payment_amount*gl_currency_api.get_rate(ipa.payment_currency_code,gl.currency_code,trunc(aisca.check_date),:p_pay_inv_exch_rate_type),2) end payment_func_curr_amount, ipa.payment_date, ipa.payment_currency_code currency, xxen_util.meaning(ipa.payment_status,'IBY_PAYMENT_STATUSES',0) payment_status, nvl(ipa.payee_party_name,hp1.party_name) trading_partner, fav.application_name source_product, idpa.calling_app_doc_ref_number document_reference_number, xxen_util.meaning(idpa.document_type,'IBY_DOCUMENT_TYPES',0) document_type, xxen_util.meaning(idpa.document_status,'IBY_DOCS_PAYABLE_STATUSES',0) document_status, idpa.document_date, idpa.document_amount, idpa.document_currency_code document_currency, idpa.payment_amount amount_paid, idpa.payment_curr_discount_taken discount_taken, idpa.payment_amount+nvl(idpa.payment_curr_discount_taken,0) amount_paid_incl_discount, idpa.payment_currency_code document_payment_currency, idpa.payment_date document_payment_date, case when idpa.document_currency_code<>gl.currency_code then (select gdct.user_conversion_type from gl_daily_conversion_types gdct where aia.exchange_rate_type=gdct.conversion_type) end document_exch_rate_type, case when idpa.document_currency_code<>gl.currency_code then aia.exchange_date end document_exch_rate_date, case when idpa.document_currency_code<>gl.currency_code then aia.exchange_rate end document_exch_rate, nvl(aia.base_amount,idpa.document_amount) document_func_curr_amount, &invoice_distribution_columns &dist_segment_columns &dist_hierarchy_levels4 case when idpa.payment_currency_code<>gl.currency_code and aca.check_id is not null then (select gdct.user_conversion_type from gl_daily_conversion_types gdct where aca.exchange_rate_type=gdct.conversion_type) when idpa.payment_currency_code<>gl.currency_code and :p_pay_inv_exch_rate_type is not null then (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type=:p_pay_inv_exch_rate_type) end payment_exch_rate_type, case when idpa.payment_currency_code<>gl.currency_code and aca.check_id is not null then aca.exchange_date when idpa.payment_currency_code<>gl.currency_code and :p_pay_inv_exch_rate_type is not null then trunc(aisca.check_date) end payment_exch_rate_date, case when idpa.payment_currency_code<>gl.currency_code and aca.check_id is not null then aca.exchange_rate when idpa.payment_currency_code<>gl.currency_code and :p_pay_inv_exch_rate_type is not null then gl_currency_api.get_rate(idpa.payment_currency_code,gl.currency_code,trunc(aisca.check_date),:p_pay_inv_exch_rate_type) end payment_exch_rate, case when idpa.payment_currency_code=gl.currency_code then idpa.payment_amount when idpa.payment_currency_code<>gl.currency_code and aca.check_id is not null then round(idpa.payment_amount*aca.exchange_rate,2) when idpa.payment_currency_code<>gl.currency_code and :p_pay_inv_exch_rate_type is not null then round(idpa.payment_amount*gl_currency_api.get_rate(idpa.payment_currency_code,gl.currency_code,trunc(aisca.check_date),:p_pay_inv_exch_rate_type),2) end amount_paid_func_curr_amount, case when idpa.payment_currency_code=gl.currency_code then idpa.payment_curr_discount_taken when idpa.payment_currency_code<>gl.currency_code and aca.check_id is not null then round(idpa.payment_curr_discount_taken*aca.exchange_rate,2) when idpa.payment_currency_code<>gl.currency_code and :p_pay_inv_exch_rate_type is not null then round(idpa.payment_curr_discount_taken*gl_currency_api.get_rate(idpa.payment_currency_code,gl.currency_code,trunc(aisca.check_date),:p_pay_inv_exch_rate_type),2) end discount_taken_func_curr_amt, case when idpa.payment_currency_code=gl.currency_code then idpa.payment_amount+nvl(idpa.payment_curr_discount_taken,0) when idpa.payment_currency_code<>gl.currency_code and aca.check_id is not null then round((idpa.payment_amount+nvl(idpa.payment_curr_discount_taken,0))*aca.exchange_rate,2) when idpa.payment_currency_code<>gl.currency_code and :p_pay_inv_exch_rate_type is not null then round((idpa.payment_amount+nvl(idpa.payment_curr_discount_taken,0))*gl_currency_api.get_rate(idpa.payment_currency_code,gl.currency_code,trunc(aisca.check_date),:p_pay_inv_exch_rate_type),2) end amount_paid_incl_disc_func_amt, nvl(cba.currency_code,(select cba2.currency_code from ce_bank_accounts cba2 where ipsr.internal_bank_account_id=cba2.bank_account_id)) payment_currency, case when :p_pay_inv_exch_rate_type is not null and idpa.document_currency_code<>idpa.payment_currency_code then (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type=:p_pay_inv_exch_rate_type) end pay_inv_curr_exch_rate_type, case when :p_pay_inv_exch_rate_type is not null and idpa.document_currency_code<>idpa.payment_currency_code then gl_currency_api.get_rate(idpa.payment_currency_code,idpa.document_currency_code,ipa.payment_date,:p_pay_inv_exch_rate_type) end payment_inv_curr_exch_rate, case when :p_pay_inv_exch_rate_type is not null and idpa.document_currency_code<>idpa.payment_currency_code then round(idpa.payment_amount*gl_currency_api.get_rate(idpa.payment_currency_code,idpa.document_currency_code,ipa.payment_date,:p_pay_inv_exch_rate_type),2) end payment_inv_curr_amount, ieba.masked_bank_account_num payee_bank_account, ieba.masked_iban iban, iebav.bank_name payee_bank_name, idpa.bank_charge_bearer, xxen_util.meaning(idpa.exclusive_payment_flag,'YES_NOW',0) pay_each_document_alone, iprv.meaning payment_reason, idpa.payment_reason_comments, ipmv.payment_method_name payment_method, iappv.payment_profile_name payment_process_profile, hz_format_pub.format_address(hps.location_id,null,null,',',null,null,null,null) payee_address, ifv.format_name payment_format, idcv.meaning delivery_channel, idpa.settlement_priority, idpa.unique_remittance_identifier, idpa.uri_check_digit, idpa.remittance_message1, idpa.remittance_message2, idpa.remittance_message3, xxen_util.meaning(idpa.payment_function,'IBY_PAYMENT_FUNCTIONS',0) payment_function, ittv.name processing_transaction_type, cba.bank_account_name internal_bank_account, idpa.amount_withheld, ite.error_message document_validation_error, (select ivsv.validation_set_display_name from iby_validation_sets_vl ivsv where ite.validation_set_code=ivsv.validation_set_code) document_validation_set, xxen_util.meaning(ite.error_status,'IBY_TRANSACTION_ERROR_STATUSES',0) document_error_status, ite.error_date document_date_failed, ite.pass_date document_date_passed, ite.override_date document_override_date, ite.override_justification doc_override_justification, ite2.error_message payment_validation_error, (select ivsv.validation_set_display_name from iby_validation_sets_vl ivsv where ite2.validation_set_code=ivsv.validation_set_code) payment_validation_set, xxen_util.meaning(ite2.error_status,'IBY_TRANSACTION_ERROR_STATUSES',0) payment_error_status, ite2.error_date payment_date_failed, ite2.pass_date payment_date_passed, ite2.override_date payment_override_date, ite2.override_justification payment_override_justification, xxen_util.user_name(aisca.created_by) request_created_by, xxen_util.user_name(aisca.last_updated_by) request_last_updated_by, xxen_util.user_name(idpa.created_by) document_created_by, xxen_util.client_time(idpa.creation_date) document_creation_date, xxen_util.user_name(idpa.last_updated_by) document_last_updated_by, xxen_util.client_time(idpa.last_update_date) document_last_update_date, idpa.payment_service_request_id, aisca.checkrun_id, idpa.payment_id, idpa.document_payable_id from iby_pay_service_requests ipsr, ap_inv_selection_criteria_all aisca, iby_docs_payable_all idpa, ap_invoices_all aia, ( select aida.*, gcck.chart_of_accounts_id, &dist_segment_cols2 &dist_hierarchy_levels2 gcck.code_combination_id ccid from ap_invoice_distributions_all aida, gl_code_combinations_kfv gcck, dist_hierarchy h where '&show_invoice_distributions'='Y' and aida.dist_code_combination_id=gcck.code_combination_id(+) and gcck.&dist_hierarchy_segment_column between nvl(h.child_flex_value_low(+),gcck.&dist_hierarchy_segment_column) and nvl(h.child_flex_value_high(+),gcck.&dist_hierarchy_segment_column) ) aida, ap_checks_all aca, hz_parties hp1, hz_parties hp2, hz_party_sites hps, fnd_application_vl fav, iby_ext_bank_accounts_v iebav, iby_ext_bank_accounts ieba, iby_payment_reasons_vl iprv, iby_payment_methods_vl ipmv, iby_acct_pmt_profiles_vl iappv, iby_formats_vl ifv, iby_delivery_channels_vl idcv, iby_trxn_types_vl ittv, iby_payments_all ipa, iby_pay_instructions_all ipia, hr_operating_units hou, gl_ledgers gl, xle_entity_profiles xep, ce_bank_accounts cba, ( select distinct ite.transaction_id, listagg(ite.error_message,chr(10)) within group (order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) error_message, max(ite.validation_set_code) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) validation_set_code, max(ite.error_status) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) error_status, max(ite.error_date) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) error_date, max(ite.pass_date) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) pass_date, max(ite.override_date) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) override_date, max(ite.override_justification) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) override_justification from iby_transaction_errors ite where ite.transaction_type='DOCUMENT_PAYABLE' ) ite, ( select distinct ite.transaction_id, listagg(ite.error_message,chr(10)) within group (order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) error_message, max(ite.validation_set_code) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) validation_set_code, max(ite.error_status) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) error_status, max(ite.error_date) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) error_date, max(ite.pass_date) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) pass_date, max(ite.override_date) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) override_date, max(ite.override_justification) keep (dense_rank last order by ite.transaction_error_id) over (partition by ite.transaction_id &partition_by_error) override_justification from iby_transaction_errors ite where ite.transaction_type='PAYMENT' ) ite2 where 1=1 and ipsr.call_app_pay_service_req_code=aisca.checkrun_name(+) and ipsr.payment_service_request_id=idpa.payment_service_request_id and decode(idpa.calling_app_id,200,to_number(idpa.calling_app_doc_unique_ref2))=aia.invoice_id(+) and aia.invoice_id=aida.invoice_id(+) and idpa.payment_id=aca.payment_id(+) and idpa.payee_party_id=hp1.party_id and idpa.inv_payee_party_id=hp2.party_id(+) and idpa.party_site_id=hps.party_site_id(+) and idpa.calling_app_id=fav.application_id and idpa.external_bank_account_id=iebav.bank_account_id(+) and idpa.external_bank_account_id=ieba.ext_bank_account_id(+) and idpa.payment_reason_code=iprv.payment_reason_code(+) and idpa.payment_method_code=ipmv.payment_method_code(+) and idpa.payment_profile_id=iappv.payment_profile_id(+) and idpa.payment_format_code=ifv.format_code(+) and idpa.delivery_channel_code=idcv.delivery_channel_code(+) and idpa.pay_proc_trxn_type_code=ittv.pay_proc_trxn_type_code(+) and idpa.payment_id=ipa.payment_id(+) and ipa.payment_instruction_id=ipia.payment_instruction_id(+) and decode(idpa.org_type,'OPERATING_UNIT',idpa.org_id)=hou.organization_id(+) and (hou.organization_id is null or 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)) and hou.set_of_books_id=gl.ledger_id(+) and idpa.legal_entity_id=xep.legal_entity_id(+) and idpa.internal_bank_account_id=cba.bank_account_id(+) and idpa.document_payable_id=ite.transaction_id(+) and idpa.payment_id=ite2.transaction_id(+) order by xep.name, hou.name, creation_date desc, idpa.payment_id desc Performance: materialized distribution hierarchy once in a CTE to avoid repeated CONNECT BY evaluation for each invoice distribution row when Show Invoice Distributions is enabled. AR IBY Payment Process Request Details تفاصيل طلب مدير الدفع بما في ذلك الحالات والمستندات المدفوعة أو المرفوضة والمبالغ ورسائل الرفض D IBY Payment Process Request Details Zahlungsmanager-Prozessanforderungsdetails einschließlich Status, bezahlter oder abgelehnter Dokumente, Beträge und Ablehnungsfehlermeldungen E IBY Payment Process Request Details Detalles de las solicitudes de proceso del gestor de pagos, incluidos los estados, los documentos pagados o rechazados, los importes y los mensajes de error de rechazo F IBY Payment Process Request Details Les détails de la procédure de demande du gestionnaire de paiement, y compris les statuts, les documents payés ou rejetés, les montants et les messages d'erreur de rejet I IBY Payment Process Request Details I dettagli delle richieste del gestore dei pagamenti, compresi gli stati, i documenti pagati o rifiutati, gli importi e i messaggi di errore di rifiuto JA IBY Payment Process Request Details 支払い管理者のプロセスリクエストの詳細（ステータス、支払い済みまたは拒否された書類、金額、拒否メッセージを含む KO IBY Payment Process Request Details 상태, 지불 또는 거부 된 문서, 금액 및 거부 오류 메시지를 포함한 지불 관리자 프로세스 요청 세부 정보 PTB IBY Payment Process Request Details Detalhes do processo de solicitação do gerente de pagamento incluindo status, documentos pagos ou rejeitados, valores e mensagens de rejeição RU IBY Payment Process Request Details Менеджер по платежам обрабатывает заявки, включая статусы, оплаченные или отклоненные документы, суммы и сообщения об отказе в обслуживании. S IBY Payment Process Request Details Information om begäran om betalningshanterare inklusive status, betalda eller avvisade dokument, belopp och felmeddelanden om avslag TR IBY Payment Process Request Details Ödeme yöneticisi işlemleri, durumlar, ödenen veya reddedilen belgeler, tutarlar ve ret hata mesajları dahil olmak üzere istek ayrıntıları US IBY Payment Process Request Details Payment manager process request details including statuses, paid or rejected documents, amounts and rejection eror messages ZHS IBY Payment Process Request Details 支付经理处理请求的细节，包括状态、已支付或拒绝的文件、金额和拒绝的错误信息 Enginatics R12 only &dist_hierarchy_levels &dist_hierarchy_levels2 &dist_hierarchy_levels4 &dist_hierarchy_segment_column &dist_segment_cols2 &dist_segment_columns &invoice_distribution_columns &partition_by_error &show_invoice_distributions 1=1 :dist_flex_value_set_id :dist_parent_flex_value :p_pay_inv_exch_rate_type 1 -30 :dist_flex_value_set_id Number select min(fifsv.flex_value_set_id) from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) US Dist Flex Value Set Id 2 -20 1=1 :hierarchy_segment_column=:hierarchy_segment_column Char select min(fifsv.application_column_name) text from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) US Hierarchy Segment Column 3 &dist_hierarchy_segment_column <parameter_value> US Hierarchy Segment Column 4 -10 1=1 :max_hierarchy_levels=:max_hierarchy_levels Number select nvl(max(level),0)+1 from (select ffvnh.* from fnd_flex_value_norm_hierarchy ffvnh where ffvnh.flex_value_set_id in ( select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) )) ffvnh where connect_by_isleaf=1 and ffvnh.range_attribute='C' connect by nocycle ffvnh.parent_flex_value between prior ffvnh.child_flex_value_low and prior ffvnh.child_flex_value_high and ffvnh.flex_value_set_id=prior ffvnh.flex_value_set_id and prior ffvnh.range_attribute='P' start with ffvnh.parent_flex_value=:$flex$.hierarchy US Max Hierarchy Levels 5 10 1=1 hou.name=: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)) F Unité d'exploitation US Operating Unit 6 20 1=1 ipsr.call_app_pay_service_req_code=:payment_process_request Char F Demande de processus de paiement US Payment Process Request 7 30 1=1 ap_payment_util_pkg.get_psr_status(ipsr.payment_service_request_id,ipsr.payment_service_request_status)=xxen_util.lookup_code(:payment_process_request_status,'IBY_REQUEST_STATUSES',0) LOV IBY Payment Process Request Status 1DF0849953A80EF1E0630100007F1E10 Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_REQUEST_STATUSES' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value US Payment Process Request Status 8 40 1=1 ipa.payment_status=xxen_util.lookup_code(:payment_status,'IBY_PAYMENT_STATUSES',0) LOV IBY Payment Status 1E1B6241E3B0CDA3E0630100007F5FB2 Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_PAYMENT_STATUSES' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value US Payment Status 9 50 1=1 aisca.creation_date>=:request_creation_from Date select sysdate-1 from dual where :$flex$.payment_process_request is null and :$flex$.request_created_by is null and :$flex$.internal_bank_account is null and :$flex$.trading_partner is null and :$flex$.rejected_documents_only is null F Date de création de la demande Du US Request Creation Date From 10 60 1=1 aisca.creation_date<:request_creation_to+1 Date last_day(:$flex$.request_creation_date_from) F Date de création de la demande au US Request Creation Date To 11 70 1=1 aisca.created_by=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Demande créée par US Request Created By 12 80 1=1 cba.bank_account_name=:internal_bank_account LOV CE Bank Account B9847D20A0D6742FE0538931640A6379 Y select cba.bank_account_name value, hp.party_name||' ('||cba.currency_code||')' description from ce_bank_accounts cba, hz_parties hp where cba.bank_id=hp.party_id order by hp.party_name, cba.currency_code, cba.bank_account_name F Compte bancaire interne US Internal Bank Account 13 90 1=1 ipa.payee_party_name=:payee_party_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Partenaire commercial US Trading Partner 14 100 1=1 ( idpa.document_status in ( 'REJECTED', 'PAYMENT_FAILED_VALIDATION', 'FAILED_BY_RELATED_DOCUMENT', 'FAILED_BY_REJECTION_LEVEL', 'FAILED_BY_CALLING_APP', 'REMOVED', 'REMOVED_PAYMENT_REMOVED', 'REMOVED_REQUEST_TERMINATED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_PAYMENT_STOPPED', 'REMOVED_PAYMENT_VOIDED' ) or ipa.payment_status in ( 'FAILED_BY_REJECTION_LEVEL', 'FAILED_BY_CALLING_APP', 'REMOVED', 'REMOVED_REQUEST_TERMINATED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_PAYMENT_STOPPED', 'VOID', 'REJECTED', 'FAILED_VALIDATION' ) ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Rejeté ou échoué seulement US Rejected or Failed Only 15 110 1=1 idpa.document_status not in ( 'REMOVED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_PAYMENT_REMOVED', 'REMOVED_PAYMENT_STOPPED', 'REMOVED_PAYMENT_VOIDED', 'REMOVED_REQUEST_TERMINATED' ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Exclure les documents supprimés US Exclude Removed Documents 16 120 &partition_by_error , ite.transaction_error_id LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Développer les détails de l'erreur US Expand Error Details 17 130 :p_pay_inv_exch_rate_type LOV Oracle AR_SRS_RATE_TYPE Y select conversion_type id, user_conversion_type value, null description from gl_daily_conversion_types order by value,description Corporate US Exchange Rate Type 18 140 &show_invoice_distributions Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Invoice Distributions 19 &invoice_distribution_columns aida.distribution_line_number dist_line_number, xxen_util.meaning(aida.line_type_lookup_code,'INVOICE DISTRIBUTION TYPE',200) distribution_type, aida.period_name, aida.accounting_date dist_accounting_date, aida.quantity_invoiced, aida.unit_price, aida.amount dist_amount, nvl(aida.base_amount,aida.amount) dist_base_amount, aida.invoice_price_variance dist_invoice_price_variance, aida.base_invoice_price_variance dist_base_inv_price_variance, xxen_util.concatenated_segments(aida.dist_code_combination_id) expense_account, xxen_util.concatenated_segments(aida.price_var_code_combination_id) price_variance_account, xxen_util.segments_description(aida.dist_code_combination_id) expense_account_descripton, xxen_util.segments_description(aida.price_var_code_combination_id) price_variance_account_desc, xxen_util.meaning(aida.dist_match_type,'MATCH_STATUS',200) dist_match_type, decode(aida.match_status_flag,'A','Validated','T','Tested','S','Stopped','Never Validated') dist_match_status, (select pha.segment1 from po_headers_all pha where nvl((select pda.po_header_id from po_distributions_all pda where aida.po_distribution_id=pda.po_distribution_id),aia.quick_po_header_id)=pha.po_header_id) po_number, US Show Invoice Distributions 20 150 1=1 :hierarchy_segment=:hierarchy_segment LOV GL Segment C428002B0F22099BE0530100007FE0E4 Y select distinct fifsv.form_left_prompt value, lower(fifsv.application_column_name) description, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.flex_value_set_id in (select ffvnh.flex_value_set_id from fnd_flex_value_norm_hierarchy ffvnh) and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where ( xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) order by min_id_flex_num, min_segment_num select min(fifsv.form_left_prompt) from fnd_segment_attribute_values fsav, fnd_id_flex_segments_vl fifsv where fsav.application_id=101 and fsav.id_flex_code='GL#' and fsav.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) and fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y' and fsav.application_id=fifsv.application_id and fsav.id_flex_code=fifsv.id_flex_code and fsav.id_flex_num=fifsv.id_flex_num and fsav.application_column_name=fifsv.application_column_name US Hierarchy Segment 21 &dist_hierarchy_levels select 'regexp_substr(x.path,''[^|]+'',1,'||x.column_value||') level'||x.column_value||',' text from table(xxen_util.rowgen(:max_hierarchy_levels)) x US Hierarchy Segment 22 &dist_hierarchy_levels2 select decode(x.column_value,1,'h.level1,','nvl(h.level'||x.column_value||',nvl2(h.level'||(x.column_value-1)||',gcck.'||:hierarchy_segment_column||',null)) level'||x.column_value||',') text from table(xxen_util.rowgen(:max_hierarchy_levels)) x US Hierarchy Segment 23 &dist_hierarchy_levels4 select 'aida.level'||x.column_value||'||nvl2(aida.level'||x.column_value||','' - ''||xxen_util.segment_description(aida.level'||x.column_value||','''||:hierarchy_segment_column||''',aida.chart_of_accounts_id),null) dist_hierarchy_level'||x.column_value||',' text from table(xxen_util.rowgen(:max_hierarchy_levels)) x US Hierarchy Segment 24 &dist_segment_cols2 select distinct 'gcck.'||lower(fifsv.application_column_name)||' '||lower(fifsv.application_column_name)||',' text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name) min_segment_num from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:operating_unit is null or xxen_util.contains(:operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) order by min_id_flex_num, min_segment_num US Hierarchy Segment 25 &dist_segment_columns select distinct 'aida.'||lower(fifsv.application_column_name)||' "Dist '||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||'",'||chr(10)|| 'xxen_util.segment_description(aida.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', aida.chart_of_accounts_id'|| ( select ', aida.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "Dist '||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-10)||' desc",' text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:operating_unit is null or xxen_util.contains(:operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) order by min_id_flex_num, min_segment_num US Hierarchy Segment 26 160 :dist_parent_flex_value LOV FND Flex Hierarchy B52C6BB09E788499E0530100007F4F38 Y select distinct ffvnh.parent_flex_value value, (select ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end from fnd_flex_values_vl ffvv where ffvnh.flex_value_set_id=ffvv.flex_value_set_id and ffvv.parent_flex_value_low is null and ffvnh.parent_flex_value=ffvv.flex_value)||' ('||nvl2(ffvnh.is_child,null,xxen_util.meaning('TOP','TOP_BOTTOM_PERF',283)||' ')||xxen_util.meaning('CCONTAIN','ICX_CONDITIONS',0)||' '||xxen_util.meaning(ffvnh.max_range_attribute,'RANGE_ATTRIBUTE',0)||')' description, ffvnh.is_child, ffvnh.max_range_attribute from ( select distinct ffvnh.flex_value_set_id, ffvnh.parent_flex_value, (select 'Y' from gl_seg_val_norm_hierarchy gsvnh where ffvnh.parent_flex_value=gsvnh.child_flex_value and ffvnh.flex_value_set_id=gsvnh.flex_value_set_id and rownum=1) is_child, max(ffvnh.range_attribute) over (partition by ffvnh.parent_flex_value) max_range_attribute from fnd_flex_value_norm_hierarchy ffvnh where ffvnh.flex_value_set_id in ( select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set union all select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) ) ) ffvnh order by ffvnh.is_child desc, ffvnh.max_range_attribute desc, length(ffvnh.parent_flex_value), ffvnh.parent_flex_value select distinct max(x.parent_flex_value) keep (dense_rank last order by x.count) over () parent_flex_value from ( select distinct ffvh.parent_flex_value, count(*) over (partition by ffvh.parent_flex_value) count from fnd_flex_value_hierarchies ffvh where ffvh.flex_value_set_id in ( select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl, hr_operating_units hou where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and hou.set_of_books_id=gl.ledger_id ) ) ) x US Hierarchy :$flex$.hierarchy Hierarchy Max Hierarchy Levels :$flex$.hierarchy_segment Hierarchy Segment Dist Flex Value Set Id :$flex$.hierarchy_segment Hierarchy Segment Hierarchy :$flex$.hierarchy_segment Hierarchy Segment Hierarchy Segment Column :$flex$.hierarchy_segment Hierarchy Segment Max Hierarchy Levels :$flex$.internal_bank_account Internal Bank Account Request Creation Date From :$flex$.operating_unit Operating Unit Dist Flex Value Set Id :$flex$.operating_unit Operating Unit Hierarchy :$flex$.operating_unit Operating Unit Hierarchy Segment :$flex$.operating_unit Operating Unit Hierarchy Segment Column :$flex$.operating_unit Operating Unit Max Hierarchy Levels :$flex$.operating_unit Operating Unit Trading Partner :$flex$.payment_process_request Payment Process Request Request Creation Date From :$flex$.request_created_by Request Created By Request Creation Date From :$flex$.request_creation_date_from Request Creation Date From Y Request Creation Date To :$flex$.trading_partner Trading Partner Request Creation Date From