eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARRX_BRS dependencies on RA_CUSTOMER_TRX

Line 92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

88:
89: -- Declare the variables which will hold the results of the SELECT statements
90: v_status AR_LOOKUPS.meaning%TYPE;
91: v_status_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%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;

Line 93: v_transaction_number RA_CUSTOMER_TRX.trx_number%TYPE;

89: -- Declare the variables which will hold the results of the SELECT statements
90: v_status AR_LOOKUPS.meaning%TYPE;
91: v_status_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%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;

Line 94: v_document_number RA_CUSTOMER_TRX.doc_sequence_value%TYPE;

90: v_status AR_LOOKUPS.meaning%TYPE;
91: v_status_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%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;

Line 96: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%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;

Line 101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%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;
102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;
103: v_drawee_name hz_parties.party_name%TYPE;
104: v_drawee_number hz_cust_accounts.account_number%TYPE;
105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;

Line 102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%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;
102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;
103: v_drawee_name hz_parties.party_name%TYPE;
104: v_drawee_number hz_cust_accounts.account_number%TYPE;
105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;

Line 114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;

110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%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;

Line 116: v_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;

112: v_drawee_category AR_LOOKUPS.meaning%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;

Line 135: v_remit_bank_allow_override RA_CUSTOMER_TRX.override_remit_account_flag%TYPE;

131: v_remit_branch_postal_code ce_bank_branches_v.zip%TYPE;
132: v_remit_branch_address1 ce_bank_branches_v.address_line1%TYPE;
133: v_remit_branch_address2 ce_bank_branches_v.address_line2%TYPE;
134: v_remit_branch_address3 ce_bank_branches_v.address_line3%TYPE;
135: v_remit_bank_allow_override RA_CUSTOMER_TRX.override_remit_account_flag%TYPE;
136: v_remit_bank_acc_check_digits ce_bank_accounts.check_digits%TYPE;
137: v_remit_bank_acc_curr ce_bank_accounts.currency_code%TYPE;
138: v_drawee_bank_name ce_bank_branches_v.bank_name%TYPE;
139: v_drawee_bank_number ce_bank_branches_v.bank_number%TYPE;

Line 153: v_comments RA_CUSTOMER_TRX.comments%TYPE;

149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits AP_BANK_ACCOUNTS.check_digits%TYPE;
152: v_drawee_bank_acc_curr AP_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;

Line 158: v_last_printed_date RA_CUSTOMER_TRX.printing_last_printed%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;
162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;

Line 168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%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);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;
169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
170: v_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
171: v_functional_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
172: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;

Line 297: FROM ra_customer_trx_all trx,

293: AND rah1.customer_trx_id = :b_trx_id)';
294:
295: -- Open Amounts Cursor
296: l_open_amount := 'SELECT nvl(SUM(app.amount_applied),0)
297: FROM ra_customer_trx_all trx,
298: ar_receivable_applications_all app
299: WHERE trx.customer_trx_id = app.applied_customer_trx_id
300: AND app.applied_customer_trx_id = :b_trx_id '||
301: l_org_where_trx ||

Line 322: FROM ra_customer_trx_lines_all trl

318:
319: -- Assigned Amounts Cursor
320: l_assigned_amount := 'SELECT nvl(sum(trl.extended_amount),0),
321: nvl(sum(trl.extended_acctd_amount),0)
322: FROM ra_customer_trx_lines_all trl
323: WHERE trl.customer_trx_id = :b_trx_id '||
324: l_org_where_trl;
325:
326:

Line 481: ,ra_customer_trx_all trx

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
485: ,hz_cust_account_roles acct_role