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

Line 1210: FROM hz_staged_parties

1206: 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);
1207: END IF;
1208: OPEN x_cursor FOR
1209: SELECT PARTY_ID , TX4, TX45, TX46
1210: FROM hz_staged_parties
1211: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1212: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1213: AND( (l_search_merged ='Y' )
1214: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1221: l_sqlstr := 'SELECT PARTY_ID , TX4, TX45, TX46 FROM hz_staged_parties stage ';

1217: ELSE
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1219: 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);
1220: END IF;
1221: l_sqlstr := 'SELECT PARTY_ID , TX4, TX45, TX46 FROM hz_staged_parties stage ';
1222: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1223: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1224: IF l_search_merged = 'N' THEN
1225: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1328: FROM HZ_STAGED_PARTIES stage

1324: 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);
1325: END IF;
1326: OPEN x_cursor FOR
1327: SELECT PARTY_ID , TX4, TX45, TX46
1328: FROM HZ_STAGED_PARTIES stage
1329: WHERE PARTY_ID = p_dup_party_id;
1330: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1331: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1332: 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 1340: FROM HZ_STAGED_PARTIES stage

1336: 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);
1337: END IF;
1338: OPEN x_cursor FOR
1339: SELECT /*+ INDEX(stage HZ_STAGE_PARTIES_T1) */ PARTY_ID , TX4, TX45, TX46
1340: FROM HZ_STAGED_PARTIES stage
1341: WHERE contains( concat_col, p_contains_str)>0
1342: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1343: AND( (l_search_merged ='Y' )
1344: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1352: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX4, TX45, TX46

1348: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1349: 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);
1350: END IF;
1351: OPEN x_cursor FOR
1352: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4, TX45, TX46
1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1354: WHERE contains( concat_col, p_contains_str)>0
1355: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1356: AND d.party_id = stage.party_id

Line 1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1349: 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);
1350: END IF;
1351: OPEN x_cursor FOR
1352: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4, TX45, TX46
1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1354: WHERE contains( concat_col, p_contains_str)>0
1355: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1356: AND d.party_id = stage.party_id
1357: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1368: IF (l_check > 0 ) THEN
1369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1370: 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);
1371: END IF;
1372: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1373: ELSE
1374: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1375: END IF;
1376: IF p_search_ctx_id IS NULL THEN

Line 1378: ' FROM HZ_STAGED_PARTIES stage'||

1374: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1375: END IF;
1376: IF p_search_ctx_id IS NULL THEN
1377: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX4, TX45, TX46'||
1378: ' FROM HZ_STAGED_PARTIES stage'||
1379: ' WHERE contains( concat_col, :cont)>0'||
1380: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1381: ' AND ('||p_restrict_sql||')' ||
1382: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1497: SELECT 1 FROM HZ_STAGED_PARTIES p

1493: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1494: FROM HZ_STAGED_PARTY_SITES stage
1495: WHERE contains( concat_col, p_contains_str)>0
1496: AND EXISTS (
1497: SELECT 1 FROM HZ_STAGED_PARTIES p
1498: WHERE p.PARTY_ID = stage.PARTY_ID
1499: AND( (l_search_merged ='Y' )
1500: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1501: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1609: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1610: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1611: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1612: ' AND EXISTS ('||
1613: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1614: ' WHERE p.party_id = stage.party_id ' ||
1615: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1616: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1617: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1626: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1627: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1628: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1629: ' AND EXISTS ('||
1630: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1631: ' WHERE p.party_id = stage.party_id ' ||
1632: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1633: ' AND ('||p_restrict_sql||')' ||
1634: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1699: SELECT 1 FROM HZ_STAGED_PARTIES p

1695: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1696: FROM HZ_STAGED_CONTACTS stage
1697: WHERE contains( concat_col, p_contains_str)>0
1698: AND EXISTS (
1699: SELECT 1 FROM HZ_STAGED_PARTIES p
1700: WHERE p.PARTY_ID = stage.PARTY_ID
1701: AND( (l_search_merged ='Y' )
1702: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1703: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1722: SELECT 1 FROM HZ_STAGED_PARTIES p

1718: SELECT ORG_CONTACT_ID, PARTY_ID
1719: FROM HZ_STAGED_CONTACTS stage
1720: WHERE contains( concat_col, p_contains_str)>0
1721: AND EXISTS (
1722: SELECT 1 FROM HZ_STAGED_PARTIES p
1723: WHERE p.PARTY_ID = stage.PARTY_ID
1724: AND( (l_search_merged ='Y' )
1725: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1726: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1771: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1772: ' FROM HZ_STAGED_CONTACTS stage'||
1773: ' WHERE contains( concat_col, :cont)>0'||
1774: ' AND EXISTS ('||
1775: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1776: ' WHERE p.party_id = stage.party_id ' ||
1777: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1778: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1779: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1916: SELECT 1 FROM HZ_STAGED_PARTIES p

1912: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1913: FROM HZ_STAGED_CONTACT_POINTS stage
1914: WHERE contains( concat_col, p_contains_str)>0
1915: AND EXISTS (
1916: SELECT 1 FROM HZ_STAGED_PARTIES p
1917: WHERE p.PARTY_ID = stage.PARTY_ID
1918: AND( (l_search_merged ='Y' )
1919: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1920: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2025: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2'||
2026: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2027: ' WHERE contains( concat_col, :cont)>0'||
2028: ' AND EXISTS ('||
2029: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2030: ' WHERE p.party_id = stage.party_id ' ||
2031: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2032: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2033: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2042: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2'||
2043: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2044: ' WHERE contains( concat_col, :cont)>0'||
2045: ' AND EXISTS ('||
2046: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2047: ' WHERE p.party_id = stage.party_id ' ||
2048: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2049: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2050: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2098: FROM hz_staged_parties

2094: END IF;
2095: IF p_restrict_sql IS NULL THEN
2096: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2097: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2098: FROM hz_staged_parties
2099: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2100: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2101: AND( (l_search_merged ='Y' )
2102: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2103: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2104: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2105: AND rownum <= p_thresh;
2106: ELSE
2107: 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 ';
2108: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2109: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2110: IF l_search_merged = 'N' THEN
2111: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';