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

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

1281: 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);
1282: END IF;
1283: IF p_search_rel_sites = 'N' THEN
1284: OPEN x_cursor FOR
1285: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1286: FROM HZ_STAGED_PARTY_SITES stage
1287: WHERE contains( concat_col, p_contains_str)>0
1288: AND( (l_search_merged ='Y' )
1289: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1286: FROM HZ_STAGED_PARTY_SITES stage

1282: END IF;
1283: IF p_search_rel_sites = 'N' THEN
1284: OPEN x_cursor FOR
1285: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1286: FROM HZ_STAGED_PARTY_SITES stage
1287: WHERE contains( concat_col, p_contains_str)>0
1288: AND( (l_search_merged ='Y' )
1289: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1290: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 1295: FROM HZ_STAGED_PARTY_SITES stage

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

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

1298: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1299: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1300: AND stage.party_id = p_party_id
1301: UNION
1302: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1303: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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, hz_relationships r, hz_org_contacts oc

1299: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1300: AND stage.party_id = p_party_id
1301: UNION
1302: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1303: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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 1325: FROM HZ_STAGED_PARTY_SITES stage

1321: 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);
1322: END IF;
1323: OPEN x_cursor FOR
1324: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1325: FROM HZ_STAGED_PARTY_SITES stage
1326: WHERE contains( concat_col, p_contains_str)>0
1327: AND EXISTS (
1328: SELECT 1 FROM HZ_STAGED_PARTIES p
1329: WHERE p.PARTY_ID = stage.PARTY_ID

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

1340: 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);
1341: END IF;
1342: IF p_person_api = 'Y' THEN
1343: OPEN x_cursor FOR
1344: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1346: WHERE contains( concat_col, p_contains_str)>0
1347: AND( (l_search_merged ='Y' )
1348: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1341: END IF;
1342: IF p_person_api = 'Y' THEN
1343: OPEN x_cursor FOR
1344: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1346: WHERE contains( concat_col, p_contains_str)>0
1347: AND( (l_search_merged ='Y' )
1348: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1349: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1350: AND d.search_context_id = p_search_ctx_id
1351: AND d.party_id = stage.party_id
1352: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1353: UNION
1354: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1355: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1356: WHERE contains( concat_col, p_contains_str)>0
1357: AND( (l_search_merged ='Y' )
1358: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1351: AND d.party_id = stage.party_id
1352: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1353: UNION
1354: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1355: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1356: WHERE contains( concat_col, p_contains_str)>0
1357: AND( (l_search_merged ='Y' )
1358: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1359: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1363: AND oc.org_contact_id = stage.org_contact_id
1364: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1365: ELSE
1366: OPEN x_cursor FOR
1367: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1368: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1369: WHERE contains( concat_col, p_contains_str)>0
1370: AND( (l_search_merged ='Y' )
1371: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1368: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1364: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1365: ELSE
1366: OPEN x_cursor FOR
1367: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1368: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1369: WHERE contains( concat_col, p_contains_str)>0
1370: AND( (l_search_merged ='Y' )
1371: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1372: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1384: IF (l_check_dt > 0 ) THEN
1385: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1386: 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);
1387: END IF;
1388: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1389: ELSIF (l_check > 0 ) THEN
1390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1391: 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);
1392: END IF;

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

1389: ELSIF (l_check > 0 ) THEN
1390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1391: 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);
1392: END IF;
1393: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1394: END IF;
1395: IF l_search_merged = 'Y' THEN
1396: l_status_sql := ' ' ;
1397: ELSIF l_search_merged = 'I' THEN

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

1408: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1409: ELSE
1410: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1411: END IF;
1412: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1413: ' FROM HZ_STAGED_PARTY_SITES stage'||
1414: ' WHERE contains( concat_col, :cont)>0'||
1415: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1416: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1413: ' FROM HZ_STAGED_PARTY_SITES stage'||

1409: ELSE
1410: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1411: END IF;
1412: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1413: ' FROM HZ_STAGED_PARTY_SITES stage'||
1414: ' WHERE contains( concat_col, :cont)>0'||
1415: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1416: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1417: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1418: ' AND (ORG_CONTACT_ID IS NULL ' ||
1419: ' AND ('||p_restrict_sql||'))' ||
1420: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1421: ' UNION ' ||
1422: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1423: ' FROM HZ_STAGED_PARTY_SITES stage'||
1424: ' WHERE contains( concat_col, :cont)>0'||
1425: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1426: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1423: ' FROM HZ_STAGED_PARTY_SITES stage'||

1419: ' AND ('||p_restrict_sql||'))' ||
1420: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1421: ' UNION ' ||
1422: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1423: ' FROM HZ_STAGED_PARTY_SITES stage'||
1424: ' WHERE contains( concat_col, :cont)>0'||
1425: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1426: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1427: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1438: ' FROM HZ_STAGED_PARTY_SITES stage'||

1434: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1435: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1436: ELSE
1437: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1438: ' FROM HZ_STAGED_PARTY_SITES stage'||
1439: ' WHERE contains( concat_col, :cont)>0'||
1440: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1441: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1442: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1455: ' FROM HZ_STAGED_PARTY_SITES stage'||

1451: ,p_dup_party_id, p_dup_party_id;
1452: END IF;
1453: ELSE
1454: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1455: ' FROM HZ_STAGED_PARTY_SITES stage'||
1456: ' WHERE contains( concat_col, :cont)>0'||
1457: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1458: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1459: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_39 dependencies on HZ_STAGED_PARTY_SITES

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