APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_PARTY_SITES

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 341: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

337:
338: FOR cp1 IN (
339: SELECT PHONE_NUMBER||phone_area_code||phone_country_code|| ' ' phone
340: FROM APPS.hz_contact_points
341: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
342: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')
343: AND OWNER_TABLE_ID = sites.party_site_id)
344: LOOP
345: write_to_lob(site_lob,cp1.phone,stvar);

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

359: /* Bug Fix: 4006266 */
360: FOR sites in (
361: 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||' '||
362: loc.province||' '||loc.postal_code || ' ' cust_address
363: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
364: APPS.HZ_CUST_ACCT_SITES_ALL ac
365: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
366: AND loc.LOCATION_ID = ps.LOCATION_ID
367: AND ac.ROWID = rid)

Line 432: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

428:
429: FOR cp1 IN (
430: SELECT PHONE_NUMBER||phone_area_code||phone_country_code|| ' ' phone
431: FROM APPS.hz_contact_points
432: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
433: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')
434: AND OWNER_TABLE_ID = sites.party_site_id)
435: LOOP
436: write_to_char(cp1.phone,site_char);