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

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

1562: 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);
1563: END IF;
1564: IF p_search_rel_sites = 'N' THEN
1565: OPEN x_cursor FOR
1566: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1567: FROM HZ_STAGED_PARTY_SITES stage
1568: WHERE contains( concat_col, p_contains_str)>0
1569: AND( (l_search_merged ='Y' )
1570: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1567: FROM HZ_STAGED_PARTY_SITES stage

1563: END IF;
1564: IF p_search_rel_sites = 'N' THEN
1565: OPEN x_cursor FOR
1566: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1567: FROM HZ_STAGED_PARTY_SITES stage
1568: WHERE contains( concat_col, p_contains_str)>0
1569: AND( (l_search_merged ='Y' )
1570: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1571: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1571: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1572: AND stage.party_id = p_party_id;
1573: ELSE
1574: OPEN x_cursor FOR
1575: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1576: FROM HZ_STAGED_PARTY_SITES stage
1577: WHERE contains( concat_col, p_contains_str)>0
1578: AND( (l_search_merged ='Y' )
1579: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1576: FROM HZ_STAGED_PARTY_SITES stage

1572: AND stage.party_id = p_party_id;
1573: ELSE
1574: OPEN x_cursor FOR
1575: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1576: FROM HZ_STAGED_PARTY_SITES stage
1577: WHERE contains( concat_col, p_contains_str)>0
1578: AND( (l_search_merged ='Y' )
1579: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1580: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1579: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1580: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1581: AND stage.party_id = p_party_id
1582: UNION
1583: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1584: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1585: WHERE contains( concat_col, p_contains_str)>0
1586: AND( (l_search_merged ='Y' )
1587: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1580: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1581: AND stage.party_id = p_party_id
1582: UNION
1583: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1584: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1585: WHERE contains( concat_col, p_contains_str)>0
1586: AND( (l_search_merged ='Y' )
1587: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1588: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1606: FROM HZ_STAGED_PARTY_SITES stage

1602: 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);
1603: END IF;
1604: OPEN x_cursor FOR
1605: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1606: FROM HZ_STAGED_PARTY_SITES stage
1607: WHERE contains( concat_col, p_contains_str)>0
1608: AND EXISTS (
1609: SELECT 1 FROM HZ_STAGED_PARTIES p
1610: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1626: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1622: END IF;
1623: IF p_person_api = 'Y' THEN
1624: OPEN x_cursor FOR
1625: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1626: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1627: WHERE contains( concat_col, p_contains_str)>0
1628: AND( (l_search_merged ='Y' )
1629: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1630: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1631: AND d.search_context_id = p_search_ctx_id
1632: AND d.party_id = stage.party_id
1633: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1634: UNION
1635: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1636: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1637: WHERE contains( concat_col, p_contains_str)>0
1638: AND( (l_search_merged ='Y' )
1639: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1632: AND d.party_id = stage.party_id
1633: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1634: UNION
1635: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1636: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1637: WHERE contains( concat_col, p_contains_str)>0
1638: AND( (l_search_merged ='Y' )
1639: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1640: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1649: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1645: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1646: ELSE
1647: OPEN x_cursor FOR
1648: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1649: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1650: WHERE contains( concat_col, p_contains_str)>0
1651: AND( (l_search_merged ='Y' )
1652: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1653: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1665: IF (l_check_dt > 0 ) THEN
1666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1667: 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);
1668: END IF;
1669: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1670: ELSIF (l_check > 0 ) THEN
1671: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1672: 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);
1673: END IF;

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

1670: ELSIF (l_check > 0 ) THEN
1671: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1672: 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);
1673: END IF;
1674: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1675: END IF;
1676: IF l_search_merged = 'Y' THEN
1677: l_status_sql := ' ' ;
1678: ELSIF l_search_merged = 'I' THEN

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

1689: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1690: ELSE
1691: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1692: END IF;
1693: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1694: ' FROM HZ_STAGED_PARTY_SITES stage'||
1695: ' WHERE contains( concat_col, :cont)>0'||
1696: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1697: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1694: ' FROM HZ_STAGED_PARTY_SITES stage'||

1690: ELSE
1691: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1692: END IF;
1693: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1694: ' FROM HZ_STAGED_PARTY_SITES stage'||
1695: ' WHERE contains( concat_col, :cont)>0'||
1696: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1697: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1698: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1699: ' AND (ORG_CONTACT_ID IS NULL ' ||
1700: ' AND ('||p_restrict_sql||'))' ||
1701: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1702: ' UNION ' ||
1703: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1704: ' FROM HZ_STAGED_PARTY_SITES stage'||
1705: ' WHERE contains( concat_col, :cont)>0'||
1706: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1707: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1704: ' FROM HZ_STAGED_PARTY_SITES stage'||

1700: ' AND ('||p_restrict_sql||'))' ||
1701: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1702: ' UNION ' ||
1703: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1704: ' FROM HZ_STAGED_PARTY_SITES stage'||
1705: ' WHERE contains( concat_col, :cont)>0'||
1706: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1707: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1708: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1719: ' FROM HZ_STAGED_PARTY_SITES stage'||

1715: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1716: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1717: ELSE
1718: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1719: ' FROM HZ_STAGED_PARTY_SITES stage'||
1720: ' WHERE contains( concat_col, :cont)>0'||
1721: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1722: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1723: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1736: ' FROM HZ_STAGED_PARTY_SITES stage'||

1732: ,p_dup_party_id, p_dup_party_id;
1733: END IF;
1734: ELSE
1735: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1736: ' FROM HZ_STAGED_PARTY_SITES stage'||
1737: ' WHERE contains( concat_col, :cont)>0'||
1738: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1739: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1740: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||