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.CS_PARTYMERGE_PKG dependencies on HZ_MERGE_PARTY_LOG

Line 169: hz_merge_party_log pc,

165: pce.from_entity_id from_email_id,
166: pce.to_entity_id to_email_id ,
167: i.last_update_program_code
168: FROM cs_incidents_all_B i,
169: hz_merge_party_log pc,
170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,

Line 170: hz_merge_party_log pbp,

166: pce.to_entity_id to_email_id ,
167: i.last_update_program_code
168: FROM cs_incidents_all_B i,
169: hz_merge_party_log pc,
170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,

Line 171: hz_merge_party_log psp,

167: i.last_update_program_code
168: FROM cs_incidents_all_B i,
169: hz_merge_party_log pc,
170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,

Line 172: hz_merge_party_log pbc,

168: FROM cs_incidents_all_B i,
169: hz_merge_party_log pc,
170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,

Line 173: hz_merge_party_log psc,

169: hz_merge_party_log pc,
170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,

Line 174: hz_merge_party_log pbs,

170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,

Line 175: hz_merge_party_log pss,

171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,

Line 176: hz_merge_party_log ps,

172: hz_merge_party_log pbc,
173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,

Line 177: hz_merge_party_log pcs,

173: hz_merge_party_log psc,
174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,

Line 178: hz_merge_party_log pis,

174: hz_merge_party_log pbs,
175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,

Line 179: hz_merge_party_log pisu,

175: hz_merge_party_log pss,
176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,
183: hz_merge_party_log pch,

Line 180: hz_merge_party_log pils,

176: hz_merge_party_log ps,
177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,
183: hz_merge_party_log pch,
184: hz_merge_party_log pce

Line 181: hz_merge_party_log psu,

177: hz_merge_party_log pcs,
178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,
183: hz_merge_party_log pch,
184: hz_merge_party_log pce
185: WHERE pc.request_id(+) = p_request_id

Line 182: hz_merge_party_log pbu,

178: hz_merge_party_log pis,
179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,
183: hz_merge_party_log pch,
184: hz_merge_party_log pce
185: WHERE pc.request_id(+) = p_request_id
186: AND pc.merge_dict_id(+) = 1 -- Entity = HZ Party

Line 183: hz_merge_party_log pch,

179: hz_merge_party_log pisu,
180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,
183: hz_merge_party_log pch,
184: hz_merge_party_log pce
185: WHERE pc.request_id(+) = p_request_id
186: AND pc.merge_dict_id(+) = 1 -- Entity = HZ Party
187: AND pc.from_entity_id(+) = i.customer_id

Line 184: hz_merge_party_log pce

180: hz_merge_party_log pils,
181: hz_merge_party_log psu,
182: hz_merge_party_log pbu,
183: hz_merge_party_log pch,
184: hz_merge_party_log pce
185: WHERE pc.request_id(+) = p_request_id
186: AND pc.merge_dict_id(+) = 1 -- Entity = HZ Party
187: AND pc.from_entity_id(+) = i.customer_id
188: AND pc.operation_type(+) = 'Merge'

Line 292: hz_merge_party_log pbp,

288: c.ship_to_org_id,
289: pss.from_entity_id from_ship_to_site_id,
290: pss.to_entity_id to_ship_to_site_id
291: FROM cs_estimate_details c,
292: hz_merge_party_log pbp,
293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,
296: hz_merge_party_log pbs,

Line 293: hz_merge_party_log psp,

289: pss.from_entity_id from_ship_to_site_id,
290: pss.to_entity_id to_ship_to_site_id
291: FROM cs_estimate_details c,
292: hz_merge_party_log pbp,
293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,
296: hz_merge_party_log pbs,
297: hz_merge_party_log pss

Line 294: hz_merge_party_log pbc,

290: pss.to_entity_id to_ship_to_site_id
291: FROM cs_estimate_details c,
292: hz_merge_party_log pbp,
293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,
296: hz_merge_party_log pbs,
297: hz_merge_party_log pss
298: WHERE pbp.merge_dict_id(+) = 1 -- Entity = HZ Party

Line 295: hz_merge_party_log psc,

291: FROM cs_estimate_details c,
292: hz_merge_party_log pbp,
293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,
296: hz_merge_party_log pbs,
297: hz_merge_party_log pss
298: WHERE pbp.merge_dict_id(+) = 1 -- Entity = HZ Party
299: AND pbp.request_id(+) = p_request_id

Line 296: hz_merge_party_log pbs,

292: hz_merge_party_log pbp,
293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,
296: hz_merge_party_log pbs,
297: hz_merge_party_log pss
298: WHERE pbp.merge_dict_id(+) = 1 -- Entity = HZ Party
299: AND pbp.request_id(+) = p_request_id
300: AND pbp.from_entity_id(+) = c.bill_to_party_id

Line 297: hz_merge_party_log pss

293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,
296: hz_merge_party_log pbs,
297: hz_merge_party_log pss
298: WHERE pbp.merge_dict_id(+) = 1 -- Entity = HZ Party
299: AND pbp.request_id(+) = p_request_id
300: AND pbp.from_entity_id(+) = c.bill_to_party_id
301: AND pbp.operation_type(+) = 'Merge'

Line 346: FROM hz_merge_party_log p,

342: SELECT p.from_entity_id ,
343: p.to_entity_id ,
344: p.batch_party_id,
345: cc.sr_contact_point_id
346: FROM hz_merge_party_log p,
347: cs_hz_sr_contact_points cc
348: WHERE p.merge_dict_id = 4
349: AND p.operation_type = 'Merge'
350: AND p.request_id = p_request_id