DBA Data[Home] [Help]

APPS.ARRX_BRS dependencies on RA_BATCHES

Line 163: v_creation_batch_name RA_BATCHES.name%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;
162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;
163: v_creation_batch_name RA_BATCHES.name%TYPE;
164: v_drawee_address1 HZ_LOCATIONS.address1%TYPE;
165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;
166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;
167: v_drawee_contact VARCHAR2(100);

Line 504: ,ra_batches_all rab

500: ,ar_lookups arl_category
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 (+)