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

Line 1520: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1516: 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);
1517: END IF;
1518: IF p_search_rel_sites = 'N' THEN
1519: OPEN x_cursor FOR
1520: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1521: FROM HZ_STAGED_PARTY_SITES stage
1522: WHERE contains( concat_col, p_contains_str)>0
1523: AND( (l_search_merged ='Y' )
1524: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1521: FROM HZ_STAGED_PARTY_SITES stage

1517: END IF;
1518: IF p_search_rel_sites = 'N' THEN
1519: OPEN x_cursor FOR
1520: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1521: FROM HZ_STAGED_PARTY_SITES stage
1522: WHERE contains( concat_col, p_contains_str)>0
1523: AND( (l_search_merged ='Y' )
1524: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1525: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1529: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1525: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1526: AND stage.party_id = p_party_id;
1527: ELSE
1528: OPEN x_cursor FOR
1529: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1530: FROM HZ_STAGED_PARTY_SITES stage
1531: WHERE contains( concat_col, p_contains_str)>0
1532: AND( (l_search_merged ='Y' )
1533: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1530: FROM HZ_STAGED_PARTY_SITES stage

1526: AND stage.party_id = p_party_id;
1527: ELSE
1528: OPEN x_cursor FOR
1529: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1530: FROM HZ_STAGED_PARTY_SITES stage
1531: WHERE contains( concat_col, p_contains_str)>0
1532: AND( (l_search_merged ='Y' )
1533: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1534: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1537: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1533: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1534: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1535: AND stage.party_id = p_party_id
1536: UNION
1537: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1538: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1539: WHERE contains( concat_col, p_contains_str)>0
1540: AND( (l_search_merged ='Y' )
1541: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1534: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1535: AND stage.party_id = p_party_id
1536: UNION
1537: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1538: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1539: WHERE contains( concat_col, p_contains_str)>0
1540: AND( (l_search_merged ='Y' )
1541: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1542: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1560: FROM HZ_STAGED_PARTY_SITES stage

1556: 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);
1557: END IF;
1558: OPEN x_cursor FOR
1559: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1560: FROM HZ_STAGED_PARTY_SITES stage
1561: WHERE contains( concat_col, p_contains_str)>0
1562: AND EXISTS (
1563: SELECT 1 FROM HZ_STAGED_PARTIES p
1564: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1576: END IF;
1577: IF p_person_api = 'Y' THEN
1578: OPEN x_cursor FOR
1579: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
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 1589: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1585: AND d.search_context_id = p_search_ctx_id
1586: AND d.party_id = stage.party_id
1587: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1588: UNION
1589: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1590: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1591: WHERE contains( concat_col, p_contains_str)>0
1592: AND( (l_search_merged ='Y' )
1593: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1586: AND d.party_id = stage.party_id
1587: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1588: UNION
1589: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1590: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1591: WHERE contains( concat_col, p_contains_str)>0
1592: AND( (l_search_merged ='Y' )
1593: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1594: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1603: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1599: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1600: ELSE
1601: OPEN x_cursor FOR
1602: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1603: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1604: WHERE contains( concat_col, p_contains_str)>0
1605: AND( (l_search_merged ='Y' )
1606: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1607: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1619: IF (l_check_dt > 0 ) THEN
1620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1621: 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);
1622: END IF;
1623: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1624: ELSIF (l_check > 0 ) THEN
1625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1626: 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);
1627: END IF;

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

1624: ELSIF (l_check > 0 ) THEN
1625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1626: 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);
1627: END IF;
1628: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1629: END IF;
1630: IF l_search_merged = 'Y' THEN
1631: l_status_sql := ' ' ;
1632: ELSIF l_search_merged = 'I' THEN

Line 1647: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||

1643: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1644: ELSE
1645: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1646: END IF;
1647: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1648: ' FROM HZ_STAGED_PARTY_SITES stage'||
1649: ' WHERE contains( concat_col, :cont)>0'||
1650: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1651: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1648: ' FROM HZ_STAGED_PARTY_SITES stage'||

1644: ELSE
1645: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1646: END IF;
1647: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1648: ' FROM HZ_STAGED_PARTY_SITES stage'||
1649: ' WHERE contains( concat_col, :cont)>0'||
1650: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1651: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1652: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1657: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||

1653: ' AND (ORG_CONTACT_ID IS NULL ' ||
1654: ' AND ('||p_restrict_sql||'))' ||
1655: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1656: ' UNION ' ||
1657: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1658: ' FROM HZ_STAGED_PARTY_SITES stage'||
1659: ' WHERE contains( concat_col, :cont)>0'||
1660: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1661: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1658: ' FROM HZ_STAGED_PARTY_SITES stage'||

1654: ' AND ('||p_restrict_sql||'))' ||
1655: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1656: ' UNION ' ||
1657: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1658: ' FROM HZ_STAGED_PARTY_SITES stage'||
1659: ' WHERE contains( concat_col, :cont)>0'||
1660: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1661: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1662: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1673: ' FROM HZ_STAGED_PARTY_SITES stage'||

1669: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1670: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1671: ELSE
1672: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1673: ' FROM HZ_STAGED_PARTY_SITES stage'||
1674: ' WHERE contains( concat_col, :cont)>0'||
1675: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1676: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1677: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1690: ' FROM HZ_STAGED_PARTY_SITES stage'||

1686: ,p_dup_party_id, p_dup_party_id;
1687: END IF;
1688: ELSE
1689: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1690: ' FROM HZ_STAGED_PARTY_SITES stage'||
1691: ' WHERE contains( concat_col, :cont)>0'||
1692: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1693: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1694: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||