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

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

Line 1541: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1550: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1580: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1599: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID

1595: 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);
1596: END IF;
1597: IF p_person_api = 'Y' THEN
1598: OPEN x_cursor FOR
1599: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1600: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1601: WHERE contains( concat_col, p_contains_str)>0
1602: AND( (l_search_merged ='Y' )
1603: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1600: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1596: END IF;
1597: IF p_person_api = 'Y' THEN
1598: OPEN x_cursor FOR
1599: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1600: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1601: WHERE contains( concat_col, p_contains_str)>0
1602: AND( (l_search_merged ='Y' )
1603: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1604: 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, r.subject_id, stage.ORG_CONTACT_ID

1605: AND d.search_context_id = p_search_ctx_id
1606: AND d.party_id = stage.party_id
1607: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1608: UNION
1609: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1610: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
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_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1606: AND d.party_id = stage.party_id
1607: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1608: UNION
1609: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1610: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
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 1622: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID

1618: AND oc.org_contact_id = stage.org_contact_id
1619: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1620: ELSE
1621: OPEN x_cursor FOR
1622: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1624: WHERE contains( concat_col, p_contains_str)>0
1625: AND( (l_search_merged ='Y' )
1626: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1668: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1678: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1693: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1710: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_58 dependencies on HZ_STAGED_PARTY_SITES

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