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.CSF_RESOURCE_PUB dependencies on HZ_PARTIES

Line 164: , hz_parties pa

160: FROM jtf_tasks_b tb
161: , cs_incidents_all_b ib
162: , cs_incidents_all_tl it
163: , hz_locations lo
164: , hz_parties pa
165: WHERE tb.task_id = p_task_id
166: AND tb.source_object_type_code = 'SR'
167: AND tb.source_object_id = ib.incident_id
168: AND tb.source_object_id = it.incident_id

Line 178: AND owner_table_name = 'HZ_PARTIES'

174: CURSOR c_contact_point(b_party_id NUMBER) IS
175: SELECT phone_area_code
176: FROM hz_contact_points
177: WHERE owner_table_id = b_party_id
178: AND owner_table_name = 'HZ_PARTIES'
179: AND contact_point_type = 'PHONE'
180: AND primary_flag = 'Y';
181:
182: -- Service Item ID and Organization ID

Line 193: WHERE owner_table_name = 'HZ_PARTIES'

189: -- Contact VIP code
190: CURSOR c_class_code(b_party_id NUMBER) IS
191: SELECT class_code
192: FROM hz_code_assignments
193: WHERE owner_table_name = 'HZ_PARTIES'
194: AND owner_table_id = b_party_id;
195: BEGIN
196: OPEN c_rec;
197: