APPS.HZ_IMP_DQM_STAGE dependencies on HZ_IMP_CONTACTPTS_SG

Line 278: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b

274: and a.batch_id = c.batch_id
275: and b.action_flag = 'I' );
276: log( ' Update contact_points as same match rule being used');
277: update HZ_SRCH_CPTS c set party_id = ( select b.party_id
278: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b
279: where a.rowid = b.int_row_id
280: and c.int_row_id = a.rowid
281: and a.batch_id = p_batch_id
282: and a.batch_id = c.batch_id

Line 285: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b

281: and a.batch_id = p_batch_id
282: and a.batch_id = c.batch_id
283: and b.action_flag = 'I' ),
284: party_site_id = ( select b.party_site_id
285: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b
286: where a.rowid = b.int_row_id
287: and c.int_row_id = a.rowid
288: and a.batch_id = p_batch_id
289: and a.batch_id = c.batch_id

Line 292: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b

288: and a.batch_id = p_batch_id
289: and a.batch_id = c.batch_id
290: and b.action_flag = 'I' ),
291: contact_point_id = ( select b.contact_point_id
292: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b
293: where a.rowid = b.int_row_id
294: and c.int_row_id = a.rowid
295: and a.batch_id = p_batch_id
296: and a.batch_id = c.batch_id

Line 536: from HZ_IMP_CONTACTPTS_SG b

532: ELSIF (p_et_name = 'CP') THEN
533: delete from HZ_SRCH_CPTS a
534: where a.party_os || a.party_osr in (
535: select a.party_os || a.party_osr
536: from HZ_IMP_CONTACTPTS_SG b
537: where a.party_os = b.party_orig_system
538: and a.party_osr = b.party_orig_system_reference
539: and b.action_flag = 'U'
540: and a.batch_id = p_batch_id);

Line 3187: l(' from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b --');

3183: /* select a.email_address, a.party_orig_system_reference,
3184: a.party_orig_system, a.cp_orig_system, a.cp_orig_system_reference,
3185: a.site_orig_system, a.site_orig_system_reference, b.party_site_id,
3186: b.contact_point_id, b.party_id */
3187: l(' from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b --');
3188: l(' where a.batch_id = p_batch_id ');
3189: l(' and b.action_flag = ''I'' ');
3190: l(' and b.int_row_id = a.rowid ');
3191: l(' and b.party_orig_system_reference >= p_from_osr ');