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

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

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

Line 1458: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1467: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1497: FROM HZ_STAGED_PARTY_SITES stage

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

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

1512: 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);
1513: END IF;
1514: IF p_person_api = 'Y' THEN
1515: OPEN x_cursor FOR
1516: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1517: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
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_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1513: END IF;
1514: IF p_person_api = 'Y' THEN
1515: OPEN x_cursor FOR
1516: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1517: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
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 1526: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11

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

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

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

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

1535: AND oc.org_contact_id = stage.org_contact_id
1536: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1537: ELSE
1538: OPEN x_cursor FOR
1539: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1540: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1541: WHERE contains( concat_col, p_contains_str)>0
1542: AND( (l_search_merged ='Y' )
1543: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1540: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1536: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1537: ELSE
1538: OPEN x_cursor FOR
1539: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1540: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1541: WHERE contains( concat_col, p_contains_str)>0
1542: AND( (l_search_merged ='Y' )
1543: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1544: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

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

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

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

1580: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1581: ELSE
1582: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1583: END IF;
1584: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1585: ' FROM HZ_STAGED_PARTY_SITES stage'||
1586: ' WHERE contains( concat_col, :cont)>0'||
1587: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1588: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1585: ' FROM HZ_STAGED_PARTY_SITES stage'||

1581: ELSE
1582: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1583: END IF;
1584: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1585: ' FROM HZ_STAGED_PARTY_SITES stage'||
1586: ' WHERE contains( concat_col, :cont)>0'||
1587: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1588: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1589: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

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

Line 1595: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1610: ' FROM HZ_STAGED_PARTY_SITES stage'||

1606: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1607: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1608: ELSE
1609: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1610: ' FROM HZ_STAGED_PARTY_SITES stage'||
1611: ' WHERE contains( concat_col, :cont)>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 1627: ' FROM HZ_STAGED_PARTY_SITES stage'||

1623: ,p_dup_party_id, p_dup_party_id;
1624: END IF;
1625: ELSE
1626: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
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'') ) '||

APPS.HZ_MATCH_RULE_41 dependencies on HZ_STAGED_PARTY_SITES

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