ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C8A7FD7AC922667BE0530100007F4469 CE Internal Bank Account Currency (Secured) Y select distinct cba.currency_code value, fcv.name description from ce_bank_accounts cba, fnd_currencies_vl fcv where fcv.currency_code = cba.currency_code and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) ) order by cba.currency_code US CE Internal Bank Account Curency Codes secured by CE Security Profile C8A7FD7AC920667BE0530100007F4469 CE Internal Bank Account Name (Secured) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name US CE Internal Bank Account Names secured by CE Security Profile C8A7FD7AC91F667BE0530100007F4469 CE Internal Bank Account Number (secured, masked) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.masked_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num US CE Internal Bank Account Numbers secured by CE Security Profile CB5B97B15AC6A126E05362FB09055DE0 CE Internal Bank Branch Names Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name US CE Internal Bank Branch Names CB5B97B15AC5A126E05362FB09055DE0 CE Internal Bank Names Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name US CE Internal Bank Names C9C878DC04AA0259E0530100007FB368 CE Legal Entities Y select distinct xep.name value, null description from xle_entity_profiles xep, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where xep.legal_entity_id = cba.account_owner_org_id and cba.bank_account_id = cbaua.bank_account_id and ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) US CE Legal Entities C9C7B5F055130610E0530100007FBDAD with ce_bank_acct_bal_qry1 as ( select cbab.bank_account_id, cbab.balance_date_ balance_date, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.balance_date when trunc(cbab.balance_date)=:p_as_of_date and cbab.ledger_balance is not null then cbab.balance_date else cbab2.actual_balance_date end actual_balance_date, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.ledger_balance when trunc(cbab.balance_date)=:p_as_of_date and cbab.ledger_balance is not null then cbab.ledger_balance else cbab2.ledger_balance end ledger_balance, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.available_balance when trunc(cbab.balance_date)=:p_as_of_date and cbab.available_balance is not null then cbab.available_balance else cbab2.available_balance end available_balance, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.value_dated_balance when trunc(cbab.balance_date)=:p_as_of_date and cbab.value_dated_balance is not null then cbab.value_dated_balance else cbab2.value_dated_balance end value_dated_balance, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.one_day_float when trunc(cbab.balance_date)=:p_as_of_date and cbab.one_day_float is not null then cbab.one_day_float else cbab2.one_day_float end one_day_float, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.two_day_float when trunc(cbab.balance_date)=:p_as_of_date and cbab.two_day_float is not null then cbab.two_day_float else cbab2.two_day_float end two_day_float, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.average_close_ledger_mtd when trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_ledger_mtd is not null then cbab.average_close_ledger_mtd else cbab2.average_close_ledger_mtd end average_close_ledger_mtd, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.average_close_available_mtd when trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_available_mtd is not null then cbab.average_close_available_mtd else cbab2.average_close_available_mtd end average_close_available_mtd, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.average_close_ledger_ytd when trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_ledger_ytd is not null then cbab.average_close_ledger_ytd else cbab2.average_close_ledger_ytd end average_close_ledger_ytd, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.average_close_available_ytd when trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_available_ytd is not null then cbab.average_close_available_ytd else cbab2.average_close_available_ytd end average_close_available_ytd, case when :p_as_of_date is null or nvl(:p_bf_flag,'N')='N' then cbab.projected_balance when trunc(cbab.balance_date)=:p_as_of_date and cbab.projected_balance is not null then cbab.projected_balance else cpb2.projected_balance end projected_balance, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.ledger_balance is not null) then 'Ledger ' end ledger_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.available_balance is not null) then 'Available ' end available_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.value_dated_balance is not null) then 'ValueDated ' end value_dated_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.one_day_float is not null) then 'OneDayFloat ' end one_day_float_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.two_day_float is not null) then 'TwoDayFloat ' end two_day_float_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_ledger_mtd is not null) then 'AvgCloseLdgMTD ' end avg_close_ledger_mtd_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_available_mtd is not null) then 'AvgCloseAvailMTD ' end avg_close_available_mtd_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_ledger_ytd is not null) then 'AvgCloseLdgYTD ' end avg_close_ledger_ytd_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.average_close_available_ytd is not null) then 'AvgCloseAvailYTD ' end avg_close_available_ytd_bf, case when :p_as_of_date is not null and :p_bf_flag='Y' and not (trunc(cbab.balance_date)=:p_as_of_date and cbab.projected_balance is not null) then 'Projected ' end projected_bf from ( select nvl(cbab.bank_account_id,cpb.bank_account_id) bank_account_id_, nvl(cbab.balance_date,cpb.balance_date) balance_date_, cbab.*, cpb.projected_balance from ce_bank_acct_balances cbab full join ce_projected_balances cpb on cbab.bank_account_id=cpb.bank_account_id and cbab.balance_date=cpb.balance_date ) cbab, ( select distinct cbab.bank_account_id, max(nvl2(cbab.ledger_balance,cbab.balance_date,null)) over (partition by cbab.bank_account_id) actual_balance_date, max(cbab.ledger_balance) keep (dense_rank last order by nvl2(cbab.ledger_balance,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) ledger_balance, max(cbab.available_balance) keep (dense_rank last order by nvl2(cbab.available_balance,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) available_balance, max(cbab.value_dated_balance) keep (dense_rank last order by nvl2(cbab.value_dated_balance,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) value_dated_balance, max(cbab.one_day_float) keep (dense_rank last order by nvl2(cbab.one_day_float,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) one_day_float, max(cbab.two_day_float) keep (dense_rank last order by nvl2(cbab.two_day_float,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) two_day_float, max(cbab.average_close_ledger_mtd) keep (dense_rank last order by nvl2(cbab.average_close_ledger_mtd,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) average_close_ledger_mtd, max(cbab.average_close_available_mtd) keep (dense_rank last order by nvl2(cbab.average_close_available_mtd,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) average_close_available_mtd, max(cbab.average_close_ledger_ytd) keep (dense_rank last order by nvl2(cbab.average_close_ledger_ytd,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) average_close_ledger_ytd, max(cbab.average_close_available_ytd) keep (dense_rank last order by nvl2(cbab.average_close_available_ytd,1,0), cbab.balance_date, cbab.bank_acct_balance_id) over (partition by cbab.bank_account_id) average_close_available_ytd from ce_bank_acct_balances cbab where :p_as_of_date is not null and :p_bf_flag='Y' and cbab.balance_date<:p_as_of_date ) cbab2, ( select distinct cpb.bank_account_id, max(cpb.projected_balance) keep (dense_rank last order by nvl2(cpb.projected_balance,1,0), cpb.balance_date, cpb.projected_balance_id) over (partition by cpb.bank_account_id) projected_balance from ce_projected_balances cpb where :p_as_of_date is not null and :p_bf_flag='Y' and cpb.balance_date<:p_as_of_date ) cpb2 where cbab.bank_account_id_=cbab2.bank_account_id(+) and cbab.bank_account_id_=cpb2.bank_account_id(+) ), ce_bank_acct_bal_qry2 as ( select xep.name legal_entity, cbacv.masked_account_num, cbacv.bank_account_name, cbacv.currency_code bank_account_currency, ce_bankacct_ba_report_util.get_rate(cbacv.currency_code,:p_rep_currency,to_char(:p_rep_exchange_rate_date,'YYYY/MM/DD HH24:MI:SS'),:p_rep_exchange_rate_type) exchange_rate, hpb.party_name bank_name, hpbb.party_name branch_name, xxen_util.meaning('BA','BALANCE_SERCH_TYPE',260) balance_type, cbabq1.balance_date, cbabq1.ledger_balance, cbabq1.available_balance, cbabq1.value_dated_balance, cbabq1.one_day_float, cbabq1.two_day_float, cbabq1.projected_balance, cbabq1.average_close_ledger_mtd average_closing_ledger_mtd, cbabq1.average_close_available_mtd average_closing_available_mtd, cbabq1.average_close_ledger_ytd average_closing_ledger_ytd, cbabq1.average_close_available_ytd average_closing_available_ytd, cbacv.min_target_balance, cbacv.max_target_balance, cbabq1.ledger_bf, cbabq1.available_bf, cbabq1.value_dated_bf, cbabq1.one_day_float_bf, cbabq1.two_day_float_bf, cbabq1.projected_bf, cbabq1.avg_close_ledger_mtd_bf, cbabq1.avg_close_available_mtd_bf, cbabq1.avg_close_ledger_ytd_bf, cbabq1.avg_close_available_ytd_bf, 'BA' type_code, cbacv.bank_account_id, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid, cbabq1.actual_balance_date from ce_bank_acct_bal_qry1 cbabq1, ce_bank_accts_calc_v cbacv, ce_bank_accts_gt_v cbagv, gl_code_combinations gcc, hz_parties hpb, hz_parties hpbb, xle_entity_profiles xep where 2=2 and cbabq1.bank_account_id=cbacv.bank_account_id and cbabq1.bank_account_id=cbagv.bank_account_id and cbagv.asset_code_combination_id=gcc.code_combination_id(+) and cbacv.bank_id=hpb.party_id and cbacv.bank_branch_id=hpbb.party_id and cbacv.account_owner_org_id=xep.legal_entity_id union all select xep.name legal_entity, cbacv.masked_account_num, cc.name bank_account_name, cbacv.currency_code bank_account_currency, ce_bankacct_ba_report_util.get_rate(cbacv.currency_code,:p_rep_currency,to_char(:p_rep_exchange_rate_date,'YYYY/MM/DD HH24:MI:SS'),:p_rep_exchange_rate_type) exchange_rate, hpb.party_name bank_name, xxen_util.meaning('CP','BALANCE_SERCH_TYPE',260) balance_type, hpbb.party_name branch_name, cbab.balance_date, to_number(null) ledger_balance, to_number(null) available_balance, ce_bal_util.get_pool_balance(cc.cashpool_id, cbab.balance_date) value_dated_balance, to_number(null) one_day_float, to_number(null) two_day_float, to_number(null) projected_balance, to_number(null) average_closing_ledger_mtd, to_number(null) average_closing_available_mtd, to_number(null) average_closing_ledger_ytd, to_number(null) average_closing_available_ytd, to_number(null) min_target_balance, to_number(null) max_target_balance, null ledger_bf, null available_bf, null value_dated_bf, null one_day_float_bf, null two_day_float_bf, null projected_bf, null avg_close_ledger_mtd_bf, null avg_close_available_mtd_bf, null avg_close_ledger_ytd_bf, null avg_close_available_ytd_bf, 'CP' type_code, cbacv.bank_account_id, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid, to_date(null) actual_balance_date from ce_bank_accts_calc_v cbacv, ce_cashpools cc, ( select distinct ccsa.cashpool_id, cbab.balance_date from ce_cashpool_sub_accts ccsa, ce_bank_acct_balances cbab where 3=3 and ccsa.account_id=cbab.bank_account_id ) cbab, ce_bank_accts_gt_v cbagv, gl_code_combinations gcc, hz_parties hpb, hz_parties hpbb, xle_entity_profiles xep where cbacv.bank_account_id=cc.conc_account_id and cc.cashpool_id=cbab.cashpool_id and cbacv.bank_account_id=cbagv.bank_account_id and cbagv.asset_code_combination_id=gcc.code_combination_id(+) and cbacv.bank_id=hpb.party_id and cbacv.bank_branch_id=hpbb.party_id and cbacv.account_owner_org_id=xep.legal_entity_id ) -- -- Main Query Starts Here -- select cbab.legal_entity, cbab.masked_account_num bank_account_num, cbab.bank_account_name, cbab.bank_account_currency, cbab.bank_name, cbab.branch_name, cbab.balance_type, nvl(:p_as_of_date,cbab.balance_date) balance_date, cbab.ledger_balance, cbab.available_balance, cbab.value_dated_balance, cbab.one_day_float, cbab.two_day_float, cbab.average_closing_ledger_mtd, cbab.average_closing_available_mtd, cbab.average_closing_ledger_ytd, cbab.average_closing_available_ytd, cbab.projected_balance, case :p_proj_variance_type when 'C' then cbab.available_balance - cbab.projected_balance -- available balance when 'CAM' then cbab.average_closing_available_mtd - cbab.projected_balance -- Avg Closing Avail MTD when 'CAY' then cbab.average_closing_available_ytd - cbab.projected_balance -- Avg Closing Avail YTD when 'CLM' then cbab.average_closing_ledger_mtd - cbab.projected_balance -- Avg Closing Ledger MTD when 'CLY' then cbab.average_closing_ledger_ytd - cbab.projected_balance -- Avg Closing Ledger YTD when 'I' then cbab.value_dated_balance - cbab.projected_balance -- Value Dated Balance when 'L' then cbab.ledger_balance - cbab.projected_balance -- Ledger Balance when 'O' then cbab.one_day_float - cbab.projected_balance -- One Day Float when 'T' then cbab.two_day_float - cbab.projected_balance -- Two Day Float end act_vs_proj_variance, xxen_util.meaning(:p_proj_variance_type,'BANK_ACC_BAL_TYPE',260) variance_type, cbab.min_target_balance, cbab.max_target_balance, case when :p_as_of_date is not null then nvl2(cbab.ledger_balance , cbab.ledger_bf , null) || nvl2(cbab.available_balance , cbab.available_bf , null) || nvl2(cbab.value_dated_balance , cbab.value_dated_bf , null) || nvl2(cbab.one_day_float , cbab.one_day_float_bf , null) || nvl2(cbab.two_day_float , cbab.two_day_float_bf , null) || nvl2(cbab.projected_balance , cbab.projected_bf , null) || nvl2(cbab.average_closing_ledger_mtd , cbab.avg_close_ledger_mtd_bf , null) || nvl2(cbab.average_closing_available_mtd, cbab.avg_close_available_mtd_bf, null) || nvl2(cbab.average_closing_ledger_ytd , cbab.avg_close_ledger_ytd_bf , null) || nvl2(cbab.average_closing_available_ytd, cbab.avg_close_available_ytd_bf, null) end as_of_date_balances_bf_flag, -- Statement Details csh.statement_number, csh.statement_date, csh.control_begin_balance statement_opening_balance, csh.control_end_balance statement_closing_balance, -- Reporting Currency :p_rep_currency reporting_currency, case when cbab.exchange_rate>0 then to_char(cbab.exchange_rate) else nvl2(:p_rep_currency,'No Exchange Rate',null) end exchange_rate, case when cbab.exchange_rate>0 then cbab.ledger_balance * cbab.exchange_rate end rep_curr_ledger_balance, case when cbab.exchange_rate>0 then cbab.available_balance * cbab.exchange_rate end rep_curr_available_balance, case when cbab.exchange_rate>0 then cbab.value_dated_balance * cbab.exchange_rate end rep_curr_value_dated_balance, case when cbab.exchange_rate>0 then cbab.one_day_float * cbab.exchange_rate end rep_curr_one_day_float, case when cbab.exchange_rate>0 then cbab.two_day_float * cbab.exchange_rate end rep_curr_two_day_float, case when cbab.exchange_rate>0 then cbab.average_closing_ledger_mtd * cbab.exchange_rate end rep_curr_avg_close_ledger_mtd, case when cbab.exchange_rate>0 then cbab.average_closing_available_mtd * cbab.exchange_rate end rep_curr_avg_close_avail_mtd, case when cbab.exchange_rate>0 then cbab.average_closing_ledger_ytd * cbab.exchange_rate end rep_curr_avg_close_ledger_ytd, case when cbab.exchange_rate>0 then cbab.average_closing_available_ytd * cbab.exchange_rate end rep_curr_avg_close_avail_ytd, case when cbab.exchange_rate>0 then cbab.projected_balance * cbab.exchange_rate end rep_curr_projected_balance, case when cbab.exchange_rate>0 then case :p_proj_variance_type when 'C' then (cbab.available_balance - cbab.projected_balance) -- available balance when 'CAM' then (cbab.average_closing_available_mtd - cbab.projected_balance) -- Avg Closing Avail MTD when 'CAY' then (cbab.average_closing_available_ytd - cbab.projected_balance) -- Avg Closing Avail YTD when 'CLM' then (cbab.average_closing_ledger_mtd - cbab.projected_balance) -- Avg Closing Ledger MTD when 'CLY' then (cbab.average_closing_ledger_ytd - cbab.projected_balance) -- Avg Closing Ledger YTD when 'I' then (cbab.value_dated_balance - cbab.projected_balance) -- Value Dated Balance when 'L' then (cbab.ledger_balance - cbab.projected_balance) -- Ledger Balance when 'O' then (cbab.one_day_float - cbab.projected_balance) -- One Day Float when 'T' then (cbab.two_day_float - cbab.projected_balance) -- Two Day Float end * cbab.exchange_rate end rep_curr_act_vs_proj_variance, case when cbab.exchange_rate>0 then cbab.min_target_balance * cbab.exchange_rate end rep_curr_min_target_balance, case when cbab.exchange_rate>0 then cbab.max_target_balance * cbab.exchange_rate end rep_curr_max_target_balance, -- GL Cash Account Details nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'GL_BALANCING', 'Y', 'VALUE'),null) gl_company_code, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'GL_BALANCING', 'Y', 'DESCRIPTION'),null) gl_company_desc, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'GL_ACCOUNT', 'Y', 'VALUE'),null) gl_account_code, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),null) gl_account_desc, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'FA_COST_CTR', 'Y', 'VALUE'),null) gl_cost_center_code, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'FA_COST_CTR', 'Y', 'DESCRIPTION'),null) gl_cost_center_desc, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'ALL', 'Y', 'VALUE'),null) gl_cash_account, nvl2(cbab.asset_ccid,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cbab.coaid, null, cbab.asset_ccid, 'ALL', 'Y', 'DESCRIPTION'),null) gl_cash_account_desc, -- pivot labels cbab.bank_name||' - '||cbab.masked_account_num||' - '||cbab.bank_account_name||' ('|| cbab.bank_account_currency||')' bank_account_pivot_label from ce_bank_acct_bal_qry2 cbab, ce_statement_headers csh where 1=1 and decode(cbab.type_code,'BA',cbab.bank_account_id,null)=csh.bank_account_id(+) and decode(cbab.type_code,'BA',cbab.actual_balance_date,null)=csh.statement_date(+) order by cbab.bank_name, cbab.masked_account_num, cbab.balance_date Rebuild for better performance Y #,##0.00;[Red]-#,##0.00 CE_CEXSTMRR_XMLP_PKG not((:Balance_Date_From is not null or :Balance_Date_To is not null) and :Balance_As_Of_Date is not null) US CE Bank Account Balances Application: Cash Management Description: Bank Accounts - Balances Report Provides equivalent functionality to the following standard Oracle Forms/Reports - Bank Account Balances OAF Page - Bank Account Balance Range Day Report - Bank Account Balance Single Date Report - Bank Account Balance Actual vs Projected Report Single (As Of) Date Report - Specify the required Date in the As Of Date parameter - Specify Yes in the 'Bring Forward Prior Balances' if you want to roll the most recent prior balance entries forward if a balance does not exist on the specified As Of Date - Specify No in the 'Bring Forward Prior Balances' if you only want to see the balances that have been entered on the specified As Of Date. - Applicable Templates: Pivot: As of Date Summary by Currency and Account Detail As of Date/Range Date Report Range Day Report - Specify the required date range in the Balance Date From/To Parameters - When run in this mode the report shows the balances entered for every date within the date range. - Balances are not rolled forward in this mode. - Applicable Templates: Detail As of Date/Range Date Report Actual vs Projected Report - The report includes actual and projected balances in both As Of Date and Date Range Modes - Optionally specify the actual balance type to be compared to the projected balance in the 'Actual vs Projected Balance Type' parameter. When specified, the variance between the actual balance and projected balance will be displayed in the report. - Applicable Templates: Pivot: As of Date Summary by Currency and Account Detail As of Date/Range Date Report Sources: Bank Account Balance Single Date Report (CEBABSGR) Bank Account Balance Range Day Report (CEBABRGR) Bank Account Balance Actual vs Projected Report (CEBABAPR) DB package: CE_CEXSTMRR_XMLP_PKG (required to initialize security) Specify either a "Balance Date From/To Range" OR a "Balance As Of Date". Enginatics R12 only 1=1 2=2 3=3 :c_account_name_dsp :c_account_number_dsp :c_all_translation :c_bank_branch_dsp :c_bank_curr_dsp :c_bank_name_dsp :c_display_message :c_external_translation :c_gl_currency_code :c_name :c_set_of_books_id :c_stat_date_sql_lex :c_stat_number_sql_lex :c_the_end :c_trx_reference_type :p_as_of_date :p_bank_account_id :p_bf_flag :p_conc_request_id :p_debug_mode :p_proj_variance_type :p_rep_currency :p_rep_exchange_rate_date :p_rep_exchange_rate_type :p_sql_trace :p_stat_date_from :p_stat_date_from_t :p_stat_date_to :p_stat_date_to_t :p_stat_number_from :p_stat_number_to :p_statement_or_account :p_stmt_line_status :p_test_layout 1 10 1=1 cbab.legal_entity=:p_legal_entity LOV CE Legal Entities C9C878DC04AA0259E0530100007FB368 Y select distinct xep.name value, null description from xle_entity_profiles xep, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where xep.legal_entity_id = cba.account_owner_org_id and cba.bank_account_id = cbaua.bank_account_id and ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) select clbovv.name from ce_le_bg_ou_vs_v clbovv, hr_operating_units hou, gl_ledgers gl, gl_ledger_config_details glcd, xle_firstparty_information_v xfi where hou.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) and hou.set_of_books_id=gl.ledger_id and gl.object_type_code='L' and gl.configuration_id=glcd.configuration_id and glcd.object_type_code='LEGAL_ENTITY' and glcd.setup_step_code='NONE' and glcd.object_id=xfi.legal_entity_id and xfi.legal_entity_id = clbovv.legal_entity_id F Entité légale US Legal Entity 2 20 1=1 cbab.bank_name=:p_bank_name LOV CE Internal Bank Names CB5B97B15AC5A126E05362FB09055DE0 Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name F Nom de la banque US Bank Name 3 30 1=1 cbab.branch_name=:p_bank_branch_name LOV CE Internal Bank Branch Names CB5B97B15AC6A126E05362FB09055DE0 Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name F Succursale bancaire US Bank Branch 4 40 1=1 cbab.bank_account_name=:p_account_name LOV CE Internal Bank Account Name (Secured) C8A7FD7AC920667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name F Nom du compte bancaire US Bank Account Name 5 50 1=1 cbab.masked_account_num=:p_account_num LOV CE Internal Bank Account Number (secured, masked) C8A7FD7AC91F667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.masked_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num F Numéro de compte bancaire US Bank Account Number 6 60 1=1 cbab.type_code=xxen_util.lookup_code(:p_balance_type,'BALANCE_SERCH_TYPE',260) LOV custom Y select cl.meaning value, null description from ce_lookups cl where cl.lookup_type = 'BALANCE_SERCH_TYPE' order by cl.meaning select cl.meaning value from ce_lookups cl where cl.lookup_type = 'BALANCE_SERCH_TYPE' and cl.lookup_code = 'BA' Y F Type d'équilibre US Balance Type 7 70 1=1 cbab.balance_date>=:p_balance_date_from Date F Date du solde Du US Balance Date From 8 80 1=1 cbab.balance_date<:p_balance_date_to+1 Date :$flex$.Balance_Date_From F Date du solde Au US Balance Date To 9 90 :p_as_of_date Date trunc(sysdate) F Solde à la date US Balance As Of Date 10 2=2 cbabq1.balance_date=(select max(cbabq.balance_date) from ce_bank_acct_bal_qry1 cbabq where cbabq1.bank_account_id=cbabq.bank_account_id and cbabq.balance_date<=:p_as_of_date) F Solde à la date US Balance As Of Date 11 3=3 cbab.balance_date=( select max(cbab2.balance_date) from ce_cashpool_sub_accts ccsa2, ce_bank_acct_balances cbab2 where ccsa.cashpool_id=ccsa2.cashpool_id and ccsa2.account_id=cbab2.bank_account_id and cbab2.balance_date<=:p_as_of_date ) F Solde à la date US Balance As Of Date 12 100 :p_bf_flag LOV custom Y select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' and :$flex$.Balance_As_Of_Date is not null order by id select meaning value from fnd_lookups where fnd_lookups.lookup_type='YES_NO' and lookup_code = 'Y' and :$flex$.Balance_As_Of_Date is not null F Report des soldes antérieurs US Bring Forward Prior Balances 13 1=1 cbab.balance_date = :p_as_of_date No F Report des soldes antérieurs US Bring Forward Prior Balances 14 110 :p_proj_variance_type LOV Oracle CE_BALANCE_TYPES Y select lookup_code id, meaning value, null description from ce_lookups where lookup_type='BANK_ACC_BAL_TYPE' order by value,description F Réel vs projeté Type de solde US Actual vs Projected Balance Type 15 120 1=1 cbab.bank_account_currency=:p_currency_code LOV CE Internal Bank Account Currency (Secured) C8A7FD7AC922667BE0530100007F4469 Y select distinct cba.currency_code value, fcv.name description from ce_bank_accounts cba, fnd_currencies_vl fcv where fcv.currency_code = cba.currency_code and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) ) order by cba.currency_code F Devise du compte bancaire US Bank Account Currency 16 130 :p_rep_currency LOV Oracle CE_FC_CURRENCIES Y select currency_code id, currency_code value, name description from fnd_currencies_vl where enabled_flag='Y' and currency_flag='Y' and (nvl(end_date_active,sysdate)>=sysdate) and (nvl(start_date_active,sysdate)<=sysdate) order by currency_code F Devise de référence US Reporting Currency 17 140 :p_rep_exchange_rate_type LOV Oracle XLA_EXCHANGE_RATE_TYPES_REPORTING Y select conversion_type id, user_conversion_type value, null description from gl_daily_conversion_types where :$flex$.ce_fc_currencies is not null order by value,description F Type de taux de change de déclaration US Reporting Exchange Rate Type 18 150 :p_rep_exchange_rate_date Date trunc(sysdate) F Date du taux de change de référence US Reporting Exchange Rate Date :$flex$.Balance_As_Of_Date Balance As Of Date Y Bring Forward Prior Balances :$flex$.Balance_Date_From Balance Date From Y Balance Date To :$flex$.Bank_name Bank Name Bank Branch :$flex$.bank_branch Bank Branch Bank Account Name :$flex$.bank_branch Bank Branch Bank Account Number :$flex$.bank_name Bank Name Bank Account Name :$flex$.bank_name Bank Name Bank Account Number :$flex$.ce_fc_currencies Reporting Currency Reporting Exchange Rate Type :$flex$.legal_entity Legal Entity Bank Account Name :$flex$.legal_entity Legal Entity Bank Account Number Detail As of Date/Range Date Report Detail As of Date/Range Date Report SYSADMIN 15 ACT_VS_PROJ_VARIANCE 23 AS_OF_DATE_BALANCES_BF_FLAG 10 AVAILABLE_BALANCE 18 AVERAGE_CLOSING_AVAILABLE_MTD 20 AVERAGE_CLOSING_AVAILABLE_YTD 17 AVERAGE_CLOSING_LEDGER_MTD 19 AVERAGE_CLOSING_LEDGER_YTD 8 BALANCE_DATE 3 7 BALANCE_TYPE 4 BANK_ACCOUNT_CURRENCY 3 BANK_ACCOUNT_NAME 2 2 BANK_ACCOUNT_NUM 51 BANK_ACCOUNT_PIVOT_LABEL 5 BANK_NAME 1 6 BRANCH_NAME 29 EXCHANGE_RATE 45 GL_ACCOUNT_CODE 46 GL_ACCOUNT_DESC 49 GL_CASH_ACCOUNT 50 GL_CASH_ACCOUNT_DESC 43 GL_COMPANY_CODE 44 GL_COMPANY_DESC 47 GL_COST_CENTER_CODE 48 GL_COST_CENTER_DESC 9 LEDGER_BALANCE 1 LEGAL_ENTITY 22 MAX_TARGET_BALANCE 21 MIN_TARGET_BALANCE 12 ONE_DAY_FLOAT 14 PROJECTED_BALANCE 28 REPORTING_CURRENCY 36 REP_CURR_ACT_VS_PROJ_VARIANCE 31 REP_CURR_AVAILABLE_BALANCE 38 REP_CURR_AVG_CLOSE_AVAIL_MTD 40 REP_CURR_AVG_CLOSE_AVAIL_YTD 37 REP_CURR_AVG_CLOSE_LEDGER_MTD 39 REP_CURR_AVG_CLOSE_LEDGER_YTD 30 REP_CURR_LEDGER_BALANCE 42 REP_CURR_MAX_TARGET_BALANCE 41 REP_CURR_MIN_TARGET_BALANCE 33 REP_CURR_ONE_DAY_FLOAT 35 REP_CURR_PROJECTED_BALANCE 34 REP_CURR_TWO_DAY_FLOAT 32 REP_CURR_VALUE_DATED_BALANCE 27 STATEMENT_CLOSING_BALANCE 25 STATEMENT_DATE 24 STATEMENT_NUMBER 26 STATEMENT_OPENING_BALANCE 13 TWO_DAY_FLOAT 11 VALUE_DATED_BALANCE 16 VARIANCE_TYPE S Site Pivot: As of Date Summary by Currency and Account Pivot: As of Date Summary by Currency and Account SYSADMIN 15 ACT_VS_PROJ_VARIANCE 23 AS_OF_DATE_BALANCES_BF_FLAG 10 AVAILABLE_BALANCE 18 AVERAGE_CLOSING_AVAILABLE_MTD 20 AVERAGE_CLOSING_AVAILABLE_YTD 17 AVERAGE_CLOSING_LEDGER_MTD 19 AVERAGE_CLOSING_LEDGER_YTD 8 BALANCE_DATE 3 7 BALANCE_TYPE 4 BANK_ACCOUNT_CURRENCY 3 BANK_ACCOUNT_NAME 2 2 BANK_ACCOUNT_NUM 51 BANK_ACCOUNT_PIVOT_LABEL 5 BANK_NAME 1 6 BRANCH_NAME 29 EXCHANGE_RATE 45 GL_ACCOUNT_CODE 46 GL_ACCOUNT_DESC 49 GL_CASH_ACCOUNT 50 GL_CASH_ACCOUNT_DESC 43 GL_COMPANY_CODE 44 GL_COMPANY_DESC 47 GL_COST_CENTER_CODE 48 GL_COST_CENTER_DESC 9 LEDGER_BALANCE 1 LEGAL_ENTITY 22 MAX_TARGET_BALANCE 21 MIN_TARGET_BALANCE 12 ONE_DAY_FLOAT 14 PROJECTED_BALANCE 28 REPORTING_CURRENCY 36 REP_CURR_ACT_VS_PROJ_VARIANCE 31 REP_CURR_AVAILABLE_BALANCE 38 REP_CURR_AVG_CLOSE_AVAIL_MTD 40 REP_CURR_AVG_CLOSE_AVAIL_YTD 37 REP_CURR_AVG_CLOSE_LEDGER_MTD 39 REP_CURR_AVG_CLOSE_LEDGER_YTD 30 REP_CURR_LEDGER_BALANCE 42 REP_CURR_MAX_TARGET_BALANCE 41 REP_CURR_MIN_TARGET_BALANCE 33 REP_CURR_ONE_DAY_FLOAT 35 REP_CURR_PROJECTED_BALANCE 34 REP_CURR_TWO_DAY_FLOAT 32 REP_CURR_VALUE_DATED_BALANCE 27 STATEMENT_CLOSING_BALANCE 25 STATEMENT_DATE 24 STATEMENT_NUMBER 26 STATEMENT_OPENING_BALANCE 13 TWO_DAY_FLOAT 11 VALUE_DATED_BALANCE 16 VARIANCE_TYPE ACT_VS_PROJ_VARIANCE VALUE 7 SUM AVAILABLE_BALANCE VALUE 2 SUM AVERAGE_CLOSING_AVAILABLE_MTD VALUE 9 AVG AVERAGE_CLOSING_AVAILABLE_YTD VALUE 11 AVG AVERAGE_CLOSING_LEDGER_MTD VALUE 8 AVG AVERAGE_CLOSING_LEDGER_YTD VALUE 10 AVG BALANCE_DATE FILTER 8 BALANCE_TYPE FILTER 7 BANK_ACCOUNT_CURRENCY ROW 1 BANK_ACCOUNT_NAME FILTER 6 BANK_ACCOUNT_NUM FILTER 5 BANK_ACCOUNT_PIVOT_LABEL ROW 2 BANK_NAME FILTER 3 BRANCH_NAME FILTER 4 GL_COMPANY_DESC FILTER 2 LEDGER_BALANCE VALUE 1 SUM LEGAL_ENTITY FILTER 1 ONE_DAY_FLOAT VALUE 4 SUM PROJECTED_BALANCE VALUE 6 SUM REPORTING_CURRENCY FILTER 9 REP_CURR_ACT_VS_PROJ_VARIANCE VALUE 18 SUM REP_CURR_AVAILABLE_BALANCE VALUE 13 SUM REP_CURR_AVG_CLOSE_AVAIL_MTD VALUE 20 AVG REP_CURR_AVG_CLOSE_AVAIL_YTD VALUE 22 AVG REP_CURR_AVG_CLOSE_LEDGER_MTD VALUE 19 AVG REP_CURR_AVG_CLOSE_LEDGER_YTD VALUE 21 AVG REP_CURR_LEDGER_BALANCE VALUE 12 SUM REP_CURR_ONE_DAY_FLOAT VALUE 15 SUM REP_CURR_PROJECTED_BALANCE VALUE 17 SUM REP_CURR_TWO_DAY_FLOAT VALUE 16 SUM REP_CURR_VALUE_DATED_BALANCE VALUE 14 SUM TWO_DAY_FLOAT VALUE 5 SUM VALUE_DATED_BALANCE VALUE 3 SUM S Site SYSADMIN Pivot: As of Date Summary by Currency and Account DEVELOPER Pivot: As of Date Summary by Currency and Account ENGINATICS Pivot: As of Date Summary by Currency and Account ANDY.HAACK Pivot: As of Date Summary by Currency and Account Detail As of Date/Range Date Report