APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_LOCATIONS

Line 245: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,

241: /* Bug Fix: 4006266 */
242: FOR sites in (
243: SELECT cust_account_id, ac.cust_acct_site_id, ps.party_site_id, loc.address1||' '||loc.address2||' '||loc.address3||' '||loc.address4||' '|| loc.city||' '||loc.state||' '||
244: loc.province||' '||loc.postal_code || ' ' cust_address
245: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
246: APPS.HZ_CUST_ACCT_SITES_ALL ac
247: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
248: AND loc.LOCATION_ID = ps.LOCATION_ID
249: AND ac.ROWID = rid)

Line 368: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,

364: /* Bug Fix: 4006266 */
365: FOR sites in (
366: SELECT ac.status, cust_account_id, ac.cust_acct_site_id, ps.party_site_id, loc.address1||' '||loc.address2||' '||loc.address3 ||' '||loc.address4||' '|| loc.city||' '||loc.state||' '||
367: loc.province||' '||loc.postal_code || ' ' cust_address
368: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
369: APPS.HZ_CUST_ACCT_SITES_ALL ac
370: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
371: AND loc.LOCATION_ID = ps.LOCATION_ID
372: AND ac.ROWID = rid)