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_240 dependencies on HZ_STAGED_PARTY_SITES

Line 1347: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11

1343: hz_utility_v2pub.debug(p_message=>'Single Party Scenario',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1344: END IF;
1345: IF p_search_rel_sites = 'N' THEN
1346: OPEN x_cursor FOR
1347: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1348: FROM HZ_STAGED_PARTY_SITES stage
1349: WHERE contains( concat_col, p_contains_str)>0
1350: AND( (l_search_merged ='Y' )
1351: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1348: FROM HZ_STAGED_PARTY_SITES stage

1344: END IF;
1345: IF p_search_rel_sites = 'N' THEN
1346: OPEN x_cursor FOR
1347: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1348: FROM HZ_STAGED_PARTY_SITES stage
1349: WHERE contains( concat_col, p_contains_str)>0
1350: AND( (l_search_merged ='Y' )
1351: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1352: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1356: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11

1352: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1353: AND stage.party_id = p_party_id;
1354: ELSE
1355: OPEN x_cursor FOR
1356: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1357: FROM HZ_STAGED_PARTY_SITES stage
1358: WHERE contains( concat_col, p_contains_str)>0
1359: AND( (l_search_merged ='Y' )
1360: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1357: FROM HZ_STAGED_PARTY_SITES stage

1353: AND stage.party_id = p_party_id;
1354: ELSE
1355: OPEN x_cursor FOR
1356: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1357: FROM HZ_STAGED_PARTY_SITES stage
1358: WHERE contains( concat_col, p_contains_str)>0
1359: AND( (l_search_merged ='Y' )
1360: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1361: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1364: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX11

1360: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1361: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1362: AND stage.party_id = p_party_id
1363: UNION
1364: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX11
1365: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1366: WHERE contains( concat_col, p_contains_str)>0
1367: AND( (l_search_merged ='Y' )
1368: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1365: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

1361: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1362: AND stage.party_id = p_party_id
1363: UNION
1364: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX11
1365: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1366: WHERE contains( concat_col, p_contains_str)>0
1367: AND( (l_search_merged ='Y' )
1368: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1369: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1387: FROM HZ_STAGED_PARTY_SITES stage

1383: 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);
1384: END IF;
1385: OPEN x_cursor FOR
1386: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1387: FROM HZ_STAGED_PARTY_SITES stage
1388: WHERE contains( concat_col, p_contains_str)>0
1389: AND EXISTS (
1390: SELECT 1 FROM HZ_STAGED_PARTIES p
1391: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1407: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1403: END IF;
1404: IF p_person_api = 'Y' THEN
1405: OPEN x_cursor FOR
1406: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1407: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1408: WHERE contains( concat_col, p_contains_str)>0
1409: AND( (l_search_merged ='Y' )
1410: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1411: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1416: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11

1412: AND d.search_context_id = p_search_ctx_id
1413: AND d.party_id = stage.party_id
1414: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1415: UNION
1416: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11
1417: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1418: WHERE contains( concat_col, p_contains_str)>0
1419: AND( (l_search_merged ='Y' )
1420: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1417: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1413: AND d.party_id = stage.party_id
1414: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1415: UNION
1416: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11
1417: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1418: WHERE contains( concat_col, p_contains_str)>0
1419: AND( (l_search_merged ='Y' )
1420: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1421: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1430: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1426: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1427: ELSE
1428: OPEN x_cursor FOR
1429: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1430: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1431: WHERE contains( concat_col, p_contains_str)>0
1432: AND( (l_search_merged ='Y' )
1433: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1434: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1450: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

1446: IF (l_check_dt > 0 ) THEN
1447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1448: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ps hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1449: END IF;
1450: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1451: ELSIF (l_check > 0 ) THEN
1452: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1453: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1454: END IF;

Line 1455: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) /';

1451: ELSIF (l_check > 0 ) THEN
1452: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1453: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1454: END IF;
1455: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1456: END IF;
1457: IF l_search_merged = 'Y' THEN
1458: l_status_sql := ' ' ;
1459: ELSIF l_search_merged = 'I' THEN

Line 1474: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||

1470: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1471: ELSE
1472: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1473: END IF;
1474: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1475: ' FROM HZ_STAGED_PARTY_SITES stage'||
1476: ' WHERE contains( concat_col, :cont)>0'||
1477: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1478: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1475: ' FROM HZ_STAGED_PARTY_SITES stage'||

1471: ELSE
1472: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1473: END IF;
1474: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1475: ' FROM HZ_STAGED_PARTY_SITES stage'||
1476: ' WHERE contains( concat_col, :cont)>0'||
1477: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1478: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1479: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1484: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||

1480: ' AND (ORG_CONTACT_ID IS NULL ' ||
1481: ' AND ('||p_restrict_sql||'))' ||
1482: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1483: ' UNION ' ||
1484: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1485: ' FROM HZ_STAGED_PARTY_SITES stage'||
1486: ' WHERE contains( concat_col, :cont)>0'||
1487: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1488: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1485: ' FROM HZ_STAGED_PARTY_SITES stage'||

1481: ' AND ('||p_restrict_sql||'))' ||
1482: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1483: ' UNION ' ||
1484: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1485: ' FROM HZ_STAGED_PARTY_SITES stage'||
1486: ' WHERE contains( concat_col, :cont)>0'||
1487: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1488: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1489: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1500: ' FROM HZ_STAGED_PARTY_SITES stage'||

1496: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1497: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1498: ELSE
1499: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1500: ' FROM HZ_STAGED_PARTY_SITES stage'||
1501: ' WHERE contains( concat_col, :cont)>0'||
1502: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1503: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1504: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1517: ' FROM HZ_STAGED_PARTY_SITES stage'||

1513: ,p_dup_party_id, p_dup_party_id;
1514: END IF;
1515: ELSE
1516: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1517: ' FROM HZ_STAGED_PARTY_SITES stage'||
1518: ' WHERE contains( concat_col, :cont)>0'||
1519: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1520: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1521: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||