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

Line 1043: FROM hz_staged_parties

1039: 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);
1040: END IF;
1041: OPEN x_cursor FOR
1042: SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1043: FROM hz_staged_parties
1044: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1045: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1046: AND( (l_search_merged ='Y' )
1047: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1050: ELSE
1051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1052: 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);
1053: END IF;
1054: l_sqlstr := 'SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44 FROM hz_staged_parties stage ';
1055: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1056: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1057: IF l_search_merged = 'N' THEN
1058: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1161: FROM HZ_STAGED_PARTIES stage

1157: 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);
1158: END IF;
1159: OPEN x_cursor FOR
1160: SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1161: FROM HZ_STAGED_PARTIES stage
1162: WHERE PARTY_ID = p_dup_party_id;
1163: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1164: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1165: 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 1173: FROM HZ_STAGED_PARTIES stage

1169: 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);
1170: END IF;
1171: OPEN x_cursor FOR
1172: SELECT /*+ INDEX(stage HZ_STAGE_PARTIES_T1) */ PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1173: FROM HZ_STAGED_PARTIES stage
1174: WHERE contains( concat_col, p_contains_str)>0
1175: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1176: AND( (l_search_merged ='Y' )
1177: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

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

1181: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1182: 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);
1183: END IF;
1184: OPEN x_cursor FOR
1185: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1186: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1187: WHERE contains( concat_col, p_contains_str)>0
1188: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1189: AND d.party_id = stage.party_id

Line 1186: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1182: 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);
1183: END IF;
1184: OPEN x_cursor FOR
1185: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1186: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1187: WHERE contains( concat_col, p_contains_str)>0
1188: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1189: AND d.party_id = stage.party_id
1190: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1201: IF (l_check > 0 ) THEN
1202: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1203: 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);
1204: END IF;
1205: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1206: ELSE
1207: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1208: END IF;
1209: IF p_search_ctx_id IS NULL THEN

Line 1211: ' FROM HZ_STAGED_PARTIES stage'||

1207: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1208: END IF;
1209: IF p_search_ctx_id IS NULL THEN
1210: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44'||
1211: ' FROM HZ_STAGED_PARTIES stage'||
1212: ' WHERE contains( concat_col, :cont)>0'||
1213: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1214: ' AND ('||p_restrict_sql||')' ||
1215: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1330: SELECT 1 FROM HZ_STAGED_PARTIES p

1326: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1327: FROM HZ_STAGED_PARTY_SITES stage
1328: WHERE contains( concat_col, p_contains_str)>0
1329: AND EXISTS (
1330: SELECT 1 FROM HZ_STAGED_PARTIES p
1331: WHERE p.PARTY_ID = stage.PARTY_ID
1332: AND( (l_search_merged ='Y' )
1333: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1334: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1442: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1443: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1444: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1445: ' AND EXISTS ('||
1446: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1447: ' WHERE p.party_id = stage.party_id ' ||
1448: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1449: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1450: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1459: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1460: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1461: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1462: ' AND EXISTS ('||
1463: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1464: ' WHERE p.party_id = stage.party_id ' ||
1465: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1466: ' AND ('||p_restrict_sql||')' ||
1467: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1532: SELECT 1 FROM HZ_STAGED_PARTIES p

1528: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1529: FROM HZ_STAGED_CONTACTS stage
1530: WHERE contains( concat_col, p_contains_str)>0
1531: AND EXISTS (
1532: SELECT 1 FROM HZ_STAGED_PARTIES p
1533: WHERE p.PARTY_ID = stage.PARTY_ID
1534: AND( (l_search_merged ='Y' )
1535: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1536: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1555: SELECT 1 FROM HZ_STAGED_PARTIES p

1551: SELECT ORG_CONTACT_ID, PARTY_ID
1552: FROM HZ_STAGED_CONTACTS stage
1553: WHERE contains( concat_col, p_contains_str)>0
1554: AND EXISTS (
1555: SELECT 1 FROM HZ_STAGED_PARTIES p
1556: WHERE p.PARTY_ID = stage.PARTY_ID
1557: AND( (l_search_merged ='Y' )
1558: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1559: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1604: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1605: ' FROM HZ_STAGED_CONTACTS stage'||
1606: ' WHERE contains( concat_col, :cont)>0'||
1607: ' AND EXISTS ('||
1608: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1609: ' WHERE p.party_id = stage.party_id ' ||
1610: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1611: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1612: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1749: SELECT 1 FROM HZ_STAGED_PARTIES p

1745: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1746: FROM HZ_STAGED_CONTACT_POINTS stage
1747: WHERE contains( concat_col, p_contains_str)>0
1748: AND EXISTS (
1749: SELECT 1 FROM HZ_STAGED_PARTIES p
1750: WHERE p.PARTY_ID = stage.PARTY_ID
1751: AND( (l_search_merged ='Y' )
1752: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1753: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1858: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1859: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1860: ' WHERE contains( concat_col, :cont)>0'||
1861: ' AND EXISTS ('||
1862: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1863: ' WHERE p.party_id = stage.party_id ' ||
1864: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1865: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1866: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1875: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1876: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1877: ' WHERE contains( concat_col, :cont)>0'||
1878: ' AND EXISTS ('||
1879: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1880: ' WHERE p.party_id = stage.party_id ' ||
1881: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1882: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1883: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1931: FROM hz_staged_parties

1927: END IF;
1928: IF p_restrict_sql IS NULL THEN
1929: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
1930: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
1931: FROM hz_staged_parties
1932: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1933: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1934: AND( (l_search_merged ='Y' )
1935: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1936: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
1937: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
1938: AND rownum <= p_thresh;
1939: ELSE
1940: 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 ';
1941: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1942: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1943: IF l_search_merged = 'N' THEN
1944: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';