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.

[Home] [Help]

APPS.HZ_MATCH_RULE_37 dependencies on HZ_STAGED_PARTY_SITES

Line 1518: 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

1514: 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);
1515: END IF;
1516: IF p_search_rel_sites = 'N' THEN
1517: OPEN x_cursor FOR
1518: 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
1519: FROM HZ_STAGED_PARTY_SITES stage
1520: WHERE contains( concat_col, p_contains_str)>0
1521: AND( (l_search_merged ='Y' )
1522: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1519: FROM HZ_STAGED_PARTY_SITES stage

1515: END IF;
1516: IF p_search_rel_sites = 'N' THEN
1517: OPEN x_cursor FOR
1518: 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
1519: FROM HZ_STAGED_PARTY_SITES stage
1520: WHERE contains( concat_col, p_contains_str)>0
1521: AND( (l_search_merged ='Y' )
1522: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1523: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1527: 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

1523: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1524: AND stage.party_id = p_party_id;
1525: ELSE
1526: OPEN x_cursor FOR
1527: 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
1528: FROM HZ_STAGED_PARTY_SITES stage
1529: WHERE contains( concat_col, p_contains_str)>0
1530: AND( (l_search_merged ='Y' )
1531: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1528: FROM HZ_STAGED_PARTY_SITES stage

1524: AND stage.party_id = p_party_id;
1525: ELSE
1526: OPEN x_cursor FOR
1527: 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
1528: FROM HZ_STAGED_PARTY_SITES stage
1529: WHERE contains( concat_col, p_contains_str)>0
1530: AND( (l_search_merged ='Y' )
1531: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1532: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1535: 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

1531: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1532: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1533: AND stage.party_id = p_party_id
1534: UNION
1535: 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
1536: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1537: WHERE contains( concat_col, p_contains_str)>0
1538: AND( (l_search_merged ='Y' )
1539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1532: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1533: AND stage.party_id = p_party_id
1534: UNION
1535: 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
1536: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1537: WHERE contains( concat_col, p_contains_str)>0
1538: AND( (l_search_merged ='Y' )
1539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1540: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1558: FROM HZ_STAGED_PARTY_SITES stage

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

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

1573: 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);
1574: END IF;
1575: IF p_person_api = 'Y' THEN
1576: OPEN x_cursor FOR
1577: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1578: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1579: WHERE contains( concat_col, p_contains_str)>0
1580: AND( (l_search_merged ='Y' )
1581: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1578: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1574: END IF;
1575: IF p_person_api = 'Y' THEN
1576: OPEN x_cursor FOR
1577: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1578: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1579: WHERE contains( concat_col, p_contains_str)>0
1580: AND( (l_search_merged ='Y' )
1581: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1582: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1587: 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

1583: AND d.search_context_id = p_search_ctx_id
1584: AND d.party_id = stage.party_id
1585: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1586: UNION
1587: 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
1588: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1589: WHERE contains( concat_col, p_contains_str)>0
1590: AND( (l_search_merged ='Y' )
1591: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1584: AND d.party_id = stage.party_id
1585: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1586: UNION
1587: 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
1588: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1589: WHERE contains( concat_col, p_contains_str)>0
1590: AND( (l_search_merged ='Y' )
1591: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1592: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 1601: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1645: 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'||

1641: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1642: ELSE
1643: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1644: END IF;
1645: 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'||
1646: ' FROM HZ_STAGED_PARTY_SITES stage'||
1647: ' WHERE contains( concat_col, :cont)>0'||
1648: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1649: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1646: ' FROM HZ_STAGED_PARTY_SITES stage'||

1642: ELSE
1643: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1644: END IF;
1645: 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'||
1646: ' FROM HZ_STAGED_PARTY_SITES stage'||
1647: ' WHERE contains( concat_col, :cont)>0'||
1648: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1649: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1650: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1655: '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'||

1651: ' AND (ORG_CONTACT_ID IS NULL ' ||
1652: ' AND ('||p_restrict_sql||'))' ||
1653: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1654: ' UNION ' ||
1655: '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'||
1656: ' FROM HZ_STAGED_PARTY_SITES stage'||
1657: ' WHERE contains( concat_col, :cont)>0'||
1658: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1659: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1656: ' FROM HZ_STAGED_PARTY_SITES stage'||

1652: ' AND ('||p_restrict_sql||'))' ||
1653: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1654: ' UNION ' ||
1655: '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'||
1656: ' FROM HZ_STAGED_PARTY_SITES stage'||
1657: ' WHERE contains( concat_col, :cont)>0'||
1658: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1659: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1660: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1671: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1688: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_37 dependencies on HZ_STAGED_PARTY_SITES

Line 1518: 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