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

Line 955: FROM hz_staged_parties

951: 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);
952: END IF;
953: OPEN x_cursor FOR
954: SELECT PARTY_ID , TX2, TX8, TX4
955: FROM hz_staged_parties
956: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
957: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
958: AND( (l_search_merged ='Y' )
959: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 966: l_sqlstr := 'SELECT PARTY_ID , TX2, TX8, TX4 FROM hz_staged_parties stage ';

962: ELSE
963: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
964: 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);
965: END IF;
966: l_sqlstr := 'SELECT PARTY_ID , TX2, TX8, TX4 FROM hz_staged_parties stage ';
967: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
968: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
969: IF l_search_merged = 'N' THEN
970: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1065: FROM HZ_STAGED_PARTIES stage

1061: 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);
1062: END IF;
1063: OPEN x_cursor FOR
1064: SELECT PARTY_ID , TX2, TX8, TX4
1065: FROM HZ_STAGED_PARTIES stage
1066: WHERE PARTY_ID = p_dup_party_id;
1067: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1068: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1069: 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 1077: FROM HZ_STAGED_PARTIES stage

1073: 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);
1074: END IF;
1075: OPEN x_cursor FOR
1076: SELECT PARTY_ID , TX2, TX8, TX4
1077: FROM HZ_STAGED_PARTIES stage
1078: WHERE contains( concat_col, p_contains_str)>0
1079: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1080: AND( (l_search_merged ='Y' )
1081: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1089: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX2, TX8, TX4

1085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1086: 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);
1087: END IF;
1088: OPEN x_cursor FOR
1089: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4
1090: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1091: WHERE contains( concat_col, p_contains_str)>0
1092: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1093: AND d.party_id = stage.party_id

Line 1090: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1086: 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);
1087: END IF;
1088: OPEN x_cursor FOR
1089: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4
1090: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1091: WHERE contains( concat_col, p_contains_str)>0
1092: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1093: AND d.party_id = stage.party_id
1094: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1105: IF (l_check > 0 ) THEN
1106: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1107: 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);
1108: END IF;
1109: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1110: END IF;
1111: IF p_search_ctx_id IS NULL THEN
1112: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX2, TX8, TX4'||
1113: ' FROM HZ_STAGED_PARTIES stage'||

Line 1113: ' FROM HZ_STAGED_PARTIES stage'||

1109: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1110: END IF;
1111: IF p_search_ctx_id IS NULL THEN
1112: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX2, TX8, TX4'||
1113: ' FROM HZ_STAGED_PARTIES stage'||
1114: ' WHERE contains( concat_col, :cont)>0'||
1115: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1116: ' AND ('||p_restrict_sql||')' ||
1117: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1232: SELECT 1 FROM HZ_STAGED_PARTIES p

1228: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1229: FROM HZ_STAGED_PARTY_SITES stage
1230: WHERE contains( concat_col, p_contains_str)>0
1231: AND EXISTS (
1232: SELECT 1 FROM HZ_STAGED_PARTIES p
1233: WHERE p.PARTY_ID = stage.PARTY_ID
1234: AND( (l_search_merged ='Y' )
1235: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1236: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1344: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1345: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1346: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1347: ' AND EXISTS ('||
1348: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1349: ' WHERE p.party_id = stage.party_id ' ||
1350: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1351: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1352: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1361: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1362: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1363: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1364: ' AND EXISTS ('||
1365: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1366: ' WHERE p.party_id = stage.party_id ' ||
1367: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1368: ' AND ('||p_restrict_sql||')' ||
1369: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1434: SELECT 1 FROM HZ_STAGED_PARTIES p

1430: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1431: FROM HZ_STAGED_CONTACTS stage
1432: WHERE contains( concat_col, p_contains_str)>0
1433: AND EXISTS (
1434: SELECT 1 FROM HZ_STAGED_PARTIES p
1435: WHERE p.PARTY_ID = stage.PARTY_ID
1436: AND( (l_search_merged ='Y' )
1437: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1438: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1457: SELECT 1 FROM HZ_STAGED_PARTIES p

1453: SELECT ORG_CONTACT_ID, PARTY_ID
1454: FROM HZ_STAGED_CONTACTS stage
1455: WHERE contains( concat_col, p_contains_str)>0
1456: AND EXISTS (
1457: SELECT 1 FROM HZ_STAGED_PARTIES p
1458: WHERE p.PARTY_ID = stage.PARTY_ID
1459: AND( (l_search_merged ='Y' )
1460: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1461: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1506: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1507: ' FROM HZ_STAGED_CONTACTS stage'||
1508: ' WHERE contains( concat_col, :cont)>0'||
1509: ' AND EXISTS ('||
1510: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1511: ' WHERE p.party_id = stage.party_id ' ||
1512: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1513: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1514: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1651: SELECT 1 FROM HZ_STAGED_PARTIES p

1647: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1648: FROM HZ_STAGED_CONTACT_POINTS stage
1649: WHERE contains( concat_col, p_contains_str)>0
1650: AND EXISTS (
1651: SELECT 1 FROM HZ_STAGED_PARTIES p
1652: WHERE p.PARTY_ID = stage.PARTY_ID
1653: AND( (l_search_merged ='Y' )
1654: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1655: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1760: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1761: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1762: ' WHERE contains( concat_col, :cont)>0'||
1763: ' AND EXISTS ('||
1764: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1765: ' WHERE p.party_id = stage.party_id ' ||
1766: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1767: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1768: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1777: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1778: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1779: ' WHERE contains( concat_col, :cont)>0'||
1780: ' AND EXISTS ('||
1781: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1782: ' WHERE p.party_id = stage.party_id ' ||
1783: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1784: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1785: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1833: FROM hz_staged_parties

1829: END IF;
1830: IF p_restrict_sql IS NULL THEN
1831: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
1832: SELECT p_search_ctx_id, PARTY_ID, 50
1833: FROM hz_staged_parties
1834: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1835: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1836: AND( (l_search_merged ='Y' )
1837: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1838: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
1839: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
1840: AND rownum <= p_thresh;
1841: ELSE
1842: 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 ';
1843: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1844: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1845: IF l_search_merged = 'N' THEN
1846: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';