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

Line 1088: FROM hz_staged_parties

1084: 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);
1085: END IF;
1086: OPEN x_cursor FOR
1087: SELECT PARTY_ID , TX40, TX39
1088: FROM hz_staged_parties
1089: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1090: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1091: AND( (l_search_merged ='Y' )
1092: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1099: l_sqlstr := 'SELECT PARTY_ID , TX40, TX39 FROM hz_staged_parties stage ';

1095: ELSE
1096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1097: 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);
1098: END IF;
1099: l_sqlstr := 'SELECT PARTY_ID , TX40, TX39 FROM hz_staged_parties stage ';
1100: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1101: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1102: IF l_search_merged = 'N' THEN
1103: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1193: FROM HZ_STAGED_PARTIES stage

1189: 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);
1190: END IF;
1191: OPEN x_cursor FOR
1192: SELECT PARTY_ID , TX40, TX39
1193: FROM HZ_STAGED_PARTIES stage
1194: WHERE PARTY_ID = p_dup_party_id;
1195: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1197: 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 1205: FROM HZ_STAGED_PARTIES stage

1201: 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);
1202: END IF;
1203: OPEN x_cursor FOR
1204: SELECT PARTY_ID , TX40, TX39
1205: FROM HZ_STAGED_PARTIES stage
1206: WHERE contains( concat_col, p_contains_str)>0
1207: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1208: AND( (l_search_merged ='Y' )
1209: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1217: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX40, TX39

1213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1214: 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);
1215: END IF;
1216: OPEN x_cursor FOR
1217: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1219: WHERE contains( concat_col, p_contains_str)>0
1220: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1221: AND d.party_id = stage.party_id

Line 1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1214: 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);
1215: END IF;
1216: OPEN x_cursor FOR
1217: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1219: WHERE contains( concat_col, p_contains_str)>0
1220: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1221: AND d.party_id = stage.party_id
1222: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1233: IF (l_check > 0 ) THEN
1234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1235: 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);
1236: END IF;
1237: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1238: END IF;
1239: IF p_search_ctx_id IS NULL THEN
1240: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX40, TX39'||
1241: ' FROM HZ_STAGED_PARTIES stage'||

Line 1241: ' FROM HZ_STAGED_PARTIES stage'||

1237: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1238: END IF;
1239: IF p_search_ctx_id IS NULL THEN
1240: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX40, TX39'||
1241: ' FROM HZ_STAGED_PARTIES stage'||
1242: ' WHERE contains( concat_col, :cont)>0'||
1243: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1244: ' AND ('||p_restrict_sql||')' ||
1245: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1360: SELECT 1 FROM HZ_STAGED_PARTIES p

1356: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1357: FROM HZ_STAGED_PARTY_SITES stage
1358: WHERE contains( concat_col, p_contains_str)>0
1359: AND EXISTS (
1360: SELECT 1 FROM HZ_STAGED_PARTIES p
1361: WHERE p.PARTY_ID = stage.PARTY_ID
1362: AND( (l_search_merged ='Y' )
1363: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1364: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1472: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1473: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1474: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1475: ' AND EXISTS ('||
1476: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1477: ' WHERE p.party_id = stage.party_id ' ||
1478: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1479: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1480: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1489: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1490: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1491: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1492: ' AND EXISTS ('||
1493: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1494: ' WHERE p.party_id = stage.party_id ' ||
1495: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1496: ' AND ('||p_restrict_sql||')' ||
1497: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1562: SELECT 1 FROM HZ_STAGED_PARTIES p

1558: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22
1559: FROM HZ_STAGED_CONTACTS stage
1560: WHERE contains( concat_col, p_contains_str)>0
1561: AND EXISTS (
1562: SELECT 1 FROM HZ_STAGED_PARTIES p
1563: WHERE p.PARTY_ID = stage.PARTY_ID
1564: AND( (l_search_merged ='Y' )
1565: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1566: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1585: SELECT 1 FROM HZ_STAGED_PARTIES p

1581: SELECT ORG_CONTACT_ID, PARTY_ID, TX22
1582: FROM HZ_STAGED_CONTACTS stage
1583: WHERE contains( concat_col, p_contains_str)>0
1584: AND EXISTS (
1585: SELECT 1 FROM HZ_STAGED_PARTIES p
1586: WHERE p.PARTY_ID = stage.PARTY_ID
1587: AND( (l_search_merged ='Y' )
1588: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1589: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1634: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX22'||
1635: ' FROM HZ_STAGED_CONTACTS stage'||
1636: ' WHERE contains( concat_col, :cont)>0'||
1637: ' AND EXISTS ('||
1638: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1639: ' WHERE p.party_id = stage.party_id ' ||
1640: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1641: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1642: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1779: SELECT 1 FROM HZ_STAGED_PARTIES p

1775: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1776: FROM HZ_STAGED_CONTACT_POINTS stage
1777: WHERE contains( concat_col, p_contains_str)>0
1778: AND EXISTS (
1779: SELECT 1 FROM HZ_STAGED_PARTIES p
1780: WHERE p.PARTY_ID = stage.PARTY_ID
1781: AND( (l_search_merged ='Y' )
1782: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1783: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1888: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1889: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1890: ' WHERE contains( concat_col, :cont)>0'||
1891: ' AND EXISTS ('||
1892: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1893: ' WHERE p.party_id = stage.party_id ' ||
1894: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1895: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1896: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1905: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1906: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1907: ' WHERE contains( concat_col, :cont)>0'||
1908: ' AND EXISTS ('||
1909: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1910: ' WHERE p.party_id = stage.party_id ' ||
1911: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1912: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1913: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1961: FROM hz_staged_parties

1957: END IF;
1958: IF p_restrict_sql IS NULL THEN
1959: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
1960: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
1961: FROM hz_staged_parties
1962: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1963: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1964: AND( (l_search_merged ='Y' )
1965: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1966: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
1967: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
1968: AND rownum <= p_thresh;
1969: ELSE
1970: 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 ';
1971: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1972: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1973: IF l_search_merged = 'N' THEN
1974: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';