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 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') ) ) 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 C8861CE5924A9B19E0530100007F5856 GL Concatenated Segments Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gl_security_pkg.validate_access(null,gcck.code_combination_id)='TRUE' and gcck.chart_of_accounts_id 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 gcck.chart_of_accounts_id 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 gcck.concatenated_segments 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期，取决于会计科目表或分类账。 E6B8F47D5CA17149E0530100007FDC36 GL Relative Period to Current Y select distinct to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (partition by gl.name order by ((glp.period_year * 10000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type from gl_ledgers gl, gl_periods glp, gl_periods glpc 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')) and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x order by x.relative_period desc US 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 (:$flex$.ledger is not null or :$flex$.ledger_category is not null) 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')) 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 BEBDD4DE82FE009EE0530100007F0818 ZX Tax Rate Code Y select distinct zrv.tax_rate_code value, zrv.tax||' ('||zrv.tax_regime_code||')' description from zx_rates_vl zrv where sysdate between zrv.effective_from and nvl(zrv.effective_to,sysdate) order by zrv.tax_rate_code US 41F04464364FCFBBE06362FB0905F25B with h as ( 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 ), gcck as (select &materialize_hint gcck.* from gl_code_combinations_kfv gcck where 2=2) -- -- Main Query -- select &hierarchy_levels3 y.* from ( select &hierarchy_levels2 x.*, case when max(x.je_header_id) over (partition by x.ledger,x.concatenated_segments) is not null then 'Y' else 'N' end has_activity, case when sum(decode(x.record_type,'Balance',abs(x.accounted_amount))) over (partition by x.ledger,x.concatenated_segments)>0 then 'Y' end has_balance from ( select &leading_hint case when count(distinct gp.period_num) over ()>1 then lpad(gp.period_num,2,'0')||' ' end||gjh.period_name period_name, lpad(gp.period_num,2,'0')||' '||gjh.period_name period_name_label, gl.name ledger, gjsv.user_je_source_name source_name, gjh.external_reference reference, (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, decode(row_number() over (partition by gjl.rowid order by 1),1,gjl.entered_dr) line_entered_dr, decode(row_number() over (partition by gjl.rowid order by 1),1,gjl.entered_cr) line_entered_cr, decode(row_number() over (partition by gjl.rowid order by 1),1,nvl(gjl.entered_dr,0)-nvl(gjl.entered_cr,0)) line_entered_amount, decode(row_number() over (partition by gjl.rowid order by 1),1,gjl.accounted_dr) line_accounted_dr, decode(row_number() over (partition by gjl.rowid order by 1),1,gjl.accounted_cr) line_accounted_cr, decode(row_number() over (partition by gjl.rowid order by 1),1,nvl(gjl.accounted_dr,0)-nvl(gjl.accounted_cr,0)) line_accounted_amount, decode(row_number() over (partition by gjl.rowid order by 1),1,gjl.stat_amount) line_stat_amount, gjl.description line_description, coalesce( zrb.tax_rate_code, listagg(zl.tax_rate_code,', ') within group (order by zl.tax_rate_code) over (partition by nvl(rctla.link_to_cust_trx_line_id,rctla.customer_trx_line_id)), aila.tax_rate_code, aila.tax_classification_code ) tax_rate_code, coalesce( zrb.percentage_rate, max(zl.tax_rate) over (partition by nvl(rctla.link_to_cust_trx_line_id,rctla.customer_trx_line_id)), aila.tax_rate, ( select zl.tax_rate from zx.zx_lines zl where zl.application_id=200 and zl.entity_code='AP_INVOICES' and zl.event_class_code in ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES') and aila.invoice_id=zl.trx_id and zl.trx_level_type='LINE' and aila.line_number=zl.trx_line_id and rownum=1 ) ) tax_rate, xxen_util.meaning(gjl.tax_line_flag,'YES_NO',0) tax_line, xxen_util.meaning(gjl.taxable_line_flag,'YES_NO',0) taxable_line, xxen_util.meaning(gjl.amount_includes_tax_flag,'YES_NO',0) amount_includes_tax, xxen_util.meaning(xal.accounting_class_code,'XLA_ACCOUNTING_CLASS',602,'Y') accounting_class, xxen_util.meaning(gcck.gl_account_type,'ACCOUNT_TYPE',0) account_type, &segment_columns nvl2(xal.gl_sl_link_id,xdl.unrounded_entered_dr,gjl.entered_dr) entered_dr, nvl2(xal.gl_sl_link_id,xdl.unrounded_entered_cr,gjl.entered_cr) entered_cr, nvl2(xal.gl_sl_link_id,nvl(xdl.unrounded_entered_dr,0)-nvl(xdl.unrounded_entered_cr,0),nvl(gjl.entered_dr,0)-nvl(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,xdl.unrounded_accounted_dr,gjl.accounted_dr) accounted_dr, nvl2(xal.gl_sl_link_id,xdl.unrounded_accounted_cr,gjl.accounted_cr) accounted_cr, nvl2(xal.gl_sl_link_id,nvl(xdl.unrounded_accounted_dr,0)-nvl(xdl.unrounded_accounted_cr,0),nvl(gjl.accounted_dr,0)-nvl(gjl.accounted_cr,0)) accounted_amount, gl.currency_code ledger_currency, &revaluation_columns 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, xah.description accounting_event_description, nvl(xah.accounting_date,gjh.default_effective_date) accounting_date, xe.transaction_date, xte.transaction_number, --Source Line Description coalesce(aia.source,rbsa.name,gjsv.user_je_source_name) sl_source, decode(gjsv.user_je_source_name,'Assets',to_char(xte.source_id_int_3),'Payables',aba.batch_name,'Receivables',decode(xah.je_category_name,'Receipts',arba.name,rba.name)) sl_batch_no, coalesce(aida.description,aila.description,aila.item_description,rctla.description,pla.item_description,rsl.item_description) source_line_description, --Assets fab.asset_number, ( select distinct listagg(fdh.concatenated_segments,chr(10)) within group (order by fdh.concatenated_segments) over (partition by fdh.asset_id) expense_account from ( select fdh.asset_id, gcck.concatenated_segments, sum(lengthb(gcck.concatenated_segments)+1) over (partition by fdh.asset_id order by gcck.concatenated_segments rows between unbounded preceding and current row) total_length from (select distinct fdh.asset_id, fdh.code_combination_id from fa_distribution_history fdh where fab.asset_id=fdh.asset_id and fdh.date_ineffective is null) fdh, gl_code_combinations_kfv gcck where fdh.code_combination_id=gcck.code_combination_id ) fdh where fdh.total_length<=4000 ) expense_account, --AP coalesce(aia.invoice_num,rcta.trx_number,(select distinct last_value(aia.invoice_num) over (order by aipa.invoice_payment_id range between unbounded preceding and unbounded following) from ap_invoice_payments_all aipa,ap_invoices_all aia where aipa.invoice_id=aia.invoice_id and aipa.check_id=aca.check_id)) invoice_number, coalesce(aia.description,rcta.comments,(select distinct last_value(aia.description) over (order by aipa.invoice_payment_id range between unbounded preceding and unbounded following) from ap_invoice_payments_all aipa,ap_invoices_all aia where aipa.invoice_id=aia.invoice_id and aipa.check_id=aca.check_id)) invoice_description, coalesce(aila.line_number,rctla.line_number) invoice_line_number, coalesce(aia.invoice_date,rcta.trx_date,(select distinct last_value(aia.invoice_date) over (order by aipa.invoice_payment_id range between unbounded preceding and unbounded following) from ap_invoice_payments_all aipa,ap_invoices_all aia where aipa.invoice_id=aia.invoice_id and aipa.check_id=aca.check_id)) invoice_date, aia.gl_date, nvl(aia.invoice_currency_code,rcta.invoice_currency_code) invoice_currency, nvl(aca.currency_code,aia.payment_currency_code) payment_currency, nvl(xxen_util.meaning(aia.payment_method_code,'PAYMENT METHOD',200),aia.payment_method_code) payment_method, nvl(aia.invoice_amount,(select sum(apsa.amount_due_original) from ar_payment_schedules_all apsa where rcta.customer_trx_id=apsa.customer_trx_id)) invoice_amount, aca.check_number, xxen_util.client_time(aca.check_date) payment_date, xxen_util.meaning(aca.status_lookup_code,'CHECK STATE',200) check_state, aca.amount check_amount, aca.cleared_amount check_cleared_amount, aipa.amount payment_amount, decode(aca.currency_code,gl.currency_code,aipa.amount,aipa.payment_base_amount) payment_amount_functional, cbbv.bank_name, cbbv.eft_swift_code swift_code, cba.bank_account_name, cba.masked_account_num bank_account_num, cba.masked_iban iban_number, pha.segment1 purchase_order, pha.comments po_description, pra.release_num release, pla.line_num purchase_order_line, plla.shipment_num po_shipment_number, nvl(rt.quantity,plla.quantity) quantity, nvl(plla.price_override,pla.unit_price) price, plla.quantity*nvl(plla.price_override,pla.unit_price) po_amount, pha.currency_code po_currency, rsh.receipt_num goods_receipt_number, --AR coalesce( ooha.order_number, case when xte.entity_code='TRANSACTIONS' and rcta.interface_header_context in ('ORDER ENTRY','INTERCOMPANY') then to_number(rcta.interface_header_attribute1) when mmt.transaction_source_type_id in (2,8,12) then (select to_number(mso.segment1) from mtl_sales_orders mso where mmt.transaction_source_id=mso.sales_order_id) end ) sales_order, jrrev.resource_name salesperson, (select name from ra_rules rr where rcta.invoicing_rule_id=rr.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, nvl(rt.quantity,(plla.quantity-nvl(plla.quantity_cancelled,0))) po_quantity, acra.receipt_number cash_receipt_number, 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,pha.vendor_id)=aps.vendor_id), (select hp.party_name from hz_cust_accounts hca, hz_parties hp where coalesce(decode(xal.party_type_code,'C',xal.party_id,null),rcta.bill_to_customer_id,acra.pay_from_customer,paa.customer_id)=hca.cust_account_id and hca.party_id=hp.party_id), (select hp.party_name from hz_parties hp,hz_cust_accounts hca,oe_order_lines_all oola where hca.party_id=hp.party_id and hca.cust_account_id=oola.sold_to_org_id and oola.line_id=coalesce(decode(gxeh.txn_source,'OM',gxeh.source_line_id),case when mmt.transaction_source_type_id in (2,8,12) then mmt.trx_source_line_id end)) ) vendor_or_customer, coalesce( (select aps.segment1 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,pha.vendor_id)=aps.vendor_id), (select hca.account_number from hz_cust_accounts hca where coalesce(decode(xal.party_type_code,'C',xal.party_id,null),rcta.bill_to_customer_id,acra.pay_from_customer,paa.customer_id)=hca.cust_account_id), (select hca.account_number from hz_cust_accounts hca,oe_order_lines_all oola where hca.cust_account_id=oola.sold_to_org_id and oola.line_id=coalesce(decode(gxeh.txn_source,'OM',gxeh.source_line_id),case when mmt.transaction_source_type_id in (2,8,12) then mmt.trx_source_line_id end)) ) vendor_or_customer_number, --Projects nvl(case when xte.entity_code='TRANSACTIONS' and rcta.interface_header_context='PROJECTS INVOICES' then rcta.interface_header_attribute1 end,ppa.segment1) project, pt.task_number 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, --WIP bd.department_code, br.resource_code, we.wip_entity_name wip_job, wt.operation_seq_num, nvl(wt.transaction_quantity,mmt.transaction_quantity) transaction_quantity, nvl(wt.transaction_uom,mmt.transaction_uom) transaction_uom, nvl(wt.primary_quantity,mmt.primary_quantity) primary_quantity, --Inventory xxen_util.client_time(mmt.transaction_date) inv_transaction_date, mp.organization_code inv_organization, coalesce(mmt.subinventory_code,rt.subinventory,rsl.to_subinventory) inv_subinventory, msiv.concatenated_segments inv_item, msiv.description inv_item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) inv_item_type, mmt.transaction_cost inv_transaction_unit_cost, mmt.actual_cost inv_actual_unit_cost, mmt.transaction_reference inv_transaction_reference, mtst.transaction_source_type_name inv_transaction_source_type, mtt.transaction_type_name inv_transaction_type, case when mmt.transaction_source_type_id=6 then (select mgd.segment1 from mtl_generic_dispositions mgd where mmt.transaction_source_id=mgd.disposition_id and mmt.organization_id=mgd.organization_id) --Account Alias when mmt.transaction_source_type_id in (2,8,12) then (select mso.segment1||'.'||mso.segment2||'.'||mso.segment3 from mtl_sales_orders mso where mmt.transaction_source_id=mso.sales_order_id)--Sales Order, Internal Order, RMA when mmt.transaction_source_type_id=11 then (select ccu.description from cst_cost_updates ccu where mmt.transaction_source_id=ccu.cost_update_id) --Cost Update when mmt.transaction_source_type_id=9 then (select mcch.cycle_count_header_name from mtl_cycle_count_headers mcch where mcch.cycle_count_header_id=mmt.transaction_source_id) --Cycle Count when mmt.transaction_source_type_id=3 then (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where mmt.transaction_source_id=gcck.code_combination_id) --Account when mmt.transaction_source_type_id=13 or mmt.transaction_source_type_id>100 then mmt.transaction_source_name --Inventory when mmt.transaction_source_type_id=10 then (select mpi.physical_inventory_name from mtl_physical_inventories mpi where mmt.transaction_source_id=mpi.physical_inventory_id and mmt.organization_id=mpi.organization_id) --Physical Inventory when mmt.transaction_source_type_id=1 then pha.segment1 --PO when mmt.transaction_source_type_id=16 then (select okhab.contract_number from okc_k_headers_all_b okhab where mmt.transaction_source_id=okhab.id) --Project Contracts when mmt.transaction_source_type_id=7 then (select prha.segment1 from po_requisition_headers_all prha where mmt.transaction_source_id=prha.requisition_header_id) --Requisition when mmt.transaction_source_type_id=5 then (select we.wip_entity_name from wip_entities we where mmt.transaction_source_id=we.wip_entity_id) --WIP Job or Schedule when mmt.transaction_source_type_id=4 then (select mtrh.request_number from mtl_txn_request_headers mtrh where mmt.transaction_source_id=mtrh.header_id) --Move Order end inv_transaction_source, &dff_cols mmt.transaction_id inv_transaction_id, coalesce(pla.operating_unit, (select haouv.name from hr_all_organization_units_vl haouv where coalesce( aca.org_id, aida.org_id, aipa.org_id, aaa.org_id, acra.org_id, rcta.org_id, rctla.org_id, cbaua.org_id, jrs.org_id, ooha.org_id, oola.org_id, paa.org_id, pdra.org_id, pea.org_id, peia.org_id, ppa.org_id, pda.org_id, pha.org_id, plla.org_id, pra.org_id, prda.org_id )=haouv.organization_id)) operating_unit, --AP/AR MDM Party/Site Identifier nvl2(xal.party_type_code,xal.party_type_code||'-'||nvl(to_char(xal.party_id),'UNKNOWN')||'-'||nvl(to_char(xal.party_site_id),'0'),null) 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') end mdm_party_desc, --Record history and ID columns xxen_util.user_name(gjh.created_by) journal_created_by, gjh.creation_date journal_creation_date, (select fav.application_name from fnd_application_vl fav where xal.application_id=fav.application_id) application, gjb.je_batch_id, gjl.je_header_id, gjl.context dff_context, xal.application_id, xal.ae_header_id, xal.ae_line_num, xah.event_id, xe.event_type_code, xe.event_date, &segments_with_desc &contra_account_segments &hierarchy_segment xal.accounting_class_code, xte.entity_code, xte.source_id_int_1, xdl.source_distribution_type, xdl.accounting_line_code, xdl.applied_to_distribution_type, gp.start_date period_date, gp.period_name period, 'Journal' record_type, gcck.chart_of_accounts_id, ( 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 7=7 ) flex_value_set_id, 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, gcck, (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, xla_distribution_links xdl, (select gdr.* from gl_daily_rates gdr where gdr.to_currency=:revaluation_currency and gdr.conversion_type=(select gdct.conversion_type from gl_daily_conversion_types gdct where gdct.user_conversion_type=:revaluation_conversion_type)) gdr, zx_rates_b zrb, fa_adjustments fa, fa_additions_b fab, ap_invoices_all aia, ap_batches_all aba, ap_payment_hist_dists aphd, ap_invoice_payments_all aipa, ap_checks_all aca, ce_bank_acct_uses_all cbaua, ce_bank_accounts cba, ce_bank_branches_v cbbv, ap_invoice_distributions_all aida, ap_invoice_lines_all aila, po_distributions_all pda, po_headers_all pha, po_releases_all pra, po_line_locations_all plla, ( select pla.*, (select fspa.inventory_organization_id from financials_system_params_all fspa where hou.set_of_books_id=fspa.set_of_books_id and pla.org_id=fspa.org_id) inventory_organization_id, hou.name operating_unit from po_lines_all pla, hr_operating_units hou where pla.org_id=hou.organization_id ) pla, po_req_distributions_all prda, ra_customer_trx_all rcta, ra_cust_trx_line_gl_dist_all rctlgda, ra_customer_trx_lines_all rctla, ra_batch_sources_all rbsa, ra_batches_all rba, zx_lines zl, jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev, ar_adjustments_all aaa, ar_cash_receipts_all acra, (select acrha.* from ar_cash_receipt_history_all acrha where acrha.current_record_flag='Y') acrha, ar_batches_all arba, pa_projects_all ppa, pa_tasks pt, 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_receiving_sub_ledger rrsl, rcv_transactions rt, rcv_shipment_headers rsh, rcv_shipment_lines rsl, wip_transactions wt, wip_entities we, bom_departments bd, bom_resources br, gmf_xla_extract_headers gxeh, mtl_material_transactions mmt, mtl_system_items_vl msiv, mtl_parameters mp, mtl_transaction_types mtt, mtl_txn_source_types mtst, oe_order_lines_all oola, oe_order_headers_all ooha &contra_account_table where 1=1 and 3=3 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 gjl.code_combination_id=gcck.code_combination_id and gjh.je_source=gjsv.je_source_name and &gl_flex_value_security 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 xal.application_id=xdl.application_id(+) and xal.ae_header_id=xdl.ae_header_id(+) and xal.ae_line_num=xdl.ae_line_num(+) and coalesce(xal.currency_conversion_date,gjh.currency_conversion_date,trunc(xe.transaction_date))=gdr.conversion_date(+) and decode(nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code),:revaluation_currency,null,nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code))=gdr.from_currency(+) and gjl.tax_code_id=zrb.tax_rate_id(+) and case when xdl.application_id=140 and xdl.source_distribution_type='TRX' then xdl.source_distribution_id_num_1 end=fa.transaction_header_id(+) and case when xdl.application_id=140 and xdl.source_distribution_type='TRX' then xdl.source_distribution_id_num_2 end=fa.adjustment_line_id(+) and case when xdl.application_id=140 then case when xdl.source_distribution_type in ('DEPRN','IAC') then xdl.source_distribution_id_num_1 when xdl.source_distribution_type='TRX' then fa.asset_id end end=fab.asset_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 coalesce(case when xdl.application_id=200 and xdl.source_distribution_type='AP_INV_DIST' then xdl.source_distribution_id_num_1 when xdl.application_id=200 and xdl.applied_to_distribution_type='AP_INV_DIST' then xdl.applied_to_dist_id_num_1 end,aphd.invoice_distribution_id)=aida.invoice_distribution_id(+) and case when xdl.application_id=200 and xdl.source_distribution_type='AP_PMT_DIST' then xdl.source_distribution_id_num_1 end=aphd.payment_hist_dist_id(+) and aphd.invoice_payment_id=aipa.invoice_payment_id(+) and aipa.check_id=aca.check_id(+) and aca.ce_bank_acct_use_id=cbaua.bank_acct_use_id(+) and cbaua.bank_account_id=cba.bank_account_id(+) and cba.bank_branch_id=cbbv.branch_party_id(+) and aida.invoice_id=aia.invoice_id(+) and aia.batch_id=aba.batch_id(+) and aida.invoice_id=aila.invoice_id(+) and aida.invoice_line_number=aila.line_number(+) and coalesce(pda.po_header_id,plla.po_header_id,rt.po_header_id,aia.quick_po_header_id,wt.po_header_id,decode(mmt.transaction_source_type_id,1,mmt.transaction_source_id))=pha.po_header_id(+) and coalesce(pda.po_release_id,plla.po_release_id,rt.po_release_id,aila.po_release_id )=pra.po_release_id(+) and coalesce(case when xdl.application_id=201 and xdl.source_distribution_type='PO_DISTRIBUTIONS_ALL' then xdl.source_distribution_id_num_1 end,aida.po_distribution_id,aila.po_distribution_id,decode(rrsl.reference1,'PO',to_number(rrsl.reference3)),rt.po_distribution_id)=pda.po_distribution_id(+) and coalesce(pda.line_location_id,aila.po_line_location_id,rt.po_line_location_id)=plla.line_location_id(+) and coalesce(pda.po_line_id,plla.po_line_id,rt.po_line_id,wt.po_line_id)=pla.po_line_id(+) and case when xdl.application_id=201 and xdl.source_distribution_type='PO_REQ_DISTRIBUTIONS_ALL' then xdl.source_distribution_id_num_1 end=prda.distribution_id(+) and 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=rcta.customer_trx_id(+) and rcta.batch_source_id=rbsa.batch_source_id(+) and rcta.org_id=rbsa.org_id(+) and rcta.batch_id=rba.batch_id(+) and rcta.primary_salesrep_id=jrs.salesrep_id(+) and rcta.org_id=jrs.org_id(+) and jrs.resource_id=jrrev.resource_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 acra.cash_receipt_id=acrha.cash_receipt_id(+) and acrha.batch_id=arba.batch_id(+) and case when xdl.application_id=222 and xdl.source_distribution_type='RA_CUST_TRX_LINE_GL_DIST_ALL' then xdl.source_distribution_id_num_1 end=rctlgda.cust_trx_line_gl_dist_id(+) and rctlgda.customer_trx_line_id=rctla.customer_trx_line_id(+) and rctla.tax_line_id=zl.tax_line_id(+) and nvl(aida.project_id,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(+) 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 nvl(aida.task_id,peia.task_id)=pt.task_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 xdl.application_id=707 and xdl.source_distribution_type='RCV_RECEIVING_SUB_LEDGER' then xdl.source_distribution_id_num_1 end=rrsl.rcv_sub_ledger_id(+) and case when xah.application_id=555 then xah.event_id end=gxeh.event_id(+) and --OPM coalesce(case when xte.application_id=707 and xte.entity_code='RCV_ACCOUNTING_EVENTS' then xte.source_id_int_1 when xte.application_id=707 and xte.entity_code='WIP_ACCOUNTING_EVENTS' then wt.rcv_transaction_id when xte.application_id=555 and gxeh.event_class_code='RECEIVE' then gxeh.source_line_id when xdl.application_id=200 and xdl.source_distribution_type='AP_INV_DIST' then nvl(aida.rcv_transaction_id,aila.rcv_transaction_id) when xdl.application_id=200 and xdl.applied_to_distribution_type='AP_INV_DIST' then nvl(aida.rcv_transaction_id,aila.rcv_transaction_id) end,mmt.rcv_transaction_id)=rt.transaction_id(+) and rt.shipment_line_id=rsl.shipment_line_id(+) and rt.shipment_header_id=rsh.shipment_header_id(+) and case when xte.application_id=707 and xte.entity_code='WIP_ACCOUNTING_EVENTS' then xte.source_id_int_1 end=wt.transaction_id(+) and wt.wip_entity_id=we.wip_entity_id(+) and wt.department_id=bd.department_id(+) and wt.resource_id=br.resource_id(+) and --inventory case when xte.application_id=707 and xte.entity_code='MTL_ACCOUNTING_EVENTS' then xte.source_id_int_1 when xah.application_id=555 and (xte.entity_code in ('INVENTORY','ORDERMANAGEMENT') or gxeh.event_class_code in ('BATCH_MATERIAL','DELIVER')) then gxeh.transaction_id end=mmt.transaction_id(+) and coalesce(mmt.organization_id,gxeh.organization_id,rsl.to_organization_id,plla.ship_to_organization_id,we.organization_id,rctla.warehouse_id)=msiv.organization_id(+) and coalesce(mmt.inventory_item_id,gxeh.inventory_item_id,rsl.item_id,pla.item_id,we.primary_item_id,rctla.inventory_item_id)=msiv.inventory_item_id(+) and coalesce(mmt.organization_id,gxeh.organization_id,rt.organization_id,rsl.to_organization_id,plla.ship_to_organization_id,we.organization_id,nvl2(rctla.inventory_item_id,rctla.warehouse_id,null))=mp.organization_id(+) and mmt.transaction_type_id=mtt.transaction_type_id(+) and mmt.transaction_source_type_id=mtst.transaction_source_type_id(+) and coalesce(decode(gxeh.txn_source,'OM',gxeh.source_line_id),case when mmt.transaction_source_type_id in (2,8,12) then mmt.trx_source_line_id end,rsl.oe_order_line_id,rt.oe_order_line_id)=oola.line_id(+) and coalesce(oola.header_id,rsl.oe_order_header_id,rt.oe_order_header_id)=ooha.header_id(+) union all select -- GL Opening Balance ' ' || gp.period_name || ' Open Bal' period_name, '00 ' || gp.period_name || ' Open Bal' period_name_label, gl.name ledger, null source_name, null reference, null category_name, null batch_name, null batch_status, null posted_date, null journal_name, null journal_description, null document_number, null tax_status_code, null line_number, gcck.concatenated_segments, null line_entered_dr, null line_entered_cr, null line_entered_amount, gb.begin_balance_dr line_accounted_dr, gb.begin_balance_cr line_accounted_cr, nvl(gb.begin_balance_dr,0)-nvl(gb.begin_balance_cr,0) line_accounted_amount, null line_stat_amount, null line_description, null tax_rate_code, null tax_rate, null tax_line, null taxable_line, null amount_includes_tax, null accounting_class, xxen_util.meaning(gcck.gl_account_type,'ACCOUNT_TYPE',0) account_type, &segment_columns null entered_dr, null entered_cr, null entered_amount, null transaction_currency, gb.begin_balance_dr accounted_dr, gb.begin_balance_cr accounted_cr, nvl(gb.begin_balance_dr,0)-nvl(gb.begin_balance_cr,0) accounted_amount, gl.currency_code ledger_currency, &revaluation_columns_balo null doc_sequence_value, null event_type, null currency_conversion_date, null currency_conversion_type, null currency_conversion_rate, xxen_util.description(gb.actual_flag,'BATCH_TYPE',101) balance_type, (select gbv.budget_name from gl_budget_versions gbv where gb.budget_version_id=gbv.budget_version_id) budget_name, (select get.encumbrance_type from gl_encumbrance_types get where get.encumbrance_type_id = gb.encumbrance_type_id) encumbrance_type, null conversion_date, null conversion_type, null conversion_rate, null accounting_event_description, null accounting_date, null transaction_date, null transaction_number, -- Source Line Description null sl_source, null sl_batch_no, null source_line_description, -- Assets null asset_number, null expense_account, --AP null invoice_number, null invoice_description, null invoice_line_number, null invoice_date, null gl_date, null invoice_currency, null payment_currency, null payment_method_code, null invoice_amount, null check_number, null payment_date, null check_state, null check_amount, null check_cleared_amount, null payment_amount, null payment_amount_functional, null bank_name, null swift_code, null bank_account_name, null bank_account_num, null iban_number, null purchase_order, null po_description, null release, null purchase_order_line, null po_shipment_number, null quantity, null price, null po_amount, null po_currency, null goods_receipt_number, --AR null sales_order, null salesperson, null invoice_rule, null accounting_rule, null po_quantity, null cash_receipt_number, null vendor_or_customer, null vendor_or_customer_number, --Projects null project, null task, null expenditure_group, null expenditure_class_code, null expenditure_status_code, null expenditure_category, null expenditure_type, null expenditure_type_description, null expenditure_item_date, null expenditure_item_quantity, null expenditure_unit_of_measure, null incurred_by_person, null incurred_by_employee_number, --WIP null department_code, null resource_code, null wip_job, null operation_seq_num, null transaction_quantity, null transaction_uom, null primary_quantity, -- inventory null inv_transaction_date, null inv_organization, null inv_subinventory, null inv_item, null inv_item_description, null inv_item_type, null inv_transaction_unit_cost, null inv_actual_unit_cost, null inv_transaction_reference, null inv_transaction_source_type, null inv_transaction_type, null inv_transaction_source, &dff_cols_null null inv_transaction_id, null operating_unit, -- AP/AR MDM Party/Site Identifier null mdm_party_value, null mdm_party_desc, --Record history and ID columns null journal_created_by, null journal_creation_date, null application, null je_batch_id, null je_header_id, null dff_context, null application_id, null ae_header_id, null ae_line_num, null event_id, null event_type_code, null event_date, &segments_with_desc &contra_account_segments2 &hierarchy_segment null accounting_class_code, null entity_code, null source_id_int_1, null source_distribution_type, null accounting_line_code, null applied_to_distribution_type, gp.start_date-1 period_date, gp.period_name period, 'Balance' record_type, gcck.chart_of_accounts_id, ( 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 7=7 ) flex_value_set_id, null view_transaction from gl_ledgers gl, gl_periods gp, gcck, gl_balances gb, (select gdr.* from gl_daily_rates gdr where gdr.to_currency=:revaluation_currency and gdr.conversion_type=(select gdct.conversion_type from gl_daily_conversion_types gdct where gdct.user_conversion_type=:revaluation_conversion_type)) gdr where -- opening balance is outer joined in case account became active after period from -- and restrict to accounts which have a balance as at period to -- in case report is run historically, exclude accounts made active after the period to 1=1 and 4=4 and :show_balances is not null and gp.period_name=nvl(:period_name,:period_name_from) and gl.period_set_name=gp.period_set_name and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and &gl_flex_value_security gcck.code_combination_id=gb.code_combination_id(+) and gl.ledger_id=gb.ledger_id(+) and gl.currency_code=gb.currency_code(+) and gp.period_name=gb.period_name(+) and gb.template_id(+) is null and gp.start_date=gdr.conversion_date(+) and exists (select null from gl_balances gb2 where gb2.period_name=nvl(:period_name,:period_name_to) and gb2.ledger_id=gl.ledger_id and gb2.currency_code=gl.currency_code and gb2.template_id is null and gb2.code_combination_id=gcck.code_combination_id and (:balance_type is null or gb2.actual_flag=(select flvv.lookup_code from fnd_lookup_values_vl flvv where xxen_util.contains(:balance_type,flvv.description)='Y' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0)) and (:budget_name is null or gb2.actual_flag<>'B' or gb2.budget_version_id in (select gbv.budget_version_id from gl_budget_versions gbv where xxen_util.contains(:budget_name,gbv.budget_name)='Y')) and (:encumbrance_type is null or gb2.actual_flag<>'E' or gb2.encumbrance_type_id in (select get.encumbrance_type_id from gl_encumbrance_types get where xxen_util.contains(:encumbrance_type,get.encumbrance_type)='Y')) ) and decode(gb.currency_code,:revaluation_currency,null,gb.currency_code)=gdr.from_currency(+) union all select -- GL Closing Balance 'ο' || gp.period_name || ' Close Bal' period_name, '99 ' || gp.period_name || ' Close Bal' period_name_label, gl.name ledger, null source_name, null reference, null category_name, null batch_name, null batch_status, null posted_date, null journal_name, null journal_description, null document_number, null tax_status_code, null line_number, gcck.concatenated_segments, null line_entered_dr, null line_entered_cr, null line_entered_amount, nvl(gb.begin_balance_dr,0)+nvl(gb.period_net_dr,0) line_accounted_dr, nvl(gb.begin_balance_cr,0)+nvl(gb.period_net_cr,0) line_accounted_cr, nvl(gb.begin_balance_dr,0)-nvl(gb.begin_balance_cr,0)+nvl(gb.period_net_dr,0)-nvl(gb.period_net_cr,0) line_accounted_amount, null line_stat_amount, null line_description, null tax_rate_code, null tax_rate, null tax_line, null taxable_line, null amount_includes_tax, null accounting_class, xxen_util.meaning(gcck.gl_account_type,'ACCOUNT_TYPE',0) account_type, &segment_columns null entered_dr, null entered_cr, null entered_amount, null transaction_currency, nvl(gb.begin_balance_dr,0)+nvl(gb.period_net_dr,0) accounted_dr, nvl(gb.begin_balance_cr,0)+nvl(gb.period_net_cr,0) accounted_cr, nvl(gb.begin_balance_dr,0)-nvl(gb.begin_balance_cr,0)+nvl(gb.period_net_dr,0)-nvl(gb.period_net_cr,0) accounted_amount, gl.currency_code ledger_currency, &revaluation_columns_balc null doc_sequence_value, null event_type, null currency_conversion_date, null currency_conversion_type, null currency_conversion_rate, xxen_util.description(gb.actual_flag,'BATCH_TYPE',101) balance_type, (select gbv.budget_name from gl_budget_versions gbv where gb.budget_version_id=gbv.budget_version_id) budget_name, (select get.encumbrance_type from gl_encumbrance_types get where get.encumbrance_type_id = gb.encumbrance_type_id) encumbrance_type, null conversion_date, null conversion_type, null conversion_rate, null accounting_event_description, null accounting_date, null transaction_date, null transaction_number, -- Source Line Description null sl_source, null sl_batch_no, null source_line_description, -- Assets null asset_number, null expense_account, --AP null invoice_number, null invoice_description, null invoice_line_number, null invoice_date, null gl_date, null invoice_currency, null payment_currency, null payment_method_code, null invoice_amount, null check_number, null payment_date, null check_state, null check_amount, null check_cleared_amount, null payment_amount, null payment_amount_functional, null bank_name, null swift_code, null bank_account_name, null bank_account_num, null iban_number, null purchase_order, null po_description, null release, null purchase_order_line, null po_shipment_number, null quantity, null price, null po_amount, null po_currency, null goods_receipt_number, --AR null sales_order, null salesperson, null invoice_rule, null accounting_rule, null po_quantity, null cash_receipt_number, null vendor_or_customer, null vendor_or_customer_number, --Projects null project, null task, null expenditure_group, null expenditure_class_code, null expenditure_status_code, null expenditure_category, null expenditure_type, null expenditure_type_description, null expenditure_item_date, null expenditure_item_quantity, null expenditure_unit_of_measure, null incurred_by_person, null incurred_by_employee_number, --WIP null department_code, null resource_code, null wip_job, null operation_seq_num, null transaction_quantity, null transaction_uom, null primary_quantity, -- inventory null inv_transaction_date, null inv_organization, null inv_subinventory, null inv_item, null inv_item_description, null inv_item_type, null inv_transaction_unit_cost, null inv_actual_unit_cost, null inv_transaction_reference, null inv_transaction_source_type, null inv_transaction_type, null inv_transaction_source, &dff_cols_null null inv_transaction_id, null operating_unit, -- AP/AR MDM Party/Site Identifier null mdm_party_value, null mdm_party_desc, null journal_created_by, null journal_creation_date, null application, null je_batch_id, null je_header_id, null dff_context, null application_id, null ae_header_id, null ae_line_num, null event_id, null event_type_code, null event_date, &segments_with_desc &contra_account_segments2 &hierarchy_segment null accounting_class_code, null entity_code, null source_id_int_1, null source_distribution_type, null accounting_line_code, null applied_to_distribution_type, gp.end_date period_date, gp.period_name period, 'Balance' record_type, gcck.chart_of_accounts_id, ( 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 7=7 ) flex_value_set_id, null view_transaction from gl_ledgers gl, gl_periods gp, gcck, gl_balances gb, (select gdr.* from gl_daily_rates gdr where gdr.to_currency=:revaluation_currency and gdr.conversion_type=(select gdct.conversion_type from gl_daily_conversion_types gdct where gdct.user_conversion_type=:revaluation_conversion_type)) gdr where 1=1 and 4=4 and :show_balances is not null and gp.period_name=nvl(:period_name,:period_name_to) and gl.period_set_name=gp.period_set_name and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and &gl_flex_value_security gcck.code_combination_id=gb.code_combination_id and gl.ledger_id=gb.ledger_id and gl.currency_code=gb.currency_code and gp.period_name=gb.period_name and gb.template_id is null and gp.end_date=gdr.conversion_date(+) and decode(gb.currency_code,:revaluation_currency,null,gb.currency_code)=gdr.from_currency(+) ) x, h where 5=5 and x.flex_value_set_id=h.flex_value_set_id(+) ) y where 6=6 order by y.ledger, y.concatenated_segments, y.period_date, y.period_name, y.batch_name, y.journal_name, y.line_number, y.transaction_date, y.transaction_number, y.invoice_line_number, y.purchase_order_line, y.task, y.accounted_amount Fixed OPM GMF joins: restricted mmt link to correct entity/event codes, restricted gxeh.source_line_id rt link to RECEIVE event_class only (DELIVER uses mmt.rcv_transaction_id), added universal mmt.rcv_transaction_id fallback, added gxeh item/org to coalesce chains, fixed vendor_or_customer subqueries to restrict gxeh.source_line_id to txn_source OM Y #,##0.00;[Red]-#,##0.00 :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 or :Relative_Period is not null or (:Relative_Period_From is not null and :Relative_Period_To is not null) US GL Account Analysis (Distributions) Detailed GL transaction report with one line per distribution including all segments and subledger data, with amounts in both transaction currency and ledger currency. The report includes VAT tax codes and rates for AR and AP transactions. Please enter a period, posted date, batch or journal restriction Enginatics &contra_account_segments &contra_account_segments2 &contra_account_table &dff_cols &dff_cols_null &gl_flex_value_security &hierarchy_levels &hierarchy_levels2 &hierarchy_levels3 &hierarchy_segment &hierarchy_segment_column &leading_hint &materialize_hint &revaluation_columns &revaluation_columns_balc &revaluation_columns_balo &segment_columns &segments_with_desc 1=1 2=2 3=3 4=4 5=5 6=6 7=7 :balance_type :budget_name :encumbrance_type :flex_value_set_id :parent_flex_value :period_name :period_name_from :period_name_to :revaluation_conversion_type :revaluation_currency :show_balances 1 -40 &gl_flex_value_security select 'gl_security_pkg.validate_access(null,gcck.code_combination_id)=''TRUE'' and' from dual where xxen_util.has_flex_value_security='Y' Char x US GL Flex Value Security 2 -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 3 -20 &hierarchy_segment_column <parameter_value> 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 4 &hierarchy_levels3 select 'y.level'||x.column_value||'||nvl2(y.level'||x.column_value||','' - ''||xxen_util.segment_description(y.level'||x.column_value||',''<parameter_value>'',y.chart_of_accounts_id),null) hierarchy_level'||x.column_value||',' text from table(xxen_util.rowgen(:max_hierarchy_levels)) x F Colonne de segment de hiérarchie US Hierarchy Segment Column 5 &hierarchy_segment gcck.<parameter_value> hierarchy_segment, US Hierarchy Segment Column 6 7=7 gcck.<parameter_value>=ffv.flex_value US Hierarchy Segment Column 7 -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 8 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 9 &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 10 20 3=3 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$.period_from is null and :$flex$.batch is null and :$flex$.journal is null and (:$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 11 30 3=3 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 12 40 3=3 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 13 50 3=3 gjh.posted_date>=:posted_date_from Date F Date d'entrée en vigueur US Posted Date From 14 60 3=3 gjh.posted_date<:posted_date_to+1 Date F Date de publication au US Posted Date To 15 70 3=3 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 16 80 3=3 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 17 90 3=3 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 18 100 3=3 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 19 110 3=3 gjl.je_line_num=:journal_line Number US Journal Line 20 120 6=6 y.tax_rate_code=:tax_code LOV ZX Tax Rate Code BEBDD4DE82FE009EE0530100007F0818 Y select distinct zrv.tax_rate_code value, zrv.tax||' ('||zrv.tax_regime_code||')' description from zx_rates_vl zrv where sysdate between zrv.effective_from and nvl(zrv.effective_to,sysdate) order by zrv.tax_rate_code F Code du taux d'imposition US Tax Rate Code 21 130 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 22 140 &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 (:$flex$.ledger is not null or :$flex$.ledger_category is not null) 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')) 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 23 &hierarchy_levels2 select decode(x.column_value,1,'h.level1,','nvl(h.level'||x.column_value||',nvl2(h.level'||(x.column_value-1)||',x.hierarchy_segment,null)) level'||x.column_value||',') text from table(xxen_util.rowgen(:max_hierarchy_levels)) x F Segment de la hiérarchie US Hierarchy Segment 24 5=5 x.hierarchy_segment between nvl(h.child_flex_value_low(+),x.hierarchy_segment) and nvl(h.child_flex_value_high(+),x.hierarchy_segment) US Hierarchy Segment 25 150 :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 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') ) ) 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 26 160 2=2 gcck.concatenated_segments=:concatenated_segments LOV GL Concatenated Segments C8861CE5924A9B19E0530100007F5856 Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gl_security_pkg.validate_access(null,gcck.code_combination_id)='TRUE' and gcck.chart_of_accounts_id 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 gcck.chart_of_accounts_id 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 gcck.concatenated_segments F Segments concaténés US Concatenated Segments 27 &leading_hint /*+ leading(gl gp gcck gjl)*/ US Concatenated Segments 28 &materialize_hint /*+ materialize*/ US Concatenated Segments 29 170 2=2 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 30 180 2=2 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 31 190 2=2 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 32 200 2=2 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 33 210 2=2 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 34 220 2=2 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 35 230 2=2 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 36 240 2=2 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 37 250 2=2 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 38 260 2=2 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 39 270 2=2 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 40 280 2=2 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 41 290 2=2 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 42 300 2=2 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 43 310 2=2 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 44 320 2=2 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 45 330 2=2 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 46 340 2=2 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 47 350 2=2 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 48 360 2=2 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 49 370 2=2 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 50 380 2=2 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 51 390 2=2 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 52 400 2=2 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 53 410 2=2 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 54 420 2=2 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 55 430 2=2 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 56 440 2=2 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 57 450 2=2 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 58 460 2=2 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 59 470 3=3 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 60 3=3 gjh.status not in ('P','U') xxen_util.meaning('E','VALIDATION_STATUS',101) F Statut US Status 61 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 62 &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 63 &revaluation_columns_balc (gb.begin_balance_dr + nvl(gb.period_net_dr,0))*decode(gb.currency_code,:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_dr, (gb.begin_balance_cr + nvl(gb.period_net_cr,0))*decode(gb.currency_code,:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_cr, ((nvl(gb.begin_balance_dr,0)-nvl(gb.begin_balance_cr,0))+(nvl(gb.period_net_dr,0)-nvl(gb.period_net_cr,0)))*decode(gb.currency_code,:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_amount, :revaluation_currency <parameter_value>_currency, F Monnaie de réévaluation US Revaluation Currency 64 &revaluation_columns_balo (gb.begin_balance_dr)*decode(gb.currency_code,:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_dr, (gb.begin_balance_cr)*decode(gb.currency_code,:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_cr, (nvl(gb.begin_balance_dr,0)-nvl(gb.begin_balance_cr,0))*decode(gb.currency_code,:revaluation_currency,1,gdr.conversion_rate) <parameter_value>_amount, :revaluation_currency <parameter_value>_currency, F Monnaie de réévaluation US Revaluation Currency 65 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 66 500 3=3 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 67 4=4 (gb.actual_flag is null or gb.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)) F Type d'équilibre US Balance Type 68 510 3=3 (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 69 4=4 (nvl(gb.actual_flag,'X')<>'B' or gb.budget_version_id in (select gbv.budget_version_id from gl_budget_versions gbv where gbv.budget_name = :budget_name)) F Nom du budget US Budget Name 70 520 3=3 (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 71 4=4 (nvl(gb.actual_flag,'X')<>'E' or gb.encumbrance_type_id in (select get.encumbrance_type_id from gl_encumbrance_types get where get.encumbrance_type = :encumbrance_type)) F Type d'engagement US Encumbrance Type 72 530 3=3 nvl2(xal.gl_sl_link_id,nvl(xdl.unrounded_accounted_dr,0)-nvl(xdl.unrounded_accounted_cr,0),nvl(gjl.accounted_dr,0)-nvl(gjl.accounted_cr,0))<>0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Exclude Zero Amount Lines 73 540 &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 Y F Afficher les segments avec des descriptions US Show Segments with Descriptions 74 550 :show_balances LOV custom Y select x.value, x.description from ( select 'Accounts with Activity only' value, null description from dual union all select 'All Accounts excluding zero balances' value, null description from dual union all select 'All Accounts' value, null description from dual ) x where :$flex$.Period is not null or (:$flex$.Period_From is not null and :$flex$.Period_To is not null) F Afficher les soldes ouverts/fermés US Show Open/Close Balances 75 6=6 y.has_activity='Y' Accounts with Activity only F Afficher les soldes ouverts/fermés US Show Open/Close Balances 76 6=6 (y.has_activity='Y' or y.has_balance='Y') All Accounts excluding zero balances F Afficher les soldes ouverts/fermés US Show Open/Close Balances 77 560 &contra_account_segments select x.text from ( select 'nvl2(gcck2.concatenated_segments,row_number() over (partition by xal.ae_header_id,xal.ae_line_num order by gcck2.concatenated_segments),null) contra_num,'||chr(10)|| 'gcck2.concatenated_segments contra_account,' text, 1 min_id_flex_num, 1 min_segment_num, 1 seq from dual where :p_show_contra is not null union select 'gcck2.'||lower(fifsv.application_column_name)||' ' || substrb('"Contra '||fifsv.form_left_prompt||'"',1,xxen_report.max_column_length) || ','||chr(10)|| 'xxen_util.segment_description(gcck2.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck2.chart_of_accounts_id'|| ( select ', gcck2.'||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('"Contra '||fifsv.form_left_prompt ,1,xxen_report.max_column_length-5)||' desc"' || ',' || nvl2(:p_show_seg_desc,'gcck2.'||lower(fifsv.application_column_name)||'||'' - '''||'||xxen_util.segment_description(gcck2.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck2.chart_of_accounts_id'|| ( select ', gcck2.'||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('"Contra '||fifsv.form_left_prompt||' with desc"',1,xxen_report.max_column_length) || ',', null) 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, 2 seq from fnd_id_flex_segments_vl fifsv where :p_show_contra is not null 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(:ledger,gl.name)='Y') ) x order by seq, min_id_flex_num, min_segment_num LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Sub Ledger Contra Accounts 78 &contra_account_segments2 select x.text from ( select 'to_number(null) contra_num,'||chr(10)|| 'null,' text, 1 min_id_flex_num, 1 min_segment_num, 1 seq from dual where :p_show_contra is not null union select 'null ' || substrb('"Contra '||fifsv.form_left_prompt||'"',1,xxen_report.max_column_length) || ','||chr(10)|| 'null ' || substrb('"Contra '||fifsv.form_left_prompt ,1,xxen_report.max_column_length-5)||' desc"' || ',' || nvl2(:p_show_seg_desc,'null ' || substrb('"Contra '||fifsv.form_left_prompt||' with desc"',1,xxen_report.max_column_length) || ',',null) 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, 2 seq from fnd_id_flex_segments_vl fifsv where :p_show_contra is not null 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(:ledger,gl.name)='Y') ) x order by seq, min_id_flex_num, min_segment_num US Show Sub Ledger Contra Accounts 79 &contra_account_table ,( select xal2.ae_header_id, xal2.application_id, xal2.ledger_id, nvl(xal2.party_type_code,'?') party_type_code, nvl(xal2.party_id,-1) party_id, nvl(xal2.party_site_id,-1) party_site_id, nvl2(xal2.accounted_dr,'DR','CR') dr_cr, xal2.code_combination_id from xla_ae_lines xal2 group by xal2.ae_header_id, xal2.application_id, xal2.ledger_id, nvl(xal2.party_type_code,'?'), nvl(xal2.party_id,-1), nvl(xal2.party_site_id,-1), nvl2(xal2.accounted_dr,'DR','CR'), xal2.code_combination_id ) xal2, gl_code_combinations_kfv gcck2 US Show Sub Ledger Contra Accounts 80 3=3 xal.ae_header_id=xal2.ae_header_id(+) and xal.application_id=xal2.application_id(+) and xal.ledger_id=xal2.ledger_id(+) and nvl(xal.party_type_code,'?')=xal2.party_type_code(+) and nvl(xal.party_id,-1)=xal2.party_id(+) and --nvl(xal.party_site_id,-1)=xal2.party_site_id(+) and nvl2(xal.accounted_dr,'DR','CR')<>xal2.dr_cr(+) and xal2.code_combination_id=gcck2.code_combination_id(+) US Show Sub Ledger Contra Accounts 81 570 &dff_cols select xxen_util.dff_columns(p_table_name=>'gl_je_lines', p_column_name_prefix=>'JL ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Journal Line DFF Attributes 82 &dff_cols_null select xxen_util.dff_columns(p_table_name=>'gl_je_lines', p_column_name_prefix=>'JL ', p_prefix=>'null ') sql_text from dual US Show Journal Line DFF Attributes 83 580 &dff_cols select xxen_util.dff_columns(p_table_name=>'ap_invoices_all', p_column_name_prefix=>'AI ')|| xxen_util.dff_columns(p_table_name=>'ap_invoice_lines_all', p_column_name_prefix=>'AIL ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Invoice DFF Attributes 84 &dff_cols_null select xxen_util.dff_columns(p_table_name=>'ap_invoices_all', p_column_name_prefix=>'AI ', p_prefix=>'null ')|| xxen_util.dff_columns(p_table_name=>'ap_invoice_lines_all', p_column_name_prefix=>'AIL ', p_prefix=>'null ') sql_text from dual US Show Invoice DFF Attributes 85 590 1=1 gp.period_name = ( select x.period_name from ( select 1-rank() over (partition by gl.name order by ((gp2.period_year * 10000) + gp2.period_num) desc) relative_period, gp2.period_name, gp2.period_type from gl_periods gp2, gl_periods gpc2 where gl.period_set_name=gp2.period_set_name and gl.accounted_period_type=gp2.period_type and gp2.adjustment_period_flag='N' and gl.period_set_name=gpc2.period_set_name and gl.accounted_period_type=gpc2.period_type and gpc2.adjustment_period_flag='N' and trunc(sysdate-1) between gpc2.start_date and gpc2.end_date and gp2.start_date <= gpc2.start_date ) x where x.relative_period = :p_relative_period ) LOV GL Relative Period to Current E6B8F47D5CA17149E0530100007FDC36 Y select distinct to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (partition by gl.name order by ((glp.period_year * 10000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type from gl_ledgers gl, gl_periods glp, gl_periods glpc 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')) and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x order by x.relative_period desc US Relative Period As of Period Close based on the Period Offset relative to the current period. Useful when scheduling the request to be run periodically, the as of date will update automatically relative to the current period. 86 600 1=1 gp.period_year*10000+gp.period_num>=( select x.period_year_num from ( select 1-rank() over (partition by gl.name order by ((gp2.period_year * 10000) + gp2.period_num) desc) relative_period, gp2.period_year*10000+gp2.period_num period_year_num from gl_periods gp2, gl_periods gpc2 where gl.period_set_name=gp2.period_set_name and gl.accounted_period_type=gp2.period_type and gp2.adjustment_period_flag='N' and gl.period_set_name=gpc2.period_set_name and gl.accounted_period_type=gpc2.period_type and gpc2.adjustment_period_flag='N' and trunc(sysdate-1) between gpc2.start_date and gpc2.end_date and gp2.start_date <= gpc2.start_date ) x where x.relative_period = :p_relative_period_from ) LOV GL Relative Period to Current E6B8F47D5CA17149E0530100007FDC36 Y select distinct to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (partition by gl.name order by ((glp.period_year * 10000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type from gl_ledgers gl, gl_periods glp, gl_periods glpc 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')) and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x order by x.relative_period desc US Relative Period From Start period offset from the current period of the calendar attached to the ledger or ledger set 87 610 1=1 gp.period_year*10000+gp.period_num<=( select x.period_year_num from ( select 1-rank() over (partition by gl.name order by ((gp2.period_year * 10000) + gp2.period_num) desc) relative_period, gp2.period_year*10000+gp2.period_num period_year_num from gl_periods gp2, gl_periods gpc2 where gl.period_set_name=gp2.period_set_name and gl.accounted_period_type=gp2.period_type and gp2.adjustment_period_flag='N' and gl.period_set_name=gpc2.period_set_name and gl.accounted_period_type=gpc2.period_type and gpc2.adjustment_period_flag='N' and trunc(sysdate-1) between gpc2.start_date and gpc2.end_date and gp2.start_date <= gpc2.start_date ) x where x.relative_period = :p_relative_period_to ) LOV GL Relative Period to Current E6B8F47D5CA17149E0530100007FDC36 Y select distinct to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (partition by gl.name order by ((glp.period_year * 10000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type from gl_ledgers gl, gl_periods glp, gl_periods glpc 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')) and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x order by x.relative_period desc :$flex$.Relative_Period_From US Relative Period To End period offset from the current period of the calendar attached to the ledger or ledger set :$flex$.Period Period Show Open/Close Balances :$flex$.Period_From Period From Show Open/Close Balances :$flex$.Period_To Period To Show Open/Close Balances :$flex$.Relative_Period_From Relative Period From Relative Period To :$flex$.balance_type Balance Type Budget Name :$flex$.balance_type Balance Type Encumbrance Type :$flex$.batch Batch Journal :$flex$.batch Batch Period :$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$.journal Journal Period :$flex$.ledger Ledger Batch :$flex$.ledger Ledger Budget Name :$flex$.ledger Ledger Concatenated Segments :$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$.ledger Ledger Relative Period :$flex$.ledger Ledger Relative Period From :$flex$.ledger Ledger Relative Period To :$flex$.period_from Period From Period :$flex$.period_from Period From Period To :$flex$.revaluation_currency Revaluation Currency Revaluation Conversion Type Pivot by Hierarchy Y SYSADMIN 54 ACCOUNTED_AMOUNT 53 ACCOUNTED_CR 52 ACCOUNTED_DR 36 ACCOUNTING_CLASS 156 ACCOUNTING_CLASS_CODE 68 ACCOUNTING_DATE 67 ACCOUNTING_EVENT_DESCRIPTION 165 ACCOUNTING_LINE_CODE 105 ACCOUNTING_RULE 37 ACCOUNT_TYPE 151 AE_HEADER_ID 152 AE_LINE_NUM 35 AMOUNT_INCLUDES_TAX 146 APPLICATION 150 APPLICATION_ID 166 APPLIED_TO_DISTRIBUTION_TYPE 72 ASSET_NUMBER 42 Account 43 Account desc 160 Account with desc 61 BALANCE_TYPE 91 BANK_ACCOUNT_NAME 92 BANK_ACCOUNT_NUM 89 BANK_NAME 15 BATCH_NAME 16 BATCH_STATUS 62 BUDGET_NAME 14 CATEGORY_NAME 171 CHART_OF_ACCOUNTS_ID 85 CHECK_AMOUNT 86 CHECK_CLEARED_AMOUNT 82 CHECK_NUMBER 84 CHECK_STATE 23 CONCATENATED_SEGMENTS 64 CONVERSION_DATE 66 CONVERSION_RATE 65 CONVERSION_TYPE 58 CURRENCY_CONVERSION_DATE 60 CURRENCY_CONVERSION_RATE 59 CURRENCY_CONVERSION_TYPE 38 Company 39 Company desc 158 Company with desc 123 DEPARTMENT_CODE 149 DFF_CONTEXT 20 DOCUMENT_NUMBER 56 DOC_SEQUENCE_VALUE 40 Department 41 Department desc 159 Department with desc 63 ENCUMBRANCE_TYPE 50 ENTERED_AMOUNT 49 ENTERED_CR 48 ENTERED_DR 157 ENTITY_CODE 155 EVENT_DATE 153 EVENT_ID 57 EVENT_TYPE 154 EVENT_TYPE_CODE 115 EXPENDITURE_CATEGORY 113 EXPENDITURE_CLASS_CODE 112 EXPENDITURE_GROUP 118 EXPENDITURE_ITEM_DATE 119 EXPENDITURE_ITEM_QUANTITY 114 EXPENDITURE_STATUS_CODE 116 EXPENDITURE_TYPE 117 EXPENDITURE_TYPE_DESCRIPTION 120 EXPENDITURE_UNIT_OF_MEASURE 172 FLEX_VALUE_SET_ID 77 GL_DATE 173 HAS_ACTIVITY 3 HIERARCHY_LEVEL1 4 HIERARCHY_LEVEL2 5 HIERARCHY_LEVEL3 6 HIERARCHY_LEVEL4 170 HIERARCHY_SEGMENT 93 IBAN_NUMBER 122 INCURRED_BY_EMPLOYEE_NUMBER 121 INCURRED_BY_PERSON 81 INVOICE_AMOUNT 78 INVOICE_CURRENCY -73.0074 INVOICE_CURRENCY_CODE 76 INVOICE_DATE 74 INVOICE_DESCRIPTION 75 INVOICE_LINE_NUMBER 73 INVOICE_NUMBER 104 INVOICE_RULE 137 INV_ACTUAL_UNIT_COST 133 INV_ITEM 134 INV_ITEM_DESCRIPTION 135 INV_ITEM_TYPE 131 INV_ORGANIZATION 132 INV_SUBINVENTORY 130 INV_TRANSACTION_DATE 142 INV_TRANSACTION_ID 138 INV_TRANSACTION_REFERENCE 141 INV_TRANSACTION_SOURCE 139 INV_TRANSACTION_SOURCE_TYPE 140 INV_TRANSACTION_TYPE 136 INV_TRANSACTION_UNIT_COST 147 JE_BATCH_ID 148 JE_HEADER_ID 144 JOURNAL_CREATED_BY 145 JOURNAL_CREATION_DATE 19 JOURNAL_DESCRIPTION 18 JOURNAL_NAME 11 LEDGER 55 LEDGER_CURRENCY 7 LEVEL1 8 LEVEL2 9 LEVEL3 10 LEVEL4 29 LINE_ACCOUNTED_AMOUNT 28 LINE_ACCOUNTED_CR 27 LINE_ACCOUNTED_DR 30 LINE_DESCRIPTION 26 LINE_ENTERED_AMOUNT 25 LINE_ENTERED_CR 24 LINE_ENTERED_DR 22 LINE_NUMBER 109 MDM_PARTY_DESC 108 MDM_PARTY_ID 143 OPERATING_UNIT 126 OPERATION_SEQ_NUM 87 PAYMENT_AMOUNT 88 PAYMENT_AMOUNT_FUNCTIONAL 79 PAYMENT_CURRENCY -73.0075 PAYMENT_CURRENCY_CODE 83 PAYMENT_DATE 80 PAYMENT_METHOD -73.0076 PAYMENT_METHOD_CODE 168 PERIOD 167 PERIOD_DATE 1 PERIOD_NAME 2 PERIOD_NAME_LABEL 17 POSTED_DATE 100 PO_AMOUNT 101 PO_CURRENCY 106 PO_QUANTITY 97 PO_SHIPMENT_NUMBER 99 PRICE 129 PRIMARY_QUANTITY 110 PROJECT 94 PURCHASE_ORDER 96 PURCHASE_ORDER_LINE 46 Product 47 Product desc 161 Product with desc 98 QUANTITY 169 RECORD_TYPE 13 REFERENCE 95 RELEASE 124 RESOURCE_CODE 103 SALESPERSON 102 SALES_ORDER 164 SOURCE_DISTRIBUTION_TYPE 162 SOURCE_ID_INT_1 71 SOURCE_LINE_DESCRIPTION 12 SOURCE_NAME 90 SWIFT_CODE 44 Sub-Account 45 Sub-Account desc 163 Sub-Account with desc 111 TASK 34 TAXABLE_LINE 33 TAX_LINE 32 TAX_RATE 31 TAX_RATE_CODE 21 TAX_STATUS_CODE 51 TRANSACTION_CURRENCY 69 TRANSACTION_DATE 70 TRANSACTION_NUMBER 127 TRANSACTION_QUANTITY 128 TRANSACTION_UOM 107 VENDOR_OR_CUSTOMER 125 WIP_JOB 174 ZERO_BALANCE ACCOUNTED_AMOUNT VALUE 2 SUM ACCOUNT_TYPE FILTER 3 CATEGORY_NAME FILTER 2 ENTERED_AMOUNT VALUE 1 SUM HIERARCHY_LEVEL1 ROW 1 HIERARCHY_LEVEL2 ROW 2 HIERARCHY_LEVEL3 ROW 3 HIERARCHY_LEVEL4 ROW 4 PERIOD_NAME COLUMN 1 SOURCE_NAME FILTER 1 TRANSACTION_CURRENCY COLUMN 2 S Site Pivot by Hierarchy with Activity Account Open/Close Balances Y Pivot by Hierarchy with Account Open/Close Balances (Accounts with Activity only) SYSADMIN 55 ACCOUNTED_AMOUNT 54 ACCOUNTED_CR 53 ACCOUNTED_DR 37 ACCOUNTING_CLASS 158 ACCOUNTING_CLASS_CODE 69 ACCOUNTING_DATE 68 ACCOUNTING_EVENT_DESCRIPTION 167 ACCOUNTING_LINE_CODE 108 ACCOUNTING_RULE 38 ACCOUNT_TYPE 153 AE_HEADER_ID 154 AE_LINE_NUM 36 AMOUNT_INCLUDES_TAX 148 APPLICATION 152 APPLICATION_ID 168 APPLIED_TO_DISTRIBUTION_TYPE 73 ASSET_NUMBER 45 Account 46 Account desc 162 Account with desc 62 BALANCE_TYPE 94 BANK_ACCOUNT_NAME 95 BANK_ACCOUNT_NUM 92 BANK_NAME 16 BATCH_NAME 17 BATCH_STATUS 63 BUDGET_NAME 15 CATEGORY_NAME 170 CHART_OF_ACCOUNTS_ID 88 CHECK_AMOUNT 89 CHECK_CLEARED_AMOUNT 85 CHECK_NUMBER 87 CHECK_STATE 24 CONCATENATED_SEGMENTS 65 CONVERSION_DATE 67 CONVERSION_RATE 66 CONVERSION_TYPE 59 CURRENCY_CONVERSION_DATE 61 CURRENCY_CONVERSION_RATE 60 CURRENCY_CONVERSION_TYPE 39 Company 40 Company desc 160 Company with desc 124 DEPARTMENT_CODE 151 DFF_CONTEXT 21 DOCUMENT_NUMBER 57 DOC_SEQUENCE_VALUE 43 Department 44 Department desc 161 Department with desc 64 ENCUMBRANCE_TYPE 51 ENTERED_AMOUNT 50 ENTERED_CR 49 ENTERED_DR 159 ENTITY_CODE 157 EVENT_DATE 155 EVENT_ID 58 EVENT_TYPE 156 EVENT_TYPE_CODE 116 EXPENDITURE_CATEGORY 114 EXPENDITURE_CLASS_CODE 113 EXPENDITURE_GROUP 119 EXPENDITURE_ITEM_DATE 120 EXPENDITURE_ITEM_QUANTITY 115 EXPENDITURE_STATUS_CODE 117 EXPENDITURE_TYPE 118 EXPENDITURE_TYPE_DESCRIPTION 121 EXPENDITURE_UNIT_OF_MEASURE 171 FLEX_VALUE_SET_ID 80 GL_DATE 172 HAS_ACTIVITY 4 HIERARCHY_LEVEL1 5 HIERARCHY_LEVEL2 6 HIERARCHY_LEVEL3 7 HIERARCHY_LEVEL4 164 HIERARCHY_SEGMENT 96 IBAN_NUMBER 123 INCURRED_BY_EMPLOYEE_NUMBER 122 INCURRED_BY_PERSON 84 INVOICE_AMOUNT 81 INVOICE_CURRENCY -76.0077 INVOICE_CURRENCY_CODE 79 INVOICE_DATE 77 INVOICE_DESCRIPTION 78 INVOICE_LINE_NUMBER 76 INVOICE_NUMBER 107 INVOICE_RULE 138 INV_ACTUAL_UNIT_COST 134 INV_ITEM 135 INV_ITEM_DESCRIPTION 136 INV_ITEM_TYPE 132 INV_ORGANIZATION 133 INV_SUBINVENTORY 131 INV_TRANSACTION_DATE 144 INV_TRANSACTION_ID 139 INV_TRANSACTION_REFERENCE 143 INV_TRANSACTION_SOURCE 141 INV_TRANSACTION_SOURCE_TYPE 142 INV_TRANSACTION_TYPE 137 INV_TRANSACTION_UNIT_COST 149 JE_BATCH_ID 150 JE_HEADER_ID 146 JOURNAL_CREATED_BY 147 JOURNAL_CREATION_DATE 20 JOURNAL_DESCRIPTION 19 JOURNAL_NAME 12 LEDGER 56 LEDGER_CURRENCY 8 LEVEL1 9 LEVEL2 10 LEVEL3 11 LEVEL4 30 LINE_ACCOUNTED_AMOUNT 29 LINE_ACCOUNTED_CR 28 LINE_ACCOUNTED_DR 31 LINE_DESCRIPTION 27 LINE_ENTERED_AMOUNT 26 LINE_ENTERED_CR 25 LINE_ENTERED_DR 23 LINE_NUMBER 75 MDM_PARTY_DESC 74 MDM_PARTY_ID 145 OPERATING_UNIT 127 OPERATION_SEQ_NUM 90 PAYMENT_AMOUNT 91 PAYMENT_AMOUNT_FUNCTIONAL 82 PAYMENT_CURRENCY -76.0078 PAYMENT_CURRENCY_CODE 86 PAYMENT_DATE 83 PAYMENT_METHOD -76.0079 PAYMENT_METHOD_CODE 3 PERIOD 174 PERIOD_DATE 1 PERIOD_NAME 2 PERIOD_NAME_LABEL 18 POSTED_DATE 103 PO_AMOUNT 104 PO_CURRENCY 109 PO_QUANTITY 100 PO_SHIPMENT_NUMBER 102 PRICE 130 PRIMARY_QUANTITY 111 PROJECT 97 PURCHASE_ORDER 99 PURCHASE_ORDER_LINE 47 Product 48 Product desc 163 Product with desc 101 QUANTITY 169 RECORD_TYPE 14 REFERENCE 98 RELEASE 125 RESOURCE_CODE 106 SALESPERSON 105 SALES_ORDER 166 SOURCE_DISTRIBUTION_TYPE 165 SOURCE_ID_INT_1 72 SOURCE_LINE_DESCRIPTION 13 SOURCE_NAME 93 SWIFT_CODE 41 Sub-Account 42 Sub-Account desc 140 Sub-Account with desc 112 TASK 35 TAXABLE_LINE 34 TAX_LINE 33 TAX_RATE 32 TAX_RATE_CODE 22 TAX_STATUS_CODE 52 TRANSACTION_CURRENCY 70 TRANSACTION_DATE 71 TRANSACTION_NUMBER 128 TRANSACTION_QUANTITY 129 TRANSACTION_UOM 110 VENDOR_OR_CUSTOMER 126 WIP_JOB 173 ZERO_BALANCE ACCOUNTED_AMOUNT VALUE 1 SUM ACCOUNT_TYPE FILTER 3 CATEGORY_NAME FILTER 2 HIERARCHY_LEVEL1 ROW 1 HIERARCHY_LEVEL2 ROW 2 HIERARCHY_LEVEL3 ROW 3 HIERARCHY_LEVEL4 ROW 4 PERIOD_NAME_LABEL COLUMN 1 SOURCE_NAME FILTER 1 Show Open/Close Balances Accounts with Activity only S Site Pivot by Hierarchy with All Account Open/Close Balances Y Pivot by Hierarchy with Account Open/Close Balances (All Accounts) SYSADMIN 56 ACCOUNTED_AMOUNT 55 ACCOUNTED_CR 54 ACCOUNTED_DR 38 ACCOUNTING_CLASS 162 ACCOUNTING_CLASS_CODE 70 ACCOUNTING_DATE 69 ACCOUNTING_EVENT_DESCRIPTION 171 ACCOUNTING_LINE_CODE 111 ACCOUNTING_RULE 39 ACCOUNT_TYPE 157 AE_HEADER_ID 158 AE_LINE_NUM 37 AMOUNT_INCLUDES_TAX 152 APPLICATION 156 APPLICATION_ID 172 APPLIED_TO_DISTRIBUTION_TYPE 76 ASSET_NUMBER 46 Account 47 Account desc 166 Account with desc 63 BALANCE_TYPE 97 BANK_ACCOUNT_NAME 98 BANK_ACCOUNT_NUM 95 BANK_NAME 16 BATCH_NAME 17 BATCH_STATUS 64 BUDGET_NAME 15 CATEGORY_NAME 174 CHART_OF_ACCOUNTS_ID 91 CHECK_AMOUNT 92 CHECK_CLEARED_AMOUNT 88 CHECK_NUMBER 90 CHECK_STATE 24 CONCATENATED_SEGMENTS 66 CONVERSION_DATE 68 CONVERSION_RATE 67 CONVERSION_TYPE 60 CURRENCY_CONVERSION_DATE 62 CURRENCY_CONVERSION_RATE 61 CURRENCY_CONVERSION_TYPE 40 Company 41 Company desc 164 Company with desc 128 DEPARTMENT_CODE 155 DFF_CONTEXT 21 DOCUMENT_NUMBER 58 DOC_SEQUENCE_VALUE 44 Department 45 Department desc 165 Department with desc 65 ENCUMBRANCE_TYPE 52 ENTERED_AMOUNT 51 ENTERED_CR 50 ENTERED_DR 163 ENTITY_CODE 161 EVENT_DATE 159 EVENT_ID 59 EVENT_TYPE 160 EVENT_TYPE_CODE 120 EXPENDITURE_CATEGORY 118 EXPENDITURE_CLASS_CODE 117 EXPENDITURE_GROUP 123 EXPENDITURE_ITEM_DATE 124 EXPENDITURE_ITEM_QUANTITY 119 EXPENDITURE_STATUS_CODE 121 EXPENDITURE_TYPE 122 EXPENDITURE_TYPE_DESCRIPTION 125 EXPENDITURE_UNIT_OF_MEASURE 175 FLEX_VALUE_SET_ID 83 GL_DATE 176 HAS_ACTIVITY 4 HIERARCHY_LEVEL1 5 HIERARCHY_LEVEL2 6 HIERARCHY_LEVEL3 7 HIERARCHY_LEVEL4 168 HIERARCHY_SEGMENT 99 IBAN_NUMBER 127 INCURRED_BY_EMPLOYEE_NUMBER 126 INCURRED_BY_PERSON 87 INVOICE_AMOUNT 84 INVOICE_CURRENCY -76.0077 INVOICE_CURRENCY_CODE 82 INVOICE_DATE 80 INVOICE_DESCRIPTION 81 INVOICE_LINE_NUMBER 79 INVOICE_NUMBER 110 INVOICE_RULE 142 INV_ACTUAL_UNIT_COST 138 INV_ITEM 139 INV_ITEM_DESCRIPTION 140 INV_ITEM_TYPE 136 INV_ORGANIZATION 137 INV_SUBINVENTORY 135 INV_TRANSACTION_DATE 148 INV_TRANSACTION_ID 143 INV_TRANSACTION_REFERENCE 147 INV_TRANSACTION_SOURCE 145 INV_TRANSACTION_SOURCE_TYPE 146 INV_TRANSACTION_TYPE 141 INV_TRANSACTION_UNIT_COST 153 JE_BATCH_ID 154 JE_HEADER_ID 150 JOURNAL_CREATED_BY 151 JOURNAL_CREATION_DATE 20 JOURNAL_DESCRIPTION 19 JOURNAL_NAME 12 LEDGER 57 LEDGER_CURRENCY 8 LEVEL1 9 LEVEL2 10 LEVEL3 11 LEVEL4 30 LINE_ACCOUNTED_AMOUNT 29 LINE_ACCOUNTED_CR 28 LINE_ACCOUNTED_DR 32 LINE_DESCRIPTION 27 LINE_ENTERED_AMOUNT 26 LINE_ENTERED_CR 25 LINE_ENTERED_DR 23 LINE_NUMBER 31 LINE_STAT_AMOUNT 78 MDM_PARTY_DESC 77 MDM_PARTY_ID 149 OPERATING_UNIT 131 OPERATION_SEQ_NUM 93 PAYMENT_AMOUNT 94 PAYMENT_AMOUNT_FUNCTIONAL 85 PAYMENT_CURRENCY -76.0078 PAYMENT_CURRENCY_CODE 89 PAYMENT_DATE 86 PAYMENT_METHOD -76.0079 PAYMENT_METHOD_CODE 3 PERIOD 178 PERIOD_DATE 1 PERIOD_NAME 2 PERIOD_NAME_LABEL 18 POSTED_DATE 106 PO_AMOUNT 107 PO_CURRENCY 112 PO_QUANTITY 103 PO_SHIPMENT_NUMBER 105 PRICE 134 PRIMARY_QUANTITY 115 PROJECT 100 PURCHASE_ORDER 102 PURCHASE_ORDER_LINE 48 Product 49 Product desc 167 Product with desc 104 QUANTITY 173 RECORD_TYPE 14 REFERENCE 101 RELEASE 129 RESOURCE_CODE 109 SALESPERSON 108 SALES_ORDER 74 SL_BATCH_NO 73 SL_SOURCE 170 SOURCE_DISTRIBUTION_TYPE 169 SOURCE_ID_INT_1 75 SOURCE_LINE_DESCRIPTION 13 SOURCE_NAME 96 SWIFT_CODE 42 Sub-Account 43 Sub-Account desc 144 Sub-Account with desc 116 TASK 36 TAXABLE_LINE 35 TAX_LINE 34 TAX_RATE 33 TAX_RATE_CODE 22 TAX_STATUS_CODE 53 TRANSACTION_CURRENCY 71 TRANSACTION_DATE 72 TRANSACTION_NUMBER 132 TRANSACTION_QUANTITY 133 TRANSACTION_UOM 113 VENDOR_OR_CUSTOMER 114 VENDOR_OR_CUSTOMER_NUMBER 130 WIP_JOB 177 ZERO_BALANCE ACCOUNTED_AMOUNT VALUE 1 SUM ACCOUNT_TYPE FILTER 3 CATEGORY_NAME FILTER 2 HIERARCHY_LEVEL1 ROW 1 HIERARCHY_LEVEL2 ROW 2 HIERARCHY_LEVEL3 ROW 3 HIERARCHY_LEVEL4 ROW 4 PERIOD_NAME_LABEL COLUMN 1 SOURCE_NAME FILTER 1 Show Open/Close Balances All Accounts excluding zero balances S Site SYSADMIN Pivot by Hierarchy with All Account Open/Close Balances DEVELOPER Pivot by Hierarchy with All Account Open/Close Balances USER Pivot by Hierarchy ENGINATICS Pivot by Hierarchy MRUGESH.POOJARY_OLD Pivot by Hierarchy MOHAMED.GALAL Pivot by Hierarchy