DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_IMP_INT_DEDUP_RESULTS

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

1465: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1466: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1467: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1468: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1469: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1470: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1471: dup_creation_date,dup_last_update_date
1472: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1473: select /*+ USE_CONCAT */ p_batch_id, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,

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

1516: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1517: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1518: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1519: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1520: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1521: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1522: dup_creation_date,dup_last_update_date
1523: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1524: select /*+ USE_CONCAT */ p_batch_id, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,

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

1561: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1562: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1563: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACTS');
1564: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1565: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1566: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1567: dup_creation_date,dup_last_update_date
1568: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1569: select /*+ USE_CONCAT */ p_batch_id, s1.CONTACT_OSR, s1.CONTACT_OS,