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 HZ_PARTIES

Line 1335: hz_parties party,

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,
1338: ar_batches bat,
1339: ar_receipt_method_accounts rma,

Line 3360: p_customer_name_l IN hz_parties.party_name%type,

3356:
3357: PROCEDURE select_update_rec(
3358: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

Line 3361: p_customer_name_h IN hz_parties.party_name%type,

3357: PROCEDURE select_update_rec(
3358: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

Line 3585: from hz_cust_accounts rc, HZ_PARTIES party

3581: IF p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
3582:
3583: l_sel_stmt := l_sel_stmt || '
3584: AND EXISTS ( select ''x''
3585: from hz_cust_accounts rc, HZ_PARTIES party
3586: where rc.cust_account_id = cr.pay_from_customer
3587: and rc.party_id = party.party_id ' ;
3588:
3589: IF p_customer_name_l IS NOT NULL THEN

Line 3931: hz_parties party,

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 */
3934: ce_bank_acct_uses bau,
3935: ce_bank_accounts cba,

Line 3936: hz_parties bank,

3932: ar_remit_gt g,
3933: /* Need to pass country code for SEPA specific receipts */
3934: ce_bank_acct_uses bau,
3935: ce_bank_accounts cba,
3936: hz_parties bank,
3937: hz_organization_profiles pr
3938: WHERE cr.selected_remittance_batch_id = p_batch_id
3939: AND g.cash_receipt_id = cr.cash_receipt_id
3940: AND hca.party_id = party.party_id

Line 4686: hz_parties bank,

4682: /* Need to pass country code for SEPA specific receipts */
4683: ar_cash_receipts_all cr,
4684: ce_bank_acct_uses bau,
4685: ce_bank_accounts cba,
4686: hz_parties bank,
4687: hz_organization_profiles pr
4688: WHERE a.batch_id = p_batch_id
4689: AND a.current_worker = WORKER_NUMBER
4690: AND a.cash_receipt_id = cr.cash_receipt_id