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.ARP_CORRECT_CC_ERRORS dependencies on HZ_PARTIES

Line 558: l_customer_name hz_parties.party_name%TYPE;

554: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
556: l_cc_trx_amount NUMBER;
557: l_cc_trx_date DATE;
558: l_customer_name hz_parties.party_name%TYPE;
559: l_customer_number hz_cust_accounts.account_number%TYPE;
560: l_customer_location hz_cust_site_uses.location%TYPE;
561: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
562: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%TYPE;

Line 603: hz_parties party,

599: l_collector,
600: l_payment_method_name
601: FROM ra_customer_trx trx,
602: ar_receipt_methods rm,
603: hz_parties party,
604: hz_cust_accounts cust,
605: hz_cust_site_uses site_uses,
606: iby_trxn_extensions_v iby,
607: iby_fndcpt_pmt_chnnls_b pc

Line 641: hz_parties RACO_BILL_PARTY,

637: INTO l_billto_contact,
638: l_salesrep_name
639: FROM ra_customer_trx CT,
640: hz_cust_account_roles RACO_BILL,
641: hz_parties RACO_BILL_PARTY,
642: hz_relationships RACO_BILL_REL,
643: ra_salesreps RA_SALES
644: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
645: and raco_bill.party_id = raco_bill_rel.party_id(+)

Line 646: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'

642: hz_relationships RACO_BILL_REL,
643: ra_salesreps RA_SALES
644: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
645: and raco_bill.party_id = raco_bill_rel.party_id(+)
646: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'
647: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'
648: and raco_bill_rel.directional_flag(+) = 'F'
649: and raco_bill.role_type(+) = 'CONTACT'
650: and raco_bill_rel.subject_id = raco_bill_party.party_id(+)

Line 647: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'

643: ra_salesreps RA_SALES
644: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
645: and raco_bill.party_id = raco_bill_rel.party_id(+)
646: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'
647: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'
648: and raco_bill_rel.directional_flag(+) = 'F'
649: and raco_bill.role_type(+) = 'CONTACT'
650: and raco_bill_rel.subject_id = raco_bill_party.party_id(+)
651: and raco_bill_rel.status(+) = 'A'

Line 2270: l_customer_name hz_parties.party_name%TYPE;

2266: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;
2267: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2268: l_cc_trx_amount NUMBER;
2269: l_cc_trx_date DATE;
2270: l_customer_name hz_parties.party_name%TYPE;
2271: l_customer_number hz_cust_accounts.account_number%TYPE;
2272: l_customer_location hz_cust_site_uses.location%TYPE;
2273: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2274: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

Line 2378: hz_parties party,

2374: l_collector,
2375: l_payment_method_name
2376: FROM ar_cash_receipts cr,
2377: ar_receipt_methods rm,
2378: hz_parties party,
2379: hz_cust_accounts cust,
2380: hz_cust_site_uses site_uses,
2381: iby_trxn_extensions_v iby
2382: WHERE rm.receipt_method_id = cr.receipt_method_id