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 AR_LOOKUPS

Line 143: HZ_CONTACT_POINTS phon, AR_LOOKUPS look

139: FROM (
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(+)

Line 155: HZ_CONTACT_POINTS phon, AR_LOOKUPS look

151: UNION
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(+)

Line 277: AR_LOOKUPS arlu

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