ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code 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 8E2FF36EDED379D2E0530100007F1FF2 GL Account Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ACCOUNT_TYPE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'L',2,'O',3,'R',4,'E',5,'C',6,'D',7) US 8E2FF36EDF3C79D2E0530100007F1FF2 GL Balance Type Y select flvv.description value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 order by flvv.lookup_code US B16C8DB2BC207B92E0530100007F1372 GL Batch Y Y select distinct gjb.name value, gjb.description from gl_je_batches gjb where gjb.je_batch_id in (select gjh.je_batch_id from gl_je_headers gjh where (:$flex$.journal is null or gjh.name=:$flex$.journal) and gjh.ledger_id in (select gl.ledger_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'))) order by gjb.name US E0594F170E1998F5E0530100007F6EA3 GL Budget Name Y select gbv.budget_name value, gbv.budget_type || ' (' || xxen_util.meaning(gbv.status,'PLAN/VERSION STATUS',101) || ')' description from gl_ledgers gl, gl_budgets gb, gl_budget_versions gbv where gl.ledger_id=gb.ledger_id and gb.budget_name=gbv.budget_name and gb.budget_type=gbv.budget_type and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='B' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) ) order by value US E0594F170E1A98F5E0530100007F6EA3 GL Encumbrance Type Y select get.encumbrance_type value, get.description description from gl_encumbrance_types get where :$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='E' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) order by value US B16C8DB2BC217B92E0530100007F1372 GL Journal Y Y select distinct gjh.name value, gjh.description from gl_je_headers gjh where (:$flex$.batch is null or gjh.je_batch_id in (select gjb.je_batch_id from gl_je_batches gjb where xxen_util.contains(:$flex$.batch,gjb.name)='Y')) and gjh.ledger_id in (select gl.ledger_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')) order by gjh.name US 8E2FF36EDF2479D2E0530100007F1FF2 GL Journal Category Y select gjcv.user_je_category_name value, gjcv.description from gl_je_categories_vl gjcv order by gjcv.user_je_category_name US 8E2FF36EDF2379D2E0530100007F1FF2 GL Journal Source Y select gjsv.user_je_source_name value, gjsv.description from gl_je_sources_vl gjsv order by gjsv.user_je_source_name US B16B03AA6AEB5FDDE0530100007FE310 GL Journal Status Y select xxen_util.meaning('P','BATCH_STATUS',101) value, null description from dual union all select xxen_util.meaning('U','BATCH_STATUS',101) value, null description from dual union all select xxen_util.meaning('E','VALIDATION_STATUS',101) value, null description from dual US 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数据访问集 "定义。 8E2FF36EDED479D2E0530100007F1FF2 GL Period (past) Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.start_date<=sysdate+400 and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type 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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null 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 (:$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 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 xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name Added +400 days to show future periods for budgets AR جميع فترات دفتر الأستاذ العام الماضية ، تعتمد على مخطط الحسابات أو دفتر الأستاذ D Alle vergangenen GL-Perioden, abhängig von Kontenplan oder Ledger E Todos los periodos pasados de LG, dependiendo del plan de cuentas o del libro mayor F Toutes les périodes de GL passées, en fonction du plan comptable ou du grand livre I Tutti i periodi GL passati, a seconda del piano dei conti o del libro mastro JA すべての過去のGL期間は、勘定科目表または元帳に依存しています。 KO 계정과 목표 또는 원장에 따라 모든 과거 GL 기간 PTB Todos os períodos anteriores da GL, dependendo do plano de contas ou do livro razão RU Все прошлые периоды GL, в зависимости от плана счетов или бухгалтерской книги. S Alla tidigare GL-perioder, beroende på kontoplan eller storbok TR Hesap planına veya genel muhasebe defterine bağlı olarak geçmiş tüm GL dönemleri US All past GL periods, dependent on chart of accounts or ledger ZHS 过去的所有GL期，取决于会计科目表或分类账。 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 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 B3D07BBAC1A645D7E0530100007FB1B8 GL Segment10 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='SEGMENT10' 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 8E2FF36EDECD79D2E0530100007F1FF2 GL Segment2 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='SEGMENT2' 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 8E2FF36EDECE79D2E0530100007F1FF2 GL Segment3 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='SEGMENT3' 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 8E2FF36EDED079D2E0530100007F1FF2 GL Segment5 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='SEGMENT5' 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 8E2FF36EDED179D2E0530100007F1FF2 GL Segment6 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='SEGMENT6' 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 8E2FF36EDED279D2E0530100007F1FF2 GL Segment7 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='SEGMENT7' 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 B3D07BBAC1A245D7E0530100007FB1B8 GL Segment8 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='SEGMENT8' 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 B3D07BBAC1A545D7E0530100007FB1B8 GL Segment9 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='SEGMENT9' 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 AD2DFDB90C593F98E0530100007FF093 select x.*, case when x.entity_code='TRANSACTIONS' and rcta.interface_header_context in ('ORDER ENTRY','INTERCOMPANY') then rcta.interface_header_attribute1 end sales_order, (select name from ra_rules rr where rcta.invoicing_rule_id=rule_id) invoice_rule, (select rr.name from ra_customer_trx_lines_all rctla, ra_rules rr where rcta.customer_trx_id=rctla.customer_trx_id and rctla.line_type='LINE' and rctla.accounting_rule_id=rr.rule_id and rownum=1) accounting_rule, coalesce(x.project_,nvl(x.project_,case when x.entity_code='TRANSACTIONS' and rcta.interface_header_context='PROJECTS INVOICES' then rcta.interface_header_attribute1 end)) project_, coalesce(x.vendor_or_customer,(select hp.party_name from hz_cust_accounts hca, hz_parties hp where coalesce(rcta.bill_to_customer_id,x.acra_pay_from_customer,x.paa_customer_id)=hca.cust_account_id and hca.party_id=hp.party_id)) vendor_or_customer_ from ( select case when count(distinct gp.period_num) over ()>1 then lpad(gp.period_num,2,'0')||' ' end||gjh.period_name period_name, gl.name ledger, (select gjsv.user_je_source_name from gl_je_sources_vl gjsv where gjh.je_source=gjsv.je_source_name) source_name, (select gjcv.user_je_category_name from gl_je_categories_vl gjcv where gjh.je_category=gjcv.je_category_name) category_name, gjb.name batch_name, xxen_util.meaning(gjb.status,'MJE_BATCH_STATUS',101) batch_status, gjh.posted_date, gjh.name journal_name, gjh.description journal_description, gjh.doc_sequence_value document_number, xxen_util.meaning(gjh.tax_status_code,'TAX_STATUS',101) tax_status_code, gjl.je_line_num line_number, gcck.concatenated_segments, gjl.description line_description, xxen_util.meaning(xal.accounting_class_code,'XLA_ACCOUNTING_CLASS',602) accounting_class_code, xxen_util.meaning(gcck.gl_account_type,'ACCOUNT_TYPE',0) account_type, &hierarchy_levels3 &segment_columns nvl2(xal.gl_sl_link_id,xal.entered_dr,gjl.entered_dr) entered_dr, nvl2(xal.gl_sl_link_id,xal.entered_cr,gjl.entered_cr) entered_cr, nvl(nvl2(xal.gl_sl_link_id,xal.entered_dr,gjl.entered_dr),0)-nvl(nvl2(xal.gl_sl_link_id,xal.entered_cr,gjl.entered_cr),0) entered_amount, nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code) transaction_currency, nvl2(xal.gl_sl_link_id,xal.accounted_dr,gjl.accounted_dr) accounted_dr, nvl2(xal.gl_sl_link_id,xal.accounted_cr,gjl.accounted_cr) accounted_cr, nvl(nvl2(xal.gl_sl_link_id,xal.accounted_dr,gjl.accounted_dr),0)-nvl(nvl2(xal.gl_sl_link_id,xal.accounted_cr,gjl.accounted_cr),0) accounted_amount, gl.currency_code ledger_currency, nvl(gjh.doc_sequence_value,xah.doc_sequence_value) doc_sequence_value, (select xett.name from xla_event_types_tl xett where xte.application_id=xett.application_id and xte.entity_code=xett.entity_code and xe.event_type_code=xett.event_type_code and xett.language=userenv('lang')) event_type, xal.currency_conversion_date, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where xal.currency_conversion_type=gdct.conversion_type) currency_conversion_type, xal.currency_conversion_rate, xxen_util.description(gjh.actual_flag,'BATCH_TYPE',101) balance_type, (select gbv.budget_name from gl_budget_versions gbv where gjh.budget_version_id=gbv.budget_version_id) budget_name, (select get.encumbrance_type from gl_encumbrance_types get where get.encumbrance_type_id = gjh.encumbrance_type_id) encumbrance_type, gjh.currency_conversion_date conversion_date, gjh.currency_conversion_type conversion_type, gjh.currency_conversion_rate conversion_rate, xe.transaction_date, xte.transaction_number, -- Assets case when xte.application_id = 140 and xte.entity_code = 'TRANSACTIONS' then (select fab.asset_number from fa_additions_b fab,fa_transaction_headers fth where fth.asset_id=fab.asset_id and fth.transaction_header_id=xte.source_id_int_1 and fth.event_id = xe.event_id) when xte.application_id = 140 and xte.entity_code = 'DEPRECIATION' then (select fab.asset_number from fa_additions_b fab, fa_deprn_detail fdd where fab.asset_id=fdd.asset_id and fdd.asset_id=xte.source_id_int_1 and fdd.period_counter=xte.source_id_int_2 and fdd.event_id=xe.event_id and rownum=1) end asset_number, --subledger columns aia.description description, (select pha.segment1 from po_headers_all pha where nvl(aia.quick_po_header_id,rt.po_header_id)=pha.po_header_id) purchase_order, --AR rt.quantity po_quantity, coalesce( (select aps.vendor_name from ap_suppliers aps where coalesce(decode(xal.party_type_code,'S',xal.party_id,null),aia.vendor_id,aca.vendor_id,rt.vendor_id)=aps.vendor_id), (select hp.party_name from hz_cust_accounts hca, hz_parties hp where decode(xal.party_type_code,'C',xal.party_id,null)=hca.cust_account_id and hca.party_id=hp.party_id) ) vendor_or_customer, -- AP/AR MDM Party/Site Identifier case when xal.party_type_code is not null then xal.party_type_code || '-' || nvl(to_char(xal.party_id),'UNKNOWN') || '-' || nvl(to_char(xal.party_site_id),'0') else null end mdm_party_id, case xal.party_type_code when 'C' then xal.party_type_code || '-' || nvl((select hp.party_name from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hca.cust_account_id=xal.party_id),'UNKNOWN') || '-' || nvl((select hcsua.location from hz_cust_site_uses_all hcsua where hcsua.site_use_id = xal.party_site_id),'0') when 'S' then xal.party_type_code || '-' || nvl((select aps.vendor_name from ap_suppliers aps where aps.vendor_id=xal.party_id),'UNKNOWN') || '-' || nvl((select apssa.vendor_site_code from ap_supplier_sites_all apssa where apssa.vendor_site_id = xal.party_site_id),'0') else null end mdm_party_desc, --Projects coalesce( (select ppa.segment1 from pa_projects_all ppa where aida.project_id=ppa.project_id), (select ppa.segment1 from pa_projects_all ppa where case when xte.application_id=275 then decode(xte.entity_code,'REVENUE',xte.source_id_int_1,'EXPENDITURES',peia.project_id) end=ppa.project_id) ) project_, (select pt.task_number from pa_tasks pt where nvl(aida.task_id,peia.task_id)=pt.task_id) task, pea.expenditure_group, xxen_util.meaning(pea.expenditure_class_code,'EXPENDITURE CLASS CODE',275) expenditure_class_code, xxen_util.meaning(pea.expenditure_status_code,'EXPENDITURE STATUS',275) expenditure_status_code, pet.expenditure_category, peia.expenditure_type, pet.description expenditure_type_description, peia.expenditure_item_date, peia.quantity expenditure_item_quantity, xxen_util.meaning(pet.unit_of_measure,'UNIT',275) expenditure_unit_of_measure, papf.full_name incurred_by_person, nvl(papf.employee_number,papf.npw_number) incurred_by_employee_number, xxen_util.user_name(gjh.created_by) journal_created_by, gjh.creation_date journal_creation_date, gjb.je_batch_id, gjl.je_header_id, gjl.je_line_num, gjl.context dff_context, xal.application_id, xal.ae_header_id, xal.ae_line_num, xah.event_id, xe.event_date, xte.entity_code, &segments_with_desc xte.source_id_int_1, case when xte.application_id=222 then case when xte.entity_code in ('TRANSACTIONS','BILLS_RECEIVABLE') then xte.source_id_int_1 when xte.entity_code='ADJUSTMENTS' then aaa.customer_trx_id end end customer_trx_id, paa.customer_id paa_customer_id, acra.pay_from_customer acra_pay_from_customer, xxen_fsg.view_transaction_(fnd_global.resp_appl_id,gl.ledger_id,fnd_global.resp_id,fnd_global.security_group_id,gjsv.user_je_source_name,xah.event_id) view_transaction from gl_ledgers gl, gl_periods gp, gl_je_batches gjb, gl_je_headers gjh, gl_je_lines gjl, gl_je_sources_vl gjsv, (select gir.je_header_id, gir.je_line_num, xal.* from gl_import_references gir, xla_ae_lines xal where gir.gl_sl_link_id=xal.gl_sl_link_id and gir.gl_sl_link_table=xal.gl_sl_link_table ) xal, xla_ae_headers xah, xla_events xe, xla.xla_transaction_entities xte, ( select &hierarchy_levels2 gcck.* from ( select ( select fifs.flex_value_set_id from fnd_id_flex_segments fifs, fnd_flex_values ffv where gcck.chart_of_accounts_id=fifs.id_flex_num and fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.application_column_name='&hierarchy_segment_column' and fifs.flex_value_set_id=ffv.flex_value_set_id and ffv.parent_flex_value_low is null and ffv.summary_flag='N' and 5=5 ) flex_value_set_id, gcck.* from gl_code_combinations_kfv gcck ) gcck, ( select &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=: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=:parent_flex_value ) x ) h where 2=2 and gcck.flex_value_set_id=h.flex_value_set_id(+) ) gcck, ap_invoices_all aia, (select distinct aida.invoice_id, min(aida.project_id) keep (dense_rank first order by aida.invoice_distribution_id) over (partition by aida.invoice_id) project_id, min(aida.task_id) keep (dense_rank first order by aida.invoice_distribution_id) over (partition by aida.invoice_id) task_id from ap_invoice_distributions_all aida where aida.task_id is not null) aida, ap_checks_all aca, ar_adjustments_all aaa, ar_cash_receipts_all acra, pa_draft_revenues_all pdra, pa_agreements_all paa, pa_expenditure_items_all peia, pa_expenditures_all pea, pa_expenditure_types pet, (select papf.* from per_all_people_f papf where sysdate>=papf.effective_start_date and sysdate<papf.effective_end_date+1) papf, rcv_transactions rt where 1=1 and gl.period_set_name=gp.period_set_name and gp.period_name=gjh.period_name and gp.period_name=gjl.period_name and gl.ledger_id=gjh.ledger_id and gjb.je_batch_id=gjh.je_batch_id and gjh.je_header_id=gjl.je_header_id and gjh.je_source=gjsv.je_source_name and gjl.je_header_id=xal.je_header_id(+) and gjl.je_line_num=xal.je_line_num(+) and xal.ae_header_id=xah.ae_header_id(+) and xal.application_id=xah.application_id(+) and xah.gl_transfer_status_code(+)='Y' and xah.accounting_entry_status_code(+)='F' and xah.event_id=xe.event_id(+) and xah.application_id=xe.application_id(+) and xah.entity_id=xte.entity_id(+) and xah.application_id=xte.application_id(+) and gl_security_pkg.validate_access(null,gjl.code_combination_id)='TRUE' and gjl.code_combination_id=gcck.code_combination_id and case when xte.application_id=200 and xte.entity_code='AP_INVOICES' then xte.source_id_int_1 end=aia.invoice_id(+) and aia.invoice_id=aida.invoice_id(+) and case when xte.application_id=200 and xte.entity_code='AP_PAYMENTS' then xte.source_id_int_1 end=aca.check_id(+) and case when xte.application_id=222 and xte.entity_code='ADJUSTMENTS' then xte.source_id_int_1 end=aaa.adjustment_id(+) and case when xte.application_id=222 and xte.entity_code='RECEIPTS' then xte.source_id_int_1 end=acra.cash_receipt_id(+) and case when xte.application_id=275 and xte.entity_code='REVENUE' then xte.source_id_int_1 end=pdra.project_id(+) and case when xte.application_id=275 and xte.entity_code='REVENUE' then xte.source_id_int_2 end=pdra.draft_revenue_num(+) and pdra.agreement_id=paa.agreement_id(+) and case when xte.application_id=275 and xte.entity_code='EXPENDITURES' then xte.source_id_int_1 end=peia.expenditure_item_id(+) and peia.expenditure_id=pea.expenditure_id(+) and peia.expenditure_type=pet.expenditure_type(+) and pea.incurred_by_person_id=papf.person_id(+) and case when xte.application_id=707 and xte.entity_code='RCV_ACCOUNTING_EVENTS' then xte.source_id_int_1 end=rt.transaction_id(+) ) x, ra_customer_trx_all rcta where x.customer_trx_id=rcta.customer_trx_id(+) Y #,##0.00;[Red]-#,##0.00 8239B077F696605AE053B46B63587AFE :Period is not null or :Period_From is not null or :Posted_Date_From is not null or :Journal is not null or :Batch is not null AR GL Account Analysis 11g إصدار متوافق مع الإصدارات السابقة (لقواعد بيانات 11 جرام) لتقرير معاملات GL التفصيلي مع سطر واحد لكل معاملة بما في ذلك جميع الشرائح وبيانات دفتر الأستاذ الفرعي ، مع المبالغ بعملة المعاملة وعملة دفتر الأستاذ. D GL Account Analysis 11g Abwärtskompatible Version (für 11g-Datenbanken) des detaillierten GL-Transaktionsberichts mit einer Zeile pro Transaktion einschließlich aller Segmente und Nebenbuchdaten, mit Beträgen in Transaktions- und Ledgerwährung. E GL Account Analysis 11g Versión compatible con versiones anteriores (para bases de datos 11g) del informe detallado de las transacciones del libro mayor con una línea por transacción que incluye todos los segmentos y datos del libro auxiliar, con importes tanto en la moneda de la transacción como en la moneda del libro mayor. F GL Account Analysis 11g Version rétrocompatible (pour les bases de données 11g) du rapport détaillé des transactions de GL avec une ligne par transaction comprenant tous les segments et les données du livre auxiliaire, avec les montants dans la devise de la transaction et dans la devise du livre. I GL Account Analysis 11g Versione compatibile all'indietro (per i database 11g) del rapporto dettagliato sulle transazioni GL con una riga per transazione che include tutti i segmenti e i dati subledger, con importi sia nella valuta della transazione che nella valuta del libro mastro. JA GL Account Analysis 11g GLトランザクション詳細レポートの下位互換バージョン(11gデータベース用)では、すべてのセグメントとサブレッジャーデータを含むトランザクションごとに1行、トランザクション通貨と元帳通貨の両方で金額が表示されます。 KO GL Account Analysis 11g 모든 세그먼트 및 보조 원장 데이터를 포함하여 거래 당 하나의 라인이있는 세부 GL 거래 보고서의 하위 호환 버전 (11g 데이터베이스 용), 거래 통화 및 원장 통화 금액 모두 포함. PTB GL Account Analysis 11g Versão retrocompatível (para bancos de dados 11g) do relatório detalhado de transações GL com uma linha por transação incluindo todos os segmentos e dados do subledger, com valores tanto na moeda da transação como na moeda do ledger. RU GL Account Analysis 11g Обратно совместимая версия (для 11g баз данных) подробного отчета по транзакциям GL с одной строкой на каждую транзакцию, включая все сегменты и данные подкатегории, с суммами как в валюте транзакции, так и в валюте бухгалтерской книги. S GL Account Analysis 11g Bakåtkompatibel version (för 11g-databaser) av detalj-GL-transaktionsrapporten med en rad per transaktion inklusive alla segment och underdelsdata, med belopp i både transaktionsvaluta och storleksvaluta. TR GL Account Analysis 11g Ayrıntılı GL işlem raporunun geriye dönük uyumlu versiyonu (11g veritabanları için), hem işlem para birimi hem de genel muhasebe para birimi cinsinden tutarlarla, tüm segmentler ve yardımcı defter verilerini içeren işlem başına bir satır. US GL Account Analysis 11g Backwards compatible version (for 11g databases) of the detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. Please enter a period, posted date, batch or journal restriction ZHS GL Account Analysis 11g 向后兼容版本（适用于11g数据库）的详细GL交易报告，每笔交易只有一行，包括所有分部和子分类账数据，金额以交易货币和分类账货币表示。 Enginatics &hierarchy_levels &hierarchy_levels2 &hierarchy_levels3 &hierarchy_segment_column &segment_columns &segments_with_desc 1=1 2=2 5=5 :flex_value_set_id :parent_flex_value 1 -30 :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 where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or 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.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') ) F Id de l'ensemble de valeurs Flex US 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 where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or 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.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') ) F Colonne de segment de hiérarchie US Hierarchy Segment Column 3 &hierarchy_segment_column <parameter_value> F Colonne de segment de hiérarchie US Hierarchy Segment Column 4 2=2 gcck.<parameter_value> between nvl(h.child_flex_value_low(+),gcck.<parameter_value>) and nvl(h.child_flex_value_high(+),gcck.<parameter_value>) F Colonne de segment de hiérarchie US Hierarchy Segment Column 5 5=5 gcck.<parameter_value>=ffv.flex_value US Hierarchy Segment Column 6 -10 1=1 :max_hierarchy_levels=:max_hierarchy_levels Number select max(level)+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 where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or 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.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') ) )) 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$.fnd_flex_hierarchy F Niveaux hiérarchiques maximums US Max Hierarchy Levels 7 10 1=1 gl.name=:ledger 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) Y F Grand livre US Ledger 8 &segment_columns select distinct 'gcck.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcck.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck.chart_of_accounts_id'|| ( select ', gcck.'||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) )||')'||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' 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.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') order by min_id_flex_num, min_segment_num F Grand livre US Ledger 9 20 1=1 gp.period_name=:period_name LOV GL Period (past) 8E2FF36EDED479D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.start_date<=sysdate+400 and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type 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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null 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 (:$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 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 xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name select distinct max(gp.period_name) keep (dense_rank last order by gp.start_date,gp.period_year,gp.period_num) over () period_name from gl.gl_periods gp where gp.start_date<=sysdate and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.chart_of_accounts is null or 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 xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) F Période US Period 10 30 1=1 gp.period_year*10000+gp.period_num>=(select gp0.period_year*10000+gp0.period_num effective_period_num from gl_periods gp0 where gl.period_set_name=gp0.period_set_name and gp0.period_name=:period_name_from) LOV GL Period (past) 8E2FF36EDED479D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.start_date<=sysdate+400 and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type 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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null 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 (:$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 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 xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name F Période du US Period From 11 40 1=1 gp.period_year*10000+gp.period_num<=(select gp0.period_year*10000+gp0.period_num effective_period_num from gl_periods gp0 where gl.period_set_name=gp0.period_set_name and gp0.period_name=:period_name_to) LOV GL Period (past) 8E2FF36EDED479D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.start_date<=sysdate+400 and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type 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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null 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 (:$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 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 xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name :$flex$.period_from F Période à US Period To 12 50 1=1 gjh.posted_date>=:posted_date_from Date F Date d'entrée en vigueur US Posted Date From 13 60 1=1 gjh.posted_date<:posted_date_to+1 Date F Date de publication au US Posted Date To 14 70 1=1 gjh.je_source in (select gjsv.je_source_name from gl_je_sources_vl gjsv where gjsv.user_je_source_name=:user_je_source_name) LOV GL Journal Source 8E2FF36EDF2379D2E0530100007F1FF2 Y select gjsv.user_je_source_name value, gjsv.description from gl_je_sources_vl gjsv order by gjsv.user_je_source_name F Source du journal US Journal Source 15 80 1=1 gjh.je_category in (select gjcv.je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=:journal_category) LOV GL Journal Category 8E2FF36EDF2479D2E0530100007F1FF2 Y select gjcv.user_je_category_name value, gjcv.description from gl_je_categories_vl gjcv order by gjcv.user_je_category_name F Catégorie de journal US Journal Category 16 90 1=1 gjb.name=:batch LOV GL Batch B16C8DB2BC207B92E0530100007F1372 Y Y select distinct gjb.name value, gjb.description from gl_je_batches gjb where gjb.je_batch_id in (select gjh.je_batch_id from gl_je_headers gjh where (:$flex$.journal is null or gjh.name=:$flex$.journal) and gjh.ledger_id in (select gl.ledger_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'))) order by gjb.name F Lot US Batch 17 100 1=1 gjh.name=:journal LOV GL Journal B16C8DB2BC217B92E0530100007F1372 Y Y select distinct gjh.name value, gjh.description from gl_je_headers gjh where (:$flex$.batch is null or gjh.je_batch_id in (select gjb.je_batch_id from gl_je_batches gjb where xxen_util.contains(:$flex$.batch,gjb.name)='Y')) and gjh.ledger_id in (select gl.ledger_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')) order by gjh.name US Journal 18 110 1=1 gjl.je_line_num=:journal_line Number US Journal Line 19 120 1=1 gcck.gl_account_type=xxen_util.lookup_code(:account_type,'ACCOUNT_TYPE',0) LOV GL Account Type 8E2FF36EDED379D2E0530100007F1FF2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ACCOUNT_TYPE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'L',2,'O',3,'R',4,'E',5,'C',6,'D',7) F Type de compte US Account Type 20 130 &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 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 where (gl.ledger_category_code=:$flex$.ledger_category or xxen_util.contains(:$flex$.ledger,gl.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 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 F Segment de la hiérarchie US Hierarchy Segment 21 &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 F Segment de la hiérarchie US Hierarchy Segment 22 &hierarchy_levels3 select 'gcck.level'||x.column_value||'||nvl2(gcck.level'||x.column_value||','' - ''||xxen_util.segment_description(gcck.level'||x.column_value||','''||:hierarchy_segment_column||''',gcck.chart_of_accounts_id),null) hierarchy_level'||x.column_value||',' text from table(xxen_util.rowgen(:max_hierarchy_levels)) x F Segment de la hiérarchie US Hierarchy Segment 23 140 :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 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.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or xxen_util.contains(:$flex$.ledger,gl.name)='Y') ) ) x F Nom de la hiérarchie US Hierarchy Name 24 150 1=1 gcck.concatenated_segments=:concatenated_segments Char F Segments concaténés US Concatenated Segments 25 160 1=1 gcck.segment1=: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 US GL_SEGMENT1 26 170 1=1 gcck.segment1>=:segment1_from 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 US GL_SEGMENT1 From 27 180 1=1 gcck.segment1<=:segment1_to 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 :$flex$.gl_segment1_from US GL_SEGMENT1 To 28 190 1=1 gcck.segment2=:segment2 LOV GL Segment2 8E2FF36EDECD79D2E0530100007F1FF2 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='SEGMENT2' 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 US GL_SEGMENT2 29 200 1=1 gcck.segment2>=:segment2_from LOV GL Segment2 8E2FF36EDECD79D2E0530100007F1FF2 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='SEGMENT2' 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 US GL_SEGMENT2 From 30 210 1=1 gcck.segment2<=:segment2_to LOV GL Segment2 8E2FF36EDECD79D2E0530100007F1FF2 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='SEGMENT2' 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 :$flex$.gl_segment2_from US GL_SEGMENT2 To 31 220 1=1 gcck.segment3=:segment3 LOV GL Segment3 8E2FF36EDECE79D2E0530100007F1FF2 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='SEGMENT3' 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 US GL_SEGMENT3 32 230 1=1 gcck.segment3>=:segment3_from LOV GL Segment3 8E2FF36EDECE79D2E0530100007F1FF2 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='SEGMENT3' 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 US GL_SEGMENT3 From 33 240 1=1 gcck.segment3<=:segment3_to LOV GL Segment3 8E2FF36EDECE79D2E0530100007F1FF2 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='SEGMENT3' 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 :$flex$.gl_segment3_from US GL_SEGMENT3 To 34 250 1=1 gcck.segment4=: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 US GL_SEGMENT4 35 260 1=1 gcck.segment4>=:segment4_from 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 US GL_SEGMENT4 From 36 270 1=1 gcck.segment4<=:segment4_to 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 :$flex$.gl_segment4_from US GL_SEGMENT4 To 37 280 1=1 gcck.segment5=:segment5 LOV GL Segment5 8E2FF36EDED079D2E0530100007F1FF2 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='SEGMENT5' 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 US GL_SEGMENT5 38 290 1=1 gcck.segment5>=:segment5_from LOV GL Segment5 8E2FF36EDED079D2E0530100007F1FF2 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='SEGMENT5' 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 US GL_SEGMENT5 From 39 300 1=1 gcck.segment5<=:segment5_to LOV GL Segment5 8E2FF36EDED079D2E0530100007F1FF2 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='SEGMENT5' 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 :$flex$.gl_segment5_from US GL_SEGMENT5 To 40 310 1=1 gcck.segment6=:segment6 LOV GL Segment6 8E2FF36EDED179D2E0530100007F1FF2 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='SEGMENT6' 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 US GL_SEGMENT6 41 320 1=1 gcck.segment6>=:segment6_from LOV GL Segment6 8E2FF36EDED179D2E0530100007F1FF2 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='SEGMENT6' 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 US GL_SEGMENT6 From 42 330 1=1 gcck.segment6<=:segment6_to LOV GL Segment6 8E2FF36EDED179D2E0530100007F1FF2 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='SEGMENT6' 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 :$flex$.gl_segment6_from US GL_SEGMENT6 To 43 340 1=1 gcck.segment7=:segment7 LOV GL Segment7 8E2FF36EDED279D2E0530100007F1FF2 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='SEGMENT7' 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 US GL_SEGMENT7 44 350 1=1 gcck.segment7>=:segment7_from LOV GL Segment7 8E2FF36EDED279D2E0530100007F1FF2 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='SEGMENT7' 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 US GL_SEGMENT7 From 45 360 1=1 gcck.segment7<=:segment7_to LOV GL Segment7 8E2FF36EDED279D2E0530100007F1FF2 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='SEGMENT7' 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 :$flex$.gl_segment7_from US GL_SEGMENT7 To 46 370 1=1 gcck.segment8=:segment8 LOV GL Segment8 B3D07BBAC1A245D7E0530100007FB1B8 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='SEGMENT8' 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 US GL_SEGMENT8 47 380 1=1 gcck.segment8>=:segment8_from LOV GL Segment8 B3D07BBAC1A245D7E0530100007FB1B8 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='SEGMENT8' 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 US GL_SEGMENT8 From 48 390 1=1 gcck.segment8<=:segment8_to LOV GL Segment8 B3D07BBAC1A245D7E0530100007FB1B8 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='SEGMENT8' 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 :$flex$.gl_segment8_from US GL_SEGMENT8 To 49 400 1=1 gcck.segment9=:segment9 LOV GL Segment9 B3D07BBAC1A545D7E0530100007FB1B8 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='SEGMENT9' 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 US GL_SEGMENT9 50 410 1=1 gcck.segment9>=:segment9_from LOV GL Segment9 B3D07BBAC1A545D7E0530100007FB1B8 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='SEGMENT9' 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 US GL_SEGMENT9 From 51 420 1=1 gcck.segment9<=:segment9_to LOV GL Segment9 B3D07BBAC1A545D7E0530100007FB1B8 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='SEGMENT9' 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 :$flex$.gl_segment9_from US GL_SEGMENT9 To 52 430 1=1 gcck.segment10=:segment10 LOV GL Segment10 B3D07BBAC1A645D7E0530100007FB1B8 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='SEGMENT10' 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 US GL_SEGMENT10 53 440 1=1 gcck.segment10>=:segment10_from LOV GL Segment10 B3D07BBAC1A645D7E0530100007FB1B8 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='SEGMENT10' 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 US GL_SEGMENT10 From 54 450 1=1 gcck.segment10<=:segment10_to LOV GL Segment10 B3D07BBAC1A645D7E0530100007FB1B8 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='SEGMENT10' 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 :$flex$.gl_segment10_from US GL_SEGMENT10 To 55 460 1=1 gjh.status=xxen_util.lookup_code(:status,'BATCH_STATUS',101) LOV GL Journal Status B16B03AA6AEB5FDDE0530100007FE310 Y select xxen_util.meaning('P','BATCH_STATUS',101) value, null description from dual union all select xxen_util.meaning('U','BATCH_STATUS',101) value, null description from dual union all select xxen_util.meaning('E','VALIDATION_STATUS',101) value, null description from dual xxen_util.meaning('P','BATCH_STATUS',101) F Statut US Status 56 1=1 gjh.status not in ('P','U') Error F Statut US Status 57 470 1=1 nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code)=:transaction_currency LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US Transaction Currency 58 480 :revaluation_currency LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code F Monnaie de réévaluation US Revaluation Currency 59 &revaluation_columns nvl2(xal.gl_sl_link_id,xal.entered_dr,gjl.entered_dr)*decode(nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code),:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_dr, nvl2(xal.gl_sl_link_id,xal.entered_cr,gjl.entered_cr)*decode(nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code),:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_cr, (nvl(nvl2(xal.gl_sl_link_id,xal.entered_dr,gjl.entered_dr),0)-nvl(nvl2(xal.gl_sl_link_id,xal.entered_cr,gjl.entered_cr),0))*decode(nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code),:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_amount, :revaluation_currency <parameter_value>_currency, F Monnaie de réévaluation US Revaluation Currency 60 490 :revaluation_conversion_type LOV custom Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct where :$flex$.revaluation_currency is not null order by gdct.user_conversion_type Corporate F Réévaluation Conversion Type US Revaluation Conversion Type 61 500 1=1 gjh.actual_flag in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.description=:balance_type and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0) LOV GL Balance Type 8E2FF36EDF3C79D2E0530100007F1FF2 Y select flvv.description value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 order by flvv.lookup_code select flv.description from fnd_lookup_values flv where flv.lookup_type='BATCH_TYPE' and flv.view_application_id=101 and flv.language(+)=userenv('lang') and flv.security_group_id=0 and flv.lookup_code = 'A' F Type d'équilibre US Balance Type 62 510 1=1 (gjh.actual_flag<>'B' or gjh.budget_version_id in (select gbv.budget_version_id from gl_budget_versions gbv where gbv.budget_name = :budget_name)) LOV GL Budget Name E0594F170E1998F5E0530100007F6EA3 Y select gbv.budget_name value, gbv.budget_type || ' (' || xxen_util.meaning(gbv.status,'PLAN/VERSION STATUS',101) || ')' description from gl_ledgers gl, gl_budgets gb, gl_budget_versions gbv where gl.ledger_id=gb.ledger_id and gb.budget_name=gbv.budget_name and gb.budget_type=gbv.budget_type and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='B' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) ) order by value F Nom du budget US Budget Name 63 520 1=1 (gjh.actual_flag<>'E' or gjh.encumbrance_type_id in (select get.encumbrance_type_id from gl_encumbrance_types get where get.encumbrance_type = :encumbrance_type)) LOV GL Encumbrance Type E0594F170E1A98F5E0530100007F6EA3 Y select get.encumbrance_type value, get.description description from gl_encumbrance_types get where :$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='E' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) order by value F Type d'engagement US Encumbrance Type 64 530 &segments_with_desc select 'gcck.'||lower(fifsv.application_column_name)||'||'' - '''||'||xxen_util.segment_description(gcck.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck.chart_of_accounts_id'|| ( select ', gcck.'||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) )||')'||' "'||substrb(xxen_util.init_cap(fifsv.form_left_prompt),1,xxen_report.max_column_length-10)||' with desc",' text from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=(select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y' and rownum=1) order by fifsv.segment_num LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les segments avec des descriptions US Show Segments with Descriptions :$flex$.balance_type Balance Type Budget Name :$flex$.balance_type Balance Type Encumbrance Type :$flex$.batch Batch Journal :$flex$.fnd_flex_hierarchy Hierarchy Name Max Hierarchy Levels :$flex$.gl_segment10_from GL_SEGMENT10 From GL_SEGMENT10 To :$flex$.gl_segment1_from GL_SEGMENT1 From GL_SEGMENT1 To :$flex$.gl_segment2_from GL_SEGMENT2 From GL_SEGMENT2 To :$flex$.gl_segment3_from GL_SEGMENT3 From GL_SEGMENT3 To :$flex$.gl_segment4_from GL_SEGMENT4 From GL_SEGMENT4 To :$flex$.gl_segment5_from GL_SEGMENT5 From GL_SEGMENT5 To :$flex$.gl_segment6_from GL_SEGMENT6 From GL_SEGMENT6 To :$flex$.gl_segment7_from GL_SEGMENT7 From GL_SEGMENT7 To :$flex$.gl_segment8_from GL_SEGMENT8 From GL_SEGMENT8 To :$flex$.gl_segment9_from GL_SEGMENT9 From GL_SEGMENT9 To :$flex$.hierarchy_segment Hierarchy Segment Flex Value Set Id :$flex$.hierarchy_segment Hierarchy Segment Hierarchy Name :$flex$.hierarchy_segment Hierarchy Segment Hierarchy Segment Column :$flex$.hierarchy_segment Hierarchy Segment Max Hierarchy Levels :$flex$.journal Journal Batch :$flex$.ledger Ledger Batch :$flex$.ledger Ledger Budget Name :$flex$.ledger Ledger Flex Value Set Id :$flex$.ledger Ledger GL_SEGMENT1 :$flex$.ledger Ledger GL_SEGMENT1 From :$flex$.ledger Ledger GL_SEGMENT1 To :$flex$.ledger Ledger GL_SEGMENT10 :$flex$.ledger Ledger GL_SEGMENT10 From :$flex$.ledger Ledger GL_SEGMENT10 To :$flex$.ledger Ledger GL_SEGMENT2 :$flex$.ledger Ledger GL_SEGMENT2 From :$flex$.ledger Ledger GL_SEGMENT2 To :$flex$.ledger Ledger GL_SEGMENT3 :$flex$.ledger Ledger GL_SEGMENT3 From :$flex$.ledger Ledger GL_SEGMENT3 To :$flex$.ledger Ledger GL_SEGMENT4 :$flex$.ledger Ledger GL_SEGMENT4 From :$flex$.ledger Ledger GL_SEGMENT4 To :$flex$.ledger Ledger GL_SEGMENT5 :$flex$.ledger Ledger GL_SEGMENT5 From :$flex$.ledger Ledger GL_SEGMENT5 To :$flex$.ledger Ledger GL_SEGMENT6 :$flex$.ledger Ledger GL_SEGMENT6 From :$flex$.ledger Ledger GL_SEGMENT6 To :$flex$.ledger Ledger GL_SEGMENT7 :$flex$.ledger Ledger GL_SEGMENT7 From :$flex$.ledger Ledger GL_SEGMENT7 To :$flex$.ledger Ledger GL_SEGMENT8 :$flex$.ledger Ledger GL_SEGMENT8 From :$flex$.ledger Ledger GL_SEGMENT8 To :$flex$.ledger Ledger GL_SEGMENT9 :$flex$.ledger Ledger GL_SEGMENT9 From :$flex$.ledger Ledger GL_SEGMENT9 To :$flex$.ledger Ledger Hierarchy Name :$flex$.ledger Ledger Hierarchy Segment :$flex$.ledger Ledger Hierarchy Segment Column :$flex$.ledger Ledger Journal :$flex$.ledger Ledger Max Hierarchy Levels :$flex$.ledger Ledger Period :$flex$.ledger Ledger Period From :$flex$.ledger Ledger Period To :$flex$.period_from Period From Period To :$flex$.revaluation_currency Revaluation Currency Revaluation Conversion Type