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_BRANCHES_V

Line 121: v_remit_bank_name ce_bank_branches_v.bank_name%TYPE;

117: v_issued_by_drawee RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE;
118: v_signed_by_drawee RA_CUST_TRX_TYPES.signed_flag%TYPE;
119: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
120: v_transaction_batch_source RA_BATCH_SOURCES.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;

Line 122: v_remit_bank_number ce_bank_branches_v.bank_number%TYPE;

118: v_signed_by_drawee RA_CUST_TRX_TYPES.signed_flag%TYPE;
119: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
120: v_transaction_batch_source RA_BATCH_SOURCES.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;

Line 123: v_remit_branch_name ce_bank_branches_v.bank_branch_name%TYPE;

119: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
120: v_transaction_batch_source RA_BATCH_SOURCES.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;

Line 124: v_remit_branch_number ce_bank_branches_v.branch_number%TYPE;

120: v_transaction_batch_source RA_BATCH_SOURCES.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;

Line 128: v_remit_branch_city ce_bank_branches_v.city%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;
132: v_remit_branch_address1 ce_bank_branches_v.address_line1%TYPE;

Line 129: v_remit_branch_state ce_bank_branches_v.state%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;
132: v_remit_branch_address1 ce_bank_branches_v.address_line1%TYPE;
133: v_remit_branch_address2 ce_bank_branches_v.address_line2%TYPE;

Line 130: v_remit_branch_country ce_bank_branches_v.country%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;
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;

Line 131: v_remit_branch_postal_code ce_bank_branches_v.zip%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;
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;

Line 132: v_remit_branch_address1 ce_bank_branches_v.address_line1%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;
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;

Line 133: v_remit_branch_address2 ce_bank_branches_v.address_line2%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;
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;

Line 134: v_remit_branch_address3 ce_bank_branches_v.address_line3%TYPE;

130: v_remit_branch_country ce_bank_branches_v.country%TYPE;
131: v_remit_branch_postal_code ce_bank_branches_v.zip%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;

Line 138: v_drawee_bank_name ce_bank_branches_v.bank_name%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;
142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;

Line 139: v_drawee_bank_number ce_bank_branches_v.bank_number%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;
142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;

Line 140: v_drawee_branch_name ce_bank_branches_v.bank_branch_name%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;
142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;

Line 141: v_drawee_branch_number ce_bank_branches_v.branch_number%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;
142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;

Line 144: v_drawee_branch_city ce_bank_branches_v.city%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;
142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;

Line 145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;

141: v_drawee_branch_number ce_bank_branches_v.branch_number%TYPE;
142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;

Line 146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;

142: v_drawee_bank_acc_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;

Line 147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;

143: v_drawee_bank_acc_number IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits IBY_EXT_BANK_ACCOUNTS.check_digits%TYPE;

Line 148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;

144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits IBY_EXT_BANK_ACCOUNTS.check_digits%TYPE;
152: v_drawee_bank_acc_curr IBY_EXT_BANK_ACCOUNTS.currency_code%TYPE;

Line 149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;

145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits IBY_EXT_BANK_ACCOUNTS.check_digits%TYPE;
152: v_drawee_bank_acc_curr IBY_EXT_BANK_ACCOUNTS.currency_code%TYPE;
153: v_comments RA_CUSTOMER_TRX.comments%TYPE;

Line 150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;

146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits IBY_EXT_BANK_ACCOUNTS.check_digits%TYPE;
152: v_drawee_bank_acc_curr IBY_EXT_BANK_ACCOUNTS.currency_code%TYPE;
153: v_comments RA_CUSTOMER_TRX.comments%TYPE;
154: v_days_late NUMBER;

Line 278: ,ce_bank_branches_v rabb

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(+)
281: AND rm.receipt_method_id = rma.receipt_method_id(+)
282: AND arb.remit_bank_acct_use_id = raba.bank_acct_use_id(+)

Line 492: ,ce_bank_branches_v abb

488: ,hz_cust_site_uses_all rasu
489: ,IBY_EXT_BANK_ACCOUNTS_V aba
490: ,IBY_FNDCPT_TX_EXTENSIONS ifte
491: ,iby_pmt_instr_uses_all ipiu
492: ,ce_bank_branches_v abb
493: ,hz_cust_accounts cust_acct
494: ,hz_parties party
495: ,ce_bank_branches_v rabb
496: ,ce_bank_accounts cba

Line 495: ,ce_bank_branches_v rabb

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