DBA Data[Home] [Help]

APPS.JTF_TERR_LOOKUP_PUB dependencies on HZ_LOCATIONS

Line 275: HZ_LOCATIONS loc,

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(+)
279: and party.party_id = site.party_id(+)

Line 301: HZ_LOCATIONS loc,

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(+)
305: AND site.status = 'A'