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

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

1185: 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);
1186: END IF;
1187: IF p_search_rel_sites = 'N' THEN
1188: OPEN x_cursor FOR
1189: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1190: FROM HZ_STAGED_PARTY_SITES stage
1191: WHERE contains( concat_col, p_contains_str)>0
1192: AND( (l_search_merged ='Y' )
1193: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1190: FROM HZ_STAGED_PARTY_SITES stage

1186: END IF;
1187: IF p_search_rel_sites = 'N' THEN
1188: OPEN x_cursor FOR
1189: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1190: FROM HZ_STAGED_PARTY_SITES stage
1191: WHERE contains( concat_col, p_contains_str)>0
1192: AND( (l_search_merged ='Y' )
1193: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1194: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1194: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1195: AND stage.party_id = p_party_id;
1196: ELSE
1197: OPEN x_cursor FOR
1198: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1199: FROM HZ_STAGED_PARTY_SITES stage
1200: WHERE contains( concat_col, p_contains_str)>0
1201: AND( (l_search_merged ='Y' )
1202: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1199: FROM HZ_STAGED_PARTY_SITES stage

1195: AND stage.party_id = p_party_id;
1196: ELSE
1197: OPEN x_cursor FOR
1198: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1199: FROM HZ_STAGED_PARTY_SITES stage
1200: WHERE contains( concat_col, p_contains_str)>0
1201: AND( (l_search_merged ='Y' )
1202: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1203: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1202: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1203: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1204: AND stage.party_id = p_party_id
1205: UNION
1206: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1207: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1208: WHERE contains( concat_col, p_contains_str)>0
1209: AND( (l_search_merged ='Y' )
1210: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1203: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1204: AND stage.party_id = p_party_id
1205: UNION
1206: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX3
1207: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1208: WHERE contains( concat_col, p_contains_str)>0
1209: AND( (l_search_merged ='Y' )
1210: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1211: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1229: FROM HZ_STAGED_PARTY_SITES stage

1225: 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);
1226: END IF;
1227: OPEN x_cursor FOR
1228: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1229: FROM HZ_STAGED_PARTY_SITES stage
1230: WHERE contains( concat_col, p_contains_str)>0
1231: AND EXISTS (
1232: SELECT 1 FROM HZ_STAGED_PARTIES p
1233: WHERE p.PARTY_ID = stage.PARTY_ID

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

1244: 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);
1245: END IF;
1246: IF p_person_api = 'Y' THEN
1247: OPEN x_cursor FOR
1248: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1249: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1250: WHERE contains( concat_col, p_contains_str)>0
1251: AND( (l_search_merged ='Y' )
1252: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1249: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1245: END IF;
1246: IF p_person_api = 'Y' THEN
1247: OPEN x_cursor FOR
1248: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1249: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1250: WHERE contains( concat_col, p_contains_str)>0
1251: AND( (l_search_merged ='Y' )
1252: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1253: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1254: AND d.search_context_id = p_search_ctx_id
1255: AND d.party_id = stage.party_id
1256: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1257: UNION
1258: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1259: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1260: WHERE contains( concat_col, p_contains_str)>0
1261: AND( (l_search_merged ='Y' )
1262: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1255: AND d.party_id = stage.party_id
1256: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1257: UNION
1258: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1259: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1260: WHERE contains( concat_col, p_contains_str)>0
1261: AND( (l_search_merged ='Y' )
1262: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1263: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1267: AND oc.org_contact_id = stage.org_contact_id
1268: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1269: ELSE
1270: OPEN x_cursor FOR
1271: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1272: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1273: WHERE contains( concat_col, p_contains_str)>0
1274: AND( (l_search_merged ='Y' )
1275: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1272: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1268: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1269: ELSE
1270: OPEN x_cursor FOR
1271: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1272: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1273: WHERE contains( concat_col, p_contains_str)>0
1274: AND( (l_search_merged ='Y' )
1275: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1276: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1288: IF (l_check_dt > 0 ) THEN
1289: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1290: 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);
1291: END IF;
1292: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1293: ELSIF (l_check > 0 ) THEN
1294: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1295: 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);
1296: END IF;

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

1293: ELSIF (l_check > 0 ) THEN
1294: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1295: 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);
1296: END IF;
1297: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1298: END IF;
1299: IF l_search_merged = 'Y' THEN
1300: l_status_sql := ' ' ;
1301: ELSIF l_search_merged = 'I' THEN

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

1312: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1313: ELSE
1314: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1315: END IF;
1316: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1317: ' FROM HZ_STAGED_PARTY_SITES stage'||
1318: ' WHERE contains( concat_col, :cont)>0'||
1319: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1320: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1317: ' FROM HZ_STAGED_PARTY_SITES stage'||

1313: ELSE
1314: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1315: END IF;
1316: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1317: ' FROM HZ_STAGED_PARTY_SITES stage'||
1318: ' WHERE contains( concat_col, :cont)>0'||
1319: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1320: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1321: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1322: ' AND (ORG_CONTACT_ID IS NULL ' ||
1323: ' AND ('||p_restrict_sql||'))' ||
1324: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1325: ' UNION ' ||
1326: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1327: ' FROM HZ_STAGED_PARTY_SITES stage'||
1328: ' WHERE contains( concat_col, :cont)>0'||
1329: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1330: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1327: ' FROM HZ_STAGED_PARTY_SITES stage'||

1323: ' AND ('||p_restrict_sql||'))' ||
1324: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1325: ' UNION ' ||
1326: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1327: ' FROM HZ_STAGED_PARTY_SITES stage'||
1328: ' WHERE contains( concat_col, :cont)>0'||
1329: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1330: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1331: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1342: ' FROM HZ_STAGED_PARTY_SITES stage'||

1338: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1339: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1340: ELSE
1341: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1342: ' FROM HZ_STAGED_PARTY_SITES stage'||
1343: ' WHERE contains( concat_col, :cont)>0'||
1344: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1345: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1346: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1359: ' FROM HZ_STAGED_PARTY_SITES stage'||

1355: ,p_dup_party_id, p_dup_party_id;
1356: END IF;
1357: ELSE
1358: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX3'||
1359: ' FROM HZ_STAGED_PARTY_SITES stage'||
1360: ' WHERE contains( concat_col, :cont)>0'||
1361: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1362: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1363: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_5 dependencies on HZ_STAGED_PARTY_SITES

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