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 AP_BANK_ACCOUNTS

Line 100: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;

96: l_currency_code ar_cash_receipts.currency_code%TYPE;
97: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
98: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
99: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
100: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
101: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
102: o_batch_id NUMBER;
103:
104: p_create_only VARCHAR2(1);

Line 944: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;

940: l_currency_code ar_cash_receipts.currency_code%TYPE;
941: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
942: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
943: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
944: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
945: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
946: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
947: l_return_status VARCHAR2(1);
948: o_batch_id NUMBER;

Line 1447: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,

1443: p_currency_code IN ar_batches.currency_code%TYPE,
1444: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1445: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1446: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1447: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1448: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1449: p_batch_id OUT NOCOPY NUMBER
1450: ) IS
1451: l_batch_rec ar_batches%ROWTYPE;

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

1524: select bbt.bank_branch_id ,bbt.remit_account_id
1525: from ap_bank_branches bbt
1526: where bbt.bank_branch_id in
1527: (select distinct bb.bank_branch_id
1528: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp
1529: where rma.receipt_method_id = nvl(p_receipt_method_id, rma.receipt_method_id )
1530: and rma.bank_account_id = ba.bank_account_id
1531: and ( ba.currency_code = p_currency_code
1532: or ba.receipt_multi_currency_flag = 'Y' )

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

1538: and ( bb.bank_branch_id = ba.bank_branch_id
1539: or ( bb.institution_type = 'CLEARING HOUSE'
1540: and exists
1541: ( select 1
1542: from ar_receipt_method_accounts rma2, ap_bank_accounts ba2, ap_bank_branches bb2
1543: where rma2.receipt_method_id = nvl(p_receipt_method_id, rma2.receipt_method_id)
1544: and rma2.bank_account_id = ba2.bank_account_id
1545: and ba2.set_of_books_id = asp.set_of_books_id
1546: and ba2.currency_code = p_currency_code