DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_IMP_INT_DEDUP_RESULTS

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

1502: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1503: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1504: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1505: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1506: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1507: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1508: dup_creation_date,dup_last_update_date
1509: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1510: select /*+ USE_CONCAT */ p_batch_id, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,

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

1556: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1557: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1558: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1559: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1560: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1561: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1562: dup_creation_date,dup_last_update_date
1563: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1564: select /*+ USE_CONCAT */ p_batch_id, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,

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

1607: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1608: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1609: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACTS');
1610: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1611: insert into hz_imp_int_dedup_results(batch_id, winner_record_osr, winner_record_os,
1612: dup_record_osr, dup_record_os, detail_party_osr, detail_party_os, entity, score,
1613: dup_creation_date,dup_last_update_date
1614: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1615: select /*+ USE_CONCAT */ p_batch_id, s1.CONTACT_OSR, s1.CONTACT_OS,