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

Line 1117: FROM hz_staged_parties

1113: 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);
1114: END IF;
1115: OPEN x_cursor FOR
1116: SELECT PARTY_ID , TX4
1117: FROM hz_staged_parties
1118: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1119: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1120: AND( (l_search_merged ='Y' )
1121: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1128: l_sqlstr := 'SELECT PARTY_ID , TX4 FROM hz_staged_parties stage ';

1124: ELSE
1125: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1126: 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);
1127: END IF;
1128: l_sqlstr := 'SELECT PARTY_ID , TX4 FROM hz_staged_parties stage ';
1129: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1130: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1131: IF l_search_merged = 'N' THEN
1132: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1221: FROM HZ_STAGED_PARTIES stage

1217: 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);
1218: END IF;
1219: OPEN x_cursor FOR
1220: SELECT PARTY_ID , TX4
1221: FROM HZ_STAGED_PARTIES stage
1222: WHERE PARTY_ID = p_dup_party_id;
1223: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1225: 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 1233: FROM HZ_STAGED_PARTIES stage

1229: 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);
1230: END IF;
1231: OPEN x_cursor FOR
1232: SELECT /*+ INDEX(stage HZ_STAGE_PARTIES_T1) */ PARTY_ID , TX4
1233: FROM HZ_STAGED_PARTIES stage
1234: WHERE contains( concat_col, p_contains_str)>0
1235: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1236: AND( (l_search_merged ='Y' )
1237: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1245: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX4

1241: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1242: 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);
1243: END IF;
1244: OPEN x_cursor FOR
1245: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4
1246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1247: WHERE contains( concat_col, p_contains_str)>0
1248: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1249: AND d.party_id = stage.party_id

Line 1246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1242: 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);
1243: END IF;
1244: OPEN x_cursor FOR
1245: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4
1246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1247: WHERE contains( concat_col, p_contains_str)>0
1248: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1249: AND d.party_id = stage.party_id
1250: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1261: IF (l_check > 0 ) THEN
1262: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1263: 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);
1264: END IF;
1265: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1266: ELSE
1267: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1268: END IF;
1269: IF p_search_ctx_id IS NULL THEN

Line 1271: ' FROM HZ_STAGED_PARTIES stage'||

1267: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1268: END IF;
1269: IF p_search_ctx_id IS NULL THEN
1270: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX4'||
1271: ' FROM HZ_STAGED_PARTIES stage'||
1272: ' WHERE contains( concat_col, :cont)>0'||
1273: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1274: ' AND ('||p_restrict_sql||')' ||
1275: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1390: SELECT 1 FROM HZ_STAGED_PARTIES p

1386: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1387: FROM HZ_STAGED_PARTY_SITES stage
1388: WHERE contains( concat_col, p_contains_str)>0
1389: AND EXISTS (
1390: SELECT 1 FROM HZ_STAGED_PARTIES p
1391: WHERE p.PARTY_ID = stage.PARTY_ID
1392: AND( (l_search_merged ='Y' )
1393: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1394: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1502: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1503: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1504: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1505: ' AND EXISTS ('||
1506: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1507: ' WHERE p.party_id = stage.party_id ' ||
1508: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1509: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1510: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1519: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1520: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1521: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1522: ' AND EXISTS ('||
1523: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1524: ' WHERE p.party_id = stage.party_id ' ||
1525: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1526: ' AND ('||p_restrict_sql||')' ||
1527: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1592: SELECT 1 FROM HZ_STAGED_PARTIES p

1588: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1589: FROM HZ_STAGED_CONTACTS stage
1590: WHERE contains( concat_col, p_contains_str)>0
1591: AND EXISTS (
1592: SELECT 1 FROM HZ_STAGED_PARTIES p
1593: WHERE p.PARTY_ID = stage.PARTY_ID
1594: AND( (l_search_merged ='Y' )
1595: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1596: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1615: SELECT 1 FROM HZ_STAGED_PARTIES p

1611: SELECT ORG_CONTACT_ID, PARTY_ID
1612: FROM HZ_STAGED_CONTACTS stage
1613: WHERE contains( concat_col, p_contains_str)>0
1614: AND EXISTS (
1615: SELECT 1 FROM HZ_STAGED_PARTIES p
1616: WHERE p.PARTY_ID = stage.PARTY_ID
1617: AND( (l_search_merged ='Y' )
1618: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1619: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1664: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1665: ' FROM HZ_STAGED_CONTACTS stage'||
1666: ' WHERE contains( concat_col, :cont)>0'||
1667: ' AND EXISTS ('||
1668: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1669: ' WHERE p.party_id = stage.party_id ' ||
1670: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1671: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1672: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1809: SELECT 1 FROM HZ_STAGED_PARTIES p

1805: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2, TX6
1806: FROM HZ_STAGED_CONTACT_POINTS stage
1807: WHERE contains( concat_col, p_contains_str)>0
1808: AND EXISTS (
1809: SELECT 1 FROM HZ_STAGED_PARTIES p
1810: WHERE p.PARTY_ID = stage.PARTY_ID
1811: AND( (l_search_merged ='Y' )
1812: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1813: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1918: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2, TX6'||
1919: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1920: ' WHERE contains( concat_col, :cont)>0'||
1921: ' AND EXISTS ('||
1922: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1923: ' WHERE p.party_id = stage.party_id ' ||
1924: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1925: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1926: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1935: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2, TX6'||
1936: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1937: ' WHERE contains( concat_col, :cont)>0'||
1938: ' AND EXISTS ('||
1939: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1940: ' WHERE p.party_id = stage.party_id ' ||
1941: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1942: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1943: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1991: FROM hz_staged_parties

1987: END IF;
1988: IF p_restrict_sql IS NULL THEN
1989: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
1990: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
1991: FROM hz_staged_parties
1992: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1993: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1994: AND( (l_search_merged ='Y' )
1995: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1996: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
1997: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
1998: AND rownum <= p_thresh;
1999: ELSE
2000: 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 ';
2001: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2002: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2003: IF l_search_merged = 'N' THEN
2004: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';