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_IREC_PAYMENTS dependencies on AR_PAYMENT_SCHEDULES

Line 661: FROM ar_payment_schedules

657: AND TRUNC(p_trx_date) BETWEEN TRUNC(arma.start_date) AND TRUNC(nvl(arma.end_date, p_trx_date));
658:
659: CURSOR payment_schedule_info_cur IS
660: SELECT customer_site_use_id, invoice_currency_code, exchange_rate,trx_number
661: FROM ar_payment_schedules
662: WHERE payment_schedule_id = p_payment_schedule_id;
663:
664: payment_method_info payment_method_info_cur%ROWTYPE;
665: payment_schedule_info payment_schedule_info_cur%ROWTYPE;

Line 672: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;

668: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
669:
670: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
671: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
672: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
673:
674: l_procedure_name VARCHAR2(30);
675: l_debug_info VARCHAR2(200);
676:

Line 1056: l_currency_code ar_payment_schedules.invoice_currency_code%type;

1052:
1053: l_ps_balance NUMBER;
1054: l_bank_account_method NUMBER;
1055: l_credit_card_method NUMBER; /* J Rautiainen ACH Implementation */
1056: l_currency_code ar_payment_schedules.invoice_currency_code%type;
1057: l_class ar_payment_schedules.class%TYPE;
1058: l_creation_status ar_receipt_classes.creation_status%TYPE;
1059:
1060: BEGIN

Line 1057: l_class ar_payment_schedules.class%TYPE;

1053: l_ps_balance NUMBER;
1054: l_bank_account_method NUMBER;
1055: l_credit_card_method NUMBER; /* J Rautiainen ACH Implementation */
1056: l_currency_code ar_payment_schedules.invoice_currency_code%type;
1057: l_class ar_payment_schedules.class%TYPE;
1058: l_creation_status ar_receipt_classes.creation_status%TYPE;
1059:
1060: BEGIN
1061:

Line 1072: FROM ar_payment_schedules

1068: -- check trx type and balance: trx type must be debit item, balance > 0
1069:
1070: SELECT amount_due_remaining, class, invoice_currency_code
1071: INTO l_ps_balance, l_class, l_currency_code
1072: FROM ar_payment_schedules
1073: WHERE payment_schedule_id = p_payment_schedule_id;
1074: --Bug 4161986 - Pay Icon does not appear in the ChargeBack and its activities page. Added the class CB(Chargeback)
1075: IF l_ps_balance <= 0
1076: OR l_class NOT IN ('INV', 'DEP', 'GUAR', 'DM', 'CB') THEN

Line 2223: FROM AR_PAYMENT_SCHEDULES ps,

2219: ps.org_id,
2220: ct.PAYING_CUSTOMER_ID,
2221: ct.PAYING_SITE_USE_ID,
2222: ( decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) ) dispute_amt
2223: FROM AR_PAYMENT_SCHEDULES ps,
2224: RA_CUSTOMER_TRX ct,
2225: HZ_CUST_ACCOUNTS acct,
2226: RA_TERMS trm
2227: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')

Line 2391: | AR_PAYMENT_SCHEDULES to the Payment List GT

Line 2494: FROM AR_PAYMENT_SCHEDULES ps,

2490: ps.org_id,
2491: 0 PAYING_CUSTOMER_ID,
2492: 0 PAYING_SITE_USE_ID,
2493: 0 dispute_amt
2494: FROM AR_PAYMENT_SCHEDULES ps,
2495: RA_CUSTOMER_TRX_ALL ct,
2496: HZ_CUST_ACCOUNTS acct,
2497: RA_TERMS trm
2498: WHERE ps.customer_id = p_customer_id

Line 3872: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;

3868: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;
3869: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;
3870: l_receipt_exchange_rate_date DATE;
3871:
3872: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;
3873: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
3874: l_remit_bank_account_id AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID%TYPE;
3875: l_receipt_creation_status VARCHAR2(80);
3876: l_site_use_id NUMBER(15);

Line 3881: l_invoice_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;

3877: l_bank_account_id NUMBER;
3878: l_bank_account_uses_id NUMBER;
3879: l_cvv2 iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
3880:
3881: l_invoice_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
3882: l_cr_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
3883: x_return_status VARCHAR2(100);
3884: l_msg_count NUMBER;
3885: l_msg_data VARCHAR2(4000);

Line 4977: from ar_payment_schedules ps, ra_customer_trx_all ct

4973:
4974: select class, amount_due_remaining, cash_receipt_id, ps.CUSTOMER_ID, ct.PAYING_CUSTOMER_ID, ps.CUSTOMER_SITE_USE_ID,ct.PAYING_SITE_USE_ID, ps.customer_trx_id,
4975: (decode( nvl(AMOUNT_DUE_ORIGINAL,0),0,1,(AMOUNT_DUE_ORIGINAL/abs(AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(amount_in_dispute,0)) )
4976: into l_trx_class, l_amount_due_remaining, l_cash_receipt_id, l_pay_for_cust_id, l_paying_cust_id, l_pay_for_cust_site_id, l_paying_cust_site_id, l_customer_trx_id, l_dispute_amount
4977: from ar_payment_schedules ps, ra_customer_trx_all ct
4978: where ps.CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID(+)
4979: and ps.payment_schedule_id = p_payment_schedule_id;
4980:
4981: --Bug 4479224

Line 5169: FROM AR_PAYMENT_SCHEDULES ps,

5165: l_pay_for_cust_id,
5166: --Bug 4062938 - Handling of transactions with no site id
5167: decode(ps.customer_site_use_id, null, -1,ps.customer_site_use_id) as CUSTOMER_SITE_USE_ID,
5168: (decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) )
5169: FROM AR_PAYMENT_SCHEDULES ps,
5170: RA_CUSTOMER_TRX_ALL ct,
5171: HZ_CUST_ACCOUNTS acct,
5172: RA_TERMS trm
5173: WHERE ps.payment_schedule_id = p_payment_schedule_id

Line 5655: FUNCTION get_discount_wrapper ( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5651: | MODIFICATION HISTORY
5652: | Date Author Description of Changes
5653: | 19-JUL-2004 vnb Created
5654: +============================================================*/
5655: FUNCTION get_discount_wrapper ( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5656: p_in_applied_amount IN NUMBER) RETURN NUMBER IS
5657: l_discount_amount NUMBER;
5658: l_customer_id NUMBER;
5659: l_customer_site_use_id NUMBER;

Line 5666: FROM ar_payment_schedules

5662: l_grace_days_flag VARCHAR2(2);
5663: BEGIN
5664: SELECT CUSTOMER_ID, CUSTOMER_SITE_USE_ID
5665: INTO l_customer_id, l_customer_site_use_id
5666: FROM ar_payment_schedules
5667: WHERE PAYMENT_SCHEDULE_ID = p_ps_id;
5668:
5669: -- Check if grace days have to be considered for discount.
5670: --l_grace_days_flag := is_grace_days_enabled_wrapper();

Line 6013: | This procedure will update the PAYMENT_APPROVAL column in ar_payment_schedules

6009: /*=====================================================================
6010: | PROCEDURE update_invoice_payment_status
6011: |
6012: | DESCRIPTION
6013: | This procedure will update the PAYMENT_APPROVAL column in ar_payment_schedules
6014: | with the value p_inv_pay_status for the records in p_payment_schedule_id_list
6015: |
6016: | PARAMETERS
6017: | p_payment_schedule_id_list IN Inv_list_table_type

Line 6044: UPDATE AR_PAYMENT_SCHEDULES set PAYMENT_APPROVAL = p_inv_pay_status,

6040: l_last_updated_by := FND_GLOBAL.USER_ID;
6041:
6042: FORALL trx
6043: IN p_payment_schedule_id_list.first .. p_payment_schedule_id_list.last
6044: UPDATE AR_PAYMENT_SCHEDULES set PAYMENT_APPROVAL = p_inv_pay_status,
6045: LAST_UPDATE_DATE = l_last_update_date, LAST_UPDATED_BY = l_last_updated_by,
6046: LAST_UPDATE_LOGIN = l_last_update_login
6047: where payment_schedule_id = p_payment_schedule_id_list(trx);
6048: