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_58 dependencies on HZ_STAGED_CONTACTS

Line 1781: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID, TX22

1777: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1778: 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);
1779: END IF;
1780: OPEN x_cursor FOR
1781: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22
1782: FROM HZ_STAGED_CONTACTS stage
1783: WHERE contains( concat_col, p_contains_str)>0
1784: AND EXISTS (
1785: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 1782: FROM HZ_STAGED_CONTACTS stage

1778: 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);
1779: END IF;
1780: OPEN x_cursor FOR
1781: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22
1782: FROM HZ_STAGED_CONTACTS stage
1783: WHERE contains( concat_col, p_contains_str)>0
1784: AND EXISTS (
1785: SELECT 1 FROM HZ_STAGED_PARTIES p
1786: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1805: FROM HZ_STAGED_CONTACTS stage

1801: 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);
1802: END IF;
1803: OPEN x_cursor FOR
1804: SELECT ORG_CONTACT_ID, PARTY_ID, TX22
1805: FROM HZ_STAGED_CONTACTS stage
1806: WHERE contains( concat_col, p_contains_str)>0
1807: AND EXISTS (
1808: SELECT 1 FROM HZ_STAGED_PARTIES p
1809: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1823: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID, TX22

1819: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1820: 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);
1821: END IF;
1822: OPEN x_cursor FOR
1823: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
1824: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1825: WHERE contains( concat_col, p_contains_str)>0
1826: AND d.search_context_id = p_search_ctx_id
1827: AND d.party_id = stage.party_id

Line 1824: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1820: 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);
1821: END IF;
1822: OPEN x_cursor FOR
1823: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
1824: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1825: WHERE contains( concat_col, p_contains_str)>0
1826: AND d.search_context_id = p_search_ctx_id
1827: AND d.party_id = stage.party_id
1828: AND( (l_search_merged ='Y' )

Line 1843: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACTS_U1) /';

1839: IF (l_check_dt > 0 ) THEN
1840: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1841: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ct hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1842: END IF;
1843: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
1844: ELSIF (l_check > 0 ) THEN
1845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1846: 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);
1847: END IF;

Line 1848: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACTS_N1) /';

1844: ELSIF (l_check > 0 ) THEN
1845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1846: 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);
1847: END IF;
1848: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
1849: END IF;
1850: IF l_search_merged = 'Y' THEN
1851: l_status_sql := ' ' ;
1852: ELSIF l_search_merged = 'I' THEN

Line 1858: ' FROM HZ_STAGED_CONTACTS stage'||

1854: ELSE
1855: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
1856: END IF;
1857: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX22'||
1858: ' FROM HZ_STAGED_CONTACTS stage'||
1859: ' WHERE contains( concat_col, :cont)>0'||
1860: ' AND EXISTS ('||
1861: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1862: ' WHERE p.party_id = stage.party_id ' ||

Line 3465: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID, TX22

3461: p_search_ctx_id NUMBER,
3462: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3463: BEGIN
3464: OPEN x_cursor FOR
3465: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3466: FROM HZ_STAGED_CONTACTS stage
3467: WHERE contains( concat_col, p_contains_str)>0
3468: AND ORG_CONTACT_ID in (
3469: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3466: FROM HZ_STAGED_CONTACTS stage

3462: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3463: BEGIN
3464: OPEN x_cursor FOR
3465: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3466: FROM HZ_STAGED_CONTACTS stage
3467: WHERE contains( concat_col, p_contains_str)>0
3468: AND ORG_CONTACT_ID in (
3469: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3470: org_contact_id

APPS.HZ_MATCH_RULE_58 dependencies on HZ_STAGED_CONTACTS

Line 1781: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22