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

Line 1319: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID

1315: 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);
1316: END IF;
1317: IF p_search_rel_sites = 'N' THEN
1318: OPEN x_cursor FOR
1319: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1320: FROM HZ_STAGED_PARTY_SITES stage
1321: WHERE contains( concat_col, p_contains_str)>0
1322: AND( (l_search_merged ='Y' )
1323: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1320: FROM HZ_STAGED_PARTY_SITES stage

1316: END IF;
1317: IF p_search_rel_sites = 'N' THEN
1318: OPEN x_cursor FOR
1319: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1320: FROM HZ_STAGED_PARTY_SITES stage
1321: WHERE contains( concat_col, p_contains_str)>0
1322: AND( (l_search_merged ='Y' )
1323: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1324: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1328: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID

1324: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1325: AND stage.party_id = p_party_id;
1326: ELSE
1327: OPEN x_cursor FOR
1328: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1329: FROM HZ_STAGED_PARTY_SITES stage
1330: WHERE contains( concat_col, p_contains_str)>0
1331: AND( (l_search_merged ='Y' )
1332: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1329: FROM HZ_STAGED_PARTY_SITES stage

1325: AND stage.party_id = p_party_id;
1326: ELSE
1327: OPEN x_cursor FOR
1328: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1329: FROM HZ_STAGED_PARTY_SITES stage
1330: WHERE contains( concat_col, p_contains_str)>0
1331: AND( (l_search_merged ='Y' )
1332: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1333: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1336: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID

1332: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1333: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1334: AND stage.party_id = p_party_id
1335: UNION
1336: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1337: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1338: WHERE contains( concat_col, p_contains_str)>0
1339: AND( (l_search_merged ='Y' )
1340: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1333: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1334: AND stage.party_id = p_party_id
1335: UNION
1336: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1337: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1338: WHERE contains( concat_col, p_contains_str)>0
1339: AND( (l_search_merged ='Y' )
1340: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1341: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1359: FROM HZ_STAGED_PARTY_SITES stage

1355: 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);
1356: END IF;
1357: OPEN x_cursor FOR
1358: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1359: FROM HZ_STAGED_PARTY_SITES stage
1360: WHERE contains( concat_col, p_contains_str)>0
1361: AND EXISTS (
1362: SELECT 1 FROM HZ_STAGED_PARTIES p
1363: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1379: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1375: END IF;
1376: IF p_person_api = 'Y' THEN
1377: OPEN x_cursor FOR
1378: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1379: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1380: WHERE contains( concat_col, p_contains_str)>0
1381: AND( (l_search_merged ='Y' )
1382: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1383: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1384: AND d.search_context_id = p_search_ctx_id
1385: AND d.party_id = stage.party_id
1386: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1387: UNION
1388: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1389: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1390: WHERE contains( concat_col, p_contains_str)>0
1391: AND( (l_search_merged ='Y' )
1392: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1385: AND d.party_id = stage.party_id
1386: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1387: UNION
1388: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1389: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1390: WHERE contains( concat_col, p_contains_str)>0
1391: AND( (l_search_merged ='Y' )
1392: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1393: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1402: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1398: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1399: ELSE
1400: OPEN x_cursor FOR
1401: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1402: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1403: WHERE contains( concat_col, p_contains_str)>0
1404: AND( (l_search_merged ='Y' )
1405: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1406: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1418: IF (l_check_dt > 0 ) THEN
1419: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1420: 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);
1421: END IF;
1422: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1423: ELSIF (l_check > 0 ) THEN
1424: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1425: 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);
1426: END IF;

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

1423: ELSIF (l_check > 0 ) THEN
1424: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1425: 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);
1426: END IF;
1427: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1428: END IF;
1429: IF l_search_merged = 'Y' THEN
1430: l_status_sql := ' ' ;
1431: ELSIF l_search_merged = 'I' THEN

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

1442: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1443: ELSE
1444: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1445: END IF;
1446: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1447: ' FROM HZ_STAGED_PARTY_SITES stage'||
1448: ' WHERE contains( concat_col, :cont)>0'||
1449: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1450: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1447: ' FROM HZ_STAGED_PARTY_SITES stage'||

1443: ELSE
1444: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1445: END IF;
1446: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1447: ' FROM HZ_STAGED_PARTY_SITES stage'||
1448: ' WHERE contains( concat_col, :cont)>0'||
1449: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1450: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1451: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1452: ' AND (ORG_CONTACT_ID IS NULL ' ||
1453: ' AND ('||p_restrict_sql||'))' ||
1454: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1455: ' UNION ' ||
1456: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1457: ' FROM HZ_STAGED_PARTY_SITES stage'||
1458: ' WHERE contains( concat_col, :cont)>0'||
1459: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1460: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1457: ' FROM HZ_STAGED_PARTY_SITES stage'||

1453: ' AND ('||p_restrict_sql||'))' ||
1454: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1455: ' UNION ' ||
1456: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1457: ' FROM HZ_STAGED_PARTY_SITES stage'||
1458: ' WHERE contains( concat_col, :cont)>0'||
1459: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1460: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1461: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1472: ' FROM HZ_STAGED_PARTY_SITES stage'||

1468: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1469: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1470: ELSE
1471: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1472: ' FROM HZ_STAGED_PARTY_SITES stage'||
1473: ' WHERE contains( concat_col, :cont)>0'||
1474: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1475: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1476: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1489: ' FROM HZ_STAGED_PARTY_SITES stage'||

1485: ,p_dup_party_id, p_dup_party_id;
1486: END IF;
1487: ELSE
1488: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1489: ' FROM HZ_STAGED_PARTY_SITES stage'||
1490: ' WHERE contains( concat_col, :cont)>0'||
1491: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1492: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1493: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||