APPS.ARP_REVERSE_RECEIPT dependencies on HZ_CUST_ACCT_SITES

Line 1662: hz_cust_acct_sites add1

1658: l_site_use_id ar_cash_receipts.customer_site_use_id%TYPE ) IS
1659: SELECT su1.site_use_id site_use_id,
1660: su1.cust_acct_site_id address_id
1661: FROM hz_cust_site_uses su1,
1662: hz_cust_acct_sites add1
1663: WHERE add1.cust_account_id = l_customer_id
1664: AND add1.cust_acct_site_id = su1.cust_acct_site_id
1665: /* 02-JUN-2000 J Rautiainen BR Implementation
1666: * The site can also be DRAWEE */

Line 1676: hz_cust_acct_sites add2

1672: SELECT DECODE( su2.site_use_id,
1673: NULL, NULL, add2.cust_account_id ) ship_to_customer_id,
1674: su2.site_use_id ship_to_site_use_id
1675: FROM hz_cust_site_uses su2,
1676: hz_cust_acct_sites add2
1677: WHERE add2.cust_account_id = l_customer_id
1678: AND add2.cust_acct_site_id = su2.cust_acct_site_id
1679: AND su2.site_use_code = 'SHIP_TO'
1680: ORDER BY su2.primary_flag desc;