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

Line 1498: FROM hz_staged_parties

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

Line 1509: l_sqlstr := 'SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)) FROM hz_staged_parties stage ';

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

Line 1630: FROM HZ_STAGED_PARTIES stage

1626: 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);
1627: END IF;
1628: OPEN x_cursor FOR
1629: SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))
1630: FROM HZ_STAGED_PARTIES stage
1631: WHERE PARTY_ID = p_dup_party_id;
1632: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1634: 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 1642: FROM HZ_STAGED_PARTIES stage

1638: 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);
1639: END IF;
1640: OPEN x_cursor FOR
1641: SELECT PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))
1642: FROM HZ_STAGED_PARTIES stage
1643: WHERE contains( concat_col, p_contains_str)>0
1644: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1645: AND( (l_search_merged ='Y' )
1646: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1654: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))

1650: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1651: 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);
1652: END IF;
1653: OPEN x_cursor FOR
1654: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))
1655: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1656: WHERE contains( concat_col, p_contains_str)>0
1657: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1658: AND d.party_id = stage.party_id

Line 1655: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1651: 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);
1652: END IF;
1653: OPEN x_cursor FOR
1654: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))
1655: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1656: WHERE contains( concat_col, p_contains_str)>0
1657: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1658: AND d.party_id = stage.party_id
1659: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1670: IF (l_check > 0 ) THEN
1671: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1672: 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);
1673: END IF;
1674: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1675: END IF;
1676: IF p_search_ctx_id IS NULL THEN
1677: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))'||
1678: ' FROM HZ_STAGED_PARTIES stage'||

Line 1678: ' FROM HZ_STAGED_PARTIES stage'||

1674: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1675: END IF;
1676: IF p_search_ctx_id IS NULL THEN
1677: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))'||
1678: ' FROM HZ_STAGED_PARTIES stage'||
1679: ' WHERE contains( concat_col, :cont)>0'||
1680: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1681: ' AND ('||p_restrict_sql||')' ||
1682: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1797: SELECT 1 FROM HZ_STAGED_PARTIES p

1793: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1794: FROM HZ_STAGED_PARTY_SITES stage
1795: WHERE contains( concat_col, p_contains_str)>0
1796: AND EXISTS (
1797: SELECT 1 FROM HZ_STAGED_PARTIES p
1798: WHERE p.PARTY_ID = stage.PARTY_ID
1799: AND( (l_search_merged ='Y' )
1800: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
1801: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

1909: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1910: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1911: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
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 ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
1917: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1926: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1927: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1928: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1929: ' AND EXISTS ('||
1930: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1931: ' WHERE p.party_id = stage.party_id ' ||
1932: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
1933: ' AND ('||p_restrict_sql||')' ||
1934: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 1999: SELECT 1 FROM HZ_STAGED_PARTIES p

1995: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
1996: FROM HZ_STAGED_CONTACTS stage
1997: WHERE contains( concat_col, p_contains_str)>0
1998: AND EXISTS (
1999: SELECT 1 FROM HZ_STAGED_PARTIES p
2000: WHERE p.PARTY_ID = stage.PARTY_ID
2001: AND( (l_search_merged ='Y' )
2002: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2003: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 2022: SELECT 1 FROM HZ_STAGED_PARTIES p

2018: SELECT ORG_CONTACT_ID, PARTY_ID, TX6, TX5
2019: FROM HZ_STAGED_CONTACTS stage
2020: WHERE contains( concat_col, p_contains_str)>0
2021: AND EXISTS (
2022: SELECT 1 FROM HZ_STAGED_PARTIES p
2023: WHERE p.PARTY_ID = stage.PARTY_ID
2024: AND( (l_search_merged ='Y' )
2025: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2026: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2071: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX6, TX5'||
2072: ' FROM HZ_STAGED_CONTACTS stage'||
2073: ' WHERE contains( concat_col, :cont)>0'||
2074: ' AND EXISTS ('||
2075: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2076: ' WHERE p.party_id = stage.party_id ' ||
2077: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2078: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2079: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2216: SELECT 1 FROM HZ_STAGED_PARTIES p

2212: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2213: FROM HZ_STAGED_CONTACT_POINTS stage
2214: WHERE contains( concat_col, p_contains_str)>0
2215: AND EXISTS (
2216: SELECT 1 FROM HZ_STAGED_PARTIES p
2217: WHERE p.PARTY_ID = stage.PARTY_ID
2218: AND( (l_search_merged ='Y' )
2219: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2220: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2325: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8'||
2326: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2327: ' WHERE contains( concat_col, :cont)>0'||
2328: ' AND EXISTS ('||
2329: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2330: ' WHERE p.party_id = stage.party_id ' ||
2331: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2332: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2333: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2342: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8'||
2343: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2344: ' WHERE contains( concat_col, :cont)>0'||
2345: ' AND EXISTS ('||
2346: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2347: ' WHERE p.party_id = stage.party_id ' ||
2348: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2349: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2350: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2398: FROM hz_staged_parties

2394: END IF;
2395: IF p_restrict_sql IS NULL THEN
2396: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2397: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2398: FROM hz_staged_parties
2399: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2400: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2401: AND( (l_search_merged ='Y' )
2402: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2403: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2404: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2405: AND rownum <= p_thresh;
2406: ELSE
2407: 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 ';
2408: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2409: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2410: IF l_search_merged = 'N' THEN
2411: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';