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

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

1495: 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);
1496: END IF;
1497: IF p_search_rel_sites = 'N' THEN
1498: OPEN x_cursor FOR
1499: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1500: FROM HZ_STAGED_PARTY_SITES stage
1501: WHERE contains( concat_col, p_contains_str)>0
1502: AND( (l_search_merged ='Y' )
1503: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1500: FROM HZ_STAGED_PARTY_SITES stage

1496: END IF;
1497: IF p_search_rel_sites = 'N' THEN
1498: OPEN x_cursor FOR
1499: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1500: FROM HZ_STAGED_PARTY_SITES stage
1501: WHERE contains( concat_col, p_contains_str)>0
1502: AND( (l_search_merged ='Y' )
1503: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1504: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1504: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1505: AND stage.party_id = p_party_id;
1506: ELSE
1507: OPEN x_cursor FOR
1508: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1509: FROM HZ_STAGED_PARTY_SITES stage
1510: WHERE contains( concat_col, p_contains_str)>0
1511: AND( (l_search_merged ='Y' )
1512: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1509: FROM HZ_STAGED_PARTY_SITES stage

1505: AND stage.party_id = p_party_id;
1506: ELSE
1507: OPEN x_cursor FOR
1508: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1509: FROM HZ_STAGED_PARTY_SITES stage
1510: WHERE contains( concat_col, p_contains_str)>0
1511: AND( (l_search_merged ='Y' )
1512: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1513: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1512: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1513: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1514: AND stage.party_id = p_party_id
1515: UNION
1516: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1517: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1518: WHERE contains( concat_col, p_contains_str)>0
1519: AND( (l_search_merged ='Y' )
1520: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1513: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1514: AND stage.party_id = p_party_id
1515: UNION
1516: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1517: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1518: WHERE contains( concat_col, p_contains_str)>0
1519: AND( (l_search_merged ='Y' )
1520: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1521: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1539: FROM HZ_STAGED_PARTY_SITES stage

1535: 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);
1536: END IF;
1537: OPEN x_cursor FOR
1538: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID
1539: FROM HZ_STAGED_PARTY_SITES stage
1540: WHERE contains( concat_col, p_contains_str)>0
1541: AND EXISTS (
1542: SELECT 1 FROM HZ_STAGED_PARTIES p
1543: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1559: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1555: END IF;
1556: IF p_person_api = 'Y' THEN
1557: OPEN x_cursor FOR
1558: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1559: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1560: WHERE contains( concat_col, p_contains_str)>0
1561: AND( (l_search_merged ='Y' )
1562: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1563: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1568: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID

1564: AND d.search_context_id = p_search_ctx_id
1565: AND d.party_id = stage.party_id
1566: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1567: UNION
1568: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1569: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1570: WHERE contains( concat_col, p_contains_str)>0
1571: AND( (l_search_merged ='Y' )
1572: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1565: AND d.party_id = stage.party_id
1566: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1567: UNION
1568: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1569: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1570: WHERE contains( concat_col, p_contains_str)>0
1571: AND( (l_search_merged ='Y' )
1572: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1573: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1582: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1578: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1579: ELSE
1580: OPEN x_cursor FOR
1581: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1582: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
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 1602: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

1598: IF (l_check_dt > 0 ) THEN
1599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1600: 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);
1601: END IF;
1602: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1603: ELSIF (l_check > 0 ) THEN
1604: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1605: 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);
1606: END IF;

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

1603: ELSIF (l_check > 0 ) THEN
1604: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1605: 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);
1606: END IF;
1607: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1608: END IF;
1609: IF l_search_merged = 'Y' THEN
1610: l_status_sql := ' ' ;
1611: ELSIF l_search_merged = 'I' THEN

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

1622: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1623: ELSE
1624: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1625: END IF;
1626: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1627: ' FROM HZ_STAGED_PARTY_SITES stage'||
1628: ' WHERE contains( concat_col, :cont)>0'||
1629: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1630: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1627: ' FROM HZ_STAGED_PARTY_SITES stage'||

1623: ELSE
1624: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1625: END IF;
1626: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1627: ' FROM HZ_STAGED_PARTY_SITES stage'||
1628: ' WHERE contains( concat_col, :cont)>0'||
1629: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1630: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1631: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1632: ' AND (ORG_CONTACT_ID IS NULL ' ||
1633: ' AND ('||p_restrict_sql||'))' ||
1634: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1635: ' UNION ' ||
1636: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1637: ' FROM HZ_STAGED_PARTY_SITES stage'||
1638: ' WHERE contains( concat_col, :cont)>0'||
1639: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1640: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1637: ' FROM HZ_STAGED_PARTY_SITES stage'||

1633: ' AND ('||p_restrict_sql||'))' ||
1634: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1635: ' UNION ' ||
1636: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1637: ' FROM HZ_STAGED_PARTY_SITES stage'||
1638: ' WHERE contains( concat_col, :cont)>0'||
1639: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1640: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1641: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1652: ' FROM HZ_STAGED_PARTY_SITES stage'||

1648: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1649: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1650: ELSE
1651: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1652: ' FROM HZ_STAGED_PARTY_SITES stage'||
1653: ' WHERE contains( concat_col, :cont)>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 1669: ' FROM HZ_STAGED_PARTY_SITES stage'||

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