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 AR_PAYMENT_SCHEDULES

Line 71: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

67: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
68: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
69: l_populate VARCHAR2(1);
70: l_populate_amt VARCHAR2(1) := 'Y';
71: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
72: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
73: l_new_original_funct_amt AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
74:
75: -- Declare variables for Dynamic Cursors

Line 72: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;

68: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
69: l_populate VARCHAR2(1);
70: l_populate_amt VARCHAR2(1) := 'Y';
71: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
72: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
73: l_new_original_funct_amt AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
74:
75: -- Declare variables for Dynamic Cursors
76: v_CursorID_main INTEGER;

Line 73: l_new_original_funct_amt AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;

69: l_populate VARCHAR2(1);
70: l_populate_amt VARCHAR2(1) := 'Y';
71: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
72: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
73: l_new_original_funct_amt AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
74:
75: -- Declare variables for Dynamic Cursors
76: v_CursorID_main INTEGER;
77: v_Dummy_main INTEGER;

Line 98: v_original_entered_amount AR_PAYMENT_SCHEDULES.amount_due_original%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;
102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;

Line 99: v_open_entered_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%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;
102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;
103: v_drawee_name hz_parties.party_name%TYPE;

Line 100: v_open_functional_amount AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%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;
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;

Line 172: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;

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;
173:
174:
175:
176: BEGIN

Line 501: ,ar_payment_schedules_all ps

497: ,ar_lookups arl_class
498: ,ar_lookups arl_category
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