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 548: l_customer_name hz_parties.party_name%TYPE;

544: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
546: l_cc_trx_amount NUMBER;
547: l_cc_trx_date DATE;
548: l_customer_name hz_parties.party_name%TYPE;
549: l_customer_number hz_cust_accounts.account_number%TYPE;
550: l_customer_location hz_cust_site_uses.location%TYPE;
551: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
552: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;

Line 596: hz_parties party,

592: l_collector,
593: l_payment_method_name
594: FROM ra_customer_trx trx,
595: ar_receipt_methods rm,
596: hz_parties party,
597: hz_cust_accounts cust,
598: hz_cust_site_uses site_uses,
599: iby_trxn_extensions_v iby
600: WHERE trx.receipt_method_id = rm.receipt_method_id

Line 632: hz_parties RACO_BILL_PARTY,

628: INTO l_billto_contact,
629: l_salesrep_name
630: FROM ra_customer_trx CT,
631: hz_cust_account_roles RACO_BILL,
632: hz_parties RACO_BILL_PARTY,
633: hz_relationships RACO_BILL_REL,
634: ra_salesreps RA_SALES
635: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
636: and raco_bill.party_id = raco_bill_rel.party_id(+)

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

633: hz_relationships RACO_BILL_REL,
634: ra_salesreps RA_SALES
635: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
636: and raco_bill.party_id = raco_bill_rel.party_id(+)
637: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'
638: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'
639: and raco_bill_rel.directional_flag(+) = 'F'
640: and raco_bill.role_type(+) = 'CONTACT'
641: and raco_bill_rel.subject_id = raco_bill_party.party_id(+)

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

634: ra_salesreps RA_SALES
635: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
636: and raco_bill.party_id = raco_bill_rel.party_id(+)
637: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'
638: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'
639: and raco_bill_rel.directional_flag(+) = 'F'
640: and raco_bill.role_type(+) = 'CONTACT'
641: and raco_bill_rel.subject_id = raco_bill_party.party_id(+)
642: and raco_bill_rel.status(+) = 'A'

Line 2132: l_customer_name hz_parties.party_name%TYPE;

2128: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;
2129: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2130: l_cc_trx_amount NUMBER;
2131: l_cc_trx_date DATE;
2132: l_customer_name hz_parties.party_name%TYPE;
2133: l_customer_number hz_cust_accounts.account_number%TYPE;
2134: l_customer_location hz_cust_site_uses.location%TYPE;
2135: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2136: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;

Line 2242: hz_parties party,

2238: l_collector,
2239: l_payment_method_name
2240: FROM ar_cash_receipts cr,
2241: ar_receipt_methods rm,
2242: hz_parties party,
2243: hz_cust_accounts cust,
2244: hz_cust_site_uses site_uses,
2245: iby_trxn_extensions_v iby
2246: WHERE rm.receipt_method_id = cr.receipt_method_id