DBA Data[Home] [Help]

APPS.ARRX_BRS dependencies on RA_CUST_TRX_TYPES

Line 97: v_magnetic_format_code RA_CUST_TRX_TYPES.magnetic_format_code%TYPE;

93: v_transaction_number RA_CUSTOMER_TRX.trx_number%TYPE;
94: v_document_number RA_CUSTOMER_TRX.doc_sequence_value%TYPE;
95: v_document_sequence_name FND_DOCUMENT_SEQUENCES.name%TYPE;
96: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
97: v_magnetic_format_code RA_CUST_TRX_TYPES.magnetic_format_code%TYPE;
98: v_original_entered_amount AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
99: v_open_entered_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
100: v_open_functional_amount AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE;

Line 117: v_issued_by_drawee RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE;

113: v_drawee_location HZ_CUST_SITE_USES.location%TYPE;
114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;
115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%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;

Line 118: v_signed_by_drawee RA_CUST_TRX_TYPES.signed_flag%TYPE;

114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;
115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%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;

Line 119: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;

115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%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;

Line 480: FROM ra_cust_trx_types_all ctt

476: ,rah.status status_code
477: ,rab.name creation_batch_name
478: ,rabs.name transaction_batch_source
479: ,nvl(ps.exchange_rate,1)
480: FROM ra_cust_trx_types_all ctt
481: ,ra_customer_trx_all trx
482: ,hz_cust_acct_sites raa
483: ,hz_party_sites party_site
484: ,hz_locations loc