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

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

1538: 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);
1539: END IF;
1540: IF p_search_rel_sites = 'N' THEN
1541: OPEN x_cursor FOR
1542: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1543: FROM HZ_STAGED_PARTY_SITES stage
1544: WHERE contains( concat_col, p_contains_str)>0
1545: AND( (l_search_merged ='Y' )
1546: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1543: FROM HZ_STAGED_PARTY_SITES stage

1539: END IF;
1540: IF p_search_rel_sites = 'N' THEN
1541: OPEN x_cursor FOR
1542: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1543: FROM HZ_STAGED_PARTY_SITES stage
1544: WHERE contains( concat_col, p_contains_str)>0
1545: AND( (l_search_merged ='Y' )
1546: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1547: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1547: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1548: AND stage.party_id = p_party_id;
1549: ELSE
1550: OPEN x_cursor FOR
1551: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1552: FROM HZ_STAGED_PARTY_SITES stage
1553: WHERE contains( concat_col, p_contains_str)>0
1554: AND( (l_search_merged ='Y' )
1555: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1552: FROM HZ_STAGED_PARTY_SITES stage

1548: AND stage.party_id = p_party_id;
1549: ELSE
1550: OPEN x_cursor FOR
1551: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1552: FROM HZ_STAGED_PARTY_SITES stage
1553: WHERE contains( concat_col, p_contains_str)>0
1554: AND( (l_search_merged ='Y' )
1555: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1556: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1555: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1556: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1557: AND stage.party_id = p_party_id
1558: UNION
1559: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1560: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1561: WHERE contains( concat_col, p_contains_str)>0
1562: AND( (l_search_merged ='Y' )
1563: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1556: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1557: AND stage.party_id = p_party_id
1558: UNION
1559: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1560: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1561: WHERE contains( concat_col, p_contains_str)>0
1562: AND( (l_search_merged ='Y' )
1563: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1564: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1582: FROM HZ_STAGED_PARTY_SITES stage

1578: 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);
1579: END IF;
1580: OPEN x_cursor FOR
1581: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1582: FROM HZ_STAGED_PARTY_SITES stage
1583: WHERE contains( concat_col, p_contains_str)>0
1584: AND EXISTS (
1585: SELECT 1 FROM HZ_STAGED_PARTIES p
1586: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1598: END IF;
1599: IF p_person_api = 'Y' THEN
1600: OPEN x_cursor FOR
1601: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1603: WHERE contains( concat_col, p_contains_str)>0
1604: AND( (l_search_merged ='Y' )
1605: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1606: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1607: AND d.search_context_id = p_search_ctx_id
1608: AND d.party_id = stage.party_id
1609: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1610: UNION
1611: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1612: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1613: WHERE contains( concat_col, p_contains_str)>0
1614: AND( (l_search_merged ='Y' )
1615: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1608: AND d.party_id = stage.party_id
1609: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1610: UNION
1611: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1612: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1613: WHERE contains( concat_col, p_contains_str)>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 1625: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1621: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1622: ELSE
1623: OPEN x_cursor FOR
1624: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1625: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1626: WHERE contains( concat_col, p_contains_str)>0
1627: AND( (l_search_merged ='Y' )
1628: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1629: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1641: IF (l_check_dt > 0 ) THEN
1642: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1643: 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);
1644: END IF;
1645: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1646: ELSIF (l_check > 0 ) THEN
1647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1648: 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);
1649: END IF;

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

1646: ELSIF (l_check > 0 ) THEN
1647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1648: 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);
1649: END IF;
1650: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1651: END IF;
1652: IF l_search_merged = 'Y' THEN
1653: l_status_sql := ' ' ;
1654: ELSIF l_search_merged = 'I' THEN

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

1665: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1666: ELSE
1667: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1668: END IF;
1669: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1670: ' FROM HZ_STAGED_PARTY_SITES stage'||
1671: ' WHERE contains( concat_col, :cont)>0'||
1672: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1673: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1670: ' FROM HZ_STAGED_PARTY_SITES stage'||

1666: ELSE
1667: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1668: END IF;
1669: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1670: ' FROM HZ_STAGED_PARTY_SITES stage'||
1671: ' WHERE contains( concat_col, :cont)>0'||
1672: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1673: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1674: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1675: ' AND (ORG_CONTACT_ID IS NULL ' ||
1676: ' AND ('||p_restrict_sql||'))' ||
1677: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1678: ' UNION ' ||
1679: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1680: ' FROM HZ_STAGED_PARTY_SITES stage'||
1681: ' WHERE contains( concat_col, :cont)>0'||
1682: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1683: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1680: ' FROM HZ_STAGED_PARTY_SITES stage'||

1676: ' AND ('||p_restrict_sql||'))' ||
1677: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1678: ' UNION ' ||
1679: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1680: ' FROM HZ_STAGED_PARTY_SITES stage'||
1681: ' WHERE contains( concat_col, :cont)>0'||
1682: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1683: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1684: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1695: ' FROM HZ_STAGED_PARTY_SITES stage'||

1691: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1692: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1693: ELSE
1694: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1695: ' FROM HZ_STAGED_PARTY_SITES stage'||
1696: ' WHERE contains( concat_col, :cont)>0'||
1697: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1698: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1699: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1712: ' FROM HZ_STAGED_PARTY_SITES stage'||

1708: ,p_dup_party_id, p_dup_party_id;
1709: END IF;
1710: ELSE
1711: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1712: ' FROM HZ_STAGED_PARTY_SITES stage'||
1713: ' WHERE contains( concat_col, :cont)>0'||
1714: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1715: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1716: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||