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 536: hz_parties party

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

Line 551: hz_parties party

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

Line 1753: p_customer_name IN hz_parties.party_name%TYPE,

1749: /* modified for tca uptake */
1750: PROCEDURE Default_cash_ids(
1751: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
1752: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1753: p_customer_name IN hz_parties.party_name%TYPE,
1754: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1755: p_location IN hz_cust_site_uses.location%type,
1756: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1757: /* 6612301 */

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

7898: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
7899: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
7900: ,p_currency_code IN fnd_currencies.currency_code%TYPE
7901: ,p_amount IN NUMBER
7902: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
7903: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
7904: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2

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

7900: ,p_currency_code IN fnd_currencies.currency_code%TYPE
7901: ,p_amount IN NUMBER
7902: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
7903: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
7904: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
7908: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE

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

7901: ,p_amount IN NUMBER
7902: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
7903: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
7904: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
7908: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
7909: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE

Line 7931: l_party_id hz_parties.party_id%TYPE;

7927: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7928: l_org_id ar_cash_receipts.org_id%TYPE;
7929: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
7930: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
7931: l_party_id hz_parties.party_id%TYPE;
7932: l_party_site_id hz_parties.party_id%TYPE;
7933: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
7934: BEGIN
7935: IF PG_DEBUG in ('Y', 'C') THEN

Line 7932: l_party_site_id hz_parties.party_id%TYPE;

7928: l_org_id ar_cash_receipts.org_id%TYPE;
7929: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
7930: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
7931: l_party_id hz_parties.party_id%TYPE;
7932: l_party_site_id hz_parties.party_id%TYPE;
7933: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
7934: BEGIN
7935: IF PG_DEBUG in ('Y', 'C') THEN
7936: arp_util.debug('ar_receipt_lib_pvt.default_refund_attributes(+)');

Line 7987: ,hz_parties p

7983: INTO p_party_id
7984: ,x_party_name
7985: ,x_party_number
7986: FROM hz_cust_accounts ca
7987: ,hz_parties p
7988: WHERE p.party_id = ca.party_id
7989: AND ca.cust_account_id = l_cust_acct_id;
7990: EXCEPTION
7991: WHEN OTHERS THEN