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

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

Line 1498: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1507: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1537: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1556: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID

1552: 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);
1553: END IF;
1554: IF p_person_api = 'Y' THEN
1555: OPEN x_cursor FOR
1556: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1557: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1558: WHERE contains( concat_col, p_contains_str)>0
1559: AND( (l_search_merged ='Y' )
1560: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1557: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1579: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID

1575: AND oc.org_contact_id = stage.org_contact_id
1576: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1577: ELSE
1578: OPEN x_cursor FOR
1579: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1581: WHERE contains( concat_col, p_contains_str)>0
1582: AND( (l_search_merged ='Y' )
1583: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1576: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1577: ELSE
1578: OPEN x_cursor FOR
1579: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1581: WHERE contains( concat_col, p_contains_str)>0
1582: AND( (l_search_merged ='Y' )
1583: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1584: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

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

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

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

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

Line 1625: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1635: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1650: ' FROM HZ_STAGED_PARTY_SITES stage'||

1646: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1647: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1648: ELSE
1649: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID '||
1650: ' FROM HZ_STAGED_PARTY_SITES stage'||
1651: ' WHERE contains( concat_col, :cont)>0'||
1652: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1653: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1654: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1667: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_61 dependencies on HZ_STAGED_PARTY_SITES

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