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

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

Line 1192: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1201: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1231: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1251: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1274: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1319: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1329: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1344: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1361: ' FROM HZ_STAGED_PARTY_SITES stage'||

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