ENGINATICSSYSTEM_ADMINISTRATORSYSADMINE811F942597A2075E0530100007FF4F2Blitz Upload ModeYselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual
US8E2FF36EDE9079D2E0530100007F1FF2FND CurrencyYselect
fcv.currency_code value,
fcv.description
from
fnd_currencies_vl fcv
where
fcv.enabled_flag='Y'
order by
fcv.currency_codeUSDD3BDFF9582F51D0E0530100007FEDB0FND Currency CodesYselect
fct.currency_code id,
fct.currency_code value,
fct.description
from
fnd_currencies_tl fct
where
fct.source_lang=userenv('lang')
order by
fct.currency_codeUS8E2FF36EDEB879D2E0530100007F1FF2GL LedgerYselect
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.nameARدفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحاليةDLedger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen AnmeldeverantwortungELibros 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 actualFGrands 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 actuelleILibri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login correnteJA現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳KO현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장PTBLedgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de loginRUЛеджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в системуSLedgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaretTRMevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterlerUSLedgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibilityZHS由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。1772B3EAC0C36715E0630100007FF9DEselect
null action_,
null status_,
null message_,
null modified_columns_,
null row_id,
null request_id_,
null request_output,
to_number(null) group_id,
glv.name ledger_name,
gbe.name budget_organization,
gbve.budget_name,
xxen_util.meaning(gbv.require_budget_journals_flag ,'YES_NO',0) budget_requires_journal,
null journal_source_name,
null journal_category_name,
gbauv.currency_code,
gbpr.period_year fiscal_year,
null add_or_replace,
gcck.concatenated_segments account,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=1 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period1_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=1 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=1 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period1_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=2 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period2_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=2 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=2 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period2_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=3 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period3_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=3 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=3 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period3_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=4 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period4_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=4 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=4 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period4_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=5 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period5_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=5 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=5 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period5_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=6 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period6_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=6 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=6 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period6_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=7 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period7_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=7 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=7 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period7_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=8 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period8_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=8 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=8 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period8_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=9 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period9_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=9 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=9 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period9_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=10 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period10_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=10 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=10 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period10_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=11 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period11_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=11 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=11 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period11_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=12 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period12_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=12 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=12 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period12_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=13 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period13_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=13 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=13 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period13_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=14 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period14_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=14 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=14 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period14_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=15 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period15_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=15 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=15 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period15_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=16 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period16_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=16 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=16 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period16_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=17 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period17_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=17 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=17 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period17_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=18 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period18_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=18 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=18 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period18_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=19 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period19_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=19 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=19 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period19_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=20 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period20_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=20 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=20 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period20_amount
from
gl_budget_assignments_unique_v gbauv,
gl_budgets_v gbv,
gl_budget_entities gbe,
gl_entity_budgets geb,
gl_budget_versions gbve,
gl_ledgers_v glv,
gl_budget_period_ranges gbpr,
gl_code_combinations_kfv gcck
where
1=1 and
gbauv.entry_code='E' and
gbauv.code_combination_id=gcck.code_combination_id and
gbauv.ledger_id=glv.ledger_id and
glv.chart_of_accounts_id=gcck.chart_of_accounts_id and
gbe.budget_entity_id=gbauv.budget_entity_id and
gbv.budget_name=gbve.budget_name and
gbv.budget_name=gbve.budget_name and
glv.ledger_id=gbe.ledger_id and
geb.budget_version_id=gbve.budget_version_id and
gbe.budget_entity_id=geb.budget_entity_id and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.open_flag='O' and
gcck.enabled_flag='Y' and
gcck.summary_flag='N' and
gcck.detail_budgeting_allowed='Y' and
gcck.template_id is null and
sysdate between nvl(gcck.start_date_active,sysdate) and nvl(gcck.end_date_active,(sysdate+1))YU:upload_mode=xxen_upload.action_create or
(
:budget_organization is not null and
:budget is not null and
:currency is not null
)Axxen_gl_upload.populate_budget_interfacexxen_gl_upload.submit_budget_importxxen_gl_upload.validate_budget_entry(
p_user_je_source_name=>:$column$.journal_source_name,
p_user_je_category_name=>:$column$.journal_category_name,
p_budget_name=>:$column$.budget_name
)USGL Budget Amounts UploadGL Budget Amounts Upload
===================
This can be used to upload GL Budget AmountsPlease enter Budget Organization, Budget and Currency criteria for downloadEnginaticsR12 onlyUpload1=11101=1:ledger=:ledgerLOVGL Ledger8E2FF36EDEB879D2E0530100007F1FF2Yselect
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.namecoalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger)YUSLedger2201=1:upload_mode like '%' || xxen_upload.action_updateLOVBlitz Upload ModeE811F942597A2075E0530100007FF4F2Yselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual
YUSUpload Mode3301=1gbe.name=:budget_organizationLOV customYselect
gbe.name value,
gbe.description
from
gl_budget_entities gbe,
gl_ledgers_v glv
where
gbe.ledger_id=glv.ledger_id and
glv.name=:$flex$.ledgerUSBudget Organization4401=1gbv.budget_name=:budgetLOV customYselect
gbv.budget_name value,
gbv.description
from
gl_entity_budgets geb,
gl_budget_versions gbv,
gl_budget_entities gbe,
gl_ledgers_v glv
where
geb.budget_version_id=gbv.budget_version_id and
geb.budget_entity_id=gbe.budget_entity_id and
gbe.name=:$flex$.budget_organization and
gbe.ledger_id=glv.ledger_id and
glv.name=:$flex$.ledger and
gbv.status='O'USBudget5501=1gbauv.currency_code=:currencyLOVFND Currency CodesDD3BDFF9582F51D0E0530100007FEDB0Yselect
fct.currency_code id,
fct.currency_code value,
fct.description
from
fnd_currencies_tl fct
where
fct.source_lang=userenv('lang')
order by
fct.currency_codeUSCurrency6601=1gbpr.period_year=:fiscal_yearLOV customYselect distinct
gbpr.period_year value,
null description
from
gl_budget_period_ranges gbpr,
gl_budget_versions gbv,
gl_budgets gb
where
gb.budget_name=:$flex$.budget and
gbv.budget_name=gb.budget_name and
gbv.budget_version_id=gbpr.budget_version_id and
gbpr.open_flag='O'USFiscal Year7701=1gcck.concatenated_segments=:accountLOV customYselect
gcck.concatenated_segments value,
null description
from
gl_budget_assignments_unique_v gbauv,
gl_ledgers_v glv,
gl_code_combinations_kfv gcck,
gl_budget_entities gbe
where
glv.name=:$flex$.ledger and
gbauv.currency_code=:$flex$.currency and
gbauv.entry_code='E' and
gbauv.code_combination_id=gcck.code_combination_id and
glv.ledger_id=gbauv.ledger_id and
glv.chart_of_accounts_id=gcck.chart_of_accounts_id and
gbe.name=:$flex$.budget_organization and
gbe.ledger_id=glv.ledger_id and
gbe.budget_entity_id=gbauv.budget_entity_id and
gcck.enabled_flag='Y' and
gcck.summary_flag='N' and
gcck.detail_budgeting_allowed='Y' and
gcck.template_id is null and
sysdate between nvl(gcck.start_date_active,sysdate) and nvl(gcck.end_date_active,(sysdate+1))
order by
gbauv.ordering_value,
gbauv.budget_entity_id,
gbauv.code_combination_idUSAccount:$flex$.budgetBudgetFiscal Year:$flex$.budget_organizationBudget OrganizationAccount:$flex$.budget_organizationBudget OrganizationBudget:$flex$.currencyCurrencyAccount:$flex$.ledgerLedgerAccount:$flex$.ledgerLedgerBudget:$flex$.ledgerLedgerBudget Organization1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar24MODIFIED_COLUMNS_Charvarchar2Y5ROW_IDCharvarchar2Y6REQUEST_ID_Charvarchar2Y7REQUEST_OUTPUTCharvarchar2Budget Import concurrent request output8GROUP_IDNumbernumberY9LEDGER_NAMELOVvarchar2GL Ledger8E2FF36EDEB879D2E0530100007F1FF2Yselect
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.nameselect
gl.ledger_id id,
gl.name value
from
gl_ledgers gl:$flex$.ledgerY10BUDGET_ORGANIZATIONLOV customvarchar2Yselect
gbe.name value,
gbe.description
from
gl_budget_entities gbe,
gl_ledgers_v glv
where
gbe.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_nameY11BUDGET_NAMELOV customvarchar2Yselect
gbv.budget_name value,
gbv.description
from
gl_entity_budgets geb,
gl_budget_versions gbv,
gl_budget_entities gbe,
gl_ledgers_v glv
where
geb.budget_version_id=gbv.budget_version_id and
geb.budget_entity_id=gbe.budget_entity_id and
gbe.name=:$column$.budget_organization and
gbe.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gbv.status='O'Y12BUDGET_REQUIRES_JOURNALCharvarchar2select xxen_util.meaning(gb.require_budget_journals_flag ,'YES_NO',0) from gl_budgets gb where gb.budget_name=:$column$.budget_name13JOURNAL_SOURCE_NAMELOV customvarchar2Yselect
gjsv.user_je_source_name value,
gjsv.description
from
gl_je_sources_v gjsv,
gl_budgets gb
where
gb.budget_name=:$column$.budget_name and
gb.require_budget_journals_flag='Y'14JOURNAL_CATEGORY_NAMELOV customvarchar2Yselect
gjcv.user_je_category_name value,
gjcv.description
from
gl_je_categories_v gjcv,
gl_budgets gb
where
gb.budget_name=:$column$.budget_name and
gb.require_budget_journals_flag='Y'15CURRENCY_CODELOVvarchar2FND Currency8E2FF36EDE9079D2E0530100007F1FF2Yselect
fcv.currency_code value,
fcv.description
from
fnd_currencies_vl fcv
where
fcv.enabled_flag='Y'
order by
fcv.currency_codeY16FISCAL_YEARLOV customnumberYselect distinct
gbpr.period_year value,
null description
from
gl_budget_period_ranges gbpr,
gl_budget_versions gbv,
gl_budgets gb
where
gb.budget_name=:$column$.budget_name and
gbv.budget_name=gb.budget_name and
gbv.budget_version_id=gbpr.budget_version_id and
gbpr.open_flag='O'Y17ADD_OR_REPLACELOV customvarchar2Yselect
flvv.lookup_code id,
flvv.meaning value,
flvv.description
from
fnd_lookup_values_vl flvv,
gl_budgets gb
where
flvv.lookup_type ='GL_BUDGET_UPDATE_MODE' and
gb.budget_name=:$column$.budget_name and
gb.require_budget_journals_flag='N'
union all
select
flvv.lookup_code id,
flvv.meaning value,
flvv.description
from
fnd_lookup_values_vl flvv,
gl_budgets gb
where
flvv.lookup_type ='GL_BUDGET_UPDATE_MODE' and
gb.budget_name=:$column$.budget_name and
gb.require_budget_journals_flag='Y' and
flvv.lookup_code='A'Y18ACCOUNTLOV customvarchar2YYselect
gcck.concatenated_segments value,
null description
from
gl_budget_assignments_unique_v gbauv,
gl_ledgers_v glv,
gl_code_combinations_kfv gcck,
gl_budget_entities gbe
where
glv.name=:$column$.ledger_name and
gbauv.currency_code=:$column$.currency_code and
gbauv.entry_code='E' and
gbauv.code_combination_id=gcck.code_combination_id and
glv.ledger_id=gbauv.ledger_id and
glv.chart_of_accounts_id=gcck.chart_of_accounts_id and
gbe.name=:$column$.budget_organization and
gbe.ledger_id=glv.ledger_id and
gbe.budget_entity_id=gbauv.budget_entity_id and
gcck.enabled_flag='Y' and
gcck.summary_flag='N' and
gcck.detail_budgeting_allowed='Y' and
gcck.template_id is null and
sysdate between nvl(gcck.start_date_active,sysdate) and nvl(gcck.end_date_active,(sysdate+1))
order by
gbauv.ordering_value,
gbauv.budget_entity_id,
gbauv.code_combination_idY19PERIOD1_NAMECharvarchar2select
gps.period_name
from
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=1 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num20PERIOD1_AMOUNTNumbernumber21PERIOD2_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=2 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num22PERIOD2_AMOUNTNumbernumber23PERIOD3_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=3 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num24PERIOD3_AMOUNTNumbernumber25PERIOD4_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=4 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num26PERIOD4_AMOUNTNumbernumber27PERIOD5_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=5 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num28PERIOD5_AMOUNTNumbernumber29PERIOD6_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=6 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num30PERIOD6_AMOUNTNumbernumber31PERIOD7_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=7 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num32PERIOD7_AMOUNTNumbernumber33PERIOD8_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=8 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num34PERIOD8_AMOUNTNumbernumber35PERIOD9_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=9 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num36PERIOD9_AMOUNTNumbernumber37PERIOD10_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=10 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num38PERIOD10_AMOUNTNumbernumber39PERIOD11_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=11 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num40PERIOD11_AMOUNTNumbernumber41PERIOD12_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=12 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num42PERIOD12_AMOUNTNumbernumber43PERIOD13_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=13 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num44PERIOD13_AMOUNTNumbernumber45PERIOD14_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=14 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num46PERIOD14_AMOUNTNumbernumber47PERIOD15_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=15 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num48PERIOD15_AMOUNTNumbernumber49PERIOD16_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=16 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num50PERIOD16_AMOUNTNumbernumber51PERIOD17_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=17 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num52PERIOD17_AMOUNTNumbernumber53PERIOD18_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=18 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num54PERIOD18_AMOUNTNumbernumber55PERIOD19_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=19 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num56PERIOD19_AMOUNTNumbernumber57PERIOD20_NAMECharvarchar2select
gps.period_name
from
gl_budgets gb,
gl_period_statuses gps,
gl_ledgers_v glv,
gl_budget_versions gbv,
gl_budget_period_ranges gbpr
where
gbv.budget_name=gb.budget_name and
gb.budget_name=:$column$.budget_name and
gps.ledger_id=glv.ledger_id and
glv.name=:$column$.ledger_name and
gps.period_year=:$column$.fiscal_year and
gps.application_id=101 and
gps.period_num=20 and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.period_year=gps.period_year and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num58PERIOD20_AMOUNTNumbernumberU1p_ledger_idinNumberLEDGER_NAMEU2p_budget_nameinCharBUDGET_NAMEU3p_budget_entity_nameinCharBUDGET_ORGANIZATIONU4p_currency_codeinCharCURRENCY_CODEU5p_fiscal_yearinCharFISCAL_YEARU6p_update_logic_typeinCharADD_OR_REPLACEU7p_accountinCharACCOUNTvalueU8p_period1_amountinNumberPERIOD1_AMOUNTU9p_period2_amountinNumberPERIOD2_AMOUNTU10p_period3_amountinNumberPERIOD3_AMOUNTU11p_period4_amountinNumberPERIOD4_AMOUNTU12p_period5_amountinNumberPERIOD5_AMOUNTU13p_period6_amountinNumberPERIOD6_AMOUNTU14p_period7_amountinNumberPERIOD7_AMOUNTU15p_period8_amountinNumberPERIOD8_AMOUNTU16p_period9_amountinNumberPERIOD9_AMOUNTU17p_period10_amountinNumberPERIOD10_AMOUNTU18p_period11_amountinNumberPERIOD11_AMOUNTU19p_period12_amountinNumberPERIOD12_AMOUNTU20p_period13_amountinNumberPERIOD13_AMOUNTU21p_period14_amountinNumberPERIOD14_AMOUNTU22p_period15_amountinNumberPERIOD15_AMOUNTU23p_period16_amountinNumberPERIOD16_AMOUNTU24p_period17_amountinNumberPERIOD17_AMOUNTU25p_period18_amountinNumberPERIOD18_AMOUNTU26p_period19_amountinNumberPERIOD19_AMOUNTU27p_period20_amountinNumberPERIOD20_AMOUNTU28p_period21_amountinNumberU29p_period22_amountinNumberU30p_period23_amountinNumberU31p_period24_amountinNumberU32p_period25_amountinNumberU33p_period26_amountinNumberU34p_period27_amountinNumberU35p_period28_amountinNumberU36p_period29_amountinNumberU37p_period30_amountinNumberU38p_period31_amountinNumberU39p_period32_amountinNumberU40p_period33_amountinNumberU41p_period34_amountinNumberU42p_period35_amountinNumberU43p_period36_amountinNumberU44p_period37_amountinNumberU45p_period38_amountinNumberU46p_period39_amountinNumberU47p_period40_amountinNumberU48p_period41_amountinNumberU49p_period42_amountinNumberU50p_period43_amountinNumberU51p_period44_amountinNumberU52p_period45_amountinNumberU53p_period46_amountinNumberU54p_period47_amountinNumberU55p_period48_amountinNumberU56p_period49_amountinNumberU57p_period50_amountinNumberU58p_period51_amountinNumberU59p_period52_amountinNumberU60p_period53_amountinNumberU61p_period54_amountinNumberU62p_period55_amountinNumberU63p_period56_amountinNumberU64p_period57_amountinNumberU65p_period58_amountinNumberU66p_period59_amountinNumberU67p_period60_amountinNumberU68p_user_je_category_nameinCharJOURNAL_CATEGORY_NAMEU69p_user_je_source_nameinCharJOURNAL_SOURCE_NAMEU71status_outCharSTATUS_CODE_U72message_outCharMESSAGE_U73row_id_outCharROW_IDP1p_user_je_source_nameinCharJOURNAL_SOURCE_NAMEP2p_ledger_nameinCharLEDGER_NAMEvalueP3p_budget_organizationinCharBUDGET_ORGANIZATIONP4p_budget_nameinCharBUDGET_NAMEP5request_id_outNumberREQUEST_ID_P6action_inCharACTION_CODE_P7status_outCharSTATUS_CODE_P8message_outCharMESSAGE_P9group_idoutNumberGROUP_IDError SQLselect
xxen_upload.action_meaning(xu.action_code_) action_,
xxen_upload.status_meaning(xxen_upload.status_error) status_,
xu.message_||' Please check the request output for details.' message_,
xu.modified_columns_,
xu.row_id,
xu.request_id_,
case when xu.request_id_ is not null then 'HYPERLINK("'||xxen_util.concurrent_request_file_url('O',xu.request_id_)||'")' end request_output,
xu.group_id,
xu.ledger_name,
xu.budget_organization,
xu.budget_name,
xu.budget_requires_journal,
xu.journal_source_name,
xu.journal_category_name,
xu.currency_code,
to_number(xu.fiscal_year) fiscal_year,
xu.add_or_replace,
xu.account,
xu.period1_name,
xu.period1_amount,
xu.period2_name,
xu.period2_amount,
xu.period3_name,
xu.period3_amount,
xu.period4_name,
xu.period4_amount,
xu.period5_name,
xu.period5_amount,
xu.period6_name,
xu.period6_amount,
xu.period7_name,
xu.period7_amount,
xu.period8_name,
xu.period8_amount,
xu.period9_name,
xu.period9_amount,
xu.period10_name,
xu.period10_amount,
xu.period11_name,
xu.period11_amount,
xu.period12_name,
xu.period12_amount,
xu.period13_name,
xu.period13_amount,
xu.period14_name,
xu.period14_amount,
xu.period15_name,
xu.period15_amount,
xu.period16_name,
xu.period16_amount,
xu.period17_name,
xu.period17_amount,
xu.period18_name,
xu.period18_amount,
xu.period19_name,
xu.period19_amount,
xu.period20_name,
xu.period20_amount
from
xxen_gl_budget_amounts_1858_u xu,
gl_budgets gb
where
gb.budget_name=xu.budget_name and
( xu.status_code_=xxen_upload.status_error or
(
(gb.require_budget_journals_flag='Y' and
exists (select 1 from gl_interface gi where gi.group_id=xu.group_id and nvl(gi.status,'PROCESSED')<>'PROCESSED'))
or
(gb.require_budget_journals_flag='N' and
exists (select 1 from gl_budget_interface gbi where gbi.rowid=chartorowid(xu.row_id)))
)
)Order Bybudget_organization,
budget_name,
accountSuccess SQLselect
xxen_upload.action_meaning(xu.action_code_) action_,
xxen_upload.status_meaning(xxen_upload.status_success) status_,
'Successfully processed' message_,
xu.modified_columns_,
xu.row_id,
xu.request_id_,
case when xu.request_id_ is not null then 'HYPERLINK("'||xxen_util.concurrent_request_file_url('O',xu.request_id_)||'")' end request_output,
to_number(null) group_id,
glv.name ledger_name,
gbe.name budget_organization,
gbve.budget_name,
xu.budget_requires_journal,
xu.journal_source_name,
xu.journal_category_name,
xu.currency_code,
to_number(xu.fiscal_year) fiscal_year,
null add_or_replace,
gcck.concatenated_segments account,
xu.period1_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=1 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=1 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period1_amount,
xu.period2_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=2 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=2 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period2_amount,
xu.period3_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=3 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=3 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period3_amount,
xu.period4_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=4 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=4 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period4_amount,
xu.period5_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=5 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=5 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period5_amount,
xu.period6_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=6 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=6 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period6_amount,
xu.period7_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=7 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=7 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period7_amount,
xu.period8_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=8 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=8 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period8_amount,
xu.period9_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=9 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=9 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period9_amount,
xu.period10_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=10 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=10 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period10_amount,
xu.period11_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=11 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=11 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period11_amount,
xu.period12_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=12 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=12 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period12_amount,
xu.period13_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=13 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=13 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period13_amount,
xu.period14_name,
(
select
(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.budget_version_id=geb.budget_version_id and
gb.period_num=14 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id and
gb.last_update_date>sysdate-.1
) period14_amount,
xu.period15_name,
(
select
(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.budget_version_id=geb.budget_version_id and
gb.period_num=15 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id and
gb.last_update_date>sysdate-.1
) period15_amount,
xu.period16_name,
(
select
(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.budget_version_id=geb.budget_version_id and
gb.period_num=16 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id and
gb.last_update_date>sysdate-.1
) period16_amount,
xu.period17_name,
(
select
(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.budget_version_id=geb.budget_version_id and
gb.period_num=17 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id and
gb.last_update_date>sysdate-.1
) period17_amount,
xu.period18_name,
(
select
(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.budget_version_id=geb.budget_version_id and
gb.period_num=18 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id and
gb.last_update_date>sysdate-.1
) period18_amount,
xu.period19_name,
(
select
(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.budget_version_id=geb.budget_version_id and
gb.period_num=19 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id and
gb.last_update_date>sysdate-.1
) period19_amount,
xu.period20_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=20 and
gbp.period_year=xu.fiscal_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=20 and
gb.period_year=xu.fiscal_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
)
end period20_amount
from
xxen_gl_budget_amounts_1858_u xu,
gl_budgets_v gbv,
gl_budget_entities gbe,
gl_entity_budgets geb,
gl_budget_versions gbve,
gl_ledgers_v glv,
gl_code_combinations_kfv gcck
where
xu.status_code_=xxen_upload.status_success and
gcck.chart_of_accounts_id=glv.chart_of_accounts_id and
gbv.budget_name=gbve.budget_name and
gbv.budget_name=gbve.budget_name and
glv.ledger_id=gbe.ledger_id and
geb.budget_version_id=gbve.budget_version_id and
gbe.budget_entity_id=geb.budget_entity_id and
gbv.budget_name=xu.budget_name and
gbe.name=xu.budget_organization and
xu.account=gcck.concatenated_segments and
gcck.enabled_flag='Y' and
gcck.summary_flag='N' and
gcck.detail_budgeting_allowed='Y' and
gcck.template_id is null and
sysdate between nvl(gcck.start_date_active,sysdate) and nvl(gcck.end_date_active,(sysdate+1)) and
(
(gbv.require_budget_journals_flag='Y' and
not exists (select 1 from gl_interface gi where gi.group_id=xu.group_id and nvl(gi.status,'PROCESSED')<>'PROCESSED'))
or
(gbv.require_budget_journals_flag='N' and
not exists (select 1 from gl_budget_interface gbi where gbi.rowid=chartorowid(xu.row_id)))
)LOV query:$column$.budget_organizationBUDGET_ORGANIZATIONACCOUNTLOV query:$column$.currency_codeCURRENCY_CODEACCOUNTLOV query:$column$.ledger_nameLEDGER_NAMEACCOUNTLOV query:$column$.budget_nameBUDGET_NAMEADD_OR_REPLACELOV query:$column$.budget_organizationBUDGET_ORGANIZATIONBUDGET_NAMELOV query:$column$.ledger_nameLEDGER_NAMEBUDGET_NAMELOV query:$column$.ledger_nameLEDGER_NAMEBUDGET_ORGANIZATIONDefault value:$column$.budget_nameBUDGET_NAMEBUDGET_REQUIRES_JOURNALLOV query:$column$.budget_nameBUDGET_NAMEFISCAL_YEARLOV query:$column$.budget_nameBUDGET_NAMEJOURNAL_CATEGORY_NAMELOV query:$column$.budget_nameBUDGET_NAMEJOURNAL_SOURCE_NAMEDefault value:$flex$.ledgerLedger|1=1|LEDGER_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD10_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD10_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD10_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD11_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD11_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD11_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD12_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD12_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD12_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD13_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD13_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD13_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD14_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD14_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD14_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD15_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD15_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD15_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD16_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD16_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD16_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD17_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD17_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD17_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD18_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD18_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD18_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD19_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD19_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD19_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD1_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD1_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD1_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD20_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD20_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD20_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD2_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD2_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD2_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD3_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD3_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD3_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD4_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD4_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD4_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD5_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD5_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD5_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD6_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD6_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD6_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD7_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD7_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD7_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD8_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD8_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD8_NAMEDefault value:$column$.budget_nameBUDGET_NAMEPERIOD9_NAMEDefault value:$column$.fiscal_yearFISCAL_YEARPERIOD9_NAMEDefault value:$column$.ledger_nameLEDGER_NAMEPERIOD9_NAMEValue to id query:$column$.budget_nameBUDGET_NAMEp_update_logic_typeExcel validation:$column$.budget_nameBUDGET_NAMEExcel validation:$column$.journal_category_nameJOURNAL_CATEGORY_NAMEExcel validation:$column$.journal_source_nameJOURNAL_SOURCE_NAME