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

Line 1329: FROM hz_staged_parties

1325: 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);
1326: END IF;
1327: OPEN x_cursor FOR
1328: SELECT PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46
1329: FROM hz_staged_parties
1330: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1331: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1332: AND( (l_search_merged ='Y' )
1333: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1340: l_sqlstr := 'SELECT PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46 FROM hz_staged_parties stage ';

1336: ELSE
1337: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1338: 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);
1339: END IF;
1340: l_sqlstr := 'SELECT PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46 FROM hz_staged_parties stage ';
1341: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1342: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1343: IF l_search_merged = 'N' THEN
1344: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1468: FROM HZ_STAGED_PARTIES stage

1464: 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);
1465: END IF;
1466: OPEN x_cursor FOR
1467: SELECT PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46
1468: FROM HZ_STAGED_PARTIES stage
1469: WHERE PARTY_ID = p_dup_party_id;
1470: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1472: 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 1480: FROM HZ_STAGED_PARTIES stage

1476: 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);
1477: END IF;
1478: OPEN x_cursor FOR
1479: SELECT PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46
1480: FROM HZ_STAGED_PARTIES stage
1481: WHERE contains( concat_col, p_contains_str)>0
1482: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1483: AND( (l_search_merged ='Y' )
1484: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1492: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46

1488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1489: 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);
1490: END IF;
1491: OPEN x_cursor FOR
1492: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46
1493: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1494: WHERE contains( concat_col, p_contains_str)>0
1495: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1496: AND d.party_id = stage.party_id

Line 1493: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1489: 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);
1490: END IF;
1491: OPEN x_cursor FOR
1492: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46
1493: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1494: WHERE contains( concat_col, p_contains_str)>0
1495: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1496: AND d.party_id = stage.party_id
1497: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1508: IF (l_check > 0 ) THEN
1509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1510: 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);
1511: END IF;
1512: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1513: END IF;
1514: IF p_search_ctx_id IS NULL THEN
1515: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46'||
1516: ' FROM HZ_STAGED_PARTIES stage'||

Line 1516: ' FROM HZ_STAGED_PARTIES stage'||

1512: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1513: END IF;
1514: IF p_search_ctx_id IS NULL THEN
1515: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46'||
1516: ' FROM HZ_STAGED_PARTIES stage'||
1517: ' WHERE contains( concat_col, :cont)>0'||
1518: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1519: ' AND ('||p_restrict_sql||')' ||
1520: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1635: SELECT 1 FROM HZ_STAGED_PARTIES p

1631: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1632: FROM HZ_STAGED_PARTY_SITES stage
1633: WHERE contains( concat_col, p_contains_str)>0
1634: AND EXISTS (
1635: SELECT 1 FROM HZ_STAGED_PARTIES p
1636: WHERE p.PARTY_ID = stage.PARTY_ID
1637: AND( (l_search_merged ='Y' )
1638: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1639: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1747: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1748: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1749: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1750: ' AND EXISTS ('||
1751: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1752: ' WHERE p.party_id = stage.party_id ' ||
1753: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1754: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1755: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1764: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1765: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1766: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1767: ' AND EXISTS ('||
1768: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1769: ' WHERE p.party_id = stage.party_id ' ||
1770: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1771: ' AND ('||p_restrict_sql||')' ||
1772: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1837: SELECT 1 FROM HZ_STAGED_PARTIES p

1833: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1834: FROM HZ_STAGED_CONTACTS stage
1835: WHERE contains( concat_col, p_contains_str)>0
1836: AND EXISTS (
1837: SELECT 1 FROM HZ_STAGED_PARTIES p
1838: WHERE p.PARTY_ID = stage.PARTY_ID
1839: AND( (l_search_merged ='Y' )
1840: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1841: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1860: SELECT 1 FROM HZ_STAGED_PARTIES p

1856: SELECT ORG_CONTACT_ID, PARTY_ID
1857: FROM HZ_STAGED_CONTACTS stage
1858: WHERE contains( concat_col, p_contains_str)>0
1859: AND EXISTS (
1860: SELECT 1 FROM HZ_STAGED_PARTIES p
1861: WHERE p.PARTY_ID = stage.PARTY_ID
1862: AND( (l_search_merged ='Y' )
1863: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1864: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1909: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1910: ' FROM HZ_STAGED_CONTACTS stage'||
1911: ' WHERE contains( concat_col, :cont)>0'||
1912: ' AND EXISTS ('||
1913: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1914: ' WHERE p.party_id = stage.party_id ' ||
1915: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1916: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1917: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2054: SELECT 1 FROM HZ_STAGED_PARTIES p

2050: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2051: FROM HZ_STAGED_CONTACT_POINTS stage
2052: WHERE contains( concat_col, p_contains_str)>0
2053: AND EXISTS (
2054: SELECT 1 FROM HZ_STAGED_PARTIES p
2055: WHERE p.PARTY_ID = stage.PARTY_ID
2056: AND( (l_search_merged ='Y' )
2057: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2058: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2163: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2164: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2165: ' WHERE contains( concat_col, :cont)>0'||
2166: ' AND EXISTS ('||
2167: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2168: ' WHERE p.party_id = stage.party_id ' ||
2169: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2170: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2171: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2180: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2181: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2182: ' WHERE contains( concat_col, :cont)>0'||
2183: ' AND EXISTS ('||
2184: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2185: ' WHERE p.party_id = stage.party_id ' ||
2186: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2187: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2188: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2236: FROM hz_staged_parties

2232: END IF;
2233: IF p_restrict_sql IS NULL THEN
2234: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2235: SELECT p_search_ctx_id, PARTY_ID, 100
2236: FROM hz_staged_parties
2237: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2238: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2239: AND( (l_search_merged ='Y' )
2240: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2241: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2242: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2243: AND rownum <= p_thresh;
2244: ELSE
2245: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, 100 FROM hz_staged_parties stage ';
2246: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2247: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2248: IF l_search_merged = 'N' THEN
2249: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';