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_RECEIPT_METHOD_ACCOUNTS

Line 105: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;

101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
103: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
104: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
105: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
106: o_batch_id NUMBER;
107:
108: p_create_only VARCHAR2(1);
109: l_flow1 VARCHAR2(1);

Line 994: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;

990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
993: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
994: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
995: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
996: l_return_status VARCHAR2(1);
997: o_batch_id NUMBER;
998: l_ins_stmt VARCHAR2(5000);

Line 1339: ar_receipt_method_accounts rma,

1335: hz_parties party,
1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,
1338: ar_batches bat,
1339: ar_receipt_method_accounts rma,
1340: ar_distributions d
1341: WHERE cr.selected_remittance_batch_id = :b_batch_id
1342: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1343: AND bat.batch_id = cr.selected_remittance_batch_id

Line 1511: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,

1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1508: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1509: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1510: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1511: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1512: p_remit_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE DEFAULT NULL, --bug12924584
1513: p_batch_id OUT NOCOPY NUMBER
1514: ) IS
1515: l_batch_rec ar_batches%ROWTYPE;

Line 1592: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp

1588: select bbt.bank_branch_id ,bbt.remit_account_id
1589: from ap_bank_branches bbt
1590: where bbt.bank_branch_id in
1591: (select distinct bb.bank_branch_id
1592: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp
1593: where rma.receipt_method_id = nvl(p_receipt_method_id, rma.receipt_method_id )
1594: and rma.bank_account_id = ba.bank_account_id
1595: and ( ba.currency_code = p_currency_code
1596: or ba.receipt_multi_currency_flag = 'Y' )

Line 1606: from ar_receipt_method_accounts rma2, ap_bank_accounts ba2, ap_bank_branches bb2

1602: and ( bb.bank_branch_id = ba.bank_branch_id
1603: or ( bb.institution_type = 'CLEARING HOUSE'
1604: and exists
1605: ( select 1
1606: from ar_receipt_method_accounts rma2, ap_bank_accounts ba2, ap_bank_branches bb2
1607: where rma2.receipt_method_id = nvl(p_receipt_method_id, rma2.receipt_method_id)
1608: and rma2.bank_account_id = ba2.bank_account_id
1609: and ba2.set_of_books_id = asp.set_of_books_id
1610: and ba2.currency_code = p_currency_code

Line 1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

Line 1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;

1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

Line 1965: ar_receipt_method_accounts rma,

1961: cr.payment_trxn_extension_id
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

Line 2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

Line 2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;

2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

Line 3495: ar_receipt_method_accounts rma1,

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
3497: WHERE crh1.status = ''CONFIRMED''
3498: AND crh1.current_record_flag = ''Y'' ';
3499:

Line 3496: ar_receipt_method_accounts rma2

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
3497: WHERE crh1.status = ''CONFIRMED''
3498: AND crh1.current_record_flag = ''Y'' ';
3499:
3500: if(pg_execution_from = 'PARALLEL') then

Line 5700: ar_receipt_method_accounts rma,

5696:
5697: select nvl(decode(ab.remit_method_code,'FACTORING',appfactor.program_name,appremit.program_name),'ARXAPFRM')
5698: into l_prog_name
5699: from ar_batches ab,
5700: ar_receipt_method_accounts rma,
5701: ap_payment_programs appremit,
5702: ap_payment_programs appfactor
5703: where ab.type = 'REMITTANCE'
5704: and ab.batch_id = p_batch_id