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

Line 1841: FROM hz_staged_parties

1837: 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);
1838: END IF;
1839: OPEN x_cursor FOR
1840: SELECT PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47
1841: FROM hz_staged_parties
1842: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
1843: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
1844: AND( (l_search_merged ='Y' )
1845: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

Line 1852: l_sqlstr := 'SELECT PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47 FROM hz_staged_parties stage ';

1848: ELSE
1849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1850: 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);
1851: END IF;
1852: l_sqlstr := 'SELECT PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47 FROM hz_staged_parties stage ';
1853: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
1854: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
1855: IF l_search_merged = 'N' THEN
1856: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';

Line 2018: FROM HZ_STAGED_PARTIES stage

2014: 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);
2015: END IF;
2016: OPEN x_cursor FOR
2017: SELECT PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47
2018: FROM HZ_STAGED_PARTIES stage
2019: WHERE PARTY_ID = p_dup_party_id;
2020: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
2021: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2022: 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 2030: FROM HZ_STAGED_PARTIES stage

2026: 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);
2027: END IF;
2028: OPEN x_cursor FOR
2029: SELECT PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47
2030: FROM HZ_STAGED_PARTIES stage
2031: WHERE contains( concat_col, p_contains_str)>0
2032: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))
2033: AND( (l_search_merged ='Y' )
2034: OR (l_search_merged = 'I' AND nvl(stage.status, 'A') in ('A', 'I'))

Line 2042: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) / stage.PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47

2038: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2039: 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);
2040: END IF;
2041: OPEN x_cursor FOR
2042: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47
2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
2044: WHERE contains( concat_col, p_contains_str)>0
2045: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
2046: AND d.party_id = stage.party_id

Line 2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

2039: 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);
2040: END IF;
2041: OPEN x_cursor FOR
2042: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47
2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
2044: WHERE contains( concat_col, p_contains_str)>0
2045: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
2046: AND d.party_id = stage.party_id
2047: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

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

2058: IF (l_check > 0 ) THEN
2059: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2060: 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);
2061: END IF;
2062: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
2063: END IF;
2064: IF p_search_ctx_id IS NULL THEN
2065: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47'||
2066: ' FROM HZ_STAGED_PARTIES stage'||

Line 2066: ' FROM HZ_STAGED_PARTIES stage'||

2062: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTIES_U1) */';
2063: END IF;
2064: IF p_search_ctx_id IS NULL THEN
2065: l_sqlstr := 'SELECT ' || l_hint || ' PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47'||
2066: ' FROM HZ_STAGED_PARTIES stage'||
2067: ' WHERE contains( concat_col, :cont)>0'||
2068: ' AND ((:TX36 IS NULL OR :TX36||'' '' = stage.TX36))'||
2069: ' AND ('||p_restrict_sql||')' ||
2070: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 2185: SELECT 1 FROM HZ_STAGED_PARTIES p

2181: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2182: FROM HZ_STAGED_PARTY_SITES stage
2183: WHERE contains( concat_col, p_contains_str)>0
2184: AND EXISTS (
2185: SELECT 1 FROM HZ_STAGED_PARTIES p
2186: WHERE p.PARTY_ID = stage.PARTY_ID
2187: AND( (l_search_merged ='Y' )
2188: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2189: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2297: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2298: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2299: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2300: ' AND EXISTS ('||
2301: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2302: ' WHERE p.party_id = stage.party_id ' ||
2303: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2304: ' AND ('||get_adjusted_restrict_sql(p_restrict_sql)||')' ||
2305: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

2314: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2315: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2316: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2317: ' AND EXISTS ('||
2318: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2319: ' WHERE p.party_id = stage.party_id ' ||
2320: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2321: ' AND ('||p_restrict_sql||')' ||
2322: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 2387: SELECT 1 FROM HZ_STAGED_PARTIES p

2383: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
2384: FROM HZ_STAGED_CONTACTS stage
2385: WHERE contains( concat_col, p_contains_str)>0
2386: AND EXISTS (
2387: SELECT 1 FROM HZ_STAGED_PARTIES p
2388: WHERE p.PARTY_ID = stage.PARTY_ID
2389: AND( (l_search_merged ='Y' )
2390: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2391: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

Line 2410: SELECT 1 FROM HZ_STAGED_PARTIES p

2406: SELECT ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
2407: FROM HZ_STAGED_CONTACTS stage
2408: WHERE contains( concat_col, p_contains_str)>0
2409: AND EXISTS (
2410: SELECT 1 FROM HZ_STAGED_PARTIES p
2411: WHERE p.PARTY_ID = stage.PARTY_ID
2412: AND( (l_search_merged ='Y' )
2413: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2414: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2459: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX2, TX156, TX6, TX5'||
2460: ' FROM HZ_STAGED_CONTACTS stage'||
2461: ' WHERE contains( concat_col, :cont)>0'||
2462: ' AND EXISTS ('||
2463: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2464: ' WHERE p.party_id = stage.party_id ' ||
2465: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2466: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2467: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2604: SELECT 1 FROM HZ_STAGED_PARTIES p

2600: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2601: FROM HZ_STAGED_CONTACT_POINTS stage
2602: WHERE contains( concat_col, p_contains_str)>0
2603: AND EXISTS (
2604: SELECT 1 FROM HZ_STAGED_PARTIES p
2605: WHERE p.PARTY_ID = stage.PARTY_ID
2606: AND( (l_search_merged ='Y' )
2607: OR (l_search_merged = 'I' AND nvl(p.status, 'A') in ('A', 'I'))
2608: OR (l_search_merged = 'N' AND nvl(p.status, 'A') in ('A')) )

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

2713: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2714: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2715: ' WHERE contains( concat_col, :cont)>0'||
2716: ' AND EXISTS ('||
2717: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2718: ' WHERE p.party_id = stage.party_id ' ||
2719: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2720: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2721: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2730: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2731: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2732: ' WHERE contains( concat_col, :cont)>0'||
2733: ' AND EXISTS ('||
2734: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2735: ' WHERE p.party_id = stage.party_id ' ||
2736: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36)) '|| l_status_sql ||' ) ' ||
2737: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2738: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2786: FROM hz_staged_parties

2782: END IF;
2783: IF p_restrict_sql IS NULL THEN
2784: INSERT INTO HZ_MATCHED_PARTIES_GT (SEARCH_CONTEXT_ID, PARTY_ID, SCORE)
2785: SELECT p_search_ctx_id, PARTY_ID, decode(TX8,g_party_stage_rec.TX8||' ',100,90)
2786: FROM hz_staged_parties
2787: WHERE TX8 LIKE g_party_stage_rec.TX8||' %'
2788: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = TX36))
2789: AND( (l_search_merged ='Y' )
2790: OR (l_search_merged = 'I' AND nvl(status, 'A') in ('A', 'I'))

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

2791: OR (l_search_merged = 'N' AND nvl(status, 'A') in ('A')))
2792: AND (p_dup_party_id IS NULL OR party_id <> p_dup_party_id)
2793: AND rownum <= p_thresh;
2794: ELSE
2795: 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 ';
2796: l_sqlstr := l_sqlstr || ' WHERE TX8 like :TX8||'' %'' ';
2797: l_sqlstr := l_sqlstr || ' AND (:TX36 IS NULL OR :TX36||'' '' = TX36) ';
2798: IF l_search_merged = 'N' THEN
2799: l_sqlstr := l_sqlstr || ' AND nvl(status,''A'')=''A'' ';