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.FUN_NET_ARAP_PKG dependencies on AR_RECEIPT_METHODS

Line 40: payment_type_code ar_receipt_methods.payment_type_code%TYPE);

36: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,
37: txn_curr_net_amt fun_net_ar_txns.txn_curr_net_amt%TYPE,
38: net_amt fun_net_ar_txns.netted_amt%TYPE,
39: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,
40: payment_type_code ar_receipt_methods.payment_type_code%TYPE);
41: TYPE txnTblType IS TABLE OF txnRecType INDEX BY BINARY_INTEGER;
42: TYPE arReceiptRecType IS RECORD
43: (
44: currency_code fun_net_batches.batch_currency%TYPE,

Line 58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,

54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
57: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
59: org_id fun_net_batches.org_id%TYPE
60: );
61: g_batch_id fun_net_batches_all.batch_id%TYPE;
62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;

Line 539: FROM ar_receipt_methods arm

535: WHERE fnar.cust_trx_type_id = rct.cust_trx_type_id
536: AND fnar.agreement_id = :v_agreement_id2)
537: AND NOT EXISTS
538: (SELECT ''X''
539: FROM ar_receipt_methods arm
540: WHERE arm.receipt_method_id = rct.receipt_method_id
541: AND arm.payment_type_code = ''CREDIT_CARD'')
542: AND NOT EXISTS
543: (SELECT ''X''

Line 2608: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma

2604: begin
2605: select cba.receipt_multi_currency_flag
2606: into l_flag
2607: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,
2608: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma
2609: where rc.creation_method_code = 'NETTING'
2610: and rc.receipt_class_id = rm.receipt_class_id
2611: and ba.bank_account_id = cba.bank_account_id
2612: and rm.receipt_method_id = rma.receipt_method_id

Line 3600: AR_RECEIPT_METHODS arm

3596: FROM FUN_NET_AR_TXNS ftxn,
3597: RA_CUSTOMER_TRX trx,
3598: RA_CUSTOMER_TRX_LINES trx_line,
3599: AR_PAYMENT_SCHEDULES ARPS,
3600: AR_RECEIPT_METHODS arm
3601: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3602: AND trx.customer_trx_id = trx_line.customer_trx_id
3603: AND ARPS.customer_Trx_id = trx.customer_Trx_id
3604: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE

Line 3652: AR_RECEIPT_METHODS arm,

3648: BULK COLLECT INTO txnTable
3649: FROM FUN_NET_AR_TXNS ftxn,
3650: RA_CUSTOMER_TRX trx,
3651: AR_PAYMENT_SCHEDULES ARPS,
3652: AR_RECEIPT_METHODS arm,
3653: RA_CUST_TRX_TYPES ctype
3654: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3655: AND ARPS.customer_Trx_id = trx.customer_Trx_id
3656: --AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE

Line 3701: AR_RECEIPT_METHODS arm,

3697: BULK COLLECT INTO txnTable
3698: FROM FUN_NET_AR_TXNS ftxn,
3699: RA_CUSTOMER_TRX trx,
3700: AR_PAYMENT_SCHEDULES ARPS,
3701: AR_RECEIPT_METHODS arm,
3702: RA_CUST_TRX_TYPES ctype
3703: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3704: AND ARPS.customer_Trx_id = trx.customer_Trx_id
3705: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE

Line 4311: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;

4307: x_return_status OUT NOCOPY VARCHAR2,
4308: x_msg_data OUT NOCOPY VARCHAR2,
4309: x_msg_count OUT NOCOPY NUMBER)
4310: IS
4311: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;
4312: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
4313: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
4314: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;
4315: arReceiptRec arReceiptRecType;

Line 4351: FROM ar_receipt_methods

4347: -- Bug 5967665, Changed the where clause to WHERE receipt_method_id= -1
4348: BEGIN
4349: SELECT receipt_method_id
4350: INTO l_receipt_method_id
4351: FROM ar_receipt_methods
4352: WHERE receipt_method_id= -1;
4353: EXCEPTION
4354: WHEN OTHERS THEN
4355: fun_net_util.Log_String(g_event_level,

Line 4465: AR_RECEIPT_METHODS arm,

4461: BULK COLLECT INTO txnTable2
4462: FROM FUN_NET_AR_TXNS ftxn,
4463: RA_CUSTOMER_TRX trx,
4464: AR_PAYMENT_SCHEDULES ARPS,
4465: AR_RECEIPT_METHODS arm,
4466: RA_CUST_TRX_TYPES ctype
4467: WHERE ftxn.customer_trx_id = trx.customer_trx_id
4468: AND ARPS.customer_Trx_id = trx.customer_Trx_id
4469: --AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE

Line 4514: AR_RECEIPT_METHODS arm,

4510: BULK COLLECT INTO txnTable2
4511: FROM FUN_NET_AR_TXNS ftxn,
4512: RA_CUSTOMER_TRX trx,
4513: AR_PAYMENT_SCHEDULES ARPS,
4514: AR_RECEIPT_METHODS arm,
4515: RA_CUST_TRX_TYPES ctype
4516: WHERE ftxn.customer_trx_id = trx.customer_trx_id
4517: AND ARPS.customer_Trx_id = trx.customer_Trx_id
4518: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE