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

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

1450: 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);
1451: END IF;
1452: IF p_search_rel_sites = 'N' THEN
1453: OPEN x_cursor FOR
1454: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1455: FROM HZ_STAGED_PARTY_SITES stage
1456: WHERE contains( concat_col, p_contains_str)>0
1457: AND( (l_search_merged ='Y' )
1458: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1455: FROM HZ_STAGED_PARTY_SITES stage

1451: END IF;
1452: IF p_search_rel_sites = 'N' THEN
1453: OPEN x_cursor FOR
1454: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1455: FROM HZ_STAGED_PARTY_SITES stage
1456: WHERE contains( concat_col, p_contains_str)>0
1457: AND( (l_search_merged ='Y' )
1458: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1459: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1459: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1460: AND stage.party_id = p_party_id;
1461: ELSE
1462: OPEN x_cursor FOR
1463: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1464: FROM HZ_STAGED_PARTY_SITES stage
1465: WHERE contains( concat_col, p_contains_str)>0
1466: AND( (l_search_merged ='Y' )
1467: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1464: FROM HZ_STAGED_PARTY_SITES stage

1460: AND stage.party_id = p_party_id;
1461: ELSE
1462: OPEN x_cursor FOR
1463: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1464: FROM HZ_STAGED_PARTY_SITES stage
1465: WHERE contains( concat_col, p_contains_str)>0
1466: AND( (l_search_merged ='Y' )
1467: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1468: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1467: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1468: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1469: AND stage.party_id = p_party_id
1470: UNION
1471: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX11
1472: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1473: WHERE contains( concat_col, p_contains_str)>0
1474: AND( (l_search_merged ='Y' )
1475: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1468: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1469: AND stage.party_id = p_party_id
1470: UNION
1471: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX4, TX11
1472: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1473: WHERE contains( concat_col, p_contains_str)>0
1474: AND( (l_search_merged ='Y' )
1475: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1476: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1494: FROM HZ_STAGED_PARTY_SITES stage

1490: 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);
1491: END IF;
1492: OPEN x_cursor FOR
1493: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1494: FROM HZ_STAGED_PARTY_SITES stage
1495: WHERE contains( concat_col, p_contains_str)>0
1496: AND EXISTS (
1497: SELECT 1 FROM HZ_STAGED_PARTIES p
1498: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1514: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1510: END IF;
1511: IF p_person_api = 'Y' THEN
1512: OPEN x_cursor FOR
1513: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1514: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1515: WHERE contains( concat_col, p_contains_str)>0
1516: AND( (l_search_merged ='Y' )
1517: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1518: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1519: AND d.search_context_id = p_search_ctx_id
1520: AND d.party_id = stage.party_id
1521: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1522: UNION
1523: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11
1524: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1525: WHERE contains( concat_col, p_contains_str)>0
1526: AND( (l_search_merged ='Y' )
1527: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1520: AND d.party_id = stage.party_id
1521: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1522: UNION
1523: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11
1524: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1525: WHERE contains( concat_col, p_contains_str)>0
1526: AND( (l_search_merged ='Y' )
1527: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1528: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1537: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1533: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1534: ELSE
1535: OPEN x_cursor FOR
1536: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1537: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1538: WHERE contains( concat_col, p_contains_str)>0
1539: AND( (l_search_merged ='Y' )
1540: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1541: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1553: IF (l_check_dt > 0 ) THEN
1554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1555: 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);
1556: END IF;
1557: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1558: ELSIF (l_check > 0 ) THEN
1559: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1560: 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);
1561: END IF;

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

1558: ELSIF (l_check > 0 ) THEN
1559: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1560: 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);
1561: END IF;
1562: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1563: END IF;
1564: IF l_search_merged = 'Y' THEN
1565: l_status_sql := ' ' ;
1566: ELSIF l_search_merged = 'I' THEN

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

1577: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1578: ELSE
1579: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1580: END IF;
1581: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1582: ' FROM HZ_STAGED_PARTY_SITES stage'||
1583: ' WHERE contains( concat_col, :cont)>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'||

1578: ELSE
1579: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1580: END IF;
1581: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1582: ' FROM HZ_STAGED_PARTY_SITES stage'||
1583: ' WHERE contains( concat_col, :cont)>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 1591: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||

1587: ' AND (ORG_CONTACT_ID IS NULL ' ||
1588: ' AND ('||p_restrict_sql||'))' ||
1589: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1590: ' UNION ' ||
1591: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1592: ' FROM HZ_STAGED_PARTY_SITES stage'||
1593: ' WHERE contains( concat_col, :cont)>0'||
1594: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1595: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1592: ' FROM HZ_STAGED_PARTY_SITES stage'||

1588: ' AND ('||p_restrict_sql||'))' ||
1589: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1590: ' UNION ' ||
1591: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1592: ' FROM HZ_STAGED_PARTY_SITES stage'||
1593: ' WHERE contains( concat_col, :cont)>0'||
1594: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1595: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1596: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1607: ' FROM HZ_STAGED_PARTY_SITES stage'||

1603: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1604: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1605: ELSE
1606: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1607: ' FROM HZ_STAGED_PARTY_SITES stage'||
1608: ' WHERE contains( concat_col, :cont)>0'||
1609: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1610: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1611: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1624: ' FROM HZ_STAGED_PARTY_SITES stage'||

1620: ,p_dup_party_id, p_dup_party_id;
1621: END IF;
1622: ELSE
1623: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX4, TX11'||
1624: ' FROM HZ_STAGED_PARTY_SITES stage'||
1625: ' WHERE contains( concat_col, :cont)>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'') ) '||