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

Line 1594: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22

1590: 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);
1591: END IF;
1592: IF p_search_rel_sites = 'N' THEN
1593: OPEN x_cursor FOR
1594: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1595: FROM HZ_STAGED_PARTY_SITES stage
1596: WHERE contains( concat_col, p_contains_str)>0
1597: AND( (l_search_merged ='Y' )
1598: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1595: FROM HZ_STAGED_PARTY_SITES stage

1591: END IF;
1592: IF p_search_rel_sites = 'N' THEN
1593: OPEN x_cursor FOR
1594: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1595: FROM HZ_STAGED_PARTY_SITES stage
1596: WHERE contains( concat_col, p_contains_str)>0
1597: AND( (l_search_merged ='Y' )
1598: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1599: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1603: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22

1599: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1600: AND stage.party_id = p_party_id;
1601: ELSE
1602: OPEN x_cursor FOR
1603: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1604: FROM HZ_STAGED_PARTY_SITES stage
1605: WHERE contains( concat_col, p_contains_str)>0
1606: AND( (l_search_merged ='Y' )
1607: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1604: FROM HZ_STAGED_PARTY_SITES stage

1600: AND stage.party_id = p_party_id;
1601: ELSE
1602: OPEN x_cursor FOR
1603: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1604: FROM HZ_STAGED_PARTY_SITES stage
1605: WHERE contains( concat_col, p_contains_str)>0
1606: AND( (l_search_merged ='Y' )
1607: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1608: 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, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22

1607: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1608: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1609: AND stage.party_id = p_party_id
1610: UNION
1611: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1612: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

1608: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1609: AND stage.party_id = p_party_id
1610: UNION
1611: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1612: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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 1634: FROM HZ_STAGED_PARTY_SITES stage

1630: 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);
1631: END IF;
1632: OPEN x_cursor FOR
1633: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1634: FROM HZ_STAGED_PARTY_SITES stage
1635: WHERE contains( concat_col, p_contains_str)>0
1636: AND EXISTS (
1637: SELECT 1 FROM HZ_STAGED_PARTIES p
1638: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1654: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1650: END IF;
1651: IF p_person_api = 'Y' THEN
1652: OPEN x_cursor FOR
1653: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1654: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1655: WHERE contains( concat_col, p_contains_str)>0
1656: AND( (l_search_merged ='Y' )
1657: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1658: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1663: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22

1659: AND d.search_context_id = p_search_ctx_id
1660: AND d.party_id = stage.party_id
1661: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1662: UNION
1663: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1664: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1665: WHERE contains( concat_col, p_contains_str)>0
1666: AND( (l_search_merged ='Y' )
1667: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1660: AND d.party_id = stage.party_id
1661: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1662: UNION
1663: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1664: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1665: WHERE contains( concat_col, p_contains_str)>0
1666: AND( (l_search_merged ='Y' )
1667: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1668: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1677: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1673: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1674: ELSE
1675: OPEN x_cursor FOR
1676: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1677: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1678: WHERE contains( concat_col, p_contains_str)>0
1679: AND( (l_search_merged ='Y' )
1680: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1681: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1693: IF (l_check_dt > 0 ) THEN
1694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1695: 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);
1696: END IF;
1697: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1698: ELSIF (l_check > 0 ) THEN
1699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1700: 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);
1701: END IF;

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

1698: ELSIF (l_check > 0 ) THEN
1699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1700: 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);
1701: END IF;
1702: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1703: END IF;
1704: IF l_search_merged = 'Y' THEN
1705: l_status_sql := ' ' ;
1706: ELSIF l_search_merged = 'I' THEN

Line 1721: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||

1717: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1718: ELSE
1719: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1720: END IF;
1721: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||
1722: ' FROM HZ_STAGED_PARTY_SITES stage'||
1723: ' WHERE contains( concat_col, :cont)>0'||
1724: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1725: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1722: ' FROM HZ_STAGED_PARTY_SITES stage'||

1718: ELSE
1719: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1720: END IF;
1721: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||
1722: ' FROM HZ_STAGED_PARTY_SITES stage'||
1723: ' WHERE contains( concat_col, :cont)>0'||
1724: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1725: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1726: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1731: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||

1727: ' AND (ORG_CONTACT_ID IS NULL ' ||
1728: ' AND ('||p_restrict_sql||'))' ||
1729: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1730: ' UNION ' ||
1731: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||
1732: ' FROM HZ_STAGED_PARTY_SITES stage'||
1733: ' WHERE contains( concat_col, :cont)>0'||
1734: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1735: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1732: ' FROM HZ_STAGED_PARTY_SITES stage'||

1728: ' AND ('||p_restrict_sql||'))' ||
1729: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1730: ' UNION ' ||
1731: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||
1732: ' FROM HZ_STAGED_PARTY_SITES stage'||
1733: ' WHERE contains( concat_col, :cont)>0'||
1734: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1735: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1736: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1747: ' FROM HZ_STAGED_PARTY_SITES stage'||

1743: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1744: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1745: ELSE
1746: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||
1747: ' FROM HZ_STAGED_PARTY_SITES stage'||
1748: ' WHERE contains( concat_col, :cont)>0'||
1749: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1750: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1751: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1764: ' FROM HZ_STAGED_PARTY_SITES stage'||

1760: ,p_dup_party_id, p_dup_party_id;
1761: END IF;
1762: ELSE
1763: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX10, TX14, TX22'||
1764: ' FROM HZ_STAGED_PARTY_SITES stage'||
1765: ' WHERE contains( concat_col, :cont)>0'||
1766: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1767: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1768: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||