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.

[Home] [Help]

APPS.HZ_MATCH_RULE_4 dependencies on HZ_STAGED_PARTY_SITES

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

1296: 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);
1297: END IF;
1298: IF p_search_rel_sites = 'N' THEN
1299: OPEN x_cursor FOR
1300: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1301: FROM HZ_STAGED_PARTY_SITES stage
1302: WHERE contains( concat_col, p_contains_str)>0
1303: AND( (l_search_merged ='Y' )
1304: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1301: FROM HZ_STAGED_PARTY_SITES stage

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

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

1305: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1306: AND stage.party_id = p_party_id;
1307: ELSE
1308: OPEN x_cursor FOR
1309: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1310: FROM HZ_STAGED_PARTY_SITES stage
1311: WHERE contains( concat_col, p_contains_str)>0
1312: AND( (l_search_merged ='Y' )
1313: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1310: FROM HZ_STAGED_PARTY_SITES stage

1306: AND stage.party_id = p_party_id;
1307: ELSE
1308: OPEN x_cursor FOR
1309: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1310: FROM HZ_STAGED_PARTY_SITES stage
1311: WHERE contains( concat_col, p_contains_str)>0
1312: AND( (l_search_merged ='Y' )
1313: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1314: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1313: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1314: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1315: AND stage.party_id = p_party_id
1316: UNION
1317: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1318: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1319: WHERE contains( concat_col, p_contains_str)>0
1320: AND( (l_search_merged ='Y' )
1321: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1314: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1315: AND stage.party_id = p_party_id
1316: UNION
1317: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1318: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1319: WHERE contains( concat_col, p_contains_str)>0
1320: AND( (l_search_merged ='Y' )
1321: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1322: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1340: FROM HZ_STAGED_PARTY_SITES stage

1336: 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);
1337: END IF;
1338: OPEN x_cursor FOR
1339: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1340: FROM HZ_STAGED_PARTY_SITES stage
1341: WHERE contains( concat_col, p_contains_str)>0
1342: AND EXISTS (
1343: SELECT 1 FROM HZ_STAGED_PARTIES p
1344: WHERE p.PARTY_ID = stage.PARTY_ID

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

1355: 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);
1356: END IF;
1357: IF p_person_api = 'Y' THEN
1358: OPEN x_cursor FOR
1359: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1360: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1361: WHERE contains( concat_col, p_contains_str)>0
1362: AND( (l_search_merged ='Y' )
1363: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1360: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1356: END IF;
1357: IF p_person_api = 'Y' THEN
1358: OPEN x_cursor FOR
1359: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1360: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1361: WHERE contains( concat_col, p_contains_str)>0
1362: AND( (l_search_merged ='Y' )
1363: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1364: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1365: AND d.search_context_id = p_search_ctx_id
1366: AND d.party_id = stage.party_id
1367: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1368: UNION
1369: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1370: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1371: WHERE contains( concat_col, p_contains_str)>0
1372: AND( (l_search_merged ='Y' )
1373: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1366: AND d.party_id = stage.party_id
1367: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1368: UNION
1369: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1370: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1371: WHERE contains( concat_col, p_contains_str)>0
1372: AND( (l_search_merged ='Y' )
1373: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1374: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1378: AND oc.org_contact_id = stage.org_contact_id
1379: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1380: ELSE
1381: OPEN x_cursor FOR
1382: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1384: WHERE contains( concat_col, p_contains_str)>0
1385: AND( (l_search_merged ='Y' )
1386: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1379: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1380: ELSE
1381: OPEN x_cursor FOR
1382: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1384: WHERE contains( concat_col, p_contains_str)>0
1385: AND( (l_search_merged ='Y' )
1386: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1387: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1399: IF (l_check_dt > 0 ) THEN
1400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1401: 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);
1402: END IF;
1403: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1404: ELSIF (l_check > 0 ) THEN
1405: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1406: 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);
1407: END IF;

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

1404: ELSIF (l_check > 0 ) THEN
1405: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1406: 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);
1407: END IF;
1408: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1409: END IF;
1410: IF l_search_merged = 'Y' THEN
1411: l_status_sql := ' ' ;
1412: ELSIF l_search_merged = 'I' THEN

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

1423: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1424: ELSE
1425: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1426: END IF;
1427: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1428: ' FROM HZ_STAGED_PARTY_SITES stage'||
1429: ' WHERE contains( concat_col, :cont)>0'||
1430: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1431: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1428: ' FROM HZ_STAGED_PARTY_SITES stage'||

1424: ELSE
1425: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1426: END IF;
1427: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1428: ' FROM HZ_STAGED_PARTY_SITES stage'||
1429: ' WHERE contains( concat_col, :cont)>0'||
1430: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1431: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1432: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1433: ' AND (ORG_CONTACT_ID IS NULL ' ||
1434: ' AND ('||p_restrict_sql||'))' ||
1435: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1436: ' UNION ' ||
1437: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ 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'')) '||

Line 1438: ' FROM HZ_STAGED_PARTY_SITES stage'||

1434: ' AND ('||p_restrict_sql||'))' ||
1435: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1436: ' UNION ' ||
1437: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ 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 1453: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1470: ' FROM HZ_STAGED_PARTY_SITES stage'||

1466: ,p_dup_party_id, p_dup_party_id;
1467: END IF;
1468: ELSE
1469: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1470: ' FROM HZ_STAGED_PARTY_SITES stage'||
1471: ' WHERE contains( concat_col, :cont)>0'||
1472: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1473: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1474: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_4 dependencies on HZ_STAGED_PARTY_SITES

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