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 8E2FF36EDEE379D2E0530100007F1FF2 GL Chart of Accounts Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where 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 fifsv.id_flex_structure_name AR مخطط حسابات جميع دفاتر الأستاذ التي يمكن الوصول إليها من خلال تعيين مجموعة الوصول إلى دفتر الأستاذ D Kontenplan aller Ledger, die über die Ledger-Zugriffs-Set-Zuordnung zugänglich sind E Plan de cuentas de todos los libros de contabilidad accesibles mediante la asignación de conjuntos de acceso a los libros de contabilidad F Plan comptable de tous les grands livres accessibles par affectation d'un ensemble d'accès aux grands livres I Piano dei conti di tutti i registri accessibili tramite l'assegnazione del set di accesso ai registri JA 元帳アクセスセットの割り当てでアクセス可能なすべての元帳の勘定科目一覧表 KO 원장 액세스 세트 할당으로 액세스 할 수있는 모든 원장의 계정과 목표 PTB Plano de contas de todos os ledgers acessíveis por atribuição de conjunto de acesso ao ledger RU План счетов всех бухгалтерских книг, доступных по назначению наборов доступа к бухгалтерским книгам S Kontoplan för alla reskontrar som är tillgängliga genom tilldelning av reservertillgång TR Defter erişim seti ataması ile erişilebilen tüm defterlerin hesap planı US Chart of accounts of all ledgers accessible by ledger access set assignment ZHS 通过分类账访问集分配可进入的所有分类账的账目表。 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_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(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 8E2FF36EDECC79D2E0530100007F1FF2 GL Segment1 Y select ffvv.flex_value value, 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 description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.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') 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 ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDECF79D2E0530100007F1FF2 GL Segment4 Y select ffvv.flex_value value, 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 description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.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') 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 ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 22F9F98651AB8733E06362FB09059E54 with apg_trial_balance_lvl2_base as ( --noetix_sys.apg0_ou_acl_map_base xmap replaced by gl_ledgers and hr_operating_unit --noetix_env_pkg.get_language replaced by userenv('lang') select /*+ materialize */ xlatb.applied_to_application_id, tbent.entity_code applied_to_entity_code, xlatb.applied_to_entity_id, tbent.transaction_number applied_to_transaction_num, (case when tbent.entity_code = 'AP_INVOICES' then 'Invoice' when tbent.entity_code = 'AP_PAYMENTS' then 'Payment' else tbent.entity_code end) applied_to_transaction_type, xlatb.code_combination_id, xlatb.ledger_id, xlatb.definition_code report_definition_code, sum(nvl(xlatb.entered_rounded_dr,0))-sum(nvl(xlatb.entered_rounded_cr, 0)) rounded_applied_amount, sum(nvl(xlatb.acctd_rounded_dr,0))-sum(nvl(xlatb.acctd_rounded_cr,0)) rounded_applied_amount_base, :p_trial_bal_effective_date trial_balance_effective_date from xla.xla_transaction_entities tbent, xla_trial_balances xlatb, hr_operating_units hou, gl_ledgers gl where 3=3 and 2=2 and nvl(tbent.security_id_int_1,-9999) = hou.organization_id and hou.set_of_books_id= gl.ledger_id and tbent.ledger_id=gl.ledger_id and xlatb.applied_to_entity_id is not null and tbent.ledger_id = xlatb.ledger_id and xlatb.applied_to_entity_id = tbent.entity_id and tbent.application_id = 200 and xlatb.gl_date <= :p_trial_bal_effective_date group by (case when tbent.entity_code = 'AP_INVOICES' then 'Invoice' when tbent.entity_code = 'AP_PAYMENTS' then 'Payment' else tbent.entity_code end), :p_trial_bal_effective_date, tbent.entity_code, tbent.transaction_number, xlatb.applied_to_application_id, xlatb.applied_to_entity_id, xlatb.code_combination_id, xlatb.definition_code, xlatb.ledger_id ), apg_trial_balance_lvl_base as ( select /*+ materialize */ xlatb.applied_to_entity_id, min(xlatb.gl_date) gl_date from xla_trial_balances xlatb, hr_operating_units hou, gl_ledgers gl where 3=3 and 2=2 and xlatb.applied_to_entity_id is not null and hou.set_of_books_id= gl.ledger_id and xlatb.ledger_id=gl.ledger_id group by xlatb.applied_to_entity_id ), apg_trial_balance_lvl1_base as ( select /*+ materialize */ evcls.name accounting_event_class_name, xlatb.code_combination_id code_combination_id, max(xlatb.gl_date) gl_date, xlatb.ledger_id ledger_id, nvl(entty.security_id_int_1,-9999) org_id, sum(nvl(xlatb.entered_rounded_cr,0)-nvl(xlatb.entered_rounded_dr,0)) original_amount, sum(nvl(xlatb.acctd_rounded_cr,0)-nvl(xlatb.acctd_rounded_dr,0)) original_amount_base, xlatb.party_id party_id, xlatb.record_type_code record_type_code, xlatb.definition_code report_definition_code, tbdfn.name report_definition_name, xlatb.source_entity_id source_entity_id, vend.vendor_name supplier_name, party.party_name third_party_name, (case when vend.vendor_id is null then party.party_type else 'SUPPLIER' end) third_party_type_code, xlatb.trx_currency_code transaction_currency_code, entty.entity_code transaction_entity_code, entty.source_id_int_1 transaction_id, entty.transaction_number transaction_number, (case when entty.entity_code = 'AP_INVOICES' then 'Invoice' when entty.entity_code='AP_PAYMENTS' then 'Payment' else entty.entity_code end)transaction_type, :p_trial_bal_effective_date Trial_Balance_Effective_Date from apg_trial_balance_lvl_base inv, xla_event_classes_tl evcls, xla_tb_definitions_tl tbdfn, hz_parties party, ap_suppliers vend, xla_trial_balances xlatb, xla.xla_transaction_entities entty, hr_operating_units hou, gl_ledgers gl where 3=3 and 2=2 and nvl(entty.security_id_int_1,-9999) = hou.organization_id and hou.set_of_books_id= gl.ledger_id and entty.ledger_id=gl.ledger_id and xlatb.source_entity_id = entty.entity_id and xlatb.applied_to_entity_id is null and entty.ledger_id = xlatb.ledger_id and xlatb.source_application_id = entty.application_id and xlatb.definition_code = tbdfn.definition_code and xlatb.party_id = vend.vendor_id and vend.party_id = party.party_id and entty.application_id = 200 and (inv.gl_date <= :p_trial_bal_effective_date or xlatb.gl_date<=:p_trial_bal_effective_date) and evcls.language = userenv('lang') and evcls.entity_code = entty.entity_code and evcls.application_id = entty.application_id and evcls.event_class_code = xlatb.event_class_code and tbdfn.language = userenv('lang') and inv.applied_to_entity_id (+) = entty.entity_id group by (case when entty.entity_code = 'AP_INVOICES' then 'Invoice' when entty.entity_code='AP_PAYMENTS' then 'Payment' else entty.entity_code end), entty.entity_code, entty.source_id_int_1, entty.transaction_number, evcls.name, :p_trial_bal_effective_date, nvl(entty.security_id_int_1,-9999), party.party_name, tbdfn.name, vend.vendor_name, xlatb.code_combination_id, xlatb.definition_code, xlatb.ledger_id, xlatb.party_id, (case when vend.vendor_id is null then party.party_type else 'SUPPLIER' end), xlatb.record_type_code, xlatb.source_entity_id, xlatb.trx_currency_code ), apg_trial_balance_details as ( select tbase.accounting_event_class_name, tbase.code_combination_id, ltb.rounded_applied_amount applied_amount, ltb.rounded_applied_amount_base applied_amount_base, ltb.applied_to_entity_code, ltb.applied_to_transaction_num, ltb.applied_to_transaction_type, gl.currency_code currency_code_base, gl.name ledger_name, hou.name operating_unit_name, tbase.original_amount, tbase.original_amount_base, tbase.record_type_code, ( case when ltb.trial_balance_effective_date < tbase.gl_date then - 1 * ltb.rounded_applied_amount else nvl(tbase.original_amount, 0) - nvl(ltb.rounded_applied_amount, 0) end ) remaining_amount, ( case when ltb.trial_balance_effective_date < tbase.gl_date then - 1 * ltb.rounded_applied_amount_base else nvl(tbase.original_amount_base, 0) - nvl(ltb.rounded_applied_amount_base, 0) end ) remaining_amount_base, tbase.report_definition_name, tbase.supplier_name supplier_name, tbase.third_party_name third_party_name, tbase.third_party_type_code third_party_type_code, tbase.transaction_currency_code transaction_currency_code, (select inv.invoice_date from ap_invoices_all inv where inv.invoice_id = tbase.transaction_id)transaction_date, tbase.transaction_entity_code, tbase.gl_date transaction_gl_date, tbase.transaction_number, tbase.transaction_type, tbase.trial_balance_effective_date, round((to_date(tbase.trial_balance_effective_date)-tbase.gl_date),0)age_days from apg_trial_balance_lvl2_base ltb, apg_trial_balance_lvl1_base tbase, hr_operating_units hou, gl_ledgers gl where 2=2 and tbase.org_id = hou.organization_id and hou.set_of_books_id= gl.ledger_id and ltb.applied_to_entity_id (+) = tbase.source_entity_id and ltb.code_combination_id (+) = tbase.code_combination_id and tbase.trial_balance_effective_date = ltb.trial_balance_effective_date (+) and ltb.report_definition_code (+) = tbase.report_definition_code ) select x.ledger_name, &chart_of_accounts_name x.operating_unit_name, x.accounting_event_class_name, &segment_columns x.applied_amount, x.applied_amount_base, x.applied_to_entity_code, x.applied_to_transaction_num, x.applied_to_transaction_type, x.currency_code_base, x.original_amount, x.original_amount_base, x.record_type_code, x.remaining_amount, x.remaining_amount_base, x.report_definition_name, x.supplier_name, x.third_party_name, x.third_party_type_code, x.transaction_currency_code, x.transaction_date, x.transaction_entity_code, '' pmt, x.transaction_gl_date, x.transaction_number document_no, x.transaction_type, x.trial_balance_effective_date, case when x.age_days>120 then '120 + days' when x.age_days>91 and x.age_days<=120 then '90 -120 days' when x.age_days>61 and x.age_days<=90 then '60 - 90 days' when x.age_days>31 and x.age_days<=60 then '30 - 60 days' else 'Current' end ageing, x.age_days "Age(Days)" from apg_trial_balance_details x, gl_code_combinations_kfv gcck where 1=1 and gcck.code_combination_id=x.code_combination_id Y US AI AP Trial Balance Adcock Ingram AP Trial Balance Report Adcock Ingram &chart_of_accounts_name &segment_columns 1=1 2=2 3=3 :p_trial_bal_effective_date 1 -20 2=2 gl.name=:ledger 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) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_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(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger 2 -10 2=2 gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts) LOV GL Chart of Accounts 8E2FF36EDEE379D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where 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 fifsv.id_flex_structure_name select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where 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(+))) and rownum=1 US Chart of Accounts 3 &chart_of_accounts_name :chart_of_accounts chart_of_accounts_name, US Chart of Accounts 4 10 :p_trial_bal_effective_date Date sysdate Y US Trial Balance Effective Date 5 1=1 x.transaction_date<=:p_trial_bal_effective_date US Trial Balance Effective Date 6 20 1=1 gcck.segment1=:p_segment1 LOV GL Segment1 8E2FF36EDECC79D2E0530100007F1FF2 Y select ffvv.flex_value value, 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 description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.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') 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 ffvv.flex_value Y US GL Company Segment 7 30 1=1 1=1 LOV custom Y select xxen_util.segment_description(:$flex$.gl_company_segment,'SEGMENT1',(select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:$flex$.chart_of_accounts)) value, '' description from dual xxen_util.segment_description(:$flex$.gl_company_segment,'SEGMENT1',(select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:$flex$.chart_of_accounts)) US GL Company Segment Description 8 40 1=1 gcck.segment4=:p_segment4 LOV GL Segment4 8E2FF36EDECF79D2E0530100007F1FF2 Y select ffvv.flex_value value, 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 description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.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') 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 ffvv.flex_value Y US GL Natural Account 9 50 1=1 x.report_definition_name not like '%'||:p_pattern||'%' Char Total US Definition (does not contain) Report Definition Name (does not contain) 10 60 1=1 x.remaining_amount<>0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Amount Not Equals Zero Remaining Amount Not Equals Zero 11 70 &segment_columns with x as ( select fifsv.application_column_name, fifsv.form_left_prompt 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=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num ) select 'gcck.concatenated_segments,' text from x union select 'gcck.code_combination_id,' text from x union select ''''||:chart_of_accounts||''''||' flexfield,' text from x union select ''''||listagg(x.form_left_prompt,'-') within group (order by x.application_column_name)||''''||' segment_name_list,' text from x union select 'gcck.'||lower(x.application_column_name)||' "'||substrb(x.form_left_prompt,1,xxen_report.max_column_length-9)||'",' text from x LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N US Show All Accounts 12 &segment_columns with x as ( select fifsv.application_column_name, fifsv.form_left_prompt from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.application_column_name='SEGMENT1' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num ) select ''''||:chart_of_accounts||''''||' flexfield,' text from x union select 'gcck.'||lower(x.application_column_name)||' "'||substrb(x.form_left_prompt,1,xxen_report.max_column_length-9)||'",' text from x N US Show All Accounts 13 80 3=3 xlatb.party_id in (select vendor_id from ap_suppliers where vendor_name=:vendor_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 US Supplier Name :$flex$.chart_of_accounts Chart of Accounts GL Company Segment :$flex$.chart_of_accounts Chart of Accounts GL Company Segment Description :$flex$.chart_of_accounts Chart of Accounts GL Natural Account :$flex$.chart_of_accounts Chart of Accounts Ledger :$flex$.gl_company_segment GL Company Segment GL Company Segment Description :$flex$.ledger Ledger GL Company Segment :$flex$.ledger Ledger GL Natural Account