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

Line 975: FROM hz_staged_parties

971: 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);
972: END IF;
973: OPEN x_cursor FOR
974: SELECT PARTY_ID , TX44
975: FROM hz_staged_parties
976: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
977: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
978: AND( (l_search_merged ='Y' )
979: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 986: l_sqlstr := 'SELECT PARTY_ID , TX44 FROM hz_staged_parties stage ';

982: ELSE
983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
984: 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);
985: END IF;
986: l_sqlstr := 'SELECT PARTY_ID , TX44 FROM hz_staged_parties stage ';
987: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
988: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
989: IF l_search_merged = 'N' THEN
990: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1087: FROM HZ_STAGED_PARTIES stage

1083: 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);
1084: END IF;
1085: OPEN x_cursor FOR
1086: SELECT PARTY_ID , TX44
1087: FROM HZ_STAGED_PARTIES stage
1088: WHERE PARTY_ID = p_dup_party_id;
1089: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1091: 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 1099: FROM HZ_STAGED_PARTIES stage

1095: 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);
1096: END IF;
1097: OPEN x_cursor FOR
1098: SELECT PARTY_ID , TX44
1099: FROM HZ_STAGED_PARTIES stage
1100: WHERE contains( concat_col, p_contains_str)>0
1101: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1102: AND( (l_search_merged ='Y' )
1103: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1111: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX44

1107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1108: 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);
1109: END IF;
1110: OPEN x_cursor FOR
1111: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX44
1112: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1113: WHERE contains( concat_col, p_contains_str)>0
1114: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1115: AND d.party_id = stage.party_id

Line 1112: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1108: 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);
1109: END IF;
1110: OPEN x_cursor FOR
1111: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX44
1112: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1113: WHERE contains( concat_col, p_contains_str)>0
1114: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1115: AND d.party_id = stage.party_id
1116: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1127: IF (l_check > 0 ) THEN
1128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1129: 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);
1130: END IF;
1131: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1132: END IF;
1133: IF p_search_ctx_id IS NULL THEN
1134: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX44'||
1135: ' FROM HZ_STAGED_PARTIES stage'||

Line 1135: ' FROM HZ_STAGED_PARTIES stage'||

1131: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1132: END IF;
1133: IF p_search_ctx_id IS NULL THEN
1134: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX44'||
1135: ' FROM HZ_STAGED_PARTIES stage'||
1136: ' WHERE contains( concat_col, :cont)>0'||
1137: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1138: ' AND ('||p_restrict_sql||')' ||
1139: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1254: SELECT 1 FROM HZ_STAGED_PARTIES p

1250: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1251: FROM HZ_STAGED_PARTY_SITES stage
1252: WHERE contains( concat_col, p_contains_str)>0
1253: AND EXISTS (
1254: SELECT 1 FROM HZ_STAGED_PARTIES p
1255: WHERE p.PARTY_ID = stage.PARTY_ID
1256: AND( (l_search_merged ='Y' )
1257: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1258: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1366: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1367: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1368: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1369: ' AND EXISTS ('||
1370: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1371: ' WHERE p.party_id = stage.party_id ' ||
1372: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1373: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1374: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1383: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1384: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1385: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1386: ' AND EXISTS ('||
1387: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1388: ' WHERE p.party_id = stage.party_id ' ||
1389: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1390: ' AND ('||p_restrict_sql||')' ||
1391: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1456: SELECT 1 FROM HZ_STAGED_PARTIES p

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

Line 1479: SELECT 1 FROM HZ_STAGED_PARTIES p

1475: SELECT ORG_CONTACT_ID, PARTY_ID
1476: FROM HZ_STAGED_CONTACTS stage
1477: WHERE contains( concat_col, p_contains_str)>0
1478: AND EXISTS (
1479: SELECT 1 FROM HZ_STAGED_PARTIES p
1480: WHERE p.PARTY_ID = stage.PARTY_ID
1481: AND( (l_search_merged ='Y' )
1482: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1483: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1528: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1529: ' FROM HZ_STAGED_CONTACTS stage'||
1530: ' WHERE contains( concat_col, :cont)>0'||
1531: ' AND EXISTS ('||
1532: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1533: ' WHERE p.party_id = stage.party_id ' ||
1534: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1535: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1536: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1673: SELECT 1 FROM HZ_STAGED_PARTIES p

1669: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1670: FROM HZ_STAGED_CONTACT_POINTS stage
1671: WHERE contains( concat_col, p_contains_str)>0
1672: AND EXISTS (
1673: SELECT 1 FROM HZ_STAGED_PARTIES p
1674: WHERE p.PARTY_ID = stage.PARTY_ID
1675: AND( (l_search_merged ='Y' )
1676: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1677: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1782: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1783: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1784: ' WHERE contains( concat_col, :cont)>0'||
1785: ' AND EXISTS ('||
1786: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1787: ' WHERE p.party_id = stage.party_id ' ||
1788: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1789: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1790: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1799: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1800: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1801: ' WHERE contains( concat_col, :cont)>0'||
1802: ' AND EXISTS ('||
1803: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1804: ' WHERE p.party_id = stage.party_id ' ||
1805: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1806: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1807: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1855: FROM hz_staged_parties

1851: END IF;
1852: IF p_restrict_sql IS NULL THEN
1853: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
1854: SELECT p_search_ctx_id, PARTY_ID, 0
1855: FROM hz_staged_parties
1856: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1857: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1858: AND( (l_search_merged ='Y' )
1859: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1860: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
1861: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
1862: AND rownum <= p_thresh;
1863: ELSE
1864: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, 0 FROM hz_staged_parties stage ';
1865: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1866: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1867: IF l_search_merged = 'N' THEN
1868: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';