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 1276: ar_payment_schedules ps,

1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,
1275: ar_receipt_method_accounts rma,
1276: ar_payment_schedules ps,
1277: ar_distributions d
1278: WHERE cr.selected_remittance_batch_id = :b_batch_id
1279: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1280: AND bat.batch_id = cr.selected_remittance_batch_id

Line 1902: ar_payment_schedules ps,

1898: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1899: ar_receipt_methods rm,
1900: ar_batches bat,
1901: ar_receipt_method_accounts rma,
1902: ar_payment_schedules ps,
1903: ar_distributions d
1904: WHERE cr.selected_remittance_batch_id = :ab_batch_id
1905: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1906: AND bat.batch_id = cr.selected_remittance_batch_id

Line 3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

3278:
3279: PROCEDURE select_update_rec(
3280: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

Line 3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

3279: PROCEDURE select_update_rec(
3280: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

Line 3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

3280: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3288: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,

Line 3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3288: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3289: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,

Line 3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3288: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3289: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3290: p_batch_id IN ar_batches.batch_id%TYPE,

Line 3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3286: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3288: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3289: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3290: p_batch_id IN ar_batches.batch_id%TYPE,
3291: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 3385: ar_payment_schedules ps,

3381: l_sel_stmt := l_sel_stmt || ' cr.cash_receipt_id
3382: FROM ar_rem_cr_id_gtt crh,
3383: ar_cash_receipt_history crh1,
3384: ar_cash_receipts cr,
3385: ar_payment_schedules ps,
3386: ar_receipt_classes rclass,
3387: ar_receipt_methods rm,
3388: ar_receipt_method_accounts rma1,
3389: ar_receipt_method_accounts rma2

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

5156: PROCEDURE insert_exceptions(
5157: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5158: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5159: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5160: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5161: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5162: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5163: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
5164: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,

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

5159: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5160: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5161: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5162: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5163: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
5164: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
5165: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
5166: p_exception_code IN VARCHAR2,
5167: p_additional_message IN VARCHAR2