DBA Data[Home] [Help]

APPS.ARRX_BRS dependencies on RA_BATCH_SOURCES

Line 120: v_transaction_batch_source RA_BATCH_SOURCES.name%TYPE;

116: v_maturity_date RA_CUSTOMER_TRX.term_due_date%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;

Line 503: ,ra_batch_sources_all rabs

499: ,ar_transaction_history_all rah
500: ,fnd_document_sequences fds
501: ,ar_payment_schedules_all ps
502: ,ra_batches_all rab
503: ,ra_batch_sources_all rabs
504: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
505: AND trx.batch_source_id = rabs.batch_source_id
506: AND trx.drawee_site_use_id = rasu.site_use_id (+)
507: AND rasu.cust_acct_site_id = raa.cust_acct_site_id (+)