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

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

Line 1565: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1574: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1604: FROM HZ_STAGED_PARTY_SITES stage

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

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

1619: 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);
1620: END IF;
1621: IF p_person_api = 'Y' THEN
1622: OPEN x_cursor FOR
1623: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1624: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1625: WHERE contains( concat_col, p_contains_str)>0
1626: AND( (l_search_merged ='Y' )
1627: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1624: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

1642: AND oc.org_contact_id = stage.org_contact_id
1643: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1644: ELSE
1645: OPEN x_cursor FOR
1646: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1647: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1648: WHERE contains( concat_col, p_contains_str)>0
1649: AND( (l_search_merged ='Y' )
1650: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1647: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1692: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1702: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1717: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1734: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_40 dependencies on HZ_STAGED_PARTY_SITES

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