APPS.JTF_TERR_LOOKUP_PUB dependencies on HZ_PARTY_SITES

Line 144: WHERE phon.owner_table_name(+) = 'HZ_PARTY_SITES'

140: SELECT phon.phone_area_code area_code
141: , 0 order_by_col
142: FROM
143: HZ_CONTACT_POINTS phon, AR_LOOKUPS look
144: WHERE phon.owner_table_name(+) = 'HZ_PARTY_SITES'
145: and phon.primary_flag(+) = 'Y'
146: and phon.status(+) <> 'I'
147: and phon.phone_line_type = look.lookup_code(+)
148: and look.lookup_type(+) = 'PHONE_LINE_TYPE'

Line 274: from HZ_PARTY_SITES site,

270: '' property3,
271: '' property4,
272: '' property5
273:
274: from HZ_PARTY_SITES site,
275: HZ_LOCATIONS loc,
276: HZ_PARTIES party,
277: AR_LOOKUPS arlu
278: WHERE site.location_id = loc.location_id(+)

Line 300: from HZ_PARTY_SITES site,

296:
297: BEGIN
298:
299: SELECT count(*) into l_total_rows
300: from HZ_PARTY_SITES site,
301: HZ_LOCATIONS loc,
302: HZ_PARTIES party
303: WHERE site.location_id = loc.location_id(+)
304: and party.party_id = site.party_id(+)