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_40 dependencies on HZ_STAGED_PARTIES

Line 1308: FROM hz_staged_parties

1304: 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);
1305: END IF;
1306: OPEN x_cursor FOR
1307: SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1308: FROM hz_staged_parties
1309: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1310: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1311: AND( (l_search_merged ='Y' )
1312: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1319: l_sqlstr := 'SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44 FROM hz_staged_parties stage ';

1315: ELSE
1316: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1317: 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);
1318: END IF;
1319: l_sqlstr := 'SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44 FROM hz_staged_parties stage ';
1320: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1321: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1322: IF l_search_merged = 'N' THEN
1323: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1440: FROM HZ_STAGED_PARTIES stage

1436: 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);
1437: END IF;
1438: OPEN x_cursor FOR
1439: SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1440: FROM HZ_STAGED_PARTIES stage
1441: WHERE PARTY_ID = p_dup_party_id;
1442: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1443: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1444: 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 1452: FROM HZ_STAGED_PARTIES stage

1448: 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);
1449: END IF;
1450: OPEN x_cursor FOR
1451: SELECT /*+ INDEX(stage HZ_STAGE_PARTIES_T1) */ PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1452: FROM HZ_STAGED_PARTIES stage
1453: WHERE contains( concat_col, p_contains_str)>0
1454: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1455: AND( (l_search_merged ='Y' )
1456: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1464: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44

1460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1461: 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);
1462: END IF;
1463: OPEN x_cursor FOR
1464: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1465: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1466: WHERE contains( concat_col, p_contains_str)>0
1467: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1468: AND d.party_id = stage.party_id

Line 1465: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1461: 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);
1462: END IF;
1463: OPEN x_cursor FOR
1464: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1465: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1466: WHERE contains( concat_col, p_contains_str)>0
1467: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1468: AND d.party_id = stage.party_id
1469: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1480: IF (l_check > 0 ) THEN
1481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1482: 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);
1483: END IF;
1484: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1485: ELSE
1486: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1487: END IF;
1488: IF p_search_ctx_id IS NULL THEN

Line 1490: ' FROM HZ_STAGED_PARTIES stage'||

1486: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1487: END IF;
1488: IF p_search_ctx_id IS NULL THEN
1489: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44'||
1490: ' FROM HZ_STAGED_PARTIES stage'||
1491: ' WHERE contains( concat_col, :cont)>0'||
1492: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1493: ' AND ('||p_restrict_sql||')' ||
1494: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1609: SELECT 1 FROM HZ_STAGED_PARTIES p

1605: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1606: FROM HZ_STAGED_PARTY_SITES stage
1607: WHERE contains( concat_col, p_contains_str)>0
1608: AND EXISTS (
1609: SELECT 1 FROM HZ_STAGED_PARTIES p
1610: WHERE p.PARTY_ID = stage.PARTY_ID
1611: AND( (l_search_merged ='Y' )
1612: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1613: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1721: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1722: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1723: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1724: ' AND EXISTS ('||
1725: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1726: ' WHERE p.party_id = stage.party_id ' ||
1727: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1728: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1729: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1738: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1739: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1740: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1741: ' AND EXISTS ('||
1742: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1743: ' WHERE p.party_id = stage.party_id ' ||
1744: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1745: ' AND ('||p_restrict_sql||')' ||
1746: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1811: SELECT 1 FROM HZ_STAGED_PARTIES p

1807: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
1808: FROM HZ_STAGED_CONTACTS stage
1809: WHERE contains( concat_col, p_contains_str)>0
1810: AND EXISTS (
1811: SELECT 1 FROM HZ_STAGED_PARTIES p
1812: WHERE p.PARTY_ID = stage.PARTY_ID
1813: AND( (l_search_merged ='Y' )
1814: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1815: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1834: SELECT 1 FROM HZ_STAGED_PARTIES p

1830: SELECT ORG_CONTACT_ID, PARTY_ID, TX5, TX2
1831: FROM HZ_STAGED_CONTACTS stage
1832: WHERE contains( concat_col, p_contains_str)>0
1833: AND EXISTS (
1834: SELECT 1 FROM HZ_STAGED_PARTIES p
1835: WHERE p.PARTY_ID = stage.PARTY_ID
1836: AND( (l_search_merged ='Y' )
1837: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1838: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1883: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX5, TX2'||
1884: ' FROM HZ_STAGED_CONTACTS stage'||
1885: ' WHERE contains( concat_col, :cont)>0'||
1886: ' AND EXISTS ('||
1887: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1888: ' WHERE p.party_id = stage.party_id ' ||
1889: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1890: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1891: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2028: SELECT 1 FROM HZ_STAGED_PARTIES p

2024: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2025: FROM HZ_STAGED_CONTACT_POINTS stage
2026: WHERE contains( concat_col, p_contains_str)>0
2027: AND EXISTS (
2028: SELECT 1 FROM HZ_STAGED_PARTIES p
2029: WHERE p.PARTY_ID = stage.PARTY_ID
2030: AND( (l_search_merged ='Y' )
2031: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2032: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2137: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2138: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2139: ' WHERE contains( concat_col, :cont)>0'||
2140: ' AND EXISTS ('||
2141: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2142: ' WHERE p.party_id = stage.party_id ' ||
2143: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2144: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2145: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2154: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2155: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2156: ' WHERE contains( concat_col, :cont)>0'||
2157: ' AND EXISTS ('||
2158: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2159: ' WHERE p.party_id = stage.party_id ' ||
2160: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2161: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2162: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2210: FROM hz_staged_parties

2206: END IF;
2207: IF p_restrict_sql IS NULL THEN
2208: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2209: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2210: FROM hz_staged_parties
2211: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2212: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2213: AND( (l_search_merged ='Y' )
2214: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 2219: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, decode(TX8,:TX8||'' '',100,90) FROM hz_staged_parties stage ';

2215: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2216: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2217: AND rownum <= p_thresh;
2218: ELSE
2219: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, decode(TX8,:TX8||'' '',100,90) FROM hz_staged_parties stage ';
2220: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2221: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2222: IF l_search_merged = 'N' THEN
2223: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';