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

Line 1500: FROM hz_staged_parties

1496: 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);
1497: END IF;
1498: OPEN x_cursor FOR
1499: SELECT PARTY_ID , TX40, TX39
1500: FROM hz_staged_parties
1501: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1502: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1503: AND( (l_search_merged ='Y' )
1504: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1507: ELSE
1508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1509: 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);
1510: END IF;
1511: l_sqlstr := 'SELECT PARTY_ID , TX40, TX39 FROM hz_staged_parties stage ';
1512: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1513: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1514: IF l_search_merged = 'N' THEN
1515: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1618: FROM HZ_STAGED_PARTIES stage

1614: 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);
1615: END IF;
1616: OPEN x_cursor FOR
1617: SELECT PARTY_ID , TX40, TX39
1618: FROM HZ_STAGED_PARTIES stage
1619: WHERE PARTY_ID = p_dup_party_id;
1620: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1621: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1622: 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 1630: FROM HZ_STAGED_PARTIES stage

1626: 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);
1627: END IF;
1628: OPEN x_cursor FOR
1629: SELECT /*+ INDEX(stage HZ_STAGE_PARTIES_T1) */ PARTY_ID , TX40, TX39
1630: FROM HZ_STAGED_PARTIES stage
1631: WHERE contains( concat_col, p_contains_str)>0
1632: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1633: AND( (l_search_merged ='Y' )
1634: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

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

1638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1639: 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);
1640: END IF;
1641: OPEN x_cursor FOR
1642: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1643: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1644: WHERE contains( concat_col, p_contains_str)>0
1645: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1646: AND d.party_id = stage.party_id

Line 1643: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1639: 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);
1640: END IF;
1641: OPEN x_cursor FOR
1642: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1643: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1644: WHERE contains( concat_col, p_contains_str)>0
1645: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1646: AND d.party_id = stage.party_id
1647: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1658: IF (l_check > 0 ) THEN
1659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1660: 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);
1661: END IF;
1662: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1663: ELSE
1664: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1665: END IF;
1666: IF p_search_ctx_id IS NULL THEN

Line 1668: ' FROM HZ_STAGED_PARTIES stage'||

1664: l_hint := '/*+ INDEX(stage HZ_STAGE_PARTIES_T1) */';
1665: END IF;
1666: IF p_search_ctx_id IS NULL THEN
1667: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX40, TX39'||
1668: ' FROM HZ_STAGED_PARTIES stage'||
1669: ' WHERE contains( concat_col, :cont)>0'||
1670: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1671: ' AND ('||p_restrict_sql||')' ||
1672: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1787: SELECT 1 FROM HZ_STAGED_PARTIES p

1783: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1784: FROM HZ_STAGED_PARTY_SITES stage
1785: WHERE contains( concat_col, p_contains_str)>0
1786: AND EXISTS (
1787: SELECT 1 FROM HZ_STAGED_PARTIES p
1788: WHERE p.PARTY_ID = stage.PARTY_ID
1789: AND( (l_search_merged ='Y' )
1790: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1791: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1899: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1900: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1901: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1902: ' AND EXISTS ('||
1903: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1904: ' WHERE p.party_id = stage.party_id ' ||
1905: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1906: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1907: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1916: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1917: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1918: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1919: ' AND EXISTS ('||
1920: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1921: ' WHERE p.party_id = stage.party_id ' ||
1922: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1923: ' AND ('||p_restrict_sql||')' ||
1924: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1989: SELECT 1 FROM HZ_STAGED_PARTIES p

1985: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22
1986: FROM HZ_STAGED_CONTACTS stage
1987: WHERE contains( concat_col, p_contains_str)>0
1988: AND EXISTS (
1989: SELECT 1 FROM HZ_STAGED_PARTIES p
1990: WHERE p.PARTY_ID = stage.PARTY_ID
1991: AND( (l_search_merged ='Y' )
1992: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1993: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 2012: SELECT 1 FROM HZ_STAGED_PARTIES p

2008: SELECT ORG_CONTACT_ID, PARTY_ID, TX22
2009: FROM HZ_STAGED_CONTACTS stage
2010: WHERE contains( concat_col, p_contains_str)>0
2011: AND EXISTS (
2012: SELECT 1 FROM HZ_STAGED_PARTIES p
2013: WHERE p.PARTY_ID = stage.PARTY_ID
2014: AND( (l_search_merged ='Y' )
2015: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2016: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2061: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX22'||
2062: ' FROM HZ_STAGED_CONTACTS stage'||
2063: ' WHERE contains( concat_col, :cont)>0'||
2064: ' AND EXISTS ('||
2065: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2066: ' WHERE p.party_id = stage.party_id ' ||
2067: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2068: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2069: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2206: SELECT 1 FROM HZ_STAGED_PARTIES p

2202: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2203: FROM HZ_STAGED_CONTACT_POINTS stage
2204: WHERE contains( concat_col, p_contains_str)>0
2205: AND EXISTS (
2206: SELECT 1 FROM HZ_STAGED_PARTIES p
2207: WHERE p.PARTY_ID = stage.PARTY_ID
2208: AND( (l_search_merged ='Y' )
2209: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2210: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2315: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2316: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2317: ' WHERE contains( concat_col, :cont)>0'||
2318: ' AND EXISTS ('||
2319: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2320: ' WHERE p.party_id = stage.party_id ' ||
2321: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2322: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2323: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2332: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2333: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2334: ' WHERE contains( concat_col, :cont)>0'||
2335: ' AND EXISTS ('||
2336: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2337: ' WHERE p.party_id = stage.party_id ' ||
2338: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2339: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2340: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2388: FROM hz_staged_parties

2384: END IF;
2385: IF p_restrict_sql IS NULL THEN
2386: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2387: SELECT p_search_ctx_id, PARTY_ID, 0
2388: FROM hz_staged_parties
2389: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2390: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2391: AND( (l_search_merged ='Y' )
2392: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2393: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2394: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2395: AND rownum <= p_thresh;
2396: ELSE
2397: l_sqlstr := 'INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE) SELECT :ctx_id, PARTY_ID, 0 FROM hz_staged_parties stage ';
2398: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2399: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2400: IF l_search_merged = 'N' THEN
2401: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';