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_RECEIPT_LIB_PVT dependencies on HZ_PARTIES

Line 537: hz_parties party

533: SELECT c.cust_account_id
534: INTO l_selected_id
535: FROM hz_cust_accounts c,
536: hz_customer_profiles cp,
537: hz_parties party
538: WHERE c.cust_account_id = cp.cust_account_id (+) and
539: cp.site_use_id is null and
540: c.account_number = p_value
541: AND c.party_id = party.party_id;

Line 552: hz_parties party

548: SELECT cust_acct.cust_account_id
549: INTO l_selected_id
550: FROM hz_cust_accounts cust_acct,
551: hz_customer_profiles cp,
552: hz_parties party
553: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
554: and cust_acct.party_id = party.party_id(+)
555: and cp.site_use_id is null
556: and party.party_name = p_value;

Line 1760: p_customer_name IN hz_parties.party_name%TYPE,

1756: /* modified for tca uptake */
1757: PROCEDURE Default_cash_ids(
1758: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
1759: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1760: p_customer_name IN hz_parties.party_name%TYPE,
1761: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1762: p_location IN hz_cust_site_uses.location%type,
1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */

Line 8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE

8197: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
8198: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8199: ,p_currency_code IN fnd_currencies.currency_code%TYPE
8200: ,p_amount IN NUMBER
8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2

Line 8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE

8199: ,p_currency_code IN fnd_currencies.currency_code%TYPE
8200: ,p_amount IN NUMBER
8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE

Line 8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE

8200: ,p_amount IN NUMBER
8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE

Line 8230: l_party_id hz_parties.party_id%TYPE;

8226: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
8227: l_org_id ar_cash_receipts.org_id%TYPE;
8228: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
8230: l_party_id hz_parties.party_id%TYPE;
8231: l_party_site_id hz_parties.party_id%TYPE;
8232: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
8233: BEGIN
8234: IF PG_DEBUG in ('Y', 'C') THEN

Line 8231: l_party_site_id hz_parties.party_id%TYPE;

8227: l_org_id ar_cash_receipts.org_id%TYPE;
8228: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
8230: l_party_id hz_parties.party_id%TYPE;
8231: l_party_site_id hz_parties.party_id%TYPE;
8232: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
8233: BEGIN
8234: IF PG_DEBUG in ('Y', 'C') THEN
8235: arp_util.debug('ar_receipt_lib_pvt.default_refund_attributes(+)');

Line 8286: ,hz_parties p

8282: INTO p_party_id
8283: ,x_party_name
8284: ,x_party_number
8285: FROM hz_cust_accounts ca
8286: ,hz_parties p
8287: WHERE p.party_id = ca.party_id
8288: AND ca.cust_account_id = l_cust_acct_id;
8289: EXCEPTION
8290: WHEN OTHERS THEN