ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US B52C6BB09E788499E0530100007F4F38 FND Flex Hierarchy Y select distinct ffvnh.parent_flex_value value, (select ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end from fnd_flex_values_vl ffvv where ffvnh.flex_value_set_id=ffvv.flex_value_set_id and ffvv.parent_flex_value_low is null and ffvnh.parent_flex_value=ffvv.flex_value)||' ('||nvl2(ffvnh.is_child,null,xxen_util.meaning('TOP','TOP_BOTTOM_PERF',283)||' ')||xxen_util.meaning('CCONTAIN','ICX_CONDITIONS',0)||' '||xxen_util.meaning(ffvnh.max_range_attribute,'RANGE_ATTRIBUTE',0)||')' description, ffvnh.is_child, ffvnh.max_range_attribute from ( select distinct ffvnh.flex_value_set_id, ffvnh.parent_flex_value, (select 'Y' from gl_seg_val_norm_hierarchy gsvnh where ffvnh.parent_flex_value=gsvnh.child_flex_value and ffvnh.flex_value_set_id=gsvnh.flex_value_set_id and rownum=1) is_child, max(ffvnh.range_attribute) over (partition by ffvnh.parent_flex_value) max_range_attribute from fnd_flex_value_norm_hierarchy ffvnh where ffvnh.flex_value_set_id in ( select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set union all select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) ) ) ffvnh order by ffvnh.is_child desc, ffvnh.max_range_attribute desc, length(ffvnh.parent_flex_value), ffvnh.parent_flex_value US 8E2FF36EDED379D2E0530100007F1FF2 GL Account Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ACCOUNT_TYPE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'L',2,'O',3,'R',4,'E',5,'C',6,'D',7) US 8E2FF36EDF3C79D2E0530100007F1FF2 GL Balance Type Y select flvv.description value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 order by flvv.lookup_code US B16C8DB2BC207B92E0530100007F1372 GL Batch Y Y select distinct gjb.name value, gjb.description from gl_je_batches gjb where gjb.je_batch_id in (select gjh.je_batch_id from gl_je_headers gjh where (:$flex$.journal is null or gjh.name=:$flex$.journal) and gjh.ledger_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y'))) order by gjb.name US E0594F170E1998F5E0530100007F6EA3 GL Budget Name Y select gbv.budget_name value, gbv.budget_type || ' (' || xxen_util.meaning(gbv.status,'PLAN/VERSION STATUS',101) || ')' description from gl_ledgers gl, gl_budgets gb, gl_budget_versions gbv where gl.ledger_id=gb.ledger_id and gb.budget_name=gbv.budget_name and gb.budget_type=gbv.budget_type and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='B' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) ) order by value US 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 fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where ( xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) order by min_id_flex_num, min_segment_num US 8E2FF36EDECC79D2E0530100007F1FF2 GL Segment1 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US B3D07BBAC1A645D7E0530100007FB1B8 GL Segment10 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT10' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDECD79D2E0530100007F1FF2 GL Segment2 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDECE79D2E0530100007F1FF2 GL Segment3 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDECF79D2E0530100007F1FF2 GL Segment4 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDED079D2E0530100007F1FF2 GL Segment5 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDED179D2E0530100007F1FF2 GL Segment6 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT6' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDED279D2E0530100007F1FF2 GL Segment7 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT7' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US B3D07BBAC1A245D7E0530100007FB1B8 GL Segment8 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT8' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US B3D07BBAC1A545D7E0530100007FB1B8 GL Segment9 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT9' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) order by ffvv.flex_value Concatenate (inactive) to the description of inactive segment values US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 8239B077F696605AE053B46B63587AFE 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' end has_activity, case when max(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, gjcv.user_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, xxen_util.meaning(gjh.tax_status_code,'TAX_STATUS',101) tax_status_code, gjl.je_line_num line_number, gcck.concatenated_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, null, gcck.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') concatenated_segments_desc, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id) then gjl.entered_dr end line_entered_dr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id) then gjl.entered_cr end line_entered_cr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id) then nvl(gjl.entered_dr,0)-nvl(gjl.entered_cr,0) end line_entered_amount, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id) then gjl.accounted_dr end line_accounted_dr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id) then gjl.accounted_cr end line_accounted_cr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id) then nvl(gjl.accounted_dr,0)-nvl(gjl.accounted_cr,0) end line_accounted_amount, gjl.description line_description, zrb.tax_rate_code, 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 case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then nvl2(xal.gl_sl_link_id,xal.entered_dr,gjl.entered_dr) end entered_dr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then nvl2(xal.gl_sl_link_id,xal.entered_cr,gjl.entered_cr) end entered_cr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then 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) end entered_amount, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code) end transaction_currency, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then nvl2(xal.gl_sl_link_id,xal.accounted_dr,gjl.accounted_dr) end accounted_dr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then nvl2(xal.gl_sl_link_id,xal.accounted_cr,gjl.accounted_cr) end accounted_cr, case when 1=row_number() over (partition by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num order by gjl.je_header_id,gjl.je_line_num,xal.gl_sl_link_id,xal.ae_header_id,xal.ae_line_num) then nvl(nvl2(xal.gl_sl_link_id,xal.accounted_dr,gjl.accounted_dr),0)-nvl(nvl2(xal.gl_sl_link_id,xal.accounted_cr,gjl.accounted_cr),0) end accounted_amount, gl.currency_code ledger_currency, &revaluation_columns (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 gjh.encumbrance_type_id=get.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, -- Document Sequences gjh.doc_sequence_id document_seq_id, (select fds.name from fnd_document_sequences fds where gjh.doc_sequence_id=fds.doc_sequence_id) document_seq_name, gjh.doc_sequence_value document_seq_value, nvl(gjl.subledger_doc_sequence_id,xah.doc_sequence_id) sub_doc_seq_id, (select fds.name from fnd_document_sequences fds where nvl(gjl.subledger_doc_sequence_id,xah.doc_sequence_id)=fds.doc_sequence_id) sub_doc_seq_name, nvl(gjl.subledger_doc_sequence_value,xah.doc_sequence_value) sub_doc_seq_val, gjh.close_acct_seq_value gl_close_acct_seq_val, xah.close_acct_seq_value sl_close_acct_seq_val, nvl2(xe.event_id,xah.close_acct_seq_value,gjh.close_acct_seq_value) reporting_seq, nvl2(xal.gl_sl_link_id,xal.jgzz_recon_ref,(select gjlr.jgzz_recon_ref from gl_je_lines_recon gjlr where gjl.je_header_id=gjlr.je_header_id and gjl.je_line_num=gjlr.je_line_num)) reconciliation_reference, &dff_cols 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, --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 nvl(aia.invoice_num,rcta.trx_number) invoice_number, nvl(aia.description,rcta.comments) description, nvl(aia.invoice_date,rcta.trx_date) invoice_date, aia.gl_date, nvl(aia.invoice_currency_code,rcta.invoice_currency_code) invoice_currency, aia.payment_currency_code payment_currency, nvl(xxen_util.meaning(aia.payment_method_code,'PAYMENT METHOD',200),aia.payment_method_code) payment_method, coalesce(aia.invoice_amount,apsa.amount_due_original) invoice_amount, pha.segment1 purchase_order, pha.comments po_description, pra.release_num release, rt.quantity po_quantity, prha.segment1 requisition, prla.line_num requisition_line, 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=rule_id) invoice_rule, (select rr.name from ra_customer_trx_lines_all rctla, ra_rules rr where rcta.customer_trx_id=rctla.customer_trx_id and rctla.line_type='LINE' and rctla.accounting_rule_id=rr.rule_id and rownum=1) accounting_rule, coalesce(aps.segment1,hca.account_number) vendor_or_customer_number, coalesce(aps.vendor_name,hp.party_name) vendor_or_customer_name, coalesce(assa.vendor_site_code,hcsua.location) vendor_or_customer_site, acra.receipt_number cash_receipt_number, --Projects coalesce(ppa.segment1,case when xte.application_id=222 and xte.entity_code='TRANSACTIONS' and rcta.interface_header_context='PROJECTS INVOICES' then rcta.interface_header_attribute1 end) 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 employee_name, nvl(papf.employee_number,papf.npw_number) employee_number, --Payroll (select pjv.name from per_jobs_vl pjv where paaf.job_id=pjv.job_id) job, (select hapft.name from hr_all_positions_f_tl hapft where paaf.position_id=hapft.position_id and hapft.language=userenv('lang')) position, (select haouv.name from hr_all_organization_units_vl haouv where paaf.organization_id=haouv.organization_id) assignment_organization, --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, 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 mmt.transaction_source_id=mcch.cycle_count_header_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 prha.segment1 --Requisition when mmt.transaction_source_type_id=5 then we.wip_entity_name --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, mmt.transaction_id inv_transaction_id, cwo.comments write_off_comments, (select haouv.name from hr_all_organization_units_vl haouv where coalesce( aca.org_id, aia.org_id, assa.org_id, aaa.org_id, acra.org_id, apsa.org_id, hca.org_id, hcsua.org_id, rcta.org_id, oola.org_id, paa.org_id, pdra.org_id, pea.org_id, peia.org_id, ppa.org_id, pha.org_id, pra.org_id, prha.org_id, prla.org_id, gjb.org_id, cwo.operating_unit_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, decode(xal.party_type_code, 'C',xal.party_type_code||'-'||nvl(hp.party_name,'UNKNOWN')||'-'||nvl(hcsua.location,'0'), 'S',xal.party_type_code||'-'||nvl(aps.vendor_name,'UNKNOWN')||'-'||nvl(assa.vendor_site_code,'0') ) 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, xal.accounting_class_code, xte.entity_code, &segments_with_desc &contra_account_segments &hierarchy_segment xte.source_id_int_1, gp.start_date period_date, gp.period_name period, 'Journal' record_type, gcck.chart_of_accounts_id, ( select distinct 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, gl_je_categories_vl gjcv, (select gir.* from gl_import_references gir where gir.gl_sl_link_table in ('XLAJEL','APECL') and gir.gl_sl_link_id is not null) gir, xla_ae_lines xal, xla_ae_headers xah, xla_events xe, xla.xla_transaction_entities xte, gcck, (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_transaction_headers fth, fa_additions_b fab, ap_invoices_all aia, (select distinct aida.invoice_id, min(aida.task_id) keep (dense_rank first order by aida.invoice_distribution_id) over (partition by aida.invoice_id) task_id from ap_invoice_distributions_all aida where aida.task_id is not null) aida0, (select (select distinct max(aipa.invoice_id) keep (dense_rank last order by aipa.invoice_payment_id) over () invoice_id from ap_invoice_payments_all aipa where aca.check_id=aipa.check_id) max_aipa_invoice_id, aca.* from ap_checks_all aca) aca, ap_batches_all aba, po_headers_all pha, po_releases_all pra, po_requisition_headers_all prha, po_requisition_lines_all prla, ap_suppliers aps, ap_supplier_sites_all assa, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, ra_customer_trx_all rcta, ra_batch_sources_all rbsa, ra_batches_all rba, (select apsa.customer_trx_id, apsa.org_id, sum(apsa.amount_due_original) amount_due_original from ar_payment_schedules_all apsa group by apsa.customer_trx_id, apsa.org_id) apsa, jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev, ar_adjustments_all aaa, (select (select araa.customer_trx_id from ar_receivable_applications_all araa where acra.cash_receipt_id=araa.cash_receipt_id and araa.display='Y' and araa.status='APP' and rownum=1) customer_trx_id, acra.* from ar_cash_receipts_all acra) 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_budget_versions pbv, pa_draft_revenues_all pdra, pa_agreements_all paa, pa_expenditure_items_all peia, pa_expenditures_all pea, pa_expenditure_types pet, per_all_people_f papf, pay_assignment_actions paa, per_all_assignments_f paaf, 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, --OPM --Inventory mtl_material_transactions mmt, mtl_system_items_vl msiv, mtl_parameters mp, mtl_transaction_types mtt, mtl_txn_source_types mtst, (select (select fspa.inventory_organization_id from financials_system_params_all fspa where cwo.operating_unit_id=fspa.org_id) organization_id, cwo.* from cst_write_offs cwo) cwo, po_distributions_all pda, ap_invoice_distributions_all aida, 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 gjh.je_source=gjsv.je_source_name and gjh.je_category=gjcv.je_category_name and gjl.je_header_id=gir.je_header_id(+) and gjl.je_line_num=gir.je_line_num(+) and gir.gl_sl_link_id=xal.gl_sl_link_id(+) and gir.gl_sl_link_table=xal.gl_sl_link_table(+) and xal.ae_header_id=xah.ae_header_id(+) and xal.application_id=xah.application_id(+) and xah.gl_transfer_status_code(+)='Y' and xah.accounting_entry_status_code(+)='F' and xah.event_id=xe.event_id(+) and xah.application_id=xe.application_id(+) and xah.entity_id=xte.entity_id(+) and xah.application_id=xte.application_id(+) and &gl_flex_value_security gjl.code_combination_id=gcck.code_combination_id 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 xte.application_id=140 and xte.entity_code='TRANSACTIONS' then xte.source_id_int_1 end=fth.transaction_header_id(+) and case when xte.application_id=140 then case when xte.entity_code in ('DEPRECIATION','DEFERRED_DEPRECIATION') then xte.source_id_int_1 when xte.entity_code='TRANSACTIONS' then fth.asset_id end end=fab.asset_id(+) and coalesce(case when xte.application_id=200 then decode(xte.entity_code,'AP_INVOICES',xte.source_id_int_1,'AP_PAYMENTS',aca.max_aipa_invoice_id) end,aida.invoice_id)=aia.invoice_id(+) and aia.invoice_id=aida0.invoice_id(+) and case when xte.application_id=200 and xte.entity_code='AP_PAYMENTS' then xte.source_id_int_1 end=aca.check_id(+) and aia.batch_id=aba.batch_id(+) and coalesce(case when xte.application_id=201 and xte.entity_code='PURCHASE_ORDER' then xte.source_id_int_1 end,pra.po_header_id,aia.quick_po_header_id,rt.po_header_id,wt.po_header_id,decode(mmt.transaction_source_type_id,1,mmt.transaction_source_id),pda.po_header_id)=pha.po_header_id(+) and coalesce(case when xte.application_id=201 and xte.entity_code='RELEASE' then xte.source_id_int_1 end,rt.po_release_id)=pra.po_release_id(+) and coalesce(case when xte.application_id=201 and xte.entity_code='REQUISITION' then xte.source_id_int_1 end,prla.requisition_header_id,decode(mmt.transaction_source_type_id,7,mmt.transaction_source_id))=prha.requisition_header_id(+) and rt.requisition_line_id=prla.requisition_line_id(+) and coalesce(decode(xal.party_type_code,'S',xal.party_id),aia.vendor_id,aca.vendor_id,rt.vendor_id,pha.vendor_id,cwo.vendor_id)=aps.vendor_id(+) and decode(xal.party_type_code,'S',xal.party_site_id)=assa.party_site_id(+) and coalesce(decode(xal.party_type_code,'C',xal.party_id),rcta.bill_to_customer_id,acra.pay_from_customer,paa.customer_id,oola.sold_to_org_id)=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and decode(xal.party_type_code,'C',xal.party_site_id)=hcsua.site_use_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.customer_trx_id=apsa.customer_trx_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 coalesce(case when xte.application_id=275 then decode(xte.entity_code,'REVENUE',xte.source_id_int_1,'EXPENDITURES',peia.project_id) end,pbv.project_id,pdra.project_id,pt.project_id)=ppa.project_id(+) and case when xte.application_id=275 and xte.entity_code='BUDGETS' then xte.source_id_int_1 end=pbv.budget_version_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(aida0.task_id,peia.task_id)=pt.task_id(+) and peia.expenditure_id=pea.expenditure_id(+) and peia.expenditure_type=pet.expenditure_type(+) and coalesce(pea.incurred_by_person_id,paaf.person_id)=papf.person_id(+) and nvl(peia.expenditure_item_date,case when xte.application_id=801 and xte.entity_code='ASSIGNMENTS' then fnd_date.canonical_to_date(xte.source_id_char_1) end)>=papf.effective_start_date(+) and nvl(peia.expenditure_item_date,case when xte.application_id=801 and xte.entity_code='ASSIGNMENTS' then fnd_date.canonical_to_date(xte.source_id_char_1) end)-1<papf.effective_end_date(+) and case when xte.application_id=801 and xte.entity_code='ASSIGNMENTS' then xte.source_id_int_1 end=paa.assignment_action_id(+) and paa.assignment_id=paaf.assignment_id(+) and case when xte.application_id=801 and xte.entity_code='ASSIGNMENTS' then fnd_date.canonical_to_date(xte.source_id_char_1) end between paaf.effective_start_date(+) and paaf.effective_end_date(+) and coalesce(case when xte.application_id=707 and xte.entity_code='RCV_ACCOUNTING_EVENTS' then xte.source_id_int_1 when xte.application_id=555 and gxeh.event_class_code='RECEIVE' then gxeh.source_line_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 coalesce(wt.wip_entity_id,decode(mmt.transaction_source_type_id,5,mmt.transaction_source_id))=we.wip_entity_id(+) and wt.department_id=bd.department_id(+) and wt.resource_id=br.resource_id(+) and case when xah.application_id=555 then xah.event_id end=gxeh.event_id(+) and --Inventory coalesce(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,cwo.inventory_transaction_id)=mmt.transaction_id(+) and coalesce(mmt.organization_id,gxeh.organization_id,rsl.to_organization_id,we.organization_id,cwo.organization_id)=msiv.organization_id(+) and coalesce(mmt.inventory_item_id,gxeh.inventory_item_id,rsl.item_id,we.primary_item_id,cwo.inventory_item_id)=msiv.inventory_item_id(+) and coalesce(mmt.organization_id,gxeh.organization_id,rt.organization_id,rsl.to_organization_id,we.organization_id)=mp.organization_id(+) and mmt.transaction_type_id=mtt.transaction_type_id(+) and mmt.transaction_source_type_id=mtst.transaction_source_type_id(+) and case when xte.application_id=707 and xte.entity_code='WO_ACCOUNTING_EVENTS' then xte.source_id_int_1 end=cwo.write_off_id(+) and cwo.po_distribution_id=pda.po_distribution_id(+) and cwo.invoice_distribution_id=aida.invoice_distribution_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 tax_status_code, null line_number, gcck.concatenated_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, null, gcck.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') concatenated_segments_desc, 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_description, null tax_rate_code, 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 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, -- Document Sequences null document_seq_id, null document_seq_name, null document_seq_value, null sub_doc_seq_id, null sub_doc_seq_name, null sub_doc_seq_val, null gl_close_acct_seq_val, null sl_close_acct_seq_val, null reporting_seq, null reconciliation_reference, &dff_cols_null null sl_source, null sl_batch_no, --Assets null asset_number, null expense_account, --AP null invoice_number, null description, null invoice_date, null gl_date, null invoice_currency_code, null payment_currency_code, null payment_method_code, null invoice_amount, null purchase_order, null po_description, null release, null po_quantity, null requisition, null requisition_line, null goods_receipt_number, --AR null sales_order, null salesperson, null invoice_rule, null accounting_rule, null vendor_or_customer_number, null vendor_or_customer_name, null vendor_or_customer_site, null cash_receipt_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 employee_name, null employee_number, --Payroll null job, null position, null assignment_organization, --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_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, null inv_transaction_id, null write_off_comments, 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, null accounting_class_code, null entity_code, &segments_with_desc &contra_account_segments2 &hierarchy_segment null source_id_int_1, gp.start_date-1 period_date, gp.period_name period, 'Balance' record_type, gcck.chart_of_accounts_id, ( select distinct 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 tax_status_code, null line_number, gcck.concatenated_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, null, gcck.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') concatenated_segments_desc, 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_description, null tax_rate_code, 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 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, -- Document Sequences null document_seq_id, null document_seq_name, null document_seq_value, null sub_doc_seq_id, null sub_doc_seq_name, null sub_doc_seq_val, null gl_close_acct_seq_val, null sl_close_acct_seq_val, null reporting_seq, null reconciliation_reference, &dff_cols_null null sl_source, null sl_batch_no, --Assets null asset_number, null expense_account, --AP null invoice_number, null description, null invoice_date, null gl_date, null invoice_currency_code, null payment_currency_code, null payment_method_code, null invoice_amount, null purchase_order, null po_description, null release, null po_quantity, null requisition, null requisition_line, null goods_receipt_number, --AR null sales_order, null salesperson, null invoice_rule, null accounting_rule, null vendor_or_customer_number, null vendor_or_customer_name, null vendor_or_customer_site, null cash_receipt_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 employee_name, null employee_number, --Payroll null job, null position, null assignment_organization, --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_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, null inv_transaction_id, null write_off_comments, 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, null accounting_class_code, null entity_code, &segments_with_desc &contra_account_segments2 &hierarchy_segment null source_id_int_1, gp.end_date period_date, gp.period_name period, 'Balance' record_type, gcck.chart_of_accounts_id, ( select distinct 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 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 for non-mmt OPM cases 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) AR GL Account Analysis تقرير حركة دفتر الأستاذ العام بالتفصيل مع سطر واحد لكل معاملة بما في ذلك جميع القطاعات وبيانات دفتر الأستاذ الفرعي ، مع المبالغ بعملة المعاملة وعملة دفتر الأستاذ. الرجاء إدخال فترة ، تاريخ مرحل ، دفعة أو قيد دفتر اليومية D GL Account Analysis Detaillierter GL-Transaktionsbericht mit einer Zeile pro Transaktion einschließlich aller Segmente und Nebenbuchdaten, mit Beträgen in Transaktions- und Ledgerwährung. Bitte geben Sie eine Periode, ein Buchungsdatum, eine Charge oder eine Journaleinschränkung ein E GL Account Analysis Informe detallado de las transacciones del Libro Mayor con una línea por transacción que incluye todos los segmentos y los datos del libro auxiliar, con importes tanto en la moneda de la transacción como en la moneda del libro mayor. Introduzca un período, una fecha de contabilización, un lote o una restricción del diario F GL Account Analysis Rapport détaillé des transactions de GL avec une ligne par transaction comprenant tous les segments et les données du grand livre auxiliaire, avec des montants dans la devise de la transaction et dans la devise du grand livre. Veuillez saisir une période, une date d'affichage, un lot ou une restriction de journal I GL Account Analysis Rapporto dettagliato sulle transazioni GL con una riga per transazione che include tutti i segmenti e i dati subledger, con importi sia in valuta della transazione che in valuta del libro mastro. Inserisci un periodo, una data di registrazione, un lotto o una restrizione del giornale JA GL Account Analysis トランザクション通貨と元帳通貨の両方の金額を含む、すべてのセグメントとサブレッジャーデータを含む、トランザクションごとに1行の詳細なGLトランザクションレポート。 期間、投稿日、一括または仕訳制限を入力してください。 KO GL Account Analysis 모든 세그먼트 및 보조 원장 데이터를 포함하여 거래 당 하나의 라인이있는 상세 GL 거래 보고서 (거래 통화 및 원장 통화 금액 모두 포함). 기간, 전기 일, 배치 또는 분개 제한을 입력하십시오. PTB GL Account Analysis Relatório detalhado da transação GL com uma linha por transação incluindo todos os segmentos e dados do livro auxiliar, com valores tanto na moeda da transação quanto na moeda do livro auxiliar. Favor entrar um período, data de lançamento, lote ou restrição de diário RU GL Account Analysis Подробный отчет по транзакциям GL с одной строкой на транзакцию, включая все сегменты и данные суб-субрегистрации, с суммами как в валюте транзакции, так и в валюте бухгалтерской книги. Пожалуйста, укажите период, дату публикации, ограничение на партию или журнал. S GL Account Analysis Detaljerad GL-transaktionsrapport med en rad per transaktion inklusive alla segment och underlagsdata, med belopp i både transaktionsvaluta och huvudvaluta. Vänligen ange en period, bokfört datum, batch- eller journalrestriktion TR GL Account Analysis Hem işlem para birimi hem de genel muhasebe para birimi cinsinden tutarlarla birlikte tüm segmentler ve yardımcı defter verilerini içeren işlem başına bir satır içeren ayrıntılı GL işlem raporu. Lütfen bir dönem, yayınlanma tarihi, parti veya yevmiye kısıtlaması girin US GL Account Analysis Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. Please enter a period, posted date, batch or journal restriction ZHS GL Account Analysis 详细的GL交易报告，每笔交易只有一行，包括所有分部和子分类账数据，金额以交易货币和分类账货币表示。 请输入时期、发布日期、批次或期刊限制。 Enginatics R12 only &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 -50 1=1 select xxen_fsg.multiple_periods_where_clause(:multiple_periods_string,:ledger) from dual Char US Multiple Periods String 2 -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 3 -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 4 -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 5 &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 US Hierarchy Segment Column 6 &hierarchy_segment gcck.<parameter_value> hierarchy_segment, US Hierarchy Segment Column 7 7=7 gcck.<parameter_value>=ffv.flex_value US Hierarchy Segment Column 8 -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 9 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 10 &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 11 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 12 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 13 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 14 50 3=3 gjh.posted_date>=:posted_date_from Date F Date d'entrée en vigueur US Posted Date From 15 60 3=3 gjh.posted_date<:posted_date_to+1 Date F Date de publication au US Posted Date To 16 70 3=3 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 17 80 3=3 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 18 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 19 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 20 110 3=3 gjl.je_line_num=:journal_line Number US Journal Line 21 120 1=1 gcck.gl_account_type=xxen_util.lookup_code(:account_type,'ACCOUNT_TYPE',0) LOV GL Account Type 8E2FF36EDED379D2E0530100007F1FF2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ACCOUNT_TYPE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'L',2,'O',3,'R',4,'E',5,'C',6,'D',7) F Type de compte US Account Type 22 130 &hierarchy_levels select 'regexp_substr(x.path,''[^|]+'',1,'||x.column_value||') level'||x.column_value||',' text from table(xxen_util.rowgen(:max_hierarchy_levels)) x LOV GL Segment C428002B0F22099BE0530100007FE0E4 Y select distinct fifsv.form_left_prompt value, lower(fifsv.application_column_name) description, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.flex_value_set_id in (select ffvnh.flex_value_set_id from fnd_flex_value_norm_hierarchy ffvnh) and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where ( xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) order by min_id_flex_num, min_segment_num select min(fifsv.form_left_prompt) from fnd_segment_attribute_values fsav, fnd_id_flex_segments_vl fifsv where fsav.application_id=101 and fsav.id_flex_code='GL#' and fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where (gl.ledger_category_code=:$flex$.ledger_category or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) and fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y' and fsav.application_id=fifsv.application_id and fsav.id_flex_code=fifsv.id_flex_code and fsav.id_flex_num=fifsv.id_flex_num and fsav.application_column_name=fifsv.application_column_name F Segment de la hiérarchie US Hierarchy Segment 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) F Segment de la hiérarchie US Hierarchy Segment 25 140 :parent_flex_value LOV FND Flex Hierarchy B52C6BB09E788499E0530100007F4F38 Y select distinct ffvnh.parent_flex_value value, (select ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end from fnd_flex_values_vl ffvv where ffvnh.flex_value_set_id=ffvv.flex_value_set_id and ffvv.parent_flex_value_low is null and ffvnh.parent_flex_value=ffvv.flex_value)||' ('||nvl2(ffvnh.is_child,null,xxen_util.meaning('TOP','TOP_BOTTOM_PERF',283)||' ')||xxen_util.meaning('CCONTAIN','ICX_CONDITIONS',0)||' '||xxen_util.meaning(ffvnh.max_range_attribute,'RANGE_ATTRIBUTE',0)||')' description, ffvnh.is_child, ffvnh.max_range_attribute from ( select distinct ffvnh.flex_value_set_id, ffvnh.parent_flex_value, (select 'Y' from gl_seg_val_norm_hierarchy gsvnh where ffvnh.parent_flex_value=gsvnh.child_flex_value and ffvnh.flex_value_set_id=gsvnh.flex_value_set_id and rownum=1) is_child, max(ffvnh.range_attribute) over (partition by ffvnh.parent_flex_value) max_range_attribute from fnd_flex_value_norm_hierarchy ffvnh where ffvnh.flex_value_set_id in ( select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set union all select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') ) ) ) ffvnh order by ffvnh.is_child desc, ffvnh.max_range_attribute desc, length(ffvnh.parent_flex_value), ffvnh.parent_flex_value select distinct max(x.parent_flex_value) keep (dense_rank last order by x.count) over () parent_flex_value from ( select distinct ffvh.parent_flex_value, count(*) over (partition by ffvh.parent_flex_value) count from fnd_flex_value_hierarchies ffvh where ffvh.flex_value_set_id in ( select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set union all select fifsv.flex_value_set_id from fnd_id_flex_segments_vl fifsv where fifsv.form_left_prompt=:$flex$.hierarchy_segment and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or xxen_util.contains(:$flex$.ledger,gl.name)='Y') ) ) x F Nom de la hiérarchie US Hierarchy Name 26 150 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 160 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 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT1 31 &materialize_hint /*+ materialize*/ US GL_SEGMENT1 32 170 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 33 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT1 From 34 &materialize_hint /*+ materialize*/ US GL_SEGMENT1 From 35 180 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 36 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT1 To 37 &materialize_hint /*+ materialize*/ US GL_SEGMENT1 To 38 190 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 39 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT2 40 &materialize_hint /*+ materialize*/ US GL_SEGMENT2 41 200 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 42 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT2 From 43 &materialize_hint /*+ materialize*/ US GL_SEGMENT2 From 44 210 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 45 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT2 To 46 &materialize_hint /*+ materialize*/ US GL_SEGMENT2 To 47 220 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 48 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT3 49 &materialize_hint /*+ materialize*/ US GL_SEGMENT3 50 230 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 51 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT3 From 52 &materialize_hint /*+ materialize*/ US GL_SEGMENT3 From 53 240 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 54 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT3 To 55 &materialize_hint /*+ materialize*/ US GL_SEGMENT3 To 56 250 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 57 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT4 58 &materialize_hint /*+ materialize*/ US GL_SEGMENT4 59 260 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 60 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT4 From 61 &materialize_hint /*+ materialize*/ US GL_SEGMENT4 From 62 270 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 63 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT4 To 64 &materialize_hint /*+ materialize*/ US GL_SEGMENT4 To 65 280 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 66 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT5 67 &materialize_hint /*+ materialize*/ US GL_SEGMENT5 68 290 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 69 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT5 From 70 &materialize_hint /*+ materialize*/ US GL_SEGMENT5 From 71 300 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 72 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT5 To 73 &materialize_hint /*+ materialize*/ US GL_SEGMENT5 To 74 310 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 75 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT6 76 &materialize_hint /*+ materialize*/ US GL_SEGMENT6 77 320 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 78 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT6 From 79 &materialize_hint /*+ materialize*/ US GL_SEGMENT6 From 80 330 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 81 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT6 To 82 &materialize_hint /*+ materialize*/ US GL_SEGMENT6 To 83 340 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 84 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT7 85 &materialize_hint /*+ materialize*/ US GL_SEGMENT7 86 350 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 87 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT7 From 88 &materialize_hint /*+ materialize*/ US GL_SEGMENT7 From 89 360 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 90 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT7 To 91 &materialize_hint /*+ materialize*/ US GL_SEGMENT7 To 92 370 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 93 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT8 94 &materialize_hint /*+ materialize*/ US GL_SEGMENT8 95 380 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 96 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT8 From 97 &materialize_hint /*+ materialize*/ US GL_SEGMENT8 From 98 390 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 99 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT8 To 100 &materialize_hint /*+ materialize*/ US GL_SEGMENT8 To 101 400 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 102 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT9 103 &materialize_hint /*+ materialize*/ US GL_SEGMENT9 104 410 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 105 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT9 From 106 &materialize_hint /*+ materialize*/ US GL_SEGMENT9 From 107 420 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 108 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT9 To 109 &materialize_hint /*+ materialize*/ US GL_SEGMENT9 To 110 430 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 111 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT10 112 &materialize_hint /*+ materialize*/ US GL_SEGMENT10 113 440 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 114 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT10 From 115 &materialize_hint /*+ materialize*/ US GL_SEGMENT10 From 116 450 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 117 &leading_hint /*+ leading(gl gp gcck gjl)*/ US GL_SEGMENT10 To 118 &materialize_hint /*+ materialize*/ US GL_SEGMENT10 To 119 460 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 120 3=3 gjh.status not in ('P','U') xxen_util.meaning('E','VALIDATION_STATUS',101) F Statut US Status 121 470 3=3 nvl2(xal.gl_sl_link_id,xal.currency_code,gjh.currency_code)=:transaction_currency LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US Transaction Currency 122 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 123 &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 124 &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 125 &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 126 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 127 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 128 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 129 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 130 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 131 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 132 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 133 530 3=3 nvl(nvl2(xal.gl_sl_link_id,xal.accounted_dr,gjl.accounted_dr),0)-nvl(nvl2(xal.gl_sl_link_id,xal.accounted_cr,gjl.accounted_cr),0)<>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 134 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 :p_show_seg_desc is not null and 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 135 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 136 6=6 y.has_activity='Y' Accounts with Activity only F Afficher les soldes ouverts/fermés US Show Open/Close Balances 137 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 138 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 139 &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 140 &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 141 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 142 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 143 &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 144 580 &dff_cols select xxen_util.dff_columns(p_table_name=>'ap_invoices_all', p_column_name_prefix=>'AI ') 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 145 &dff_cols_null select xxen_util.dff_columns(p_table_name=>'ap_invoices_all', p_column_name_prefix=>'AI ', p_prefix=>'null ') sql_text from dual US Show Invoice DFF Attributes 146 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. 147 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 148 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 58ADCC23FFD06AA38E049DF081544709 Andy's template ANDY.HAACK 14 CATEGORY_NAME 1 HIERARCHY_LEVEL1 2 HIERARCHY_LEVEL2 3 HIERARCHY_LEVEL3 4 HIERARCHY_LEVEL4 11 LEDGER 5 LEVEL1 6 LEVEL2 7 LEVEL3 8 LEVEL4 9 PERIOD_NAME 10 PERIOD_NAME_LABEL 13 REFERENCE 12 SOURCE_NAME S Site 552CA5E19EEC287004F53A78571F7C18 Pivot by Account Hierarchy Y SYSADMIN 53 ACCOUNTED_AMOUNT 52 ACCOUNTED_CR 51 ACCOUNTED_DR 35 ACCOUNTING_CLASS 155 ACCOUNTING_CLASS_CODE 66 ACCOUNTING_DATE 65 ACCOUNTING_EVENT_DESCRIPTION 98 ACCOUNTING_RULE 36 ACCOUNT_TYPE 150 AE_HEADER_ID 151 AE_LINE_NUM -76.0098 AI Misc Vendor Address -76.0099 AI Misc Vendor City -76.0097 AI Misc Vendor Name -76.01 AI Misc Vendor State -76.0101 AI Misc Vendor Zip 34 AMOUNT_INCLUDES_TAX 145 APPLICATION 149 APPLICATION_ID 81 ASSET_NUMBER 119 ASSIGNMENT_ORGANIZATION 41 Account 42 Account desc 159 Account with desc 59 BALANCE_TYPE 15 BATCH_NAME 16 BATCH_STATUS 60 BUDGET_NAME 14 CATEGORY_NAME 164 CHART_OF_ACCOUNTS_ID 22 CONCATENATED_SEGMENTS 23 CONCATENATED_SEGMENTS_DESC 62 CONVERSION_DATE 64 CONVERSION_RATE 63 CONVERSION_TYPE 56 CURRENCY_CONVERSION_DATE 58 CURRENCY_CONVERSION_RATE 57 CURRENCY_CONVERSION_TYPE 37 Company 38 Company desc 157 Company with desc 120 DEPARTMENT_CODE 83 DESCRIPTION 148 DFF_CONTEXT 69 DOCUMENT_SEQ_ID 70 DOCUMENT_SEQ_NAME 71 DOCUMENT_SEQ_VALUE 39 Department 40 Department desc 158 Department with desc 115 EMPLOYEE_NAME 116 EMPLOYEE_NUMBER 61 ENCUMBRANCE_TYPE 49 ENTERED_AMOUNT 48 ENTERED_CR 47 ENTERED_DR 156 ENTITY_CODE 154 EVENT_DATE 152 EVENT_ID 55 EVENT_TYPE 153 EVENT_TYPE_CODE 109 EXPENDITURE_CATEGORY 107 EXPENDITURE_CLASS_CODE 106 EXPENDITURE_GROUP 112 EXPENDITURE_ITEM_DATE 113 EXPENDITURE_ITEM_QUANTITY 108 EXPENDITURE_STATUS_CODE 110 EXPENDITURE_TYPE 111 EXPENDITURE_TYPE_DESCRIPTION 114 EXPENDITURE_UNIT_OF_MEASURE 166 FLEX_VALUE_SET_ID -34.0037 Future1 -34.0038 Future1 desc -180.0182 Future1 with desc -34.0039 Future2 -34.004 Future2 desc -180.0183 Future2 with desc -34.0041 Future3 -34.0042 Future3 desc -180.0184 Future3 with desc -34.0043 Future4 -34.0044 Future4 desc -180.0185 Future4 with desc 75 GL_CLOSE_ACCT_SEQ_VAL 85 GL_DATE 168 HAS_ACTIVITY 1 HIERARCHY_LEVEL1 2 HIERARCHY_LEVEL2 3 HIERARCHY_LEVEL3 4 HIERARCHY_LEVEL4 165 HIERARCHY_SEGMENT 89 INVOICE_AMOUNT 86 INVOICE_CURRENCY 84 INVOICE_DATE 82 INVOICE_NUMBER 97 INVOICE_RULE 133 INV_ACTUAL_UNIT_COST 130 INV_ITEM 131 INV_ITEM_DESCRIPTION 128 INV_ORGANIZATION 129 INV_SUBINVENTORY 127 INV_TRANSACTION_DATE 140 INV_TRANSACTION_ID 136 INV_TRANSACTION_REFERENCE 139 INV_TRANSACTION_SOURCE 137 INV_TRANSACTION_SOURCE_TYPE 138 INV_TRANSACTION_TYPE 132 INV_TRANSACTION_UNIT_COST 146 JE_BATCH_ID 147 JE_HEADER_ID -76.0096 JL Action Code -76.0095 JL Amount -76.0079 JL Customer ID -76.0094 JL Date Type -76.0077 JL Deal Number -76.0091 JL Deal Subtype -76.009 JL Deal Type -76.0082 JL Dealer -76.0083 JL FO Trans ID -76.0085 JL Interest Rate -76.0081 JL Main Account -76.0086 JL Maturity Date -76.0093 JL Portfolio -76.0092 JL Product Type -76.0078 JL Source System -76.0084 JL Trade Type -76.008 JL Trading Partner -76.0089 JL Transaction Number -76.0088 JL Treasury Batch ID -76.0087 JL Value Date 117 JOB 143 JOURNAL_CREATED_BY 144 JOURNAL_CREATION_DATE 19 JOURNAL_DESCRIPTION 18 JOURNAL_NAME 11 LEDGER 54 LEDGER_CURRENCY 5 LEVEL1 6 LEVEL2 7 LEVEL3 8 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 21 LINE_NUMBER 103 MDM_PARTY_DESC 102 MDM_PARTY_ID 142 OPERATING_UNIT 123 OPERATION_SEQ_NUM 87 PAYMENT_CURRENCY 88 PAYMENT_METHOD 162 PERIOD 161 PERIOD_DATE 9 PERIOD_NAME 10 PERIOD_NAME_LABEL 118 POSITION 17 POSTED_DATE 92 PO_QUANTITY 126 PRIMARY_QUANTITY 104 PROJECT 90 PURCHASE_ORDER 45 Product 46 Product desc 134 Product with desc 78 RECONCILIATION_REFERENCE 163 RECORD_TYPE 13 REFERENCE 91 RELEASE 77 REPORTING_SEQ 93 REQUISITION 94 REQUISITION_LINE 121 RESOURCE_CODE 96 SALESPERSON 95 SALES_ORDER 80 SL_BATCH_NO 76 SL_CLOSE_ACCT_SEQ_VAL 79 SL_SOURCE 160 SOURCE_ID_INT_1 12 SOURCE_NAME 72 SUB_DOC_SEQ_ID 73 SUB_DOC_SEQ_NAME 74 SUB_DOC_SEQ_VAL -34.0035 Sub Account -34.0036 Sub Account desc -180.0181 Sub Account with desc 43 Sub-Account 44 Sub-Account desc 135 Sub-Account with desc 105 TASK 33 TAXABLE_LINE 32 TAX_LINE 31 TAX_RATE_CODE 20 TAX_STATUS_CODE 50 TRANSACTION_CURRENCY 67 TRANSACTION_DATE 68 TRANSACTION_NUMBER 124 TRANSACTION_QUANTITY 125 TRANSACTION_UOM 100 VENDOR_OR_CUSTOMER_NAME 99 VENDOR_OR_CUSTOMER_NUMBER 101 VENDOR_OR_CUSTOMER_SITE 167 VIEW_TRANSACTION 122 WIP_JOB 141 WRITE_OFF_COMMENTS 169 ZERO_BALANCE ACCOUNTED_AMOUNT VALUE 1 SUM ACCOUNT_TYPE FILTER 1 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 3 US S Site AB04A3225A6DBDA9E5190E5E56206768 Pivot by Hierarchy with Activity Account Open/Close Balances Y Pivot by Hierarchy with Account Open/Close Balances (Accounts with Activity only) SYSADMIN 54 ACCOUNTED_AMOUNT 53 ACCOUNTED_CR 52 ACCOUNTED_DR 36 ACCOUNTING_CLASS 156 ACCOUNTING_CLASS_CODE 67 ACCOUNTING_DATE 66 ACCOUNTING_EVENT_DESCRIPTION 97 ACCOUNTING_RULE 37 ACCOUNT_TYPE 151 AE_HEADER_ID 152 AE_LINE_NUM 35 AMOUNT_INCLUDES_TAX 146 APPLICATION 150 APPLICATION_ID 82 ASSET_NUMBER 121 ASSIGNMENT_ORGANIZATION 44 Account 45 Account desc 160 Account with desc 60 BALANCE_TYPE 16 BATCH_NAME 17 BATCH_STATUS 61 BUDGET_NAME 15 CATEGORY_NAME 165 CHART_OF_ACCOUNTS_ID 23 CONCATENATED_SEGMENTS 24 CONCATENATED_SEGMENTS_DESC -135.0137 CONTRA_ACCOUNT -135.0136 CONTRA_NUM 63 CONVERSION_DATE 65 CONVERSION_RATE 64 CONVERSION_TYPE 57 CURRENCY_CONVERSION_DATE 59 CURRENCY_CONVERSION_RATE 58 CURRENCY_CONVERSION_TYPE 38 Company 39 Company desc 158 Company with desc -135.0144 Contra Account -135.0145 Contra Account desc -135.0146 Contra Account with desc -135.0138 Contra Company -135.0139 Contra Company desc -135.014 Contra Company with desc -135.0141 Contra Department -135.0142 Contra Department desc -135.0143 Contra Department with desc -135.015 Contra Product -135.0151 Contra Product desc -135.0152 Contra Product with desc -135.0147 Contra Sub-Account -135.0148 Contra Sub-Account desc -135.0149 Contra Sub-Account with desc 122 DEPARTMENT_CODE 85 DESCRIPTION 149 DFF_CONTEXT -16.0017 DOCUMENT_NUMBER 70 DOCUMENT_SEQ_ID 71 DOCUMENT_SEQ_NAME 72 DOCUMENT_SEQ_VALUE -51.0052 DOC_SEQUENCE_VALUE 42 Department 43 Department desc 159 Department with desc 117 EMPLOYEE_NAME 118 EMPLOYEE_NUMBER 62 ENCUMBRANCE_TYPE 50 ENTERED_AMOUNT 49 ENTERED_CR 48 ENTERED_DR 157 ENTITY_CODE 155 EVENT_DATE 153 EVENT_ID 56 EVENT_TYPE 154 EVENT_TYPE_CODE 111 EXPENDITURE_CATEGORY 109 EXPENDITURE_CLASS_CODE 108 EXPENDITURE_GROUP 114 EXPENDITURE_ITEM_DATE 115 EXPENDITURE_ITEM_QUANTITY 110 EXPENDITURE_STATUS_CODE 112 EXPENDITURE_TYPE 113 EXPENDITURE_TYPE_DESCRIPTION 116 EXPENDITURE_UNIT_OF_MEASURE 83 EXPENSE_ACCOUNT 166 FLEX_VALUE_SET_ID 76 GL_CLOSE_ACCT_SEQ_VAL 87 GL_DATE 168 HAS_ACTIVITY 4 HIERARCHY_LEVEL1 5 HIERARCHY_LEVEL2 6 HIERARCHY_LEVEL3 7 HIERARCHY_LEVEL4 162 HIERARCHY_SEGMENT -95.0097 INCURRED_BY_EMPLOYEE_NUMBER -95.0096 INCURRED_BY_PERSON 91 INVOICE_AMOUNT 88 INVOICE_CURRENCY -71.0072 INVOICE_CURRENCY_CODE 86 INVOICE_DATE 84 INVOICE_NUMBER 96 INVOICE_RULE 135 INV_ACTUAL_UNIT_COST 132 INV_ITEM 133 INV_ITEM_DESCRIPTION 130 INV_ORGANIZATION 131 INV_SUBINVENTORY 129 INV_TRANSACTION_DATE 141 INV_TRANSACTION_ID 136 INV_TRANSACTION_REFERENCE 140 INV_TRANSACTION_SOURCE 138 INV_TRANSACTION_SOURCE_TYPE 139 INV_TRANSACTION_TYPE 134 INV_TRANSACTION_UNIT_COST 147 JE_BATCH_ID 148 JE_HEADER_ID 119 JOB 144 JOURNAL_CREATED_BY 145 JOURNAL_CREATION_DATE 20 JOURNAL_DESCRIPTION 19 JOURNAL_NAME 12 LEDGER 55 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 22 LINE_NUMBER 105 MDM_PARTY_DESC 104 MDM_PARTY_ID 143 OPERATING_UNIT 125 OPERATION_SEQ_NUM 89 PAYMENT_CURRENCY -71.0073 PAYMENT_CURRENCY_CODE 90 PAYMENT_METHOD -71.0074 PAYMENT_METHOD_CODE 3 PERIOD 170 PERIOD_DATE 1 PERIOD_NAME 2 PERIOD_NAME_LABEL 120 POSITION 18 POSTED_DATE 101 PO_QUANTITY 128 PRIMARY_QUANTITY 106 PROJECT 92 PURCHASE_ORDER 46 Product 47 Product desc 161 Product with desc 79 RECONCILIATION_REFERENCE 164 RECORD_TYPE 14 REFERENCE 93 RELEASE 78 REPORTING_SEQ 102 REQUISITION 103 REQUISITION_LINE 123 RESOURCE_CODE 95 SALESPERSON 94 SALES_ORDER 81 SL_BATCH_NO 77 SL_CLOSE_ACCT_SEQ_VAL 80 SL_SOURCE 163 SOURCE_ID_INT_1 13 SOURCE_NAME 73 SUB_DOC_SEQ_ID 74 SUB_DOC_SEQ_NAME 75 SUB_DOC_SEQ_VAL 40 Sub-Account 41 Sub-Account desc 137 Sub-Account with desc 107 TASK 34 TAXABLE_LINE 33 TAX_LINE 32 TAX_RATE_CODE 21 TAX_STATUS_CODE 51 TRANSACTION_CURRENCY 68 TRANSACTION_DATE 69 TRANSACTION_NUMBER 126 TRANSACTION_QUANTITY 127 TRANSACTION_UOM -81.0082 VENDOR_OR_CUSTOMER 99 VENDOR_OR_CUSTOMER_NAME 98 VENDOR_OR_CUSTOMER_NUMBER 100 VENDOR_OR_CUSTOMER_SITE 167 VIEW_TRANSACTION 124 WIP_JOB 142 WRITE_OFF_COMMENTS 169 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 A2D21F359394512CDCA7B38A225B7DC2 Pivot by Hierarchy with All Account Open/Close Balances Y Pivot by Hierarchy with Account Open/Close Balances (All Accounts) SYSADMIN 54 ACCOUNTED_AMOUNT 53 ACCOUNTED_CR 52 ACCOUNTED_DR 36 ACCOUNTING_CLASS 155 ACCOUNTING_CLASS_CODE 67 ACCOUNTING_DATE 66 ACCOUNTING_EVENT_DESCRIPTION 96 ACCOUNTING_RULE 37 ACCOUNT_TYPE 150 AE_HEADER_ID 151 AE_LINE_NUM 35 AMOUNT_INCLUDES_TAX 145 APPLICATION 149 APPLICATION_ID 82 ASSET_NUMBER 120 ASSIGNMENT_ORGANIZATION 44 Account 45 Account desc 159 Account with desc 60 BALANCE_TYPE 16 BATCH_NAME 17 BATCH_STATUS 61 BUDGET_NAME 15 CATEGORY_NAME 164 CHART_OF_ACCOUNTS_ID 23 CONCATENATED_SEGMENTS 24 CONCATENATED_SEGMENTS_DESC -135.0137 CONTRA_ACCOUNT -135.0136 CONTRA_NUM 63 CONVERSION_DATE 65 CONVERSION_RATE 64 CONVERSION_TYPE 57 CURRENCY_CONVERSION_DATE 59 CURRENCY_CONVERSION_RATE 58 CURRENCY_CONVERSION_TYPE 38 Company 39 Company desc 157 Company with desc -135.0144 Contra Account -135.0145 Contra Account desc -135.0146 Contra Account with desc -135.0138 Contra Company -135.0139 Contra Company desc -135.014 Contra Company with desc -135.0141 Contra Department -135.0142 Contra Department desc -135.0143 Contra Department with desc -135.015 Contra Product -135.0151 Contra Product desc -135.0152 Contra Product with desc -135.0147 Contra Sub-Account -135.0148 Contra Sub-Account desc -135.0149 Contra Sub-Account with desc 121 DEPARTMENT_CODE 84 DESCRIPTION 148 DFF_CONTEXT -16.0017 DOCUMENT_NUMBER 70 DOCUMENT_SEQ_ID 71 DOCUMENT_SEQ_NAME 72 DOCUMENT_SEQ_VALUE -51.0052 DOC_SEQUENCE_VALUE 42 Department 43 Department desc 158 Department with desc 116 EMPLOYEE_NAME 117 EMPLOYEE_NUMBER 62 ENCUMBRANCE_TYPE 50 ENTERED_AMOUNT 49 ENTERED_CR 48 ENTERED_DR 156 ENTITY_CODE 154 EVENT_DATE 152 EVENT_ID 56 EVENT_TYPE 153 EVENT_TYPE_CODE 110 EXPENDITURE_CATEGORY 108 EXPENDITURE_CLASS_CODE 107 EXPENDITURE_GROUP 113 EXPENDITURE_ITEM_DATE 114 EXPENDITURE_ITEM_QUANTITY 109 EXPENDITURE_STATUS_CODE 111 EXPENDITURE_TYPE 112 EXPENDITURE_TYPE_DESCRIPTION 115 EXPENDITURE_UNIT_OF_MEASURE 165 FLEX_VALUE_SET_ID 76 GL_CLOSE_ACCT_SEQ_VAL 86 GL_DATE 166 HAS_ACTIVITY 4 HIERARCHY_LEVEL1 5 HIERARCHY_LEVEL2 6 HIERARCHY_LEVEL3 7 HIERARCHY_LEVEL4 161 HIERARCHY_SEGMENT -95.0097 INCURRED_BY_EMPLOYEE_NUMBER -95.0096 INCURRED_BY_PERSON 90 INVOICE_AMOUNT 87 INVOICE_CURRENCY -71.0072 INVOICE_CURRENCY_CODE 85 INVOICE_DATE 83 INVOICE_NUMBER 95 INVOICE_RULE 134 INV_ACTUAL_UNIT_COST 131 INV_ITEM 132 INV_ITEM_DESCRIPTION 129 INV_ORGANIZATION 130 INV_SUBINVENTORY 128 INV_TRANSACTION_DATE 140 INV_TRANSACTION_ID 135 INV_TRANSACTION_REFERENCE 139 INV_TRANSACTION_SOURCE 137 INV_TRANSACTION_SOURCE_TYPE 138 INV_TRANSACTION_TYPE 133 INV_TRANSACTION_UNIT_COST 146 JE_BATCH_ID 147 JE_HEADER_ID 118 JOB 143 JOURNAL_CREATED_BY 144 JOURNAL_CREATION_DATE 20 JOURNAL_DESCRIPTION 19 JOURNAL_NAME 12 LEDGER 55 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 22 LINE_NUMBER 104 MDM_PARTY_DESC 103 MDM_PARTY_ID 142 OPERATING_UNIT 124 OPERATION_SEQ_NUM 88 PAYMENT_CURRENCY -71.0073 PAYMENT_CURRENCY_CODE 89 PAYMENT_METHOD -71.0074 PAYMENT_METHOD_CODE 3 PERIOD 168 PERIOD_DATE 1 PERIOD_NAME 2 PERIOD_NAME_LABEL 119 POSITION 18 POSTED_DATE 100 PO_QUANTITY 127 PRIMARY_QUANTITY 105 PROJECT 91 PURCHASE_ORDER 46 Product 47 Product desc 160 Product with desc 79 RECONCILIATION_REFERENCE 163 RECORD_TYPE 14 REFERENCE 92 RELEASE 78 REPORTING_SEQ 101 REQUISITION 102 REQUISITION_LINE 122 RESOURCE_CODE 94 SALESPERSON 93 SALES_ORDER 81 SL_BATCH_NO 77 SL_CLOSE_ACCT_SEQ_VAL 80 SL_SOURCE 162 SOURCE_ID_INT_1 13 SOURCE_NAME 73 SUB_DOC_SEQ_ID 74 SUB_DOC_SEQ_NAME 75 SUB_DOC_SEQ_VAL 40 Sub-Account 41 Sub-Account desc 136 Sub-Account with desc 106 TASK 34 TAXABLE_LINE 33 TAX_LINE 32 TAX_RATE_CODE 21 TAX_STATUS_CODE 51 TRANSACTION_CURRENCY 68 TRANSACTION_DATE 69 TRANSACTION_NUMBER 125 TRANSACTION_QUANTITY 126 TRANSACTION_UOM -81.0082 VENDOR_OR_CUSTOMER 98 VENDOR_OR_CUSTOMER_NAME 97 VENDOR_OR_CUSTOMER_NUMBER 99 VENDOR_OR_CUSTOMER_SITE 123 WIP_JOB 141 WRITE_OFF_COMMENTS 167 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 AB04A3225A6DBDA9E5190E5E56206768 ENGINATICS 552CA5E19EEC287004F53A78571F7C18 ALEXANDER.PAVLIK 552CA5E19EEC287004F53A78571F7C18