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

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

1455: 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);
1456: END IF;
1457: IF p_search_rel_sites = 'N' THEN
1458: OPEN x_cursor FOR
1459: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1460: FROM HZ_STAGED_PARTY_SITES stage
1461: WHERE contains( concat_col, p_contains_str)>0
1462: AND( (l_search_merged ='Y' )
1463: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1460: FROM HZ_STAGED_PARTY_SITES stage

1456: END IF;
1457: IF p_search_rel_sites = 'N' THEN
1458: OPEN x_cursor FOR
1459: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1460: FROM HZ_STAGED_PARTY_SITES stage
1461: WHERE contains( concat_col, p_contains_str)>0
1462: AND( (l_search_merged ='Y' )
1463: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1464: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1464: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1465: AND stage.party_id = p_party_id;
1466: ELSE
1467: OPEN x_cursor FOR
1468: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1469: FROM HZ_STAGED_PARTY_SITES stage
1470: WHERE contains( concat_col, p_contains_str)>0
1471: AND( (l_search_merged ='Y' )
1472: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1469: FROM HZ_STAGED_PARTY_SITES stage

1465: AND stage.party_id = p_party_id;
1466: ELSE
1467: OPEN x_cursor FOR
1468: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1469: FROM HZ_STAGED_PARTY_SITES stage
1470: WHERE contains( concat_col, p_contains_str)>0
1471: AND( (l_search_merged ='Y' )
1472: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1473: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1472: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1473: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1474: AND stage.party_id = p_party_id
1475: UNION
1476: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1477: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1478: WHERE contains( concat_col, p_contains_str)>0
1479: AND( (l_search_merged ='Y' )
1480: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1473: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1474: AND stage.party_id = p_party_id
1475: UNION
1476: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1477: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1478: WHERE contains( concat_col, p_contains_str)>0
1479: AND( (l_search_merged ='Y' )
1480: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1481: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1499: FROM HZ_STAGED_PARTY_SITES stage

1495: 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);
1496: END IF;
1497: OPEN x_cursor FOR
1498: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1499: FROM HZ_STAGED_PARTY_SITES stage
1500: WHERE contains( concat_col, p_contains_str)>0
1501: AND EXISTS (
1502: SELECT 1 FROM HZ_STAGED_PARTIES p
1503: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1519: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1515: END IF;
1516: IF p_person_api = 'Y' THEN
1517: OPEN x_cursor FOR
1518: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1519: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1520: WHERE contains( concat_col, p_contains_str)>0
1521: AND( (l_search_merged ='Y' )
1522: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1523: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1524: AND d.search_context_id = p_search_ctx_id
1525: AND d.party_id = stage.party_id
1526: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1527: UNION
1528: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1529: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1530: WHERE contains( concat_col, p_contains_str)>0
1531: AND( (l_search_merged ='Y' )
1532: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1525: AND d.party_id = stage.party_id
1526: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1527: UNION
1528: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1529: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1530: WHERE contains( concat_col, p_contains_str)>0
1531: AND( (l_search_merged ='Y' )
1532: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1533: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1538: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1539: ELSE
1540: OPEN x_cursor FOR
1541: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1543: WHERE contains( concat_col, p_contains_str)>0
1544: AND( (l_search_merged ='Y' )
1545: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1546: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1558: IF (l_check_dt > 0 ) THEN
1559: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1560: 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);
1561: END IF;
1562: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1563: ELSIF (l_check > 0 ) THEN
1564: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1565: 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);
1566: END IF;

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

1563: ELSIF (l_check > 0 ) THEN
1564: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1565: 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);
1566: END IF;
1567: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1568: END IF;
1569: IF l_search_merged = 'Y' THEN
1570: l_status_sql := ' ' ;
1571: ELSIF l_search_merged = 'I' THEN

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

1582: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1583: ELSE
1584: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1585: END IF;
1586: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1587: ' FROM HZ_STAGED_PARTY_SITES stage'||
1588: ' WHERE contains( concat_col, :cont)>0'||
1589: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1590: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1587: ' FROM HZ_STAGED_PARTY_SITES stage'||

1583: ELSE
1584: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1585: END IF;
1586: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1587: ' FROM HZ_STAGED_PARTY_SITES stage'||
1588: ' WHERE contains( concat_col, :cont)>0'||
1589: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1590: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1591: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1592: ' AND (ORG_CONTACT_ID IS NULL ' ||
1593: ' AND ('||p_restrict_sql||'))' ||
1594: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1595: ' UNION ' ||
1596: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1597: ' FROM HZ_STAGED_PARTY_SITES stage'||
1598: ' WHERE contains( concat_col, :cont)>0'||
1599: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1600: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1597: ' FROM HZ_STAGED_PARTY_SITES stage'||

1593: ' AND ('||p_restrict_sql||'))' ||
1594: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1595: ' UNION ' ||
1596: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1597: ' FROM HZ_STAGED_PARTY_SITES stage'||
1598: ' WHERE contains( concat_col, :cont)>0'||
1599: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1600: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1601: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1612: ' FROM HZ_STAGED_PARTY_SITES stage'||

1608: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1609: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1610: ELSE
1611: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1612: ' FROM HZ_STAGED_PARTY_SITES stage'||
1613: ' WHERE contains( concat_col, :cont)>0'||
1614: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1615: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1616: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1629: ' FROM HZ_STAGED_PARTY_SITES stage'||

1625: ,p_dup_party_id, p_dup_party_id;
1626: END IF;
1627: ELSE
1628: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1629: ' FROM HZ_STAGED_PARTY_SITES stage'||
1630: ' WHERE contains( concat_col, :cont)>0'||
1631: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1632: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1633: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||