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

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

1298: 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);
1299: END IF;
1300: IF p_search_rel_sites = 'N' THEN
1301: OPEN x_cursor FOR
1302: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, 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: END IF;
1300: IF p_search_rel_sites = 'N' THEN
1301: OPEN x_cursor FOR
1302: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, 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 1311: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3

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

Line 1312: FROM HZ_STAGED_PARTY_SITES stage

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

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

1315: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1316: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1317: AND stage.party_id = p_party_id
1318: UNION
1319: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1320: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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, hz_relationships r, hz_org_contacts oc

1316: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1317: AND stage.party_id = p_party_id
1318: UNION
1319: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1320: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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 1342: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1362: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1385: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1430: ' FROM HZ_STAGED_PARTY_SITES stage'||

1426: ELSE
1427: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1428: END IF;
1429: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1430: ' FROM HZ_STAGED_PARTY_SITES stage'||
1431: ' WHERE contains( concat_col, :cont)>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 1439: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||

1435: ' AND (ORG_CONTACT_ID IS NULL ' ||
1436: ' AND ('||p_restrict_sql||'))' ||
1437: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1438: ' UNION ' ||
1439: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1440: ' FROM HZ_STAGED_PARTY_SITES stage'||
1441: ' WHERE contains( concat_col, :cont)>0'||
1442: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1443: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1440: ' FROM HZ_STAGED_PARTY_SITES stage'||

1436: ' AND ('||p_restrict_sql||'))' ||
1437: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1438: ' UNION ' ||
1439: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1440: ' FROM HZ_STAGED_PARTY_SITES stage'||
1441: ' WHERE contains( concat_col, :cont)>0'||
1442: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1443: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1444: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1455: ' FROM HZ_STAGED_PARTY_SITES stage'||

1451: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1452: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1453: ELSE
1454: l_sqlstr := 'SELECT 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'') ) '||

Line 1472: ' FROM HZ_STAGED_PARTY_SITES stage'||

1468: ,p_dup_party_id, p_dup_party_id;
1469: END IF;
1470: ELSE
1471: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
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'') ) '||