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_CLASSES

Line 101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;

97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
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;

Line 102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
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;

Line 990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;

986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
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;

Line 991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
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;

Line 1333: ar_receipt_classes rc,

1329: MOD(CEIL((DENSE_RANK() over(order by crh.cash_receipt_id))/5000), :b_total_workers) + 1
1330: FROM ar_rem_cr_id_gtt gtt,
1331: ar_cash_receipts cr,
1332: ar_receipt_methods rm,
1333: ar_receipt_classes rc,
1334: hz_cust_accounts hca,
1335: hz_parties party,
1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,

Line 1508: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,

1504: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1506: p_currency_code IN ar_batches.currency_code%TYPE,
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

Line 3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,

3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3378: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
3379: p_return_status OUT NOCOPY VARCHAR2
3380: ) IS
3381:

Line 3493: ar_receipt_classes rclass,

3489:
3490: l_sel_stmt := l_sel_stmt || ' ar_cash_receipt_history crh1,
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''

Line 3929: ar_receipt_classes rc,

3925: cr.receipt_date,
3926: pr.home_country
3927: FROM ar_cash_receipts cr,
3928: ar_receipt_methods rm,
3929: ar_receipt_classes rc,
3930: hz_cust_accounts hca,
3931: hz_parties party,
3932: ar_remit_gt g,
3933: /* Need to pass country code for SEPA specific receipts */