AR Deposited Cash Report - Applied Detail
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Deposited Cash Report - Applied Detail
Application: Receivables
Source: Deposited Cash Report - Applied Detail (XML)
Short Name: ARXSOC2_XML
DB package: AR_ARXSOC2_XMLP_PKG
Description: Deposited Cash Report - Applied Detail
Application: Receivables
Source: Deposited Cash Report - Applied Detail (XML)
Short Name: ARXSOC2_XML
DB package: AR_ARXSOC2_XMLP_PKG
Run
AR Deposited Cash Report - Applied Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
select cr.currency_code Currency_B, cr.deposit_date deposit_date_B, cr.cash_receipt_id cash_receipt_id_B, cr.status cr_status_B, cr.amount amount_B, decode( crh.batch_id, null, cr.amount, 0 ) rcpt_control_amount_B, cr.status cr_status_BB, cr.type cr_type_B, cr.reversal_category reversal_category_B, AR_ARXSOC2_XMLP_PKG.cr_data_foundformula(cr.currency_code) CR_DATA_FOUND, AR_ARXSOC2_XMLP_PKG.ca_summary_labelformula(cr.currency_code) ca_summary_label, AR_ARXSOC2_XMLP_PKG.ca_difference_amountformula(:c_rcpt_control_amount_B, :ca_actual_amount) ca_difference_amount, AR_ARXSOC2_XMLP_PKG.ca_unapplied_amountformula(:ca_unapplied_amount_B, :ca_on_account_amount, :ca_unidentified_amount) ca_unapplied_amount, AR_ARXSOC2_XMLP_PKG.f_all_amountsformula(cr.status, cr.amount, cr.type, cr.reversal_category,cr.cash_receipt_id) F_ALL_AMOUNTS, AR_ARXSOC2_XMLP_PKG.pa_actual_amount_p pa_actual_amount, AR_ARXSOC2_XMLP_PKG.pa_unidentified_amount_p pa_unidentified_amount, AR_ARXSOC2_XMLP_PKG.pa_misc_amount_p pa_misc_amount, AR_ARXSOC2_XMLP_PKG.pa_nsf_amount_p pa_nsf_amount, AR_ARXSOC2_XMLP_PKG.pa_applied_count_p pa_applied_count, AR_ARXSOC2_XMLP_PKG.pa_unapplied_count_p pa_unapplied_count, AR_ARXSOC2_XMLP_PKG.pa_misc_count_p pa_misc_count from ar_cash_receipts cr, ar_cash_receipt_history crh, ce_bank_accounts cba, ce_bank_acct_uses ba where nvl(:p_bank_account_name_low , '!') != nvl(:p_bank_account_name_high, '@') AND &p_bank_count != 0 &lp_date_low &lp_date_high and nvl(cr.confirmed_flag,'Y') = 'Y' and deposit_date is NOT NULL and cr.cash_receipt_id = crh.cash_receipt_id and crh.first_posted_record_flag = 'Y' and cr.remit_bank_acct_use_id = ba.bank_acct_use_id and cba.bank_account_id = ba.bank_account_id &lp_bank_account_name_low &lp_bank_account_name_high union all select b.currency_code, b.deposit_date, -1, null, 0, b.control_amount, null, null, null, AR_ARXSOC2_XMLP_PKG.cr_data_foundformula(b.currency_code) CR_DATA_FOUND, AR_ARXSOC2_XMLP_PKG.ca_summary_labelformula(b.currency_code) ca_summary_label, AR_ARXSOC2_XMLP_PKG.ca_difference_amountformula(:c_rcpt_control_amount_B, :ca_actual_amount) ca_difference_amount, AR_ARXSOC2_XMLP_PKG.ca_unapplied_amountformula(:ca_unapplied_amount_B, :ca_on_account_amount, :ca_unidentified_amount) ca_unapplied_amount, AR_ARXSOC2_XMLP_PKG.f_all_amountsformula(null, 0, null, null, -1) F_ALL_AMOUNTS, AR_ARXSOC2_XMLP_PKG.pa_actual_amount_p pa_actual_amount, AR_ARXSOC2_XMLP_PKG.pa_unidentified_amount_p pa_unidentified_amount, AR_ARXSOC2_XMLP_PKG.pa_misc_amount_p pa_misc_amount, AR_ARXSOC2_XMLP_PKG.pa_nsf_amount_p pa_nsf_amount, AR_ARXSOC2_XMLP_PKG.pa_applied_count_p pa_applied_count, AR_ARXSOC2_XMLP_PKG.pa_unapplied_count_p pa_unapplied_count, AR_ARXSOC2_XMLP_PKG.pa_misc_count_p pa_misc_count from ar_batches b where nvl(:p_bank_account_name_low , '!') != nvl(:p_bank_account_name_high, '@') and &p_bank_count != 0 &lp_date_low &lp_date_high and deposit_date is not null order by 1, 2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Order By |
|
LOV Oracle | |
Deposit Date Low |
|
Date | |
Deposit Date High |
|
Date | |
Bank Account Name Low |
|
LOV Oracle | |
Bank Account Name High |
|
LOV Oracle |