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 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)

Line 437: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

433:
434: FOR cp1 IN (
435: SELECT PHONE_NUMBER||phone_area_code||phone_country_code|| ' ' phone
436: FROM APPS.hz_contact_points
437: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
438: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')
439: AND OWNER_TABLE_ID = sites.party_site_id)
440: LOOP
441: write_to_char(cp1.phone,site_char);