eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_6 dependencies on HZ_STAGED_PARTIES

Line 1378: FROM hz_staged_parties

1374: hz_utility_v2pub.debug(p_message=>'Restrict SQL is NULL and other conditions met to OPEN x_cursor',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1375: END IF;
1376: OPEN x_cursor FOR
1377: SELECT PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46
1378: FROM hz_staged_parties
1379: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1380: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1381: AND( (l_search_merged ='Y' )
1382: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1389: l_sqlstr := 'SELECT PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46 FROM hz_staged_parties stage ';

1385: ELSE
1386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug(p_message=>'Restrict SQL is NOT NULL OR other conditions not met, Else Part',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1388: END IF;
1389: l_sqlstr := 'SELECT PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46 FROM hz_staged_parties stage ';
1390: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1391: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1392: IF l_search_merged = 'N' THEN
1393: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1496: FROM HZ_STAGED_PARTIES stage

1492: hz_utility_v2pub.debug(p_message=>'part contains string is null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1493: END IF;
1494: OPEN x_cursor FOR
1495: SELECT PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46
1496: FROM HZ_STAGED_PARTIES stage
1497: WHERE PARTY_ID = p_dup_party_id;
1498: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1500: hz_utility_v2pub.debug(p_message=>'Either restrict sql is null or search context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1508: FROM HZ_STAGED_PARTIES stage

1504: hz_utility_v2pub.debug(p_message=>'Search context id is null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1505: END IF;
1506: OPEN x_cursor FOR
1507: SELECT PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46
1508: FROM HZ_STAGED_PARTIES stage
1509: WHERE contains( concat_col, p_contains_str)>0
1510: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1511: AND( (l_search_merged ='Y' )
1512: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1520: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46

1516: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1517: hz_utility_v2pub.debug(p_message=>'Search context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1518: END IF;
1519: OPEN x_cursor FOR
1520: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46
1521: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1522: WHERE contains( concat_col, p_contains_str)>0
1523: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1524: AND d.party_id = stage.party_id

Line 1521: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1517: hz_utility_v2pub.debug(p_message=>'Search context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1518: END IF;
1519: OPEN x_cursor FOR
1520: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46
1521: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1522: WHERE contains( concat_col, p_contains_str)>0
1523: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1524: AND d.party_id = stage.party_id
1525: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1540: l_hint := '/+ INDEX(stage HZ_STAGED_PARTIES_U1) /';

1536: IF (l_check > 0 ) THEN
1537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1538: hz_utility_v2pub.debug(p_message=>'Restrict sql has a Selective Hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1539: END IF;
1540: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1541: END IF;
1542: IF p_search_ctx_id IS NULL THEN
1543: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46'||
1544: ' FROM HZ_STAGED_PARTIES stage'||

Line 1544: ' FROM HZ_STAGED_PARTIES stage'||

1540: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1541: END IF;
1542: IF p_search_ctx_id IS NULL THEN
1543: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46'||
1544: ' FROM HZ_STAGED_PARTIES stage'||
1545: ' WHERE contains( concat_col, :cont)>0'||
1546: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1547: ' AND ('||p_restrict_sql||')' ||
1548: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1663: SELECT 1 FROM HZ_STAGED_PARTIES p

1659: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1660: FROM HZ_STAGED_PARTY_SITES stage
1661: WHERE contains( concat_col, p_contains_str)>0
1662: AND EXISTS (
1663: SELECT 1 FROM HZ_STAGED_PARTIES p
1664: WHERE p.PARTY_ID = stage.PARTY_ID
1665: AND( (l_search_merged ='Y' )
1666: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1667: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1779: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||

1775: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1776: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1777: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1778: ' AND EXISTS ('||
1779: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1780: ' WHERE p.party_id = stage.party_id ' ||
1781: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1782: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1783: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1796: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||

1792: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1793: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1794: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1795: ' AND EXISTS ('||
1796: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1797: ' WHERE p.party_id = stage.party_id ' ||
1798: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1799: ' AND ('||p_restrict_sql||')' ||
1800: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1865: SELECT 1 FROM HZ_STAGED_PARTIES p

1861: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
1862: FROM HZ_STAGED_CONTACTS stage
1863: WHERE contains( concat_col, p_contains_str)>0
1864: AND EXISTS (
1865: SELECT 1 FROM HZ_STAGED_PARTIES p
1866: WHERE p.PARTY_ID = stage.PARTY_ID
1867: AND( (l_search_merged ='Y' )
1868: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1869: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1888: SELECT 1 FROM HZ_STAGED_PARTIES p

1884: SELECT ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
1885: FROM HZ_STAGED_CONTACTS stage
1886: WHERE contains( concat_col, p_contains_str)>0
1887: AND EXISTS (
1888: SELECT 1 FROM HZ_STAGED_PARTIES p
1889: WHERE p.PARTY_ID = stage.PARTY_ID
1890: AND( (l_search_merged ='Y' )
1891: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1892: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1941: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||

1937: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX2, TX6, TX5'||
1938: ' FROM HZ_STAGED_CONTACTS stage'||
1939: ' WHERE contains( concat_col, :cont)>0'||
1940: ' AND EXISTS ('||
1941: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1942: ' WHERE p.party_id = stage.party_id ' ||
1943: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1944: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1945: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2082: SELECT 1 FROM HZ_STAGED_PARTIES p

2078: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2079: FROM HZ_STAGED_CONTACT_POINTS stage
2080: WHERE contains( concat_col, p_contains_str)>0
2081: AND EXISTS (
2082: SELECT 1 FROM HZ_STAGED_PARTIES p
2083: WHERE p.PARTY_ID = stage.PARTY_ID
2084: AND( (l_search_merged ='Y' )
2085: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2086: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 2195: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||

2191: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2192: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2193: ' WHERE contains( concat_col, :cont)>0'||
2194: ' AND EXISTS ('||
2195: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2196: ' WHERE p.party_id = stage.party_id ' ||
2197: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2198: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2199: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2212: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||

2208: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2209: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2210: ' WHERE contains( concat_col, :cont)>0'||
2211: ' AND EXISTS ('||
2212: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2213: ' WHERE p.party_id = stage.party_id ' ||
2214: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2215: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2216: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2264: FROM hz_staged_parties

2260: END IF;
2261: IF p_restrict_sql IS NULL THEN
2262: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2263: SELECT p_search_ctx_id, PARTY_ID, 50
2264: FROM hz_staged_parties
2265: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2266: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2267: AND( (l_search_merged ='Y' )
2268: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 2273: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, 50 FROM hz_staged_parties stage ';

2269: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2270: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2271: AND rownum <= p_thresh;
2272: ELSE
2273: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, 50 FROM hz_staged_parties stage ';
2274: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2275: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2276: IF l_search_merged = 'N' THEN
2277: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';