DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_IMP_INT_DEDUP_RESULTS

Line 1126: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,

1122: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1123: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1124: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1125: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1126: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1127: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1128: dup_creation_date,dup_last_update_date
1129: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1130: select /*+ USE_CONCAT */ p_batch_id, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,

Line 1171: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,

1167: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1168: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1169: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1170: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1171: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1172: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1173: dup_creation_date,dup_last_update_date
1174: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1175: select /*+ USE_CONCAT */ p_batch_id, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,