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 505: ,ra_batch_sources_all rabs

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