DBA Data[Home] [Help]

APPS.ARRX_BRS dependencies on AR_BATCHES

Line 155: v_remittance_batch_name AR_BATCHES.name%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;
155: v_remittance_batch_name AR_BATCHES.name%TYPE;
156: v_remittance_method AR_BATCHES.remit_method_code%TYPE;
157: v_with_recourse AR_BATCHES.with_recourse_flag%TYPE;
158: v_last_printed_date RA_CUSTOMER_TRX.printing_last_printed%TYPE;
159: v_unpaid_receipt_rev_reason AR_LOOKUPS.meaning%TYPE;

Line 156: v_remittance_method AR_BATCHES.remit_method_code%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;
155: v_remittance_batch_name AR_BATCHES.name%TYPE;
156: v_remittance_method AR_BATCHES.remit_method_code%TYPE;
157: v_with_recourse AR_BATCHES.with_recourse_flag%TYPE;
158: v_last_printed_date RA_CUSTOMER_TRX.printing_last_printed%TYPE;
159: v_unpaid_receipt_rev_reason AR_LOOKUPS.meaning%TYPE;
160: v_risk_elimination_days AR_RECEIPT_METHOD_ACCOUNTS.risk_elimination_days%TYPE;

Line 157: v_with_recourse AR_BATCHES.with_recourse_flag%TYPE;

153: v_comments RA_CUSTOMER_TRX.comments%TYPE;
154: v_days_late NUMBER;
155: v_remittance_batch_name AR_BATCHES.name%TYPE;
156: v_remittance_method AR_BATCHES.remit_method_code%TYPE;
157: v_with_recourse AR_BATCHES.with_recourse_flag%TYPE;
158: v_last_printed_date RA_CUSTOMER_TRX.printing_last_printed%TYPE;
159: v_unpaid_receipt_rev_reason AR_LOOKUPS.meaning%TYPE;
160: v_risk_elimination_days AR_RECEIPT_METHOD_ACCOUNTS.risk_elimination_days%TYPE;
161: v_remittance_date AR_TRANSACTION_HISTORY.trx_date%TYPE;

Line 273: ,ar_batches_all arb

269: ,cba.check_digits
270: ,cba.currency_code remit_bank_acc_curr
271: ,rma.risk_elimination_days
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