ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF3C79D2E0530100007F1FF2 GL Balance Type Y select flvv.description value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 order by flvv.lookup_code US B16C8DB2BC207B92E0530100007F1372 GL Batch Y Y select distinct gjb.name value, gjb.description from gl_je_batches gjb where gjb.je_batch_id in (select gjh.je_batch_id from gl_je_headers gjh where (:$flex$.journal is null or gjh.name=:$flex$.journal) and gjh.ledger_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y'))) order by gjb.name US E0594F170E1998F5E0530100007F6EA3 GL Budget Name Y select gbv.budget_name value, gbv.budget_type || ' (' || xxen_util.meaning(gbv.status,'PLAN/VERSION STATUS',101) || ')' description from gl_ledgers gl, gl_budgets gb, gl_budget_versions gbv where gl.ledger_id=gb.ledger_id and gb.budget_name=gbv.budget_name and gb.budget_type=gbv.budget_type and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='B' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) ) order by value US E0594F170E1A98F5E0530100007F6EA3 GL Encumbrance Type Y select get.encumbrance_type value, get.description description from gl_encumbrance_types get where :$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='E' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) order by value US B16C8DB2BC217B92E0530100007F1372 GL Journal Y Y select distinct gjh.name value, gjh.description from gl_je_headers gjh where (:$flex$.batch is null or gjh.je_batch_id in (select gjb.je_batch_id from gl_je_batches gjb where xxen_util.contains(:$flex$.batch,gjb.name)='Y')) and gjh.ledger_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) order by gjh.name US 8E2FF36EDF2479D2E0530100007F1FF2 GL Journal Category Y select gjcv.user_je_category_name value, gjcv.description from gl_je_categories_vl gjcv order by gjcv.user_je_category_name US 8E2FF36EDF2379D2E0530100007F1FF2 GL Journal Source Y select gjsv.user_je_source_name value, gjsv.description from gl_je_sources_vl gjsv order by gjsv.user_je_source_name US 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期，取决于会计科目表或分类账。 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 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 337FCD1376F54A51E0632B00000A6537 with gcck as (select &materialize_hint gcck.* from gl_code_combinations_kfv gcck where 2=2) select /*+ &leading_hint push_pred(msiv) */ 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, 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.stat_amount end line_stat_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, (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, &lp_gjl_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, --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, pha.segment1 purchase_order, pra.release_num release, rt.quantity po_quantity, prha.segment1 requisition, prla.line_num requisition_line, --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, --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 mgd.disposition_id=mmt.transaction_source_id and mgd.organization_id=mmt.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 mso.sales_order_id=mmt.transaction_source_id)--Sales Order, Internal Order, RMA when mmt.transaction_source_type_id=11 then (select ccu.description from cst_cost_updates ccu where ccu.cost_update_id=mmt.transaction_source_id) --Cost Update when mmt.transaction_source_type_id=9 then (select mcch.cycle_count_header_name from mtl_cycle_count_headers mcch where mcch.cycle_count_header_id=mmt.transaction_source_id) --Cycle Count when mmt.transaction_source_type_id=3 then (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id=mmt.transaction_source_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 mpi.physical_inventory_id=mmt.transaction_source_id and mpi.organization_id=mmt.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 mtrh.header_id=mmt.transaction_source_id) --Move Order end inv_transaction_source, mmt.transaction_id inv_transaction_id, cwo.comments write_off_comments, -- TB AR AR_DESCRIPTION (CASE WHEN xte.APPLICATION_ID = '222' AND xte.ENTITY_CODE = 'TRANSACTIONS' THEN (SELECT CTLA.DESCRIPTION FROM AR.RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.CUSTOMER_TRX_ID = xte.SOURCE_ID_INT_1 AND ROWNUM < 2) ELSE NULL END) "AR Trx Line Desc", -- TB AR AR_REFERENCE (CASE WHEN xte.APPLICATION_ID = '222' AND xte.ENTITY_CODE = 'TRANSACTIONS' THEN (SELECT CTA.ATTRIBUTE4 FROM AR.RA_CUSTOMER_TRX_ALL CTA WHERE CTA.CUSTOMER_TRX_ID = xte.SOURCE_ID_INT_1 AND ROWNUM < 2) ELSE NULL END) "AR Trx Reference", -- TB AR CUST_GROUP (CASE WHEN xte.APPLICATION_ID = '222' AND xte.ENTITY_CODE = 'TRANSACTIONS' THEN (SELECT tl.description FROM apps.ra_customer_trx_all t, apps.hz_cust_site_uses_all csu, applsys.fnd_flex_value_sets s, applsys.FND_FLEX_VALUES v, applsys.FND_FLEX_VALUES_TL tl WHERE t.ship_to_site_use_id = csu.site_use_id AND v.flex_value_set_id = s.flex_value_set_id AND (v.end_date_active IS NULL OR v.end_date_active > SYSDATE) AND enabled_flag = 'Y' AND v.flex_value_id = tl.flex_value_id AND flex_value_set_name LIKE 'TB_AR_Customer_Level1' AND s.zd_edition_name = 'SET1' AND s.zd_edition_name = v.zd_edition_name AND s.zd_edition_name = tl.zd_edition_name AND csu.attribute1 = v.flex_value AND t.CUSTOMER_TRX_ID = xte.SOURCE_ID_INT_1 AND ROWNUM < 2) ELSE NULL END) "Customer Group", --TB AR CUST_GROUP_CODE (CASE WHEN xte.APPLICATION_ID = '222' AND xte.ENTITY_CODE = 'TRANSACTIONS' THEN (SELECT x.attribute1 FROM APPS.HZ_CUST_SITE_USES_ALL X, APPS.RA_CUSTOMER_TRX_LINES_ALL Y WHERE X.SITE_USE_ID = Y.SHIP_TO_SITE_USE_ID AND Y.CUSTOMER_TRX_ID = xte.SOURCE_ID_INT_1 AND ROWNUM < 2) ELSE NULL END) "Customer Group Code", -- TB AR CUST_SUB_REGION (CASE WHEN xte.APPLICATION_ID = '222' AND xte.ENTITY_CODE = 'TRANSACTIONS' THEN (SELECT tl.description FROM apps.ra_customer_trx_all t, apps.hz_cust_site_uses_all csu, applsys.fnd_flex_value_sets s, applsys.FND_FLEX_VALUES v, applsys.FND_FLEX_VALUES_TL tl WHERE t.ship_to_site_use_id = csu.site_use_id AND v.flex_value_set_id = s.flex_value_set_id AND (v.end_date_active IS NULL OR v.end_date_active > SYSDATE) AND enabled_flag = 'Y' AND v.flex_value_id = tl.flex_value_id AND flex_value_set_name LIKE 'TB_AR_Customer_Level5' AND s.zd_edition_name = 'SET1' AND s.zd_edition_name = v.zd_edition_name AND s.zd_edition_name = tl.zd_edition_name AND csu.attribute5 = v.flex_value AND t.CUSTOMER_TRX_ID = xte.SOURCE_ID_INT_1 AND ROWNUM < 2) ELSE NULL END) "Customer Sub Region", --TB AR CUST_SUB_REGION_CODE (CASE WHEN xte.APPLICATION_ID = '222' AND xte.ENTITY_CODE = 'TRANSACTIONS' THEN (SELECT x.attribute5 FROM APPS.HZ_CUST_SITE_USES_ALL X, APPS.RA_CUSTOMER_TRX_LINES_ALL Y WHERE X.SITE_USE_ID = Y.SHIP_TO_SITE_USE_ID AND Y.CUSTOMER_TRX_ID = xte.SOURCE_ID_INT_1 AND ROWNUM < 2) ELSE NULL END) "Customer Sub Region Code", --TB PO PO_CAPEX_NO (CASE WHEN xte.application_id = '200' AND xte.entity_code = 'AP_INVOICES' THEN ( SELECT pol_t.attribute14 FROM xla_distribution_links xdl_t, ap_invoice_distributions_all aid_t, po_distributions_all pda_t, po_lines_all pol_t WHERE xdl_t.source_distribution_id_num_1 = aid_t.invoice_distribution_id (+) AND aid_t.po_distribution_id = pda_t.po_distribution_id (+) AND pda_t.po_header_id = pol_t.po_header_id (+) AND pda_t.po_line_id = pol_t.po_line_id (+) AND xdl_t.application_id = xte.application_id --AND xdl_t.ae_header_id = xte.ae_header_id --AND xdl_t.ae_line_num = xte.ae_line_num AND aid_t.invoice_id = xte.source_id_int_1 AND ROWNUM < 2 ) WHEN xte.application_id = '707' AND xte.entity_code = 'RCV_ACCOUNTING_EVENTS' THEN ( SELECT pol.attribute14 FROM rcv_transactions trans, po_lines_all pol WHERE trans.transaction_id = xte.source_id_int_1 AND trans.po_header_id = pol.po_header_id AND trans.po_line_id = pol.po_line_id AND ROWNUM < 2 ) WHEN xte.application_id = '707' AND xte.entity_code = 'MTL_ACCOUNTING_EVENTS' THEN ( SELECT pol.attribute14 FROM mtl_material_transactions mmt, rcv_transactions rt, po_lines_all pol WHERE mmt.rcv_transaction_id = rt.transaction_id AND rt.po_line_id = pol.po_line_id AND mmt.transaction_id = xte.source_id_int_1 AND ROWNUM < 2 ) WHEN xte.application_id = '555' AND xte.entity_code = 'PURCHASING' THEN ( SELECT pol.attribute14 FROM gmf_xla_extract_headers gxh, rcv_transactions trans, po_lines_all pol WHERE --gxh.event_id = xte.event_id gxh.source_line_id = trans.transaction_id AND trans.po_header_id = pol.po_header_id AND trans.po_line_id = pol.po_line_id AND ROWNUM < 2 ) ELSE NULL END) "PO Capex Number", -- TB PO PO_CREATED_BY (CASE WHEN xte.application_id = '555' AND xte.entity_code = 'PURCHASING' THEN (SELECT fu.user_name FROM rcv_transactions trans, po_lines_all pla, fnd_user fu WHERE trans.transaction_id = xte.source_id_int_1 AND trans.organization_id = xte.source_id_int_3 AND fu.user_id = pla.created_by AND trans.po_header_id = pla.po_header_id AND trans.po_line_id = pla.po_line_id AND trans.transaction_type = 'RECEIVE' AND ROWNUM < 2) ELSE NULL END) "PO_CREATED_BY", --TB PO PO_HEADER_COMMENT (CASE WHEN xte.application_id = '555' AND xte.entity_code = 'PURCHASING' THEN (SELECT pha.comments FROM rcv_transactions trans, po_lines_all pla, po_headers_all pha WHERE trans.transaction_id = xte.source_id_int_1 AND trans.organization_id = xte.source_id_int_3 AND trans.po_header_id = pha.po_header_id AND pha.po_header_id = pla.po_header_id AND trans.po_line_id = pla.po_line_id AND ROWNUM < 2) ELSE NULL END) "PO_HEADER_COMMENT", --TB PO PO_LINE_DESC (CASE WHEN xte.application_id = '555' AND xte.entity_code = 'PURCHASING' THEN (SELECT l.item_description FROM rcv_transactions trans, po_lines_all l WHERE trans.transaction_id = xte.source_id_int_1 AND trans.organization_id = xte.source_id_int_3 AND trans.po_header_id = l.po_header_id AND trans.po_line_id = l.po_line_id AND ROWNUM < 2) ELSE NULL END) "PO_LINE_DESC", --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 xte.source_id_int_1, gp.start_date period_date, gp.period_name period, gcck.chart_of_accounts_id, case when nvl(fnd_profile.value('XXEN_FSG_DRILLDOWN_TO_SAME_WORKBOOK'), 'N')='N' then '=dd' else '=dds' end ||'("VT","'||gl.ledger_id||','||gjsv.user_je_source_name||','||xah.event_id||','||gjl.je_line_num||'")' 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, zx_rates_b zrb, fa_transaction_headers fth, fa_additions_b fab, ap_invoices_all aia, (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, 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_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 where 1=1 and gl.period_set_name=gp.period_set_name and gp.period_name=gjh.period_name and gp.period_name=gjl.period_name and gl.ledger_id=gjh.ledger_id and gjb.je_batch_id=gjh.je_batch_id and gjh.je_header_id=gjl.je_header_id and gjh.je_source=gjsv.je_source_name and 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 gjl.tax_code_id=zrb.tax_rate_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 case when xte.application_id=140 and xte.entity_code='TRANSACTIONS' then xte.source_id_int_1 end=fth.transaction_header_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 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.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 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 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.txn_source='PUR' then gxeh.source_line_id end=rt.transaction_id(+) and rt.shipment_line_id=rsl.shipment_line_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 then gxeh.transaction_id end,cwo.inventory_transaction_id)=mmt.transaction_id(+) and coalesce(mmt.organization_id,rsl.to_organization_id,we.organization_id,cwo.organization_id)=msiv.organization_id(+) and coalesce(mmt.inventory_item_id,rsl.item_id,we.primary_item_id,cwo.inventory_item_id)=msiv.inventory_item_id(+) and coalesce(mmt.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(+) order by gl.name, gcck.concatenated_segments, gp.start_date, gp.period_name, gjb.je_batch_id, gjl.je_header_id, gjl.je_line_num , xe.transaction_date, xte.transaction_number Y #,##0.00;[Red]-#,##0.00 2379A67C7A3D1532E0636AFB09051BB2 US TB GL Account Analysis (Drilldown)v2 Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This report is used by the GL Financial Statement and Drilldown report, to show subledger details. This also has inventory and WIP details. Please enter a period, posted date, batch or journal restriction Tiger Custom &gl_flex_value_security &leading_hint &lp_gjl_dff_cols &materialize_hint &segment_columns &segments_with_desc 1=1 2=2 1 -60 1=1 select xxen_fsg.effective_dates_where_clause(:effective_dates_string) from dual Char US Effective Dates String 2 -50 1=1 select xxen_fsg.multiple_periods_where_clause(:multiple_periods_string,:ledger) from dual Char US Multiple Periods String 3 -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 4 5 1=1 (gjl.je_header_id,gjl.je_line_num) in ( select xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) je_header_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) je_line_num from xxen_report_run_param_values xrrpv where xrrpv.parameter_id in (select xrpv.parameter_id from xxen_report_parameters_v xrpv where xrpv.parameter_name='je_header_id|je_line_num') and xrrpv.run_id=:run_id ) Char US je_header_id|je_line_num 5 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) US Ledger 6 &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 US Ledger 7 15 1=1 gl.ledger_id=:ledger_id Number US Ledger ID 8 &segment_columns select distinct 'gcck.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcck.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck.chart_of_accounts_id'|| ( select ', gcck.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||')'||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' desc",' text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id =:ledger_id) order by min_id_flex_num, min_segment_num US Ledger ID 9 20 1=1 gp.period_name=:period_name LOV GL Period (past) 8E2FF36EDED479D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.start_date<=sysdate+400 and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name select distinct max(gp.period_name) keep (dense_rank last order by gp.start_date,gp.period_year,gp.period_num) over () period_name from gl.gl_periods gp where gp.start_date<=sysdate and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where :$flex$.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')) ) US Period 10 30 1=1 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 US Journal Source 11 40 1=1 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 US Journal Category 12 50 1=1 gjb.name=:batch LOV GL Batch B16C8DB2BC207B92E0530100007F1372 Y Y select distinct gjb.name value, gjb.description from gl_je_batches gjb where gjb.je_batch_id in (select gjh.je_batch_id from gl_je_headers gjh where (:$flex$.journal is null or gjh.name=:$flex$.journal) and gjh.ledger_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y'))) order by gjb.name US Batch 13 60 1=1 gjb.je_batch_id=:batch_id Number US Batch ID 14 70 1=1 gjh.name=:journal LOV GL Journal B16C8DB2BC217B92E0530100007F1372 Y Y select distinct gjh.name value, gjh.description from gl_je_headers gjh where (:$flex$.batch is null or gjh.je_batch_id in (select gjb.je_batch_id from gl_je_batches gjb where xxen_util.contains(:$flex$.batch,gjb.name)='Y')) and gjh.ledger_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) order by gjh.name US Journal 15 80 1=1 gjh.je_header_id=:je_header_id Number US Journal Header ID 16 90 1=1 gjl.je_line_num=:journal_line Number US Journal Line Num 17 100 1=1 gcck.code_combination_id=:code_combination_id Number US Concatenated Segments 18 &leading_hint leading(gl gp gcck gjl) US Concatenated Segments 19 &materialize_hint /*+ materialize*/ US Concatenated Segments 20 110 1=1 gjh.actual_flag in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.description=:balance_type and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0) LOV GL Balance Type 8E2FF36EDF3C79D2E0530100007F1FF2 Y select flvv.description value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 order by flvv.lookup_code select flv.description from fnd_lookup_values flv where flv.lookup_type='BATCH_TYPE' and flv.view_application_id=101 and flv.language(+)=userenv('lang') and flv.security_group_id=0 and flv.lookup_code = 'A' US Balance Type 21 120 1=1 (gjh.actual_flag<>'B' or gjh.budget_version_id in (select gbv.budget_version_id from gl_budget_versions gbv where gbv.budget_name = :budget_name)) LOV GL Budget Name E0594F170E1998F5E0530100007F6EA3 Y select gbv.budget_name value, gbv.budget_type || ' (' || xxen_util.meaning(gbv.status,'PLAN/VERSION STATUS',101) || ')' description from gl_ledgers gl, gl_budgets gb, gl_budget_versions gbv where gl.ledger_id=gb.ledger_id and gb.budget_name=gbv.budget_name and gb.budget_type=gbv.budget_type and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='B' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) ) order by value US Budget Name 22 130 1=1 (gjh.actual_flag<>'E' or gjh.encumbrance_type_id in (select get.encumbrance_type_id from gl_encumbrance_types get where get.encumbrance_type = :encumbrance_type)) LOV GL Encumbrance Type E0594F170E1A98F5E0530100007F6EA3 Y select get.encumbrance_type value, get.description description from gl_encumbrance_types get where :$flex$.balance_type is null or exists ( select null from fnd_lookup_values_vl flvv where xxen_util.contains(:$flex$.balance_type,flvv.description)='Y' and flvv.lookup_code='E' and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 ) order by value US Encumbrance Type 23 140 &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 US Show Segments with Descriptions 24 150 &lp_gjl_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 25 &lp_gjl_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 26 160 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 27 170 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 28 180 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 29 190 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 30 200 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 31 210 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 32 220 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 33 230 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 34 240 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 35 250 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 :$flex$.balance_type Balance Type Budget Name :$flex$.balance_type Balance Type Encumbrance Type :$flex$.batch Batch Journal :$flex$.batch Batch Period :$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$.journal Journal Batch :$flex$.journal Journal Period :$flex$.ledger Ledger Batch :$flex$.ledger Ledger Budget Name :$flex$.ledger Ledger GL_SEGMENT1 From :$flex$.ledger Ledger GL_SEGMENT1 To :$flex$.ledger Ledger GL_SEGMENT2 From :$flex$.ledger Ledger GL_SEGMENT2 To :$flex$.ledger Ledger GL_SEGMENT3 From :$flex$.ledger Ledger GL_SEGMENT3 To :$flex$.ledger Ledger GL_SEGMENT4 From :$flex$.ledger Ledger GL_SEGMENT4 To :$flex$.ledger Ledger GL_SEGMENT5 From :$flex$.ledger Ledger GL_SEGMENT5 To :$flex$.ledger Ledger Journal :$flex$.ledger Ledger Period