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

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

1442: 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);
1443: END IF;
1444: IF p_search_rel_sites = 'N' THEN
1445: OPEN x_cursor FOR
1446: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1447: FROM HZ_STAGED_PARTY_SITES stage
1448: WHERE contains( concat_col, p_contains_str)>0
1449: AND( (l_search_merged ='Y' )
1450: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1447: FROM HZ_STAGED_PARTY_SITES stage

1443: END IF;
1444: IF p_search_rel_sites = 'N' THEN
1445: OPEN x_cursor FOR
1446: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1447: FROM HZ_STAGED_PARTY_SITES stage
1448: WHERE contains( concat_col, p_contains_str)>0
1449: AND( (l_search_merged ='Y' )
1450: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1451: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 1456: FROM HZ_STAGED_PARTY_SITES stage

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

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

1459: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1460: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1461: AND stage.party_id = p_party_id
1462: UNION
1463: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1464: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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, hz_relationships r, hz_org_contacts oc

1460: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1461: AND stage.party_id = p_party_id
1462: UNION
1463: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1464: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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 1486: FROM HZ_STAGED_PARTY_SITES stage

1482: 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);
1483: END IF;
1484: OPEN x_cursor FOR
1485: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1486: FROM HZ_STAGED_PARTY_SITES stage
1487: WHERE contains( concat_col, p_contains_str)>0
1488: AND EXISTS (
1489: SELECT 1 FROM HZ_STAGED_PARTIES p
1490: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1506: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1502: END IF;
1503: IF p_person_api = 'Y' THEN
1504: OPEN x_cursor FOR
1505: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1506: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1507: WHERE contains( concat_col, p_contains_str)>0
1508: AND( (l_search_merged ='Y' )
1509: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1510: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1511: AND d.search_context_id = p_search_ctx_id
1512: AND d.party_id = stage.party_id
1513: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1514: UNION
1515: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1516: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1517: WHERE contains( concat_col, p_contains_str)>0
1518: AND( (l_search_merged ='Y' )
1519: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

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

Line 1529: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1525: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1526: ELSE
1527: OPEN x_cursor FOR
1528: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1529: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1530: WHERE contains( concat_col, p_contains_str)>0
1531: AND( (l_search_merged ='Y' )
1532: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1533: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1545: IF (l_check_dt > 0 ) THEN
1546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1547: 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);
1548: END IF;
1549: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1550: ELSIF (l_check > 0 ) THEN
1551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1552: 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);
1553: END IF;

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

1550: ELSIF (l_check > 0 ) THEN
1551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1552: 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);
1553: END IF;
1554: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1555: END IF;
1556: IF l_search_merged = 'Y' THEN
1557: l_status_sql := ' ' ;
1558: ELSIF l_search_merged = 'I' THEN

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

1569: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1570: ELSE
1571: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1572: END IF;
1573: l_sqlstr := '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, :cont)>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: ELSE
1571: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1572: END IF;
1573: l_sqlstr := '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, :cont)>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 1583: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||

1579: ' AND (ORG_CONTACT_ID IS NULL ' ||
1580: ' AND ('||p_restrict_sql||'))' ||
1581: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1582: ' UNION ' ||
1583: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1584: ' FROM HZ_STAGED_PARTY_SITES stage'||
1585: ' WHERE contains( concat_col, :cont)>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'||

1580: ' AND ('||p_restrict_sql||'))' ||
1581: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1582: ' UNION ' ||
1583: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1584: ' FROM HZ_STAGED_PARTY_SITES stage'||
1585: ' WHERE contains( concat_col, :cont)>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 1599: ' FROM HZ_STAGED_PARTY_SITES stage'||

1595: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1596: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1597: ELSE
1598: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1599: ' FROM HZ_STAGED_PARTY_SITES stage'||
1600: ' WHERE contains( concat_col, :cont)>0'||
1601: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1602: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1603: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1616: ' FROM HZ_STAGED_PARTY_SITES stage'||

1612: ,p_dup_party_id, p_dup_party_id;
1613: END IF;
1614: ELSE
1615: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1616: ' FROM HZ_STAGED_PARTY_SITES stage'||
1617: ' WHERE contains( concat_col, :cont)>0'||
1618: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1619: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1620: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||