APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_INT_DUP_RESULTS_GT

Line 384: insert into hz_int_dup_results_gt (batch_id, f_osr, f_os, t_osr, t_os, ord_f_osr, ord_t_osr, score)

380: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
381:
382:
383: -- Bug fix for 3639346 :::: Need to take scores that are >= threshold
384: insert into hz_int_dup_results_gt (batch_id, f_osr, f_os, t_osr, t_os, ord_f_osr, ord_t_osr, score)
385: select a.batch_id, a.f_osr, a.f_os, a.t_osr, a.t_os, a.ord_f_osr, a.ord_t_osr, a.score
386: from hz_int_dup_results a
387: where
388: (a.score >= p_threshold and a.batch_id = p_batch_id)

Line 411: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of parties inserted to HZ_INT_DUP_RESULTS_GT '||SQL%ROWCOUNT);

407: )
408: );
409:
410: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
411: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of parties inserted to HZ_INT_DUP_RESULTS_GT '||SQL%ROWCOUNT);
412: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
413:
414:
415: EXCEPTION

Line 1808: -- THESE ARE ALL PRECISELY THE ORD_F_OSRs IN HZ_INT_DUP_RESULTS_GT WHICH ARE NOT

1804: )
1805: IS
1806: BEGIN
1807: -- FIRST, REPORT WINNER OSRS TO INTERFACE DEDUP RESULTS
1808: -- THESE ARE ALL PRECISELY THE ORD_F_OSRs IN HZ_INT_DUP_RESULTS_GT WHICH ARE NOT
1809: -- ORD_T_OSRs OF ANY ROW AND OCCUR AT ODD LEVELS IN THE CONNECT BY.
1810:
1811: ----------------------------------------------------
1812: --- EXAMPLE :

Line 1858: -- we use the temporary table hz_int_dup_results_gt, instead of

1854: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1855:
1856:
1857:
1858: -- we use the temporary table hz_int_dup_results_gt, instead of
1859: -- hz_int_dup_results
1860: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1861: dup_record_osr, dup_record_os, entity,
1862: score, dup_creation_date, dup_last_update_date

Line 1873: from hz_int_dup_results_gt d

1869: ,hz_utility_v2pub.last_updated_by
1870: from
1871: (
1872: select distinct d.ord_f_osr as win_party_osr, d.f_os as win_party_os, level as levelu
1873: from hz_int_dup_results_gt d
1874: start with d.ord_f_osr not in
1875: (
1876: select c.ord_t_osr
1877: from hz_int_dup_results_gt c

Line 1877: from hz_int_dup_results_gt c

1873: from hz_int_dup_results_gt d
1874: start with d.ord_f_osr not in
1875: (
1876: select c.ord_t_osr
1877: from hz_int_dup_results_gt c
1878: where c.batch_id = p_batch_id
1879: )
1880: and d.batch_id = p_batch_id
1881: connect by prior ord_t_osr = ord_f_osr and prior batch_id = batch_id

Line 1894: -- hz_int_dup_results_gt and insert the winner, dup pair to hz_imp_int_dedup_results

1890: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1891:
1892:
1893: -- Take inserted winner party osrs from hz_imp_int_dedup_results , join with
1894: -- hz_int_dup_results_gt and insert the winner, dup pair to hz_imp_int_dedup_results
1895: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1896: dup_record_osr, dup_record_os, entity,
1897: score, dup_creation_date, dup_last_update_date
1898: ,created_by,creation_date,last_update_login

Line 1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b

1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1904: ,hz_utility_v2pub.last_updated_by
1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b
1906: where a.batch_id = p_batch_id and b.batch_id = p_batch_id and a.entity = 'PARTY'
1907: and b.ord_f_osr = a.winner_record_osr ;
1908:
1909: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of duplicate parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);