eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_LOOKUP_PUB dependencies on HZ_PARTIES

Line 156: WHERE phon.owner_table_name(+) = 'HZ_PARTIES'

152: SELECT phon.phone_area_code area_code
153: , 1 order_by_col
154: FROM
155: HZ_CONTACT_POINTS phon, AR_LOOKUPS look
156: WHERE phon.owner_table_name(+) = 'HZ_PARTIES'
157: and phon.primary_flag(+) = 'Y'
158: and phon.status(+) <> 'I'
159: and phon.phone_line_type = look.lookup_code(+)
160: and look.lookup_type(+) = 'PHONE_LINE_TYPE'

Line 201: -- pre-reqs : depends on hz_parties table

197: -- ***************************************************
198: -- api name : Get_Organizations
199: -- type : public.
200: -- function : Get the Organization Contact info
201: -- pre-reqs : depends on hz_parties table
202: -- parameters :
203: -- end of comments
204:
205: procedure Get_Org_Contacts

Line 276: HZ_PARTIES party,

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

Line 302: HZ_PARTIES party

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'
306: and party.party_type = 'ORGANIZATION'