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

Line 1240: FROM hz_staged_parties

1236: 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);
1237: END IF;
1238: OPEN x_cursor FOR
1239: SELECT PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1240: FROM hz_staged_parties
1241: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1242: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1243: AND( (l_search_merged ='Y' )
1244: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1251: l_sqlstr := 'SELECT PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45 FROM hz_staged_parties stage ';

1247: ELSE
1248: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1249: 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);
1250: END IF;
1251: l_sqlstr := 'SELECT PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45 FROM hz_staged_parties stage ';
1252: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1253: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1254: IF l_search_merged = 'N' THEN
1255: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1373: FROM HZ_STAGED_PARTIES stage

1369: 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);
1370: END IF;
1371: OPEN x_cursor FOR
1372: SELECT PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1373: FROM HZ_STAGED_PARTIES stage
1374: WHERE PARTY_ID = p_dup_party_id;
1375: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1376: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1377: 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 1385: FROM HZ_STAGED_PARTIES stage

1381: 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);
1382: END IF;
1383: OPEN x_cursor FOR
1384: SELECT /*+ INDEX(stage HZ_STAGE_PARTIES_T1) */ PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1385: FROM HZ_STAGED_PARTIES stage
1386: WHERE contains( concat_col, p_contains_str)>0
1387: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1388: AND( (l_search_merged ='Y' )
1389: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1397: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45

1393: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1394: 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);
1395: END IF;
1396: OPEN x_cursor FOR
1397: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1398: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1399: WHERE contains( concat_col, p_contains_str)>0
1400: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1401: AND d.party_id = stage.party_id

Line 1398: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1394: 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);
1395: END IF;
1396: OPEN x_cursor FOR
1397: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1398: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1399: WHERE contains( concat_col, p_contains_str)>0
1400: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1401: AND d.party_id = stage.party_id
1402: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1413: IF (l_check > 0 ) THEN
1414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1415: 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);
1416: END IF;
1417: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1418: ELSE
1419: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1420: END IF;
1421: IF p_search_ctx_id IS NULL THEN

Line 1423: ' FROM HZ_STAGED_PARTIES stage'||

1419: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1420: END IF;
1421: IF p_search_ctx_id IS NULL THEN
1422: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45'||
1423: ' FROM HZ_STAGED_PARTIES stage'||
1424: ' WHERE contains( concat_col, :cont)>0'||
1425: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1426: ' AND ('||p_restrict_sql||')' ||
1427: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1542: SELECT 1 FROM HZ_STAGED_PARTIES p

1538: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1539: FROM HZ_STAGED_PARTY_SITES stage
1540: WHERE contains( concat_col, p_contains_str)>0
1541: AND EXISTS (
1542: SELECT 1 FROM HZ_STAGED_PARTIES p
1543: WHERE p.PARTY_ID = stage.PARTY_ID
1544: AND( (l_search_merged ='Y' )
1545: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1546: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1654: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1655: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1656: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1657: ' AND EXISTS ('||
1658: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1659: ' WHERE p.party_id = stage.party_id ' ||
1660: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1661: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1662: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1671: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1672: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1673: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1674: ' AND EXISTS ('||
1675: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1676: ' WHERE p.party_id = stage.party_id ' ||
1677: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1678: ' AND ('||p_restrict_sql||')' ||
1679: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1744: SELECT 1 FROM HZ_STAGED_PARTIES p

1740: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1741: FROM HZ_STAGED_CONTACTS stage
1742: WHERE contains( concat_col, p_contains_str)>0
1743: AND EXISTS (
1744: SELECT 1 FROM HZ_STAGED_PARTIES p
1745: WHERE p.PARTY_ID = stage.PARTY_ID
1746: AND( (l_search_merged ='Y' )
1747: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1748: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1767: SELECT 1 FROM HZ_STAGED_PARTIES p

1763: SELECT ORG_CONTACT_ID, PARTY_ID
1764: FROM HZ_STAGED_CONTACTS stage
1765: WHERE contains( concat_col, p_contains_str)>0
1766: AND EXISTS (
1767: SELECT 1 FROM HZ_STAGED_PARTIES p
1768: WHERE p.PARTY_ID = stage.PARTY_ID
1769: AND( (l_search_merged ='Y' )
1770: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1771: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1816: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1817: ' FROM HZ_STAGED_CONTACTS stage'||
1818: ' WHERE contains( concat_col, :cont)>0'||
1819: ' AND EXISTS ('||
1820: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1821: ' WHERE p.party_id = stage.party_id ' ||
1822: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1823: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1824: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1961: SELECT 1 FROM HZ_STAGED_PARTIES p

1957: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1958: FROM HZ_STAGED_CONTACT_POINTS stage
1959: WHERE contains( concat_col, p_contains_str)>0
1960: AND EXISTS (
1961: SELECT 1 FROM HZ_STAGED_PARTIES p
1962: WHERE p.PARTY_ID = stage.PARTY_ID
1963: AND( (l_search_merged ='Y' )
1964: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1965: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2070: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7'||
2071: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2072: ' WHERE contains( concat_col, :cont)>0'||
2073: ' AND EXISTS ('||
2074: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2075: ' WHERE p.party_id = stage.party_id ' ||
2076: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2077: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2078: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2087: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7'||
2088: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2089: ' WHERE contains( concat_col, :cont)>0'||
2090: ' AND EXISTS ('||
2091: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2092: ' WHERE p.party_id = stage.party_id ' ||
2093: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2094: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2095: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2143: FROM hz_staged_parties

2139: END IF;
2140: IF p_restrict_sql IS NULL THEN
2141: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2142: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2143: FROM hz_staged_parties
2144: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2145: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2146: AND( (l_search_merged ='Y' )
2147: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 2152: 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 ';

2148: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2149: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2150: AND rownum <= p_thresh;
2151: ELSE
2152: 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 ';
2153: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2154: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2155: IF l_search_merged = 'N' THEN
2156: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';