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.ARRX_BRS dependencies on CE_BANK_ACCOUNTS

Line 125: v_remit_bank_acc_name ce_bank_accounts.bank_account_name%TYPE;

121: v_remit_bank_name ce_bank_branches_v.bank_name%TYPE;
122: v_remit_bank_number ce_bank_branches_v.bank_number%TYPE;
123: v_remit_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
124: v_remit_branch_number ce_bank_branches_v.branch_number%TYPE;
125: v_remit_bank_acc_name ce_bank_accounts.bank_account_name%TYPE;
126: v_remit_bank_acc_number ce_bank_accounts.bank_account_num%TYPE;
127: v_remit_bank_acc_id ce_bank_accounts.bank_account_id%TYPE;
128: v_remit_branch_city ce_bank_branches_v.city%TYPE;
129: v_remit_branch_state ce_bank_branches_v.state%TYPE;

Line 126: v_remit_bank_acc_number ce_bank_accounts.bank_account_num%TYPE;

122: v_remit_bank_number ce_bank_branches_v.bank_number%TYPE;
123: v_remit_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
124: v_remit_branch_number ce_bank_branches_v.branch_number%TYPE;
125: v_remit_bank_acc_name ce_bank_accounts.bank_account_name%TYPE;
126: v_remit_bank_acc_number ce_bank_accounts.bank_account_num%TYPE;
127: v_remit_bank_acc_id ce_bank_accounts.bank_account_id%TYPE;
128: v_remit_branch_city ce_bank_branches_v.city%TYPE;
129: v_remit_branch_state ce_bank_branches_v.state%TYPE;
130: v_remit_branch_country ce_bank_branches_v.country%TYPE;

Line 127: v_remit_bank_acc_id ce_bank_accounts.bank_account_id%TYPE;

123: v_remit_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
124: v_remit_branch_number ce_bank_branches_v.branch_number%TYPE;
125: v_remit_bank_acc_name ce_bank_accounts.bank_account_name%TYPE;
126: v_remit_bank_acc_number ce_bank_accounts.bank_account_num%TYPE;
127: v_remit_bank_acc_id ce_bank_accounts.bank_account_id%TYPE;
128: v_remit_branch_city ce_bank_branches_v.city%TYPE;
129: v_remit_branch_state ce_bank_branches_v.state%TYPE;
130: v_remit_branch_country ce_bank_branches_v.country%TYPE;
131: v_remit_branch_postal_code ce_bank_branches_v.zip%TYPE;

Line 136: v_remit_bank_acc_check_digits ce_bank_accounts.check_digits%TYPE;

132: v_remit_branch_address1 ce_bank_branches_v.address_line1%TYPE;
133: v_remit_branch_address2 ce_bank_branches_v.address_line2%TYPE;
134: v_remit_branch_address3 ce_bank_branches_v.address_line3%TYPE;
135: v_remit_bank_allow_override RA_CUSTOMER_TRX.override_remit_account_flag%TYPE;
136: v_remit_bank_acc_check_digits ce_bank_accounts.check_digits%TYPE;
137: v_remit_bank_acc_curr ce_bank_accounts.currency_code%TYPE;
138: v_drawee_bank_name ce_bank_branches_v.bank_name%TYPE;
139: v_drawee_bank_number ce_bank_branches_v.bank_number%TYPE;
140: v_drawee_branch_name ce_bank_branches_v.bank_branch_name%TYPE;

Line 137: v_remit_bank_acc_curr ce_bank_accounts.currency_code%TYPE;

133: v_remit_branch_address2 ce_bank_branches_v.address_line2%TYPE;
134: v_remit_branch_address3 ce_bank_branches_v.address_line3%TYPE;
135: v_remit_bank_allow_override RA_CUSTOMER_TRX.override_remit_account_flag%TYPE;
136: v_remit_bank_acc_check_digits ce_bank_accounts.check_digits%TYPE;
137: v_remit_bank_acc_curr ce_bank_accounts.currency_code%TYPE;
138: v_drawee_bank_name ce_bank_branches_v.bank_name%TYPE;
139: v_drawee_bank_number ce_bank_branches_v.bank_number%TYPE;
140: v_drawee_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
141: v_drawee_branch_number ce_bank_branches_v.branch_number%TYPE;

Line 276: ,ce_bank_accounts cba

272: FROM ar_transaction_history_all rah
273: ,ar_batches_all arb
274: ,ar_receipt_methods rm
275: ,ar_receipt_method_accounts rma
276: ,ce_bank_accounts cba
277: ,ce_bank_acct_uses raba
278: ,ce_bank_branches_v rabb
279: WHERE rah.batch_id = arb.batch_id
280: AND arb.receipt_method_id = rm.receipt_method_id(+)

Line 494: ,ce_bank_accounts cba

490: ,ce_bank_branches_v abb
491: ,hz_cust_accounts cust_acct
492: ,hz_parties party
493: ,ce_bank_branches_v rabb
494: ,ce_bank_accounts cba
495: ,ce_bank_acct_uses raba
496: ,ar_lookups arl
497: ,ar_lookups arl_class
498: ,ar_lookups arl_category