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.AR_AUTOREM_API dependencies on AR_PAYMENT_SCHEDULES

Line 1966: ar_payment_schedules ps,

1962: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1963: ar_receipt_methods rm,
1964: ar_batches bat,
1965: ar_receipt_method_accounts rma,
1966: ar_payment_schedules ps,
1967: ar_distributions d
1968: WHERE cr.selected_remittance_batch_id = :ab_batch_id
1969: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1970: AND bat.batch_id = cr.selected_remittance_batch_id

Line 3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

Line 3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

Line 3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,

Line 3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,

Line 3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,

Line 3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 3492: ar_payment_schedules ps,

3488: end if;
3489:
3490: l_sel_stmt := l_sel_stmt || ' ar_cash_receipt_history crh1,
3491: ar_cash_receipts cr,
3492: ar_payment_schedules ps,
3493: ar_receipt_classes rclass,
3494: ar_receipt_methods rm,
3495: ar_receipt_method_accounts rma1,
3496: ar_receipt_method_accounts rma2

Line 5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

5433: PROCEDURE insert_exceptions(
5434: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5440: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
5441: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,

Line 5440: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5440: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
5441: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
5442: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
5443: p_exception_code IN VARCHAR2,
5444: p_additional_message IN VARCHAR2