ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F26C78167A224EFBE0530100007F336B GL Account Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and 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(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US F26C78167A214EFBE0530100007F336B GL Balancing Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and 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(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B057D82F30B17A2DE0530100007FD563 select x1.ledger ledger, x1.operating_unit operating_unit, fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_bal_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') "&lp_bal_seg_p", fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_acc_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') "&lp_acc_seg_p", fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_accounting_flexfield', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.code_combination_id, 'ALL', 'Y', 'VALUE') gl_account_segments, x1.sort_field1 salesperson, x1.cust_name customer, x1.cust_no customer_number, x1.cust_country customer_country, x1.cust_class customer_classification, x1.credit_limits, x1.order_credit_limits, x1.collector collector, &lp_invoice_cols_s x1.revaluation_from_currency amounts_currency, -- nvl(sum(case when nvl(x1.rk,1)=1 then x1.amt_due_original else 0 end),0) original_amount, nvl(sum(case when nvl(x1.rk,1)=1 then x1.amt_due_remaining else 0 end),0) outstanding_amount, nvl(sum( case when nvl(x1.rk,1)=1 and ( x1.days_past_due > 0 or (:p_credit_option = 'DETAIL' and x1.class in ('PMT','CM','CLAIM')) or (:p_risk_option = 'DETAIL' and x1.invoice_type = :p_risk_meaning) ) then x1.amt_due_remaining else 0 end ),0) past_due_amount, -- &lp_on_acc_summ_cols :p_age_basis Aging_Basis, &lp_aging_amount_cols &lp_aging_pct_cols -- Revaluation Columns &lp_reval_columns &lp_reval_aging_amount_cols -- &party_dff_cols1 &cust_dff_cols1 -- fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_bal_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') "&lp_bal_seg_p Desc", fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_acc_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') "&lp_acc_seg_p Desc" &lp_sla_sel_outer from (--x1 start select /*+ no_push_pred(sla) */ x.ledger, (select haou.name from hr_all_organization_units haou where haou.organization_id=x.org_id) operating_unit, x.sort_field1, x.sort_field2, hcpamv.credit_limits, hcpamv.order_credit_limits, x.cust_name, x.cust_no, x.cust_country, x.cust_class, (select ac.name from ar_collectors ac where ac.collector_id=nvl(hcps.collector_id,hcpa.collector_id)) collector, x.class, x.cons_billing_number, x.invnum, x.invoice_currency_code, x.term, x.trx_date, x.due_date, x.days_past_trx, x.days_past_due, x.amt_due_original, x.amount_adjusted, x.amount_applied, x.amount_credited, x.gl_date, x.data_converted, x.ps_exchange_rate, x.code_combination_id, x.chart_of_accounts_id, x.invoice_type, x.comments, x.reference, -- &lp_bucket_cols1 -- case when (:p_credit_option='SUMMARY' and x.class in ('PMT','CM','CLAIM')) or (:p_risk_option='SUMMARY' AND x.invoice_type=:p_risk_meaning) then to_number(null) else x.amt_due_remaining end amt_due_remaining, case when :p_credit_option='SUMMARY' AND x.class='PMT' then x.amt_due_remaining else null end on_account_amount_cash, case when :p_credit_option='SUMMARY' AND x.class='CM' then x.amt_due_remaining else null end on_account_amount_credit, case when :p_risk_option='SUMMARY' AND x.invoice_type=:p_risk_meaning then x.amt_due_remaining else null end on_account_amount_risk, case when :p_credit_option='SUMMARY' AND x.class='CLAIM' then x.amt_due_remaining else null end cust_amount_claim, nvl(:p_in_currency,x.functional_currency) revaluation_from_currency, decode(nvl(:p_in_currency,x.functional_currency),:p_reval_currency,1,(select gdr.conversion_rate from gl_daily_conversion_types gdct, gl_daily_rates gdr where nvl(:p_in_currency,x.functional_currency)=gdr.from_currency and gdr.to_currency=:p_reval_currency and :p_reval_conv_date=gdr.conversion_date and gdct.user_conversion_type=:p_reval_conv_type and gdct.conversion_type=gdr.conversion_type)) reval_conv_rate, -- &party_dff_cols2 &cust_dff_cols2 -- xxen_util.meaning(:p_reporting_level,'FND_MO_REPORTING_LEVEL',0) reporting_level, case :p_reporting_level when '1000' then x.ledger when '3000' then (select haou.name from hr_all_organization_units haou where haou.organization_id=x.org_id) end reporting_entity, nvl(sla.code_combination_id, x.code_combination_id) rec_code_combination_id, x.payment_sched_id, nvl(round(sla.accounted_dr*x.installment_ratio, 2), case when x.rec_acctd_amount >= 0 then x.rec_acctd_amount else 0 end) accounted_dr, nvl(round(sla.accounted_cr * x.installment_ratio, 2), case when x.rec_acctd_amount < 0 then abs(x.rec_acctd_amount) else 0 end) accounted_cr, nvl(round(case x.sla_entity_code when 'RECEIPTS' then sla.accounted_dr else sla_net.net_accounted_dr end*x.installment_ratio,2), case when x.rec_acctd_amount >= 0 then x.rec_acctd_amount else 0 end) net_accounted_dr, nvl(round(case x.sla_entity_code when 'RECEIPTS' then sla.accounted_cr else sla_net.net_accounted_cr end*x.installment_ratio,2), case when x.rec_acctd_amount < 0 then abs(x.rec_acctd_amount) else 0 end) net_accounted_cr, row_number() over (partition by x.payment_sched_id order by nvl(sla.code_combination_id, x.code_combination_id)) rk, x.sla_entity_code from (-- x start select substrb(hp.party_name,1,50) cust_name, hca.account_number cust_no, nvl(sales.name,jrrev.resource_name) sort_field1, arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) sort_field2, nvl(sales.salesrep_id, -3) salesrep_id, rt.name term, site.site_use_id, loc.state cust_state, loc.city cust_city, (select ftv.territory_short_name from fnd_territories_vl ftv where ftv.territory_code=loc.country) cust_country, xxen_util.meaning(hca.customer_class_code,'CUSTOMER CLASS',222) cust_class, decode(decode(upper(rtrim(rpad(:p_in_format_option_low, 1))),'D','D',null),null,-1,acct_site.cust_acct_site_id) addr_id, nvl(hca.cust_account_id,-999) cust_id, hca.party_id, -- &party_dff_cols3 &cust_dff_cols3 -- ps.payment_schedule_id payment_sched_id, ps.class class, ps.trx_date, ps.due_date, decode(nvl2(:p_in_currency,'N','Y'), 'Y', ps.amount_due_original * nvl(ps.exchange_rate, 1), ps.amount_due_original) amt_due_original, xxen_ar_arxagrw_pkg.comp_amt_due_remainingformula (ps.class, arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id), ps.payment_schedule_id, ps.amt_due_remaining, ps.amount_applied, ps.amount_credited, ps.amount_adjusted ) amt_due_remaining, ps.trx_number invnum, ceil(:p_in_as_of_date_low - ps.trx_date) days_past_trx, ceil(:p_in_as_of_date_low - ps.due_date) days_past_due, ps.amount_adjusted amount_adjusted, ps.amount_applied amount_applied, ps.amount_credited amount_credited, ps.gl_date gl_date, decode(ps.invoice_currency_code, gsob.currency_code, null, decode(ps.exchange_rate, null, '*', null)) data_converted, nvl(ps.exchange_rate, 1) ps_exchange_rate, -- &lp_bucket_cols2 -- c.code_combination_id, c.chart_of_accounts_id, ci.cons_billing_number cons_billing_number, arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) invoice_type, rct.comments, rct.ct_reference reference, ps.invoice_currency_code, gsob.currency_code functional_currency, gsob.name ledger, gsob.set_of_books_id ledger_id, ps.org_id, gld.acctd_amount rec_acctd_amount, ps.customer_trx_id, 'TRANSACTIONS' sla_entity_code, ps.customer_trx_id sla_source_id, ps.amount_due_original/nvl( (select sum(ps2.amount_due_original) from ar_payment_schedules ps2 where ps2.customer_trx_id=ps.customer_trx_id and ps2.class<>'PMT'), 0) installment_ratio from hz_cust_accounts hca, hz_parties hp, ( select a.customer_id, a.customer_site_use_id , a.customer_trx_id, a.payment_schedule_id, a.class , sum(a.primary_salesrep_id) primary_salesrep_id, a.term_id, a.trx_date, a.due_date, sum(a.amount_due_remaining) amt_due_remaining, a.trx_number, a.amount_due_original, a.amount_adjusted, a.amount_applied , a.amount_credited , a.amount_adjusted_pending, a.gl_date , a.cust_trx_type_id, a.org_id, a.invoice_currency_code, a.exchange_rate, sum(a.cons_inv_id) cons_inv_id from ( select ps.customer_id, ps.customer_site_use_id, ps.customer_trx_id, ps.payment_schedule_id, ps.class, 0 primary_salesrep_id, ps.term_id, ps.trx_date, ps.due_date, nvl(sum(decode(nvl2(:p_in_currency,'N','Y'), 'Y', nvl(adj.acctd_amount, 0), adj.amount)),0) * (-1) amount_due_remaining, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.amount_adjusted_pending, ps.gl_date, ps.cust_trx_type_id, ps.org_id, ps.invoice_currency_code, nvl(ps.exchange_rate,1) exchange_rate, 0 cons_inv_id from ar_payment_schedules ps, ar_adjustments adj where ps.gl_date <= :p_in_as_of_date_low and ps.customer_id > 0 and ps.gl_date_closed > :p_in_as_of_date_low and decode(upper(:p_in_currency),null,ps.invoice_currency_code,upper(:p_in_currency))=ps.invoice_currency_code and adj.payment_schedule_id=ps.payment_schedule_id and adj.status='A' and adj.gl_date > :p_in_as_of_date_low and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and adj.org_id=ps.org_id group by ps.customer_id, ps.customer_site_use_id, ps.customer_trx_id, ps.class, ps.term_id, ps.trx_date, ps.due_date, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.amount_adjusted_pending, ps.gl_date, ps.cust_trx_type_id, ps.org_id, ps.invoice_currency_code, nvl(ps.exchange_rate,1), ps.payment_schedule_id union all select ps.customer_id, ps.customer_site_use_id, ps.customer_trx_id, ps.payment_schedule_id, ps.class, 0 primary_salesrep_id, ps.term_id, ps.trx_date, ps.due_date, nvl(sum(decode( nvl2(:p_in_currency,'N','Y'), 'Y', (decode(ps.class, 'CM', decode( app.application_type, 'CM', app.acctd_amount_applied_from, app.acctd_amount_applied_to), app.acctd_amount_applied_to)+ nvl(app.acctd_earned_discount_taken,0)+nvl(app.acctd_unearned_discount_taken,0) ),( app.amount_applied+nvl(app.earned_discount_taken,0)+nvl(app.unearned_discount_taken,0) ))*decode(ps.class,'CM', decode(app.application_type,'CM',-1,1),1)),0) amount_due_remaining, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied , ps.amount_credited, ps.amount_adjusted_pending, ps.gl_date gl_date, ps.cust_trx_type_id, ps.org_id, ps.invoice_currency_code, nvl(ps.exchange_rate, 1) exchange_rate, 0 cons_inv_id from ar_payment_schedules ps, ar_receivable_applications app where ps.gl_date <= :p_in_as_of_date_low and ps.customer_id > 0 and ps.gl_date_closed > :p_in_as_of_date_low and decode(upper(:p_in_currency),null,ps.invoice_currency_code, upper(:p_in_currency))=ps.invoice_currency_code and (app.applied_payment_schedule_id=ps.payment_schedule_id or app.payment_schedule_id=ps.payment_schedule_id) and app.status IN ('APP', 'ACTIVITY') and nvl( app.confirmed_flag, 'Y' )='Y' and app.gl_date > :p_in_as_of_date_low and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and app.org_id=ps.org_id group by ps.customer_id, ps.customer_site_use_id, ps.customer_trx_id, ps.class, ps.term_id, ps.trx_date, ps.due_date, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.amount_adjusted_pending, ps.gl_date, ps.cust_trx_type_id, ps.org_id, ps.invoice_currency_code, nvl(ps.exchange_rate, 1), ps.payment_schedule_id union all select ps.customer_id, ps.customer_site_use_id, ps.customer_trx_id, ps.payment_schedule_id, ps.class class, nvl(ct.primary_salesrep_id, -3) primary_salesrep_id, ps.term_id, ps.trx_date, ps.due_date, decode( nvl2(:p_in_currency,'N','Y'), 'Y', ps.acctd_amount_due_remaining, ps.amount_due_remaining) amt_due_remaining, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.amount_adjusted_pending, ps.gl_date, ps.cust_trx_type_id, ps.org_id, ps.invoice_currency_code, nvl(ps.exchange_rate, 1) exchange_rate, ps.cons_inv_id from ar_payment_schedules ps, ra_customer_trx ct where ps.gl_date <= :p_in_as_of_date_low and ps.gl_date_closed > :p_in_as_of_date_low and decode(upper(:p_in_currency),null, ps.invoice_currency_code, upper(:p_in_currency))=ps.invoice_currency_code and ps.customer_trx_id=ct.customer_trx_id and ps.class <> 'CB' and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and ct.org_id=ps.org_id union all select ps.customer_id, ps.customer_site_use_id , ps.customer_trx_id, ps.payment_schedule_id, ps.class class, nvl(ct.primary_salesrep_id,-3) primary_salesrep_id, ps.term_id, ps.trx_date, ps.due_date, decode( nvl2(:p_in_currency,'N','Y'), 'Y', ps.acctd_amount_due_remaining, ps.amount_due_remaining) amt_due_remaining, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.amount_adjusted_pending, ps.gl_date, ps.cust_trx_type_id, ps.org_id, ps.invoice_currency_code, nvl(ps.exchange_rate, 1) exchange_rate, ps.cons_inv_id from ar_payment_schedules ps, ra_customer_trx ct, ar_adjustments adj where ps.gl_date <= :p_in_as_of_date_low and ps.gl_date_closed > :p_in_as_of_date_low and decode(upper(:p_in_currency),null, ps.invoice_currency_code, upper(:p_in_currency))=ps.invoice_currency_code and ps.class='CB' and ps.customer_trx_id=adj.chargeback_customer_trx_id (+) and ps.org_id=adj.org_id (+) and adj.customer_trx_id=ct.customer_trx_id (+) and adj.org_id=ct.org_id (+) and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' ) a group by a.customer_id, a.customer_site_use_id, a.customer_trx_id, a.payment_schedule_id, a.class, a.term_id, a.trx_date, a.due_date, a.trx_number, a.amount_due_original, a.amount_adjusted, a.amount_applied, a.amount_credited, a.amount_adjusted_pending, a.gl_date, a.cust_trx_type_id, a.org_id, a.invoice_currency_code, a.exchange_rate ) ps, ar_cons_inv ci, ra_salesreps_all sales, jtf_rs_resource_extns_vl jrrev, hz_cust_site_uses site, hz_cust_acct_sites acct_site, hz_party_sites party_site, hz_locations loc, ra_cust_trx_line_gl_dist gld, ar_dispute_history dh, ra_terms rt, gl_code_combinations c, ra_customer_trx rct, gl_sets_of_books gsob where --upper(RTRIM(RPAD(:p_in_summary_option_low,1)) )='I' ps.customer_site_use_id=site.site_use_id and site.cust_acct_site_id=acct_site.cust_acct_site_id and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and ps.customer_id=hca.cust_account_id and hca.party_id=hp.party_id and ps.customer_trx_id=gld.customer_trx_id and gld.account_class='REC' and gld.latest_rec_flag='Y' and gld.code_combination_id=c.code_combination_id and ps.payment_schedule_id=dh.payment_schedule_id(+) and ps.term_id=rt.term_id (+) and :p_in_as_of_date_low >= nvl(dh.start_date(+), :p_in_as_of_date_low) and :p_in_as_of_date_low < nvl(dh.end_date(+), :p_in_as_of_date_low + 1) and ( dh.dispute_history_id is null or dh.dispute_history_id = (select max(dh2.dispute_history_id) from ar_dispute_history dh2 where dh2.payment_schedule_id=ps.payment_schedule_id and :p_in_as_of_date_low>=nvl(dh2.start_date(+), :p_in_as_of_date_low) and :p_in_as_of_date_low<nvl(dh2.end_date(+), :p_in_as_of_date_low + 1) ) ) and rct.customer_trx_id=ps.customer_trx_id and gsob.set_of_books_id=rct.set_of_books_id &lp_invoice_type_low &lp_invoice_type_high &lp_bal_seg_low &lp_bal_seg_high &lp_acc_seg_low &lp_acc_seg_high and ps.cons_inv_id=ci.cons_inv_id(+) and nvl(ps.primary_salesrep_id,-3)=sales.salesrep_id and sales.org_id=ps.org_id and jrrev.resource_id=sales.resource_id and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and gld.org_id=ps.org_id and site.org_id=ps.org_id and 2=2 union all select substrb(nvl(hp.party_name,:p_short_unid_phrase),1,50) cust_name, hca.account_number cust_no, nvl(sales.name,jrrev.resource_name), initcap(:p_payment_meaning), nvl(sales.salesrep_id,-3), null term, site.site_use_id, loc.state cust_state, loc.city cust_city, (select ftv.territory_short_name from fnd_territories_vl ftv where ftv.territory_code=loc.country) cust_country, xxen_util.meaning(hca.customer_class_code,'CUSTOMER CLASS',222) cust_class, decode(decode(upper(RTRIM(RPAD(:p_in_format_option_low, 1))),'D','D',null),null,-1,acct_site.cust_acct_site_id) addr_id, nvl(hca.cust_account_id, -999) cust_id, hca.party_id, -- &party_dff_cols3 &cust_dff_cols3 -- ps.payment_schedule_id, app.class, ps.trx_date, ps.due_date, decode(nvl2(:p_in_currency,'N','Y'), 'Y', ps.amount_due_original * nvl(ps.exchange_rate, 1), ps.amount_due_original) amt_due_original, xxen_ar_arxagrw_pkg.Comp_Amt_Due_RemainingFormula ( app.class, initcap(:p_payment_meaning), ps.payment_schedule_id, decode(nvl2(:p_in_currency,'N','Y'), 'Y', nvl(-SUM(app.acctd_amount), 0), nvl(-SUM(app.amount), 0)), -- amount due remaining ps.amount_applied, ps.amount_credited, ps.amount_adjusted ) amt_due_remaining, ps.trx_number, ceil(:p_in_as_of_date_low - ps.trx_date) days_past_trx, ceil(:p_in_as_of_date_low - ps.due_date) days_past_due, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.gl_date, decode(ps.invoice_currency_code, gsob.currency_code, null, decode(ps.exchange_rate, null, '*', null)), nvl(ps.exchange_rate, 1), -- &lp_bucket_cols3 -- app.code_combination_id, app.chart_of_accounts_id, ci.cons_billing_number cons_billing_number, initcap(:p_payment_meaning) invoice_type, acr.comments, null reference, ps.invoice_currency_code, gsob.currency_code functional_currency, gsob.name ledger, gsob.set_of_books_id ledger_id, ps.org_id, -- Derive accounted amount from ar_receivable_applications for Payments decode(nvl2(:p_in_currency,'N','Y'), 'Y', nvl(-SUM(app.acctd_amount), 0), nvl(-SUM(app.amount), 0)) rec_acctd_amount, ps.customer_trx_id, 'RECEIPTS' sla_entity_code, ps.cash_receipt_id sla_source_id, 1 installment_ratio from hz_cust_accounts hca, hz_parties hp, ar_payment_schedules ps, ar_cons_inv ci, ra_salesreps_all sales, jtf_rs_resource_extns_vl jrrev, hz_cust_site_uses site, hz_cust_acct_sites acct_site, hz_party_sites party_site, hz_locations loc, ar_cash_receipts acr, gl_sets_of_books gsob, ( select c.code_combination_id, c.chart_of_accounts_id, ps.payment_schedule_id payment_schedule_id, decode(app.applied_payment_schedule_id, -4, 'CLAIM',ps.class) class, app.acctd_amount_applied_from acctd_amount, app.amount_applied amount, app.status status from ar_receivable_applications app, gl_code_combinations c, ar_payment_schedules ps where app.gl_date <= :p_in_as_of_date_low --and upper(RTRIM(RPAD(:p_in_summary_option_low,1))) ='I' and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and ps.cash_receipt_id=app.cash_receipt_id and app.code_combination_id=c.code_combination_id and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC') and nvl(app.confirmed_flag, 'Y')='Y' and ps.gl_date_closed> :p_in_as_of_date_low and ((app.reversal_gl_date is not null and ps.gl_date <= :p_in_as_of_date_low ) or app.reversal_gl_date is null ) and decode(upper(:p_in_currency), null, ps.invoice_currency_code, upper(:p_in_currency))=ps.invoice_currency_code and nvl( ps.receipt_confirmed_flag, 'Y' )='Y' &lp_bal_seg_low &lp_bal_seg_high &lp_acc_seg_low &lp_acc_seg_high and app.org_id=ps.org_id ) app where ps.payment_schedule_id=app.payment_schedule_id and ps.customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and ps.customer_site_use_id=site.site_use_id(+) and site.cust_acct_site_id=acct_site.cust_acct_site_id(+) and acct_site.party_site_id=party_site.party_site_id(+) and loc.location_id(+)=party_site.location_id and acr.cash_receipt_id=ps.cash_receipt_id and gsob.set_of_books_id=acr.set_of_books_id and ps.cons_inv_id=ci.cons_inv_id(+) and sales.salesrep_id=-3 and sales.org_id =ps.org_id and jrrev.resource_id=sales.resource_id and site.org_id (+)=ps.org_id and 2=2 group by hp.party_name, hca.account_number, hca.customer_class_code, site.site_use_id, nvl(sales.name,jrrev.resource_name), nvl(sales.salesrep_id,-3), loc.state, loc.city, loc.country, acct_site.cust_acct_site_id, hca.cust_account_id, hca.party_id, -- &party_dff_cols3_g &cust_dff_cols3_g -- ps.payment_schedule_id, ps.trx_date, ps.due_date, ps.trx_number, ps.amount_due_original, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, ps.gl_date, ps.amount_in_dispute, ps.amount_adjusted_pending, ps.invoice_currency_code, ps.exchange_rate, app.class, app.code_combination_id, app.chart_of_accounts_id, decode( app.status, 'UNID', 'UNID','OTHER ACC','OTHER ACC','UNAPP'), ci.cons_billing_number , initcap(:p_payment_meaning), acr.comments, gsob.currency_code, gsob.name, gsob.set_of_books_id, ps.org_id, ps.customer_trx_id, ps.cash_receipt_id union all select substrb(nvl(hp.party_name, :p_short_unid_phrase),1,50) cust_name, hca.account_number cust_no, nvl(sales.name,jrrev.resource_name), initcap(:p_risk_meaning), nvl(sales.salesrep_id,-3), null term, site.site_use_id, loc.state cust_state, loc.city cust_city, (select ftv.territory_short_name from fnd_territories_vl ftv where ftv.territory_code=loc.country) cust_country, xxen_util.meaning(hca.customer_class_code,'CUSTOMER CLASS',222) cust_class, decode(decode(upper(RTRIM(RPAD(:p_in_format_option_low, 1))),'D','D',null),null,-1,acct_site.cust_acct_site_id) addr_id, nvl(hca.cust_account_id, -999) cust_id, hca.party_id, -- &party_dff_cols3 &cust_dff_cols3 -- ps.payment_schedule_id, initcap(:p_risk_meaning), ps.trx_date, ps.due_date, decode(nvl2(:p_in_currency,'N','Y'), 'Y', ps.amount_due_original * nvl(ps.exchange_rate, 1), ps.amount_due_original) amt_due_original, xxen_ar_arxagrw_pkg.comp_amt_due_remainingformula ( initcap(:p_risk_meaning), initcap(:p_risk_meaning), ps.payment_schedule_id, decode( nvl2(:p_in_currency,'N','Y'), 'Y', crh.acctd_amount, crh.amount), -- amount due remaining ps.amount_applied, ps.amount_credited, ps.amount_adjusted )amt_due_remaining, ps.trx_number, ceil(:p_in_as_of_date_low - ps.trx_date) days_past_trx, ceil(:p_in_as_of_date_low - ps.due_date) days_past_due, ps.amount_adjusted, ps.amount_applied, ps.amount_credited, crh.gl_date, decode(ps.invoice_currency_code, gsob.currency_code, null, decode(crh.exchange_rate, null, '*', null)), nvl(crh.exchange_rate, 1), -- &lp_bucket_cols4 -- c.code_combination_id, c.chart_of_accounts_id, ci.cons_billing_number cons_billing_number, initcap(:p_risk_meaning) invoice_type, cr.comments, null reference, ps.invoice_currency_code, gsob.currency_code functional_currency, gsob.name ledger, gsob.set_of_books_id ledger_id, ps.org_id, -- Derive accounted amount from ar_cash_receipt_history for Risk decode(nvl2(:p_in_currency,'N','Y'), 'Y', crh.acctd_amount, crh.amount) rec_acctd_amount, ps.customer_trx_id, 'RECEIPTS' sla_entity_code, cr.cash_receipt_id sla_source_id, 1 installment_ratio from hz_cust_accounts hca, hz_parties hp, ar_payment_schedules ps, ar_cons_inv ci, hz_cust_site_uses site, hz_cust_acct_sites acct_site, hz_party_sites party_site, hz_locations loc, ar_cash_receipts cr, ar_cash_receipt_history crh, gl_code_combinations c, ra_salesreps_all sales, jtf_rs_resource_extns_vl jrrev, gl_sets_of_books gsob where crh.gl_date <= :p_in_as_of_date_low --and upper(RTRIM(RPAD(:p_in_summary_option_low,1))) ='I' and upper(:p_risk_option) != 'NONE' and ps.customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and ps.cash_receipt_id=cr.cash_receipt_id and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and cr.cash_receipt_id=crh.cash_receipt_id and crh.account_code_combination_id=c.code_combination_id and ps.customer_site_use_id=site.site_use_id(+) and site.cust_acct_site_id=acct_site.cust_acct_site_id(+) and acct_site.party_site_id=party_site.party_site_id(+) and loc.location_id(+)=party_site.location_id and decode(upper(:p_in_currency), null, ps.invoice_currency_code, upper(:p_in_currency))=ps.invoice_currency_code and (crh.current_record_flag='Y' or crh.reversal_gl_date > :p_in_as_of_date_low ) and crh.status not in (decode(crh.factor_flag,'Y','RISK_ELIMINATED','N','CLEARED'),'REVERSED') and not exists (select 'x' from ar_receivable_applications ra where ra.cash_receipt_id=cr.cash_receipt_id and ra.status='ACTIVITY' and applied_payment_schedule_id=-2) and cr.cash_receipt_id not in (select ps.reversed_cash_receipt_id from ar_payment_schedules ps where ps.reversed_cash_receipt_id=cr.cash_receipt_id and ps.class='DM' and ps.gl_date<= (:p_in_as_of_date_low)) and gsob.set_of_books_id=cr.set_of_books_id &lp_bal_seg_low &lp_bal_seg_high &lp_acc_seg_low &lp_acc_seg_high and ps.cons_inv_id=ci.cons_inv_id(+) and sales.salesrep_id=-3 and sales.org_id=ps.org_id and jrrev.resource_id=sales.resource_id and crh.org_id=ps.org_id and cr.org_id=ps.org_id and site.org_id (+)=ps.org_id and 2=2 union all select substrb(hp.party_name,1,50) cust_name, hca.account_number cust_no, nvl(sales.name,jrrev.resource_name) sort_field1, arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) sort_field2, nvl(sales.salesrep_id, -3)salesrep_id, rt.name term, site.site_use_id contact_site_id, loc.state cust_state, loc.city cust_city, (select ftv.territory_short_name from fnd_territories_vl ftv where ftv.territory_code=loc.country) cust_country, xxen_util.meaning(hca.customer_class_code,'CUSTOMER CLASS',222) cust_class, decode(decode(upper(rtrim(rpad(:p_in_format_option_low, 1))),'D','D',null),null,-1,acct_site.cust_acct_site_id) addr_id, nvl(hca.cust_account_id,-999) cust_id, hca.party_id, -- &party_dff_cols3 &cust_dff_cols3 -- ps.payment_schedule_id payment_sched_id, ps.class class, ps.trx_date, ps.due_date, decode(nvl2(:p_in_currency,'N','Y'), 'Y', ps.amount_due_original * nvl(ps.exchange_rate, 1), ps.amount_due_original) amt_due_original, xxen_ar_arxagrw_pkg.comp_amt_due_remainingformula ( ps.class, arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id), ps.payment_schedule_id, decode( nvl2(:p_in_currency,'N','Y'), 'Y', ps.acctd_amount_due_remaining,ps.amount_due_remaining), -- amount due remaining ps.amount_applied, ps.amount_credited, ps.amount_adjusted )amt_due_remaining, ps.trx_number invnum, ceil(:p_in_as_of_date_low - ps.trx_date) days_past_trx, ceil(:p_in_as_of_date_low - ps.due_date) days_past_due, ps.amount_adjusted amount_adjusted, ps.amount_applied amount_applied, ps.amount_credited amount_credited, ps.gl_date gl_date, decode(ps.invoice_currency_code, gsob.currency_code, null, decode(ps.exchange_rate, null, '*', null)) data_converted, nvl(ps.exchange_rate, 1) ps_exchange_rate, -- &lp_bucket_cols3 -- c.code_combination_id, c.chart_of_accounts_id, ci.cons_billing_number cons_billing_number, arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) invoice_type, ct.comments, ct.ct_reference reference, ps.invoice_currency_code, gsob.currency_code functional_currency, gsob.name ledger, gsob.set_of_books_id ledger_id, ps.org_id, to_number(null) rec_acctd_amount, ps.customer_trx_id, 'TRANSACTIONS' sla_entity_code, ps.customer_trx_id sla_source_id, ps.amount_due_original/nvl( (select sum(ps2.amount_due_original) from ar_payment_schedules ps2 where ps2.customer_trx_id=ps.customer_trx_id and ps2.class<>'PMT'), 0) installment_ratio from hz_cust_accounts hca, hz_parties hp, ar_payment_schedules ps, ar_cons_inv ci, ra_salesreps_all sales, jtf_rs_resource_extns_vl jrrev, hz_cust_site_uses site, hz_cust_acct_sites acct_site, hz_party_sites party_site, hz_locations loc, ar_transaction_history th, ar_distributions dist, gl_code_combinations c, ra_customer_trx ct, ra_terms rt, gl_sets_of_books gsob where ps.gl_date <= :p_in_as_of_date_low --and upper(RTRIM(RPAD(:p_in_summary_option_low,1)) )='I' and ps.customer_site_use_id=site.site_use_id and xxen_ar_arxagrw_pkg.include_org_id(ps.org_id)='Y' and site.cust_acct_site_id=acct_site.cust_acct_site_id and acct_site.party_site_id =party_site.party_site_id and loc.location_id=party_site.location_id and ps.gl_date_closed > :p_in_as_of_date_low and ps.class='BR' and decode(upper(:p_in_currency),null, ps.invoice_currency_code, upper(:p_in_currency))=ps.invoice_currency_code and hca.party_id=hp.party_id and th.transaction_history_id = (select max(transaction_history_id) from ar_transaction_history th2, ar_distributions dist2 where th2.transaction_history_id=dist2.source_id and dist2.source_table='TH' and th2.gl_date <= :p_in_as_of_date_low and dist2.amount_dr is not null and th2.customer_trx_id=ps.customer_trx_id) and th.transaction_history_id=dist.source_id and dist.source_table='TH' and dist.amount_dr is not null and dist.source_table_secondary is null and dist.code_combination_id=c.code_combination_id and gsob.set_of_books_id=ct.set_of_books_id &lp_invoice_type_low &lp_invoice_type_high &lp_bal_seg_low &lp_bal_seg_high &lp_acc_seg_low &lp_acc_seg_high and ps.cons_inv_id=ci.cons_inv_id(+) and ps.customer_id=hca.cust_account_id and ps.customer_trx_id=ct.customer_trx_id and ct.customer_trx_id=th.customer_trx_id and nvl(ct.primary_salesrep_id,-3)=sales.salesrep_id and sales.org_id=ct.org_id and jrrev.resource_id=sales.resource_id and ct.org_id=ps.org_id and site.org_id=ps.org_id and ps.term_id=rt.term_id (+) and :p_br_enabled='Y' and 2=2 ) x, --X hz_customer_profiles hcpa, hz_customer_profiles hcps, (select hcpam.cust_account_profile_id, listagg(hcpam.currency_code||'='||to_char(hcpam.overall_credit_limit),',') within group (order by hcpam.currency_code) as credit_limits, listagg(hcpam.currency_code||'='||to_char(hcpam.trx_credit_limit),',') within group (order by hcpam.currency_code) as order_credit_limits from hz_cust_profile_amts hcpam where hcpam.overall_credit_limit is not null or hcpam.trx_credit_limit is not null group by hcpam.cust_account_profile_id ) hcpamv, ( select /*+ no_merge */ sla_inner.ledger_id, sla_inner.entity_code, sla_inner.source_id, sla_inner.code_combination_id, sla_inner.accounted_dr, sla_inner.accounted_cr, sla_inner.accounting_date from ( select /*+ full(xah) use_hash(xte xah xal) */ xte.ledger_id, xte.entity_code, xte.source_id_int_1 source_id, xal.code_combination_id, sum(nvl(xal.accounted_dr,0)) accounted_dr, sum(nvl(xal.accounted_cr,0)) accounted_cr, max(xah.accounting_date) accounting_date from xla_ae_headers xah, xla_ae_lines xal, xla_transaction_entities xte where :p_show_sla='Y' and xte.entity_code in ('TRANSACTIONS','RECEIPTS') and xte.application_id=xah.application_id and xte.entity_id=xah.entity_id and xah.ae_header_id=xal.ae_header_id and xah.application_id=xal.application_id and xal.application_id=222 and xah.application_id=222 and xal.accounting_class_code in ('RECEIVABLE','UNAPP','BILLS_RECEIVABLE') and xah.accounting_date<=:p_in_as_of_date_low and xah.ledger_id=xte.ledger_id and exists ( select null from gl_code_combinations gcc, gl_ledgers gl where gcc.code_combination_id=xal.code_combination_id and gl.ledger_id=xte.ledger_id and gcc.chart_of_accounts_id=gl.chart_of_accounts_id ) group by xte.ledger_id, xte.entity_code, xte.source_id_int_1, xal.code_combination_id ) sla_inner ) sla, -- SLA net: original receivable minus all applications/adjustments as of reporting date (select sn.customer_trx_id, sum(nvl(sn.acctd_amount_dr,0)) net_accounted_dr, sum(nvl(sn.acctd_amount_cr,0)) net_accounted_cr from ( -- Original receivable from ra_cust_trx_line_gl_dist select gld.customer_trx_id, case when gld.acctd_amount>=0 then gld.acctd_amount end acctd_amount_dr, case when gld.acctd_amount<0 then abs(gld.acctd_amount) end acctd_amount_cr from ra_cust_trx_line_gl_dist gld where :p_show_sla='Y' and gld.account_class='REC' and gld.latest_rec_flag='Y' and gld.gl_date <= :p_in_as_of_date_low union all -- Cash/misc application credits to invoice receivable (via ar_distributions to avoid picking up internal application rows e.g. OKS service contracts) select /*+ use_nl(ard) index(ard AR_DISTRIBUTIONS_N1) */ ara.applied_customer_trx_id customer_trx_id, ard.acctd_amount_dr, ard.acctd_amount_cr from ar_distributions ard, ar_receivable_applications ara where :p_show_sla='Y' and ard.source_table='RA' and ard.source_type='REC' and ard.source_id=ara.receivable_application_id and ara.applied_customer_trx_id is not null and ara.reversal_gl_date is null and ara.gl_date <= :p_in_as_of_date_low union all -- CM side: DR to CM receivable when CM is applied to invoice select ara.customer_trx_id, abs(nvl(ara.acctd_amount_applied_from,nvl(ara.amount_applied_from,ara.amount_applied))) acctd_amount_dr, null acctd_amount_cr from ar_receivable_applications ara where :p_show_sla='Y' and ara.status='APP' and ara.application_type='CM' and ara.customer_trx_id is not null and ara.reversal_gl_date is null and ara.gl_date <= :p_in_as_of_date_low union all -- CM application credit to invoice receivable select ara.applied_customer_trx_id customer_trx_id, null acctd_amount_dr, nvl(ara.acctd_amount_applied_to,ara.acctd_amount_applied_from) acctd_amount_cr from ar_receivable_applications ara where :p_show_sla='Y' and ara.status='APP' and ara.application_type='CM' and ara.applied_customer_trx_id is not null and ara.reversal_gl_date is null and ara.gl_date <= :p_in_as_of_date_low union all -- Adjustment distributions select /*+ use_nl(ard) index(ard AR_DISTRIBUTIONS_N1) */ adj.customer_trx_id, ard.acctd_amount_dr, ard.acctd_amount_cr from ar_distributions ard, ar_adjustments adj where :p_show_sla='Y' and ard.source_table='ADJ' and ard.source_type='REC' and ard.source_id=adj.adjustment_id and adj.gl_date <= :p_in_as_of_date_low and adj.status='A' ) sn where sn.customer_trx_id is not null group by sn.customer_trx_id ) sla_net where hcpa.cust_account_id(+)=x.cust_id and hcpa.site_use_id(+) is null and hcps.cust_account_id(+)=x.cust_id and hcps.site_use_id(+)=x.site_use_id and hcpa.cust_account_profile_id=hcpamv.cust_account_profile_id(+)and nvl(x.amt_due_remaining,0) != 0 and x.ledger_id=sla.ledger_id(+) and x.sla_entity_code=sla.entity_code(+) and x.sla_source_id=sla.source_id(+) and decode(x.sla_entity_code,'TRANSACTIONS',x.sla_source_id)=sla_net.customer_trx_id(+) ) x1 --x1 where 1=1 group by x1.ledger, x1.operating_unit, x1.code_combination_id, x1.chart_of_accounts_id, x1.sort_field1, x1.cust_name, x1.cust_no, x1.cust_country, x1.cust_class, x1.credit_limits, x1.order_credit_limits, -- &party_dff_cols1_g &cust_dff_cols1_g -- x1.collector, x1.revaluation_from_currency, x1.rec_code_combination_id, x1.reval_conv_rate &lp_invoice_cols_g order by fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_bal_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), x1.sort_field1, x1.cust_name, x1.cust_no &lp_invoice_cols_g Fixed sla_net: restored ar_distributions RA/REC for cash credits (ara-based approach incorrectly picked up internal OKS service contract application rows causing sla_net=0 for 728 open OKS invoices); fixed CM DR branch fallback to use amount_applied when acctd_amount_applied_from and amount_applied_from are both null (fixes applied CMs showing full credit instead of 0). Y #,##0.00;[Red]-#,##0.00 XXEN_AR_ARXAGRW_PKG AR AR Aging Application: المقبوضات Source: تقرير التقادم - 7 رزم حسب مندوب المبيعات/الوكيل Short Name: ARXAGRW D AR Aging Application: Debitoren Source: Fälligkeiten - Schema 7 - nach Vertriebsmitarbeiter/Vertriebsbeauftragtem Short Name: ARXAGRW E AR Aging Aplicación: Cuentas por cobrar Fuente: Envejecimiento - 7 cubos - Informe por vendedor/agente Nombre corto: ARXAGRW Paquete: XXEN_AR_ARXAGRW_PKG F AR Aging Application: Receivables Source: Balance âgée par vendeur/agent - 7 catégories Short Name: ARXAGRW I AR Aging Application: Receivables Source: Rapporto Scadenzario - 7 periodi fissi - per rappresentante commerciale/agente Short Name: ARXAGRW JA AR Aging 申請書を提出する。売掛債権 出典はこちらです。エイジング～7つのバケツ～営業マン・エージェント別レポート ショートネーム.ARXAGRW パッケージXXEN_AR_ARXAGRW_PKG KO AR Aging 신청 : AR 출처 : 노화-7 개 버킷-영업 사원 / 상담원 별 보고서 짧은 이름 : ARXAGRW 패키지 : XXEN_AR_ARXAGRW_PKG PTB AR Aging Aplicação: Contas a receber Fonte: Envelhecimento - 7 baldes - Por Relatório do vendedor/agente Nome curto: ARXAGRW Pacote: XXEN_AR_ARXAGRW_PKG RU AR Aging Приложение: Дебиторская задолженность Источник: Старение - 7 ведер - по данным продавца/агента Короткое имя: ARXAGRW Пакет: XXEN_AR_ARXAGRW_PKG S AR Aging Ansökan: Fordringar Källa: Åldrande - 7 skopor - Av säljare / agentrapport Kort namn: ARXAGRW Paket: XXEN_AR_ARXAGRW_PKG TR AR Aging Uygulama: Alacaklar Kaynak: Yaşlanma - 7 Kova - Satış Görevlisi / Temsilci Raporuna Göre Kısa isim: ARXAGRW Paket: XXEN_AR_ARXAGRW_PKG US AR Aging The AR Aging report allows users to review information about their open receivables items at a specified point in time (the As of Date). The report will show the aging of the open receivables items based on the selected aging bucket. - The report includes detailed (Transaction Level) or summary (Customer Level) information about customers current and past due invoices, debit memos, and chargebacks. - Optionally the report can include details of credit memos, on-account credits, unidentified payments, on-account and unapplied cash amounts, and receipts at risk. - Optionally the report allows the open receivables items to be revalued to a different currency on a specified revaluation date using a specified revaluation currency rate type. - All amounts in the report are shown in functional currency, except where the report is run for a specified entered currency, in which case the amounts are shown in the specified entered currency. Report Parameters: Reporting Level: The report can be run by Ledger or by Operating Unit. Reporting Context: The Ledgers or Operating Units the report is to be run for. Only Ledgers or Operating Units accessible to the current responsibility maybe selected. The report supports the multiple selection of Ledgers or Operating Units allowing to be run for more than one Ledger or Operating Unit. If the Reporting Context is left null, then the report will be run for all Operating Units accessible to the current responsibility. Report Summary: The report is summarized at either the Customer Level (Customer Summary) or at Transaction Level (Invoice Summary). The Customer Summary report includes open receivables totals at the customer level only and does not include transaction level details. The Invoice Summary report includes details and the outstanding amounts of the open receivables transactions. As of Date: The report can be run to provide an aging snapshot at a specified point in time in the past. By default, the As of Date will be the current date. Aging Bucket Name: The Aging Bucket Name determine the Aging Buckets to be used for aging the open receivables items. The aging amount columns in the report are dynamically determined based on the selected Aging Buket. Aging Basis: Transactions can be aged based on their Due Date (default) or on their Transaction (Invoice) Date. Show On Account: The report can optionally include the details and/or amounts for credit memos, on-account credits, unidentified payments, on-account and unapplied cash amounts. The options for displaying these are: Do Not Show – they are not included in the report. Summarize – the amounts are shown as separate columns in the report and are not included in the Aging Amount report columns. Age – the amounts are included in the Aging Amount report columns. Show Receipts At Risk: The report can optionally include the details and/or amounts for receipts at risk. Do Not Show – they are not included in the report. Summarize – the amounts are shown as separate a column in the report and are not included in the Aging Amount report columns. Age – the amounts are included in the Aging Amount report columns. Entered Currency: Restrict the report to open receivables items entered in the specified currency. By default, all amounts in the report are shown in functional currency, except in the case the report is run in for a specified Entered Currency. In this case the amounts are shown in the specified entered currency. Revaluation Date, Revaluation Currency, Revaluation Rate Type: If a revaluation date, currency, and rate type are specified, the report will include additional columns showing the open receivables amounts and aging in the specified revaluation currency. Additionally, there are several additional parameters which can be used to restrict the data returned by the report. Show SLA Accounting: Set to Yes to fetch SLA receivable accounting details for each transaction. ZHS AR Aging Application: 应收帐款 Source: 帐龄 - 7 时段 - 按销售人员/代理商报表 Short Name: ARXAGRW Enginatics GST Reports R12 only &cust_dff_cols1 &cust_dff_cols1_g &cust_dff_cols2 &cust_dff_cols3 &cust_dff_cols3_g &lp_acc_seg_high &lp_acc_seg_low &lp_acc_seg_p &lp_aging_amount_cols &lp_aging_pct_cols &lp_bal_seg_high &lp_bal_seg_low &lp_bal_seg_p &lp_bucket_cols1 &lp_bucket_cols2 &lp_bucket_cols3 &lp_bucket_cols4 &lp_invoice_cols_g &lp_invoice_cols_s &lp_invoice_type_high &lp_invoice_type_low &lp_on_acc_summ_cols &lp_reval_aging_amount_cols &lp_reval_columns &lp_sla_sel_outer &party_dff_cols1 &party_dff_cols1_g &party_dff_cols2 &party_dff_cols3 &party_dff_cols3_g 1=1 2=2 :g_bucket_category :lp_org_id_in_list :p_age_basis :p_br_enabled :p_coaid :p_conc_request_id :p_credit_option :p_credit_option_dsp :p_in_amt_due_high :p_in_amt_due_low :p_in_as_of_date_low :p_in_bal_segment_high :p_in_bal_segment_low :p_in_bucket_type_low :p_in_collector_high :p_in_collector_low :p_in_currency :p_in_customer_name_high :p_in_customer_name_low :p_in_customer_num_high :p_in_customer_num_low :p_in_format_option_low :p_in_invoice_type_high :p_in_invoice_type_low :p_in_salesrep_name_high :p_in_salesrep_name_low :p_in_sortoption :p_in_summary_option_low :p_min_precision :p_payment_meaning :p_rep_type :p_reporting_entity_id :p_reporting_entity_name :p_reporting_level :p_reporting_level_name :p_reval_conv_date :p_reval_conv_type :p_reval_currency :p_risk_meaning :p_risk_option :p_short_unid_phrase :p_show_sla 1 -90 :p_coaid Number select gsob.chart_of_accounts_id from gl_sets_of_books gsob, ar_system_parameters asp, hr_all_organization_units haou where gsob.set_of_books_id=asp.set_of_books_id and asp.org_id=haou.organization_id and ( :$flex$.reporting_context is null or :$flex$.reporting_level='1000' and xxen_util.contains(:$flex$.reporting_context,gsob.name)='Y' or :$flex$.reporting_level='3000' and xxen_util.contains(:$flex$.reporting_context,haou.name)='Y' ) and rownum=1 Y US Chart of Accounts Id 2 -80 :p_rep_type Char select lookup_code from ar_lookups where lookup_type = 'AR_AGING_TYPE' and lookup_code='ARXAGR' Y US Report type 3 -70 :p_in_sortoption LOV Oracle AR_ARXAGR_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXAGR' order by value,description Salesperson Y US Order By 4 -60 :p_payment_meaning Char select rtrim(rpad(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('INV/CM/ADJ','PMT'),20)) from dual US Payment Meaning 5 -50 :p_risk_meaning Char select rtrim(rpad(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('MISC_PHRASES','RISK'),20)) from dual US Risk Meaning 6 -40 :p_short_unid_phrase Char select rtrim(rpad(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('MISC_PHRASES','UNIDENTIFIED_PAYMENT'),18)) from dual US Unidentified Meaning 7 -30 :p_in_format_option_low LOV Oracle AR_REPORT_FORMAT Y select l.lookup_code id, l.meaning value, null description from ar_lookups l where l.lookup_type='REPORT_FORMAT' and l.enabled_flag='Y' and sysdate between nvl(l.start_date_active,sysdate) and nvl(l.end_date_active,sysdate) order by l.meaning,l.lookup_code D Y US Report Format 8 -20 &lp_bal_seg_p <parameter_value> Char select nvl( ( select fifsv.form_left_prompt from fnd_segment_attribute_values fsav , fnd_id_flex_segments_vl fifsv where fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.segment_attribute_type = 'GL_BALANCING' and fsav.id_flex_num = ( select distinct case when count(distinct gsob.chart_of_accounts_id) over () = 1 then gsob.chart_of_accounts_id else null end from gl_sets_of_books gsob where :$flex$.reporting_level = '1000' and :$flex$.reporting_context is not null and xxen_util.contains(:$flex$.reporting_context,gsob.name) = 'Y' union select distinct case when count(distinct gsob.chart_of_accounts_id) over () = 1 then gsob.chart_of_accounts_id else null end from gl_sets_of_books gsob , ar_system_parameters aps , hr_all_organization_units haou where gsob.set_of_books_id = aps.set_of_books_id and haou.organization_id = aps.set_of_books_id and :$flex$.reporting_level = '3000' and :$flex$.reporting_context is not null and xxen_util.contains(:$flex$.reporting_context,haou.name) = 'Y' union select distinct case when count(distinct gsob.chart_of_accounts_id) over () = 1 then gsob.chart_of_accounts_id else null end from gl_sets_of_books gsob , ar_system_parameters aps where gsob.set_of_books_id = aps.set_of_books_id and :$flex$.reporting_context is null ) and fsav.attribute_value = 'Y' and fifsv.application_id = fsav.application_id and fifsv.id_flex_code = fsav.id_flex_code and fifsv.id_flex_num = fsav.id_flex_num and fifsv.application_column_name = fsav.application_column_name ), 'Balancing Segment') from dual US Balancing Segment Label 9 -10 &lp_acc_seg_p <parameter_value> Char select nvl( ( select fifsv.form_left_prompt from fnd_segment_attribute_values fsav , fnd_id_flex_segments_vl fifsv where fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.segment_attribute_type = 'GL_ACCOUNT' and fsav.id_flex_num = ( select distinct case when count(distinct gsob.chart_of_accounts_id) over () = 1 then gsob.chart_of_accounts_id else null end from gl_sets_of_books gsob where :$flex$.reporting_level = '1000' and :$flex$.reporting_context is not null and xxen_util.contains(:$flex$.reporting_context,gsob.name) = 'Y' union select distinct case when count(distinct gsob.chart_of_accounts_id) over () = 1 then gsob.chart_of_accounts_id else null end from gl_sets_of_books gsob , ar_system_parameters aps , hr_all_organization_units haou where gsob.set_of_books_id = aps.set_of_books_id and haou.organization_id = aps.set_of_books_id and :$flex$.reporting_level = '3000' and :$flex$.reporting_context is not null and xxen_util.contains(:$flex$.reporting_context,haou.name) = 'Y' union select distinct case when count(distinct gsob.chart_of_accounts_id) over () = 1 then gsob.chart_of_accounts_id else null end from gl_sets_of_books gsob , ar_system_parameters aps where gsob.set_of_books_id = aps.set_of_books_id and :$flex$.reporting_context is null ) and fsav.attribute_value = 'Y' and fifsv.application_id = fsav.application_id and fifsv.id_flex_code = fsav.id_flex_code and fifsv.id_flex_num = fsav.id_flex_num and fifsv.application_column_name = fsav.application_column_name ), 'Account') from dual US Account Segment Label 10 10 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description 1000 Y US Reporting Level 11 20 1=1 x1.reporting_entity=:p_reporting_entity_name LOV custom Y select entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level and ( :$flex$.fnd_mo_reporting_level='1000' and ledger_category_code='PRIMARY' or :$flex$.fnd_mo_reporting_level='3000' ) order by value,description SELECT entity_name FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.fnd_mo_reporting_level and rownum=1 US Reporting Context 12 30 :p_in_summary_option_low LOV Oracle AR_TYPE_OF_REPORT Y select l.lookup_code id, l.meaning value, null description from ar_lookups l where l.lookup_type='REPORT_TYPE' and l.enabled_flag='Y' and sysdate between nvl(l.start_date_active,sysdate) and nvl(l.end_date_active,sysdate) order by l.meaning,l.lookup_code I Y US Report Summary 13 &lp_invoice_cols_g ,decode(x1.cons_billing_number,null,x1.invnum,x1.cons_billing_number || ''/'' || x1.invnum), x1.invoice_type, x1.invoice_currency_code, x1.term, x1.comments, trunc(x1.trx_date), x1.due_date, x1.days_past_trx, x1.days_past_due I US Report Summary 14 &lp_invoice_cols_s decode(x1.cons_billing_number,null,x1.invnum,x1.cons_billing_number || ''/'' || x1.invnum) "Billing/Invoice Number", x1.invoice_type "Type", x1.invoice_currency_code "Invoice Currency", x1.term, x1.comments, trunc(x1.trx_date) "Invoice Date", x1.due_date "Due Date", x1.days_past_trx "Days Past Invoice Date", x1.days_past_due "Days Past Due Date", I US Report Summary 15 40 :p_in_as_of_date_low Date sysdate Y US As Of Date 16 50 :p_in_bucket_type_low LOV custom Y select bucket_name value, xxen_util.meaning(aging_type,'AGING_BUCKETS_TYPE',222) description, aging_type from ar_aging_buckets where status='A' order by bucket_name select distinct first_value(bucket_name) over (order by aging_bucket_id desc range between unbounded preceding and unbounded following) from ar_aging_buckets where upper(aging_type)='7BUCKET' and status='A' Y US Aging Bucket Name 17 &lp_aging_amount_cols select 'sum(case when nvl(x1.rk,1)=1 then decode(x1.b' || to_char(l.seq) || ',1,x1.amt_due_remaining,null) end) "' || replace(XXEN_AR_ARXAGRW_PKG.bucket_title(:p_in_bucket_type_low,l.seq),'Due',decode(:p_age_basis,'Due Date','Due','Inv')) || '",' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Aging Bucket Name 18 &lp_aging_pct_cols select 'case nvl(sum(case when nvl(x1.rk,1)=1 then x1.amt_due_remaining end),0) when 0 then to_number(null) else round(sum(case when nvl(x1.rk,1)=1 then decode(x1.b' || to_char(l.seq) || ',1,x1.amt_due_remaining,null) end) / sum(case when nvl(x1.rk,1)=1 then x1.amt_due_remaining end) * 100,2) end "' || substrb(replace(XXEN_AR_ARXAGRW_PKG.bucket_title(:p_in_bucket_type_low,l.seq),'Due',decode(:p_age_basis,'Due Date','Due','Inv')),1,xxen_report.max_column_length-2) || ' %",' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Aging Bucket Name 19 &lp_bucket_cols1 select ' x.b' || to_char(l.seq) || ',' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Aging Bucket Name 20 &lp_bucket_cols2 select ' case when xxen_ar_arxagrw_pkg.bucket_line_type(' || to_char(l.seq) || ') is not null then arpt_sql_func_util.bucket_function ( xxen_ar_arxagrw_pkg.bucket_line_type(' || to_char(l.seq) || '), dh.amount_in_dispute, ps.amount_adjusted_pending, xxen_ar_arxagrw_pkg.bucket_days_from(' || to_char(l.seq) || '), xxen_ar_arxagrw_pkg.bucket_days_to(' || to_char(l.seq) || '), decode(:p_age_basis,''Due Date'',ps.due_date,ps.trx_date), xxen_ar_arxagrw_pkg.bucket_category, :p_in_as_of_date_low ) else to_number(null) end b' || to_char(l.seq) || ',' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Aging Bucket Name 21 &lp_bucket_cols3 select ' case when xxen_ar_arxagrw_pkg.bucket_line_type(' || to_char(l.seq) || ') is not null then arpt_sql_func_util.bucket_function ( xxen_ar_arxagrw_pkg.bucket_line_type(' || to_char(l.seq) || '), ps.amount_in_dispute, ps.amount_adjusted_pending, xxen_ar_arxagrw_pkg.bucket_days_from(' || to_char(l.seq) || '), xxen_ar_arxagrw_pkg.bucket_days_to(' || to_char(l.seq) || '), decode(:p_age_basis,''Due Date'',ps.due_date,ps.trx_date), xxen_ar_arxagrw_pkg.bucket_category, :p_in_as_of_date_low ) else to_number(null) end b' || to_char(l.seq) || ',' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Aging Bucket Name 22 &lp_bucket_cols4 select ' case when xxen_ar_arxagrw_pkg.bucket_line_type(' || to_char(l.seq) || ') is not null then arpt_sql_func_util.bucket_function ( xxen_ar_arxagrw_pkg.bucket_line_type(' || to_char(l.seq) || '), 0, 0, xxen_ar_arxagrw_pkg.bucket_days_from(' || to_char(l.seq) || '), xxen_ar_arxagrw_pkg.bucket_days_to(' || to_char(l.seq) || '), decode(:p_age_basis,''Due Date'',ps.due_date,ps.trx_date), xxen_ar_arxagrw_pkg.bucket_category, :p_in_as_of_date_low ) else to_number(null) end b' || to_char(l.seq) || ',' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Aging Bucket Name 23 60 :p_age_basis LOV custom Y select x.value, x.description from ( select 'Due Date' value,'Age based on Invoice Due Date' description from dual union select 'Invoice Date' value,'Age based on Invoice Transaction Date' description from dual ) x order by value Due Date Y US Aging Basis 24 70 :p_credit_option_dsp LOV custom Y select l.meaning value, l.description description from ar_lookups l where l.lookup_type='OPEN_CREDITS' and l.enabled_flag='Y' and sysdate between nvl(l.start_date_active,sysdate) and nvl(l.end_date_active,sysdate) order by l.meaning select meaning from ar_lookups where lookup_type = 'OPEN_CREDITS' and lookup_code = 'SUMMARY' Y US Show On Account 25 &lp_on_acc_summ_cols sum(case when nvl(x1.rk,1)=1 then x1.on_account_amount_cash end) customer_payments, sum(case when nvl(x1.rk,1)=1 then x1.on_account_amount_credit end) customer_credit_memos, sum(case when nvl(x1.rk,1)=1 then x1.on_account_amount_risk end) customer_receipts_at_risk, sum(case when nvl(x1.rk,1)=1 then x1.cust_amount_claim end) customer_claims, Summarize US Show On Account 26 80 :p_risk_option LOV Oracle AR_SHOW_RISK Y select l.lookup_code id, l.meaning value, null description from ar_lookups l where l.lookup_type='SHOW_RISK' order by l.meaning,l.lookup_code NONE Y US Show Receipts At Risk 27 90 2=2 nvl(sales.name,jrrev.resource_name) = :p_in_salesrep_name LOV custom Y select distinct nvl(rs.name,jrrev.resource_name) value, null description from ra_salesreps rs, ra_salesreps_all rsa, jtf_rs_resource_extns_vl jrrev where rsa.salesrep_id = rs.salesrep_id and rsa.org_id = rs.org_id and jrrev.resource_id = rsa.resource_id order by nvl(rs.name,jrrev.resource_name) US Salesrep Name 28 100 2=2 nvl(sales.name,jrrev.resource_name) >= :p_in_salesrep_name_low LOV custom Y select distinct nvl(rs.name,jrrev.resource_name) value, null description from ra_salesreps rs, ra_salesreps_all rsa, jtf_rs_resource_extns_vl jrrev where rsa.salesrep_id = rs.salesrep_id and rsa.org_id = rs.org_id and jrrev.resource_id = rsa.resource_id order by nvl(rs.name,jrrev.resource_name) US Salesrep Name Low 29 110 2=2 nvl(sales.name,jrrev.resource_name) <= :p_in_salesrep_name_high LOV custom Y select distinct nvl(rs.name,jrrev.resource_name) value, null description from ra_salesreps rs, ra_salesreps_all rsa, jtf_rs_resource_extns_vl jrrev where rsa.salesrep_id = rs.salesrep_id and rsa.org_id = rs.org_id and jrrev.resource_id = rsa.resource_id order by nvl(rs.name,jrrev.resource_name) :$flex$.salesrep_name_low US Salesrep Name High 30 120 2=2 hp.party_name = :p_in_customer_name LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description US Customer Name 31 130 2=2 hp.party_name >= :p_in_customer_name_low LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description US Customer Name Low 32 140 2=2 hp.party_name <= :p_in_customer_name_high LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description :$flex$.customer_name_low US Customer Name High 33 150 2=2 hca.account_number = :p_in_customer_num LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Number 34 160 2=2 hca.account_number >= :p_in_customer_num_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Number Low 35 170 2=2 hca.account_number <= :p_in_customer_num_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number :$flex$.customer_number_low US Customer Number High 36 175 2=2 hca.customer_class_code=:p_cust_class LOV custom Y select al.lookup_code id, al.meaning value, al.description from ar_lookups al where al.lookup_type = 'CUSTOMER CLASS' order by value US Customer Classification 37 180 :p_in_currency LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code US Entered Currency 38 190 :p_in_amt_due_low Number US Balance Due Low 39 200 :p_in_amt_due_high Number :$flex$.balance_due_low US Balance Due High 40 210 :p_in_invoice_type_low LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name US Invoice Type Low 41 &lp_invoice_type_low and arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) >= :p_in_invoice_type_low US Invoice Type Low 42 220 :p_in_invoice_type_high LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name :$flex$.invoice_type_low US Invoice Type High 43 &lp_invoice_type_high and arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) <= :p_in_invoice_type_high US Invoice Type High 44 230 :p_in_bal_segment_low LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and 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(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US Company Segment Low 45 &lp_bal_seg_low and fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_bal_seg', 'SQLGL', 'GL#', c.CHART_OF_ACCOUNTS_ID, NULL, c.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') >= :p_in_bal_segment_low US Company Segment Low 46 240 :p_in_bal_segment_high LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and 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(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value :$flex$.company_segment_low US Company Segment High 47 &lp_bal_seg_high and fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_bal_seg', 'SQLGL', 'GL#', c.CHART_OF_ACCOUNTS_ID, NULL, c.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') <= :p_in_bal_segment_high US Company Segment High 48 250 &lp_acc_seg_low and fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_acc_seg', 'SQLGL', 'GL#', c.chart_of_accounts_id, NULL, c.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') >= :p_in_acc_segment_low LOV GL Account F26C78167A224EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and 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(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US GL Account Segment Low 49 260 &lp_acc_seg_high and fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_acc_seg', 'SQLGL', 'GL#', c.chart_of_accounts_id, NULL, c.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') <= :p_in_acc_segment_high LOV GL Account F26C78167A224EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and 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(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value :$flex$.GL_Account_Segment_Low US GL Account Segment High 50 270 :p_reval_conv_date Date sysdate US Revaluation Date 51 280 :p_reval_currency LOV custom Y select distinct fcv.currency_code value, fcv.description from fnd_currencies_vl fcv, gl_daily_rates gdr where fcv.enabled_flag='Y' and sysdate between nvl(fcv.start_date_active,sysdate) and nvl(fcv.end_date_active,sysdate) and gdr.conversion_date=:$flex$.revaluation_date and fcv.currency_code=gdr.to_currency and gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and ( :$flex$.reporting_context is null or :$flex$.reporting_level='1000' and xxen_util.contains(:$flex$.reporting_context,gl.name)='Y' or :$flex$.reporting_level='3000' and gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.reporting_context,hou.name)='Y') ) ) order by fcv.currency_code US Revaluation Currency 52 &lp_reval_aging_amount_cols select 'sum(decode(x1.b' || to_char(l.seq) || ',1,x1.amt_due_remaining,null)) * x1.reval_conv_rate "' || substrb(replace(XXEN_AR_ARXAGRW_PKG.bucket_title(:p_in_bucket_type_low,l.seq),'Due',decode(:p_age_basis,'Due Date','Due','Inv')),1,xxen_report.max_column_length-4) || ' ' || :p_reval_currency || '",' from ( select rownum-1 seq, l.* from ar_aging_bucket_lines l, ar_aging_buckets b where l.aging_bucket_id = b.aging_bucket_id and upper(b.bucket_name) = upper(:p_in_bucket_type_low) and nvl(b.status,'A') = 'A' order by l.bucket_sequence_num ) l order by l.seq US Revaluation Currency 53 &lp_reval_columns select 'x1.revaluation_from_currency, :p_reval_currency revaluation_currency, :p_reval_conv_type revaluation_rate_type, nvl2(:p_reval_currency,:p_reval_conv_date,null) revaluation_date, x1.reval_conv_rate revaluation_rate, nvl(sum(x1.amt_due_original),0) * x1.reval_conv_rate "Original Amount ' || :p_reval_currency || '", nvl(sum(x1.amt_due_remaining),0) * x1.reval_conv_rate "Outstanding Amount ' || :p_reval_currency || '", ' || case when xxen_util.lookup_code(:p_credit_option_dsp,'OPEN_CREDITS',222) = 'SUMMARY' then 'sum(x1.on_account_amount_cash)*x1.reval_conv_rate "Customer Payments ' || :p_reval_currency || '", sum(x1.on_account_amount_credit)*x1.reval_conv_rate "Customer Credit Memos ' || :p_reval_currency || '", sum(x1.on_account_amount_risk)*x1.reval_conv_rate "Customer Receipts At Risk ' || :p_reval_currency || '", sum(x1.cust_amount_claim)*x1.reval_conv_rate "Customer Claims ' || :p_reval_currency || '", ' end from dual US Revaluation Currency 54 290 :p_reval_conv_type LOV custom Y select distinct gdct.user_conversion_type value, gdct.description||' ('||count(*) over (partition by gdr.conversion_type)||')' description from gl_daily_conversion_types gdct, gl_daily_rates gdr where gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and ( :$flex$.reporting_context is null or :$flex$.reporting_level='1000' and xxen_util.contains(:$flex$.reporting_context,gl.name)='Y' or :$flex$.reporting_level='3000' and gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.reporting_context,hou.name)='Y') ) ) and gdr.to_currency=:$flex$.revaluation_currency and gdr.conversion_date=:$flex$.revaluation_date and gdct.conversion_type=gdr.conversion_type order by gdct.user_conversion_type US Revaluation Rate Type 55 300 &party_dff_cols3 select xxen_util.dff_columns(p_table_name=>'hz_parties',p_table_alias=>'hp',p_column_name_prefix=>'Party: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Party DFF Attributes 56 &party_dff_cols1 select xxen_util.dff_columns(p_table_name=>'hz_parties',p_prefix=>'x1.',p_column_name_prefix=>'Party: ') sql_text from dual US Show Party DFF Attributes 57 &party_dff_cols1_g select xxen_util.dff_columns(p_table_name=>'hz_parties',p_prefix=>'x1.',p_column_name_prefix=>'Party: ') sql_text from dual US Show Party DFF Attributes 58 &party_dff_cols2 select xxen_util.dff_columns(p_table_name=>'hz_parties',p_prefix=>'x.',p_column_name_prefix=>'Party: ') sql_text from dual US Show Party DFF Attributes 59 &party_dff_cols3_g select xxen_util.dff_columns(p_table_name=>'hz_parties',p_table_alias=>'hp',p_hide_column_name=>'Y') sql_text from dual US Show Party DFF Attributes 60 310 &cust_dff_cols3 select xxen_util.dff_columns(p_table_name=>'hz_cust_accounts',p_table_alias=>'hca',p_column_name_prefix=>'Customer: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Account DFF Attributes 61 &cust_dff_cols1 select xxen_util.dff_columns(p_table_name=>'hz_cust_accounts',p_prefix=>'x1.',p_column_name_prefix=>'Customer: ') sql_text from dual US Show Account DFF Attributes 62 &cust_dff_cols1_g select xxen_util.dff_columns(p_table_name=>'hz_cust_accounts',p_prefix=>'x1.',p_column_name_prefix=>'Customer: ') sql_text from dual US Show Account DFF Attributes 63 &cust_dff_cols2 select xxen_util.dff_columns(p_table_name=>'hz_cust_accounts',p_prefix=>'x.',p_column_name_prefix=>'Customer: ') sql_text from dual US Show Account DFF Attributes 64 &cust_dff_cols3_g select xxen_util.dff_columns(p_table_name=>'hz_cust_accounts',p_table_alias=>'hca',p_hide_column_name=>'Y') sql_text from dual US Show Account DFF Attributes 65 500 :p_show_sla LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show SLA Accounting Set to Yes to fetch SLA accounting information 66 &lp_sla_sel_outer , fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_bal_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.rec_code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') "Sla Receivables &lp_bal_seg_p", fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_acct_flex_acc_seg', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.rec_code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') "Sla Receivables &lp_acc_seg_p", fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_accounting_flexfield', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.rec_code_combination_id, 'ALL', 'Y', 'VALUE') sla_receivables_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('lp_accounting_flexfield', 'SQLGL', 'GL#', x1.chart_of_accounts_id, null, x1.rec_code_combination_id, 'ALL', 'Y', 'DESCRIPTION') sla_receivables_segments_desc, nvl(sum(x1.accounted_dr),0) sla_receivables_accounted_dr, nvl(sum(x1.accounted_cr),0) sla_receivables_accounted_cr, nvl(sum(x1.accounted_dr),0)-nvl(sum(x1.accounted_cr),0) sla_receivables_accounted_amt, nvl(sum(case when x1.sla_entity_code='RECEIPTS' or nvl(x1.rk,1)=1 then x1.net_accounted_dr else 0 end),0)-nvl(sum(case when x1.sla_entity_code='RECEIPTS' or nvl(x1.rk,1)=1 then x1.net_accounted_cr else 0 end),0) sla_receivables_net_amt US Show SLA Accounting :$flex$.GL_Account_Segment_Low GL Account Segment Low GL Account Segment High :$flex$.balance_due_low Balance Due Low Balance Due High :$flex$.chart_of_accounts_id Chart of Accounts Id Company Segment High :$flex$.chart_of_accounts_id Chart of Accounts Id Company Segment Low :$flex$.chart_of_accounts_id Chart of Accounts Id GL Account Segment High :$flex$.chart_of_accounts_id Chart of Accounts Id GL Account Segment Low :$flex$.company_segment_low Company Segment Low Company Segment High :$flex$.customer_name_low Customer Name Low Customer Name High :$flex$.customer_number_low Customer Number Low Customer Number High :$flex$.fnd_mo_reporting_level Reporting Level Reporting Context :$flex$.invoice_type_low Invoice Type Low Invoice Type High :$flex$.reporting_context Reporting Context Account Segment Label :$flex$.reporting_context Reporting Context Balancing Segment Label :$flex$.reporting_context Reporting Context Chart of Accounts Id :$flex$.reporting_context Reporting Context Revaluation Currency :$flex$.reporting_context Reporting Context Revaluation Rate Type :$flex$.reporting_level Reporting Level Account Segment Label :$flex$.reporting_level Reporting Level Balancing Segment Label :$flex$.reporting_level Reporting Level Chart of Accounts Id :$flex$.reporting_level Reporting Level Revaluation Currency :$flex$.reporting_level Reporting Level Revaluation Rate Type :$flex$.revaluation_currency Revaluation Currency Revaluation Rate Type :$flex$.revaluation_date Revaluation Date Y Revaluation Currency :$flex$.revaluation_date Revaluation Date Y Revaluation Rate Type :$flex$.salesrep_name_low Salesrep Name Low Salesrep Name High