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

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

1289: 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);
1290: END IF;
1291: IF p_search_rel_sites = 'N' THEN
1292: OPEN x_cursor FOR
1293: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3
1294: FROM HZ_STAGED_PARTY_SITES stage
1295: WHERE contains( concat_col, p_contains_str)>0
1296: AND( (l_search_merged ='Y' )
1297: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1294: FROM HZ_STAGED_PARTY_SITES stage

1290: END IF;
1291: IF p_search_rel_sites = 'N' THEN
1292: OPEN x_cursor FOR
1293: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3
1294: FROM HZ_STAGED_PARTY_SITES stage
1295: WHERE contains( concat_col, p_contains_str)>0
1296: AND( (l_search_merged ='Y' )
1297: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1298: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1298: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1299: AND stage.party_id = p_party_id;
1300: ELSE
1301: OPEN x_cursor FOR
1302: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3
1303: FROM HZ_STAGED_PARTY_SITES stage
1304: WHERE contains( concat_col, p_contains_str)>0
1305: AND( (l_search_merged ='Y' )
1306: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1303: FROM HZ_STAGED_PARTY_SITES stage

1299: AND stage.party_id = p_party_id;
1300: ELSE
1301: OPEN x_cursor FOR
1302: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3
1303: FROM HZ_STAGED_PARTY_SITES stage
1304: WHERE contains( concat_col, p_contains_str)>0
1305: AND( (l_search_merged ='Y' )
1306: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1307: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1306: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1307: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1308: AND stage.party_id = p_party_id
1309: UNION
1310: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3
1311: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1312: WHERE contains( concat_col, p_contains_str)>0
1313: AND( (l_search_merged ='Y' )
1314: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1307: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1308: AND stage.party_id = p_party_id
1309: UNION
1310: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3
1311: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1312: WHERE contains( concat_col, p_contains_str)>0
1313: AND( (l_search_merged ='Y' )
1314: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1315: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1333: FROM HZ_STAGED_PARTY_SITES stage

1329: 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);
1330: END IF;
1331: OPEN x_cursor FOR
1332: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3
1333: FROM HZ_STAGED_PARTY_SITES stage
1334: WHERE contains( concat_col, p_contains_str)>0
1335: AND EXISTS (
1336: SELECT 1 FROM HZ_STAGED_PARTIES p
1337: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1352: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3

1348: 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);
1349: END IF;
1350: IF p_person_api = 'Y' THEN
1351: OPEN x_cursor FOR
1352: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1354: WHERE contains( concat_col, p_contains_str)>0
1355: AND( (l_search_merged ='Y' )
1356: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1349: END IF;
1350: IF p_person_api = 'Y' THEN
1351: OPEN x_cursor FOR
1352: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1354: WHERE contains( concat_col, p_contains_str)>0
1355: AND( (l_search_merged ='Y' )
1356: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1357: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1358: AND d.search_context_id = p_search_ctx_id
1359: AND d.party_id = stage.party_id
1360: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1361: UNION
1362: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3
1363: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1364: WHERE contains( concat_col, p_contains_str)>0
1365: AND( (l_search_merged ='Y' )
1366: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1359: AND d.party_id = stage.party_id
1360: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1361: UNION
1362: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3
1363: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1364: WHERE contains( concat_col, p_contains_str)>0
1365: AND( (l_search_merged ='Y' )
1366: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1367: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1375: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3

1371: AND oc.org_contact_id = stage.org_contact_id
1372: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1373: ELSE
1374: OPEN x_cursor FOR
1375: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1376: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1377: WHERE contains( concat_col, p_contains_str)>0
1378: AND( (l_search_merged ='Y' )
1379: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1376: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1372: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1373: ELSE
1374: OPEN x_cursor FOR
1375: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1376: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1377: WHERE contains( concat_col, p_contains_str)>0
1378: AND( (l_search_merged ='Y' )
1379: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1380: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1392: IF (l_check_dt > 0 ) THEN
1393: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1394: 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);
1395: END IF;
1396: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1397: ELSIF (l_check > 0 ) THEN
1398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1399: 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);
1400: END IF;

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

1397: ELSIF (l_check > 0 ) THEN
1398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1399: 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);
1400: END IF;
1401: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1402: END IF;
1403: IF l_search_merged = 'Y' THEN
1404: l_status_sql := ' ' ;
1405: ELSIF l_search_merged = 'I' THEN

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

1416: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1417: ELSE
1418: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1419: END IF;
1420: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3'||
1421: ' FROM HZ_STAGED_PARTY_SITES stage'||
1422: ' WHERE contains( concat_col, :cont)>0'||
1423: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1424: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1421: ' FROM HZ_STAGED_PARTY_SITES stage'||

1417: ELSE
1418: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1419: END IF;
1420: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3'||
1421: ' FROM HZ_STAGED_PARTY_SITES stage'||
1422: ' WHERE contains( concat_col, :cont)>0'||
1423: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1424: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1425: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1426: ' AND (ORG_CONTACT_ID IS NULL ' ||
1427: ' AND ('||p_restrict_sql||'))' ||
1428: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1429: ' UNION ' ||
1430: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3'||
1431: ' FROM HZ_STAGED_PARTY_SITES stage'||
1432: ' WHERE contains( concat_col, :cont)>0'||
1433: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1434: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1431: ' FROM HZ_STAGED_PARTY_SITES stage'||

1427: ' AND ('||p_restrict_sql||'))' ||
1428: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1429: ' UNION ' ||
1430: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3'||
1431: ' FROM HZ_STAGED_PARTY_SITES stage'||
1432: ' WHERE contains( concat_col, :cont)>0'||
1433: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1434: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1435: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1446: ' FROM HZ_STAGED_PARTY_SITES stage'||

1442: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1443: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1444: ELSE
1445: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3'||
1446: ' FROM HZ_STAGED_PARTY_SITES stage'||
1447: ' WHERE contains( concat_col, :cont)>0'||
1448: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1449: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1450: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1463: ' FROM HZ_STAGED_PARTY_SITES stage'||

1459: ,p_dup_party_id, p_dup_party_id;
1460: END IF;
1461: ELSE
1462: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3'||
1463: ' FROM HZ_STAGED_PARTY_SITES stage'||
1464: ' WHERE contains( concat_col, :cont)>0'||
1465: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1466: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1467: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_2 dependencies on HZ_STAGED_PARTY_SITES

Line 1293: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3