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 1287: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3

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

Line 1288: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1297: FROM HZ_STAGED_PARTY_SITES stage

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

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

1300: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1301: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1302: AND stage.party_id = p_party_id
1303: UNION
1304: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1305: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1306: WHERE contains( concat_col, p_contains_str)>0
1307: AND( (l_search_merged ='Y' )
1308: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

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

Line 1327: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1347: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1370: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1366: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1367: ELSE
1368: OPEN x_cursor FOR
1369: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1370: FROM HZ_DQM_PARTIES_GT d, 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 1390: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

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

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

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

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

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

Line 1415: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1425: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1440: ' FROM HZ_STAGED_PARTY_SITES stage'||

1436: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1437: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1438: ELSE
1439: l_sqlstr := 'SELECT 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 1457: ' FROM HZ_STAGED_PARTY_SITES stage'||

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