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 1592: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22

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

Line 1593: FROM HZ_STAGED_PARTY_SITES stage

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

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

1597: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1598: AND stage.party_id = p_party_id;
1599: ELSE
1600: OPEN x_cursor FOR
1601: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1602: FROM 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'))

Line 1602: FROM HZ_STAGED_PARTY_SITES stage

1598: AND stage.party_id = p_party_id;
1599: ELSE
1600: OPEN x_cursor FOR
1601: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1602: FROM 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 1609: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22

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

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

1606: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1607: AND stage.party_id = p_party_id
1608: UNION
1609: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1610: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1611: WHERE contains( concat_col, p_contains_str)>0
1612: AND( (l_search_merged ='Y' )
1613: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1614: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1632: FROM HZ_STAGED_PARTY_SITES stage

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

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

1647: 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);
1648: END IF;
1649: IF p_person_api = 'Y' THEN
1650: OPEN x_cursor FOR
1651: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1652: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1653: WHERE contains( concat_col, p_contains_str)>0
1654: AND( (l_search_merged ='Y' )
1655: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1652: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

1670: AND oc.org_contact_id = stage.org_contact_id
1671: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1672: ELSE
1673: OPEN x_cursor FOR
1674: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1675: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1676: WHERE contains( concat_col, p_contains_str)>0
1677: AND( (l_search_merged ='Y' )
1678: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1675: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1720: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1730: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1745: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1762: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_48 dependencies on HZ_STAGED_PARTY_SITES

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