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

Line 1407: FROM hz_staged_parties

1403: 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);
1404: END IF;
1405: OPEN x_cursor FOR
1406: SELECT PARTY_ID , TX34, TX39, TX40
1407: FROM hz_staged_parties
1408: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1409: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1410: AND( (l_search_merged ='Y' )
1411: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

1414: ELSE
1415: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1416: 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);
1417: END IF;
1418: l_sqlstr := 'SELECT PARTY_ID , TX34, TX39, TX40 FROM hz_staged_parties stage ';
1419: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1420: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1421: IF l_search_merged = 'N' THEN
1422: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1567: FROM HZ_STAGED_PARTIES stage

1563: 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);
1564: END IF;
1565: OPEN x_cursor FOR
1566: SELECT PARTY_ID , TX34, TX39, TX40
1567: FROM HZ_STAGED_PARTIES stage
1568: WHERE PARTY_ID = p_dup_party_id;
1569: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1570: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1571: 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 1579: FROM HZ_STAGED_PARTIES stage

1575: 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);
1576: END IF;
1577: OPEN x_cursor FOR
1578: SELECT PARTY_ID , TX34, TX39, TX40
1579: FROM HZ_STAGED_PARTIES stage
1580: WHERE contains( concat_col, p_contains_str)>0
1581: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1582: AND( (l_search_merged ='Y' )
1583: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

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

1587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1588: 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);
1589: END IF;
1590: OPEN x_cursor FOR
1591: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX39, TX40
1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1593: WHERE contains( concat_col, p_contains_str)>0
1594: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1595: AND d.party_id = stage.party_id

Line 1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1588: 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);
1589: END IF;
1590: OPEN x_cursor FOR
1591: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX39, TX40
1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1593: WHERE contains( concat_col, p_contains_str)>0
1594: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1595: AND d.party_id = stage.party_id
1596: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1607: IF (l_check > 0 ) THEN
1608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1609: 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);
1610: END IF;
1611: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1612: END IF;
1613: IF p_search_ctx_id IS NULL THEN
1614: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX34, TX39, TX40'||
1615: ' FROM HZ_STAGED_PARTIES stage'||

Line 1615: ' FROM HZ_STAGED_PARTIES stage'||

1611: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1612: END IF;
1613: IF p_search_ctx_id IS NULL THEN
1614: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX34, TX39, TX40'||
1615: ' FROM HZ_STAGED_PARTIES stage'||
1616: ' WHERE contains( concat_col, :cont)>0'||
1617: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1618: ' AND ('||p_restrict_sql||')' ||
1619: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1734: SELECT 1 FROM HZ_STAGED_PARTIES p

1730: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1731: FROM HZ_STAGED_PARTY_SITES stage
1732: WHERE contains( concat_col, p_contains_str)>0
1733: AND EXISTS (
1734: SELECT 1 FROM HZ_STAGED_PARTIES p
1735: WHERE p.PARTY_ID = stage.PARTY_ID
1736: AND( (l_search_merged ='Y' )
1737: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1738: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1846: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1847: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1848: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1849: ' AND EXISTS ('||
1850: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1851: ' WHERE p.party_id = stage.party_id ' ||
1852: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1853: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1854: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1863: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1864: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1865: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1866: ' AND EXISTS ('||
1867: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1868: ' WHERE p.party_id = stage.party_id ' ||
1869: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1870: ' AND ('||p_restrict_sql||')' ||
1871: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1936: SELECT 1 FROM HZ_STAGED_PARTIES p

1932: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1933: FROM HZ_STAGED_CONTACTS stage
1934: WHERE contains( concat_col, p_contains_str)>0
1935: AND EXISTS (
1936: SELECT 1 FROM HZ_STAGED_PARTIES p
1937: WHERE p.PARTY_ID = stage.PARTY_ID
1938: AND( (l_search_merged ='Y' )
1939: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1940: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 1959: SELECT 1 FROM HZ_STAGED_PARTIES p

1955: SELECT ORG_CONTACT_ID, PARTY_ID
1956: FROM HZ_STAGED_CONTACTS stage
1957: WHERE contains( concat_col, p_contains_str)>0
1958: AND EXISTS (
1959: SELECT 1 FROM HZ_STAGED_PARTIES p
1960: WHERE p.PARTY_ID = stage.PARTY_ID
1961: AND( (l_search_merged ='Y' )
1962: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1963: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2008: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
2009: ' FROM HZ_STAGED_CONTACTS stage'||
2010: ' WHERE contains( concat_col, :cont)>0'||
2011: ' AND EXISTS ('||
2012: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2013: ' WHERE p.party_id = stage.party_id ' ||
2014: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2015: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2016: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2153: SELECT 1 FROM HZ_STAGED_PARTIES p

2149: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2150: FROM HZ_STAGED_CONTACT_POINTS stage
2151: WHERE contains( concat_col, p_contains_str)>0
2152: AND EXISTS (
2153: SELECT 1 FROM HZ_STAGED_PARTIES p
2154: WHERE p.PARTY_ID = stage.PARTY_ID
2155: AND( (l_search_merged ='Y' )
2156: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2157: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2262: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2263: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2264: ' WHERE contains( concat_col, :cont)>0'||
2265: ' AND EXISTS ('||
2266: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2267: ' WHERE p.party_id = stage.party_id ' ||
2268: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2269: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2270: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2279: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2280: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2281: ' WHERE contains( concat_col, :cont)>0'||
2282: ' AND EXISTS ('||
2283: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2284: ' WHERE p.party_id = stage.party_id ' ||
2285: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2286: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2287: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2335: FROM hz_staged_parties

2331: END IF;
2332: IF p_restrict_sql IS NULL THEN
2333: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2334: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2335: FROM hz_staged_parties
2336: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2337: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2338: AND( (l_search_merged ='Y' )
2339: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2340: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2341: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2342: AND rownum <= p_thresh;
2343: ELSE
2344: 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 ';
2345: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2346: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2347: IF l_search_merged = 'N' THEN
2348: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';