eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_APPLICATION dependencies on CE_BANK_ACCT_USES

Line 3451: /* Reverted the fix introduced by 5571095 for bug 5638732 and replaced ce_bank_acct_uses by ce_bank_acct_uses_ou_v

3447:
3448: -- Populate CC ID columns by selecting from receipt method accounts and
3449: -- payment schedule tables.
3450: -- Release 11.5 VAT changes get discount accounts from activity
3451: /* Reverted the fix introduced by 5571095 for bug 5638732 and replaced ce_bank_acct_uses by ce_bank_acct_uses_ou_v
3452: for performance issue */
3453: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */
3454: /* 7332175 use different view as per input from CE to resolve no data found issue and keeping above performance issue in check*/
3455: SELECT ps.cash_receipt_id

Line 3453: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */

3449: -- payment schedule tables.
3450: -- Release 11.5 VAT changes get discount accounts from activity
3451: /* Reverted the fix introduced by 5571095 for bug 5638732 and replaced ce_bank_acct_uses by ce_bank_acct_uses_ou_v
3452: for performance issue */
3453: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */
3454: /* 7332175 use different view as per input from CE to resolve no data found issue and keeping above performance issue in check*/
3455: SELECT ps.cash_receipt_id
3456: , ps.amount_due_remaining
3457: , rma.unapplied_ccid

Line 3470: , ce_bank_acct_uses_ou ba

3466: , ln_batch_id
3467: FROM ar_cash_receipts cr
3468: , ar_cash_receipt_history crh
3469: , ar_receipt_methods rm
3470: , ce_bank_acct_uses_ou ba
3471: , ar_receipt_method_accounts rma
3472: , ar_payment_schedules ps
3473: , ar_receivables_trx ed
3474: , ar_receivables_trx uned

Line 4961: , ce_bank_acct_uses ba

4957: FROM ar_payment_schedules ps
4958: , ar_cash_receipts cr
4959: , ar_cash_receipt_history crh
4960: , ar_receipt_methods rm
4961: , ce_bank_acct_uses ba
4962: , ar_receipt_method_accounts rma
4963: WHERE ps.payment_schedule_id = p_receipt_ps_id
4964: AND cr.cash_receipt_id = ps.cash_receipt_id
4965: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5475: ce_bank_acct_uses ba,

5471: FROM ar_payment_schedules ps,
5472: ar_cash_receipts cr,
5473: ar_cash_receipt_history crh,
5474: ar_receipt_methods rm,
5475: ce_bank_acct_uses ba,
5476: ar_receipt_method_accounts rma,
5477: ar_receivables_trx rt
5478: WHERE ps.payment_schedule_id = p_receipt_ps_id
5479: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 6814: , ce_bank_acct_uses ba

6810: FROM ar_payment_schedules ps
6811: , ar_cash_receipts cr
6812: , ar_cash_receipt_history crh
6813: , ar_receipt_methods rm
6814: , ce_bank_acct_uses ba
6815: , ar_receipt_method_accounts rma
6816: , ar_receivables_trx rt
6817: WHERE ps.payment_schedule_id = p_receipt_ps_id
6818: AND cr.cash_receipt_id = ps.cash_receipt_id