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

Line 1689: FROM hz_staged_parties

1685: 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);
1686: END IF;
1687: OPEN x_cursor FOR
1688: SELECT PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39
1689: FROM hz_staged_parties
1690: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1691: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1692: AND( (l_search_merged ='Y' )
1693: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1700: l_sqlstr := 'SELECT PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39 FROM hz_staged_parties stage ';

1696: ELSE
1697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1698: 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);
1699: END IF;
1700: l_sqlstr := 'SELECT PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39 FROM hz_staged_parties stage ';
1701: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1702: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1703: IF l_search_merged = 'N' THEN
1704: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 1842: FROM HZ_STAGED_PARTIES stage

1838: 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);
1839: END IF;
1840: OPEN x_cursor FOR
1841: SELECT PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39
1842: FROM HZ_STAGED_PARTIES stage
1843: WHERE PARTY_ID = p_dup_party_id;
1844: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1846: 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 1854: FROM HZ_STAGED_PARTIES stage

1850: 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);
1851: END IF;
1852: OPEN x_cursor FOR
1853: SELECT PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39
1854: FROM HZ_STAGED_PARTIES stage
1855: WHERE contains( concat_col, p_contains_str)>0
1856: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
1857: AND( (l_search_merged ='Y' )
1858: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 1866: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39

1862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1863: 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);
1864: END IF;
1865: OPEN x_cursor FOR
1866: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39
1867: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1868: WHERE contains( concat_col, p_contains_str)>0
1869: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1870: AND d.party_id = stage.party_id

Line 1867: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1863: 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);
1864: END IF;
1865: OPEN x_cursor FOR
1866: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39
1867: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1868: WHERE contains( concat_col, p_contains_str)>0
1869: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1870: AND d.party_id = stage.party_id
1871: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

1882: IF (l_check > 0 ) THEN
1883: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1884: 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);
1885: END IF;
1886: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1887: END IF;
1888: IF p_search_ctx_id IS NULL THEN
1889: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39'||
1890: ' FROM HZ_STAGED_PARTIES stage'||

Line 1890: ' FROM HZ_STAGED_PARTIES stage'||

1886: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
1887: END IF;
1888: IF p_search_ctx_id IS NULL THEN
1889: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39'||
1890: ' FROM HZ_STAGED_PARTIES stage'||
1891: ' WHERE contains( concat_col, :cont)>0'||
1892: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
1893: ' AND ('||p_restrict_sql||')' ||
1894: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 2009: SELECT 1 FROM HZ_STAGED_PARTIES p

2005: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2006: FROM HZ_STAGED_PARTY_SITES stage
2007: WHERE contains( concat_col, p_contains_str)>0
2008: AND EXISTS (
2009: SELECT 1 FROM HZ_STAGED_PARTIES p
2010: WHERE p.PARTY_ID = stage.PARTY_ID
2011: AND( (l_search_merged ='Y' )
2012: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2013: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2121: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2122: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2123: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2124: ' AND EXISTS ('||
2125: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2126: ' WHERE p.party_id = stage.party_id ' ||
2127: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2128: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
2129: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

2138: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2139: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2140: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2141: ' AND EXISTS ('||
2142: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2143: ' WHERE p.party_id = stage.party_id ' ||
2144: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2145: ' AND ('||p_restrict_sql||')' ||
2146: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 2211: SELECT 1 FROM HZ_STAGED_PARTIES p

2207: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
2208: FROM HZ_STAGED_CONTACTS stage
2209: WHERE contains( concat_col, p_contains_str)>0
2210: AND EXISTS (
2211: SELECT 1 FROM HZ_STAGED_PARTIES p
2212: WHERE p.PARTY_ID = stage.PARTY_ID
2213: AND( (l_search_merged ='Y' )
2214: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2215: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 2234: SELECT 1 FROM HZ_STAGED_PARTIES p

2230: SELECT ORG_CONTACT_ID, PARTY_ID, TX6, TX5
2231: FROM HZ_STAGED_CONTACTS stage
2232: WHERE contains( concat_col, p_contains_str)>0
2233: AND EXISTS (
2234: SELECT 1 FROM HZ_STAGED_PARTIES p
2235: WHERE p.PARTY_ID = stage.PARTY_ID
2236: AND( (l_search_merged ='Y' )
2237: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2238: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2283: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX6, TX5'||
2284: ' FROM HZ_STAGED_CONTACTS stage'||
2285: ' WHERE contains( concat_col, :cont)>0'||
2286: ' AND EXISTS ('||
2287: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2288: ' WHERE p.party_id = stage.party_id ' ||
2289: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2290: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2291: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2428: SELECT 1 FROM HZ_STAGED_PARTIES p

2424: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2425: FROM HZ_STAGED_CONTACT_POINTS stage
2426: WHERE contains( concat_col, p_contains_str)>0
2427: AND EXISTS (
2428: SELECT 1 FROM HZ_STAGED_PARTIES p
2429: WHERE p.PARTY_ID = stage.PARTY_ID
2430: AND( (l_search_merged ='Y' )
2431: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2432: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2537: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2538: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2539: ' WHERE contains( concat_col, :cont)>0'||
2540: ' AND EXISTS ('||
2541: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2542: ' WHERE p.party_id = stage.party_id ' ||
2543: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2544: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2545: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2554: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2555: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2556: ' WHERE contains( concat_col, :cont)>0'||
2557: ' AND EXISTS ('||
2558: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2559: ' WHERE p.party_id = stage.party_id ' ||
2560: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2561: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2562: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2610: FROM hz_staged_parties

2606: END IF;
2607: IF p_restrict_sql IS NULL THEN
2608: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2609: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2610: FROM hz_staged_parties
2611: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2612: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2613: AND( (l_search_merged ='Y' )
2614: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2615: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2616: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2617: AND rownum <= p_thresh;
2618: ELSE
2619: 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 ';
2620: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2621: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2622: IF l_search_merged = 'N' THEN
2623: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';