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

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

1209: 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);
1210: END IF;
1211: IF p_search_rel_sites = 'N' THEN
1212: OPEN x_cursor FOR
1213: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1214: FROM HZ_STAGED_PARTY_SITES stage
1215: WHERE contains( concat_col, p_contains_str)>0
1216: AND( (l_search_merged ='Y' )
1217: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1214: FROM HZ_STAGED_PARTY_SITES stage

1210: END IF;
1211: IF p_search_rel_sites = 'N' THEN
1212: OPEN x_cursor FOR
1213: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1214: FROM HZ_STAGED_PARTY_SITES stage
1215: WHERE contains( concat_col, p_contains_str)>0
1216: AND( (l_search_merged ='Y' )
1217: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1218: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1218: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1219: AND stage.party_id = p_party_id;
1220: ELSE
1221: OPEN x_cursor FOR
1222: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1223: FROM HZ_STAGED_PARTY_SITES stage
1224: WHERE contains( concat_col, p_contains_str)>0
1225: AND( (l_search_merged ='Y' )
1226: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1223: FROM HZ_STAGED_PARTY_SITES stage

1219: AND stage.party_id = p_party_id;
1220: ELSE
1221: OPEN x_cursor FOR
1222: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1223: FROM HZ_STAGED_PARTY_SITES stage
1224: WHERE contains( concat_col, p_contains_str)>0
1225: AND( (l_search_merged ='Y' )
1226: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1227: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1226: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1227: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1228: AND stage.party_id = p_party_id
1229: UNION
1230: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1231: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1232: WHERE contains( concat_col, p_contains_str)>0
1233: AND( (l_search_merged ='Y' )
1234: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1227: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1228: AND stage.party_id = p_party_id
1229: UNION
1230: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1231: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1232: WHERE contains( concat_col, p_contains_str)>0
1233: AND( (l_search_merged ='Y' )
1234: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1235: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1253: FROM HZ_STAGED_PARTY_SITES stage

1249: 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);
1250: END IF;
1251: OPEN x_cursor FOR
1252: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1253: FROM HZ_STAGED_PARTY_SITES stage
1254: WHERE contains( concat_col, p_contains_str)>0
1255: AND EXISTS (
1256: SELECT 1 FROM HZ_STAGED_PARTIES p
1257: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1273: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1269: END IF;
1270: IF p_person_api = 'Y' THEN
1271: OPEN x_cursor FOR
1272: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1273: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1274: WHERE contains( concat_col, p_contains_str)>0
1275: AND( (l_search_merged ='Y' )
1276: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1277: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1278: AND d.search_context_id = p_search_ctx_id
1279: AND d.party_id = stage.party_id
1280: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1281: UNION
1282: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1283: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1284: WHERE contains( concat_col, p_contains_str)>0
1285: AND( (l_search_merged ='Y' )
1286: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1279: AND d.party_id = stage.party_id
1280: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1281: UNION
1282: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1283: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1284: WHERE contains( concat_col, p_contains_str)>0
1285: AND( (l_search_merged ='Y' )
1286: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1287: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1296: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1292: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1293: ELSE
1294: OPEN x_cursor FOR
1295: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1296: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1297: WHERE contains( concat_col, p_contains_str)>0
1298: AND( (l_search_merged ='Y' )
1299: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1300: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1312: IF (l_check_dt > 0 ) THEN
1313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1314: 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);
1315: END IF;
1316: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1317: ELSIF (l_check > 0 ) THEN
1318: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1319: 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);
1320: END IF;

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

1317: ELSIF (l_check > 0 ) THEN
1318: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1319: 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);
1320: END IF;
1321: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1322: END IF;
1323: IF l_search_merged = 'Y' THEN
1324: l_status_sql := ' ' ;
1325: ELSIF l_search_merged = 'I' THEN

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

1336: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1337: ELSE
1338: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1339: END IF;
1340: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1341: ' FROM HZ_STAGED_PARTY_SITES stage'||
1342: ' WHERE contains( concat_col, :cont)>0'||
1343: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1344: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1341: ' FROM HZ_STAGED_PARTY_SITES stage'||

1337: ELSE
1338: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1339: END IF;
1340: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1341: ' FROM HZ_STAGED_PARTY_SITES stage'||
1342: ' WHERE contains( concat_col, :cont)>0'||
1343: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1344: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1345: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1346: ' AND (ORG_CONTACT_ID IS NULL ' ||
1347: ' AND ('||p_restrict_sql||'))' ||
1348: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1349: ' UNION ' ||
1350: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1351: ' FROM HZ_STAGED_PARTY_SITES stage'||
1352: ' WHERE contains( concat_col, :cont)>0'||
1353: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1354: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1351: ' FROM HZ_STAGED_PARTY_SITES stage'||

1347: ' AND ('||p_restrict_sql||'))' ||
1348: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1349: ' UNION ' ||
1350: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1351: ' FROM HZ_STAGED_PARTY_SITES stage'||
1352: ' WHERE contains( concat_col, :cont)>0'||
1353: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1354: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1355: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1366: ' FROM HZ_STAGED_PARTY_SITES stage'||

1362: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1363: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1364: ELSE
1365: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1366: ' FROM HZ_STAGED_PARTY_SITES stage'||
1367: ' WHERE contains( concat_col, :cont)>0'||
1368: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1369: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1370: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1383: ' FROM HZ_STAGED_PARTY_SITES stage'||

1379: ,p_dup_party_id, p_dup_party_id;
1380: END IF;
1381: ELSE
1382: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1383: ' FROM HZ_STAGED_PARTY_SITES stage'||
1384: ' WHERE contains( concat_col, :cont)>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'') ) '||