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_CONTACT_POINTS

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