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

Line 1805: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID, TX5, TX2

1801: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1802: 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);
1803: END IF;
1804: OPEN x_cursor FOR
1805: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
1806: FROM HZ_STAGED_CONTACTS stage
1807: WHERE contains( concat_col, p_contains_str)>0
1808: AND EXISTS (
1809: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 1806: FROM HZ_STAGED_CONTACTS stage

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

Line 1829: FROM HZ_STAGED_CONTACTS stage

1825: 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);
1826: END IF;
1827: OPEN x_cursor FOR
1828: SELECT ORG_CONTACT_ID, PARTY_ID, TX5, TX2
1829: FROM HZ_STAGED_CONTACTS stage
1830: WHERE contains( concat_col, p_contains_str)>0
1831: AND EXISTS (
1832: SELECT 1 FROM HZ_STAGED_PARTIES p
1833: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1847: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2

1843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1844: 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);
1845: END IF;
1846: OPEN x_cursor FOR
1847: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1849: WHERE contains( concat_col, p_contains_str)>0
1850: AND d.search_context_id = p_search_ctx_id
1851: AND d.party_id = stage.party_id

Line 1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1844: 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);
1845: END IF;
1846: OPEN x_cursor FOR
1847: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1849: WHERE contains( concat_col, p_contains_str)>0
1850: AND d.search_context_id = p_search_ctx_id
1851: AND d.party_id = stage.party_id
1852: AND( (l_search_merged ='Y' )

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

1863: IF (l_check_dt > 0 ) THEN
1864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1865: 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);
1866: END IF;
1867: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
1868: ELSIF (l_check > 0 ) THEN
1869: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1870: 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);
1871: END IF;

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

1868: ELSIF (l_check > 0 ) THEN
1869: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1870: 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);
1871: END IF;
1872: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
1873: END IF;
1874: IF l_search_merged = 'Y' THEN
1875: l_status_sql := ' ' ;
1876: ELSIF l_search_merged = 'I' THEN

Line 1882: ' FROM HZ_STAGED_CONTACTS stage'||

1878: ELSE
1879: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
1880: END IF;
1881: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX5, TX2'||
1882: ' FROM HZ_STAGED_CONTACTS stage'||
1883: ' WHERE contains( concat_col, :cont)>0'||
1884: ' AND EXISTS ('||
1885: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1886: ' WHERE p.party_id = stage.party_id ' ||

Line 3491: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID, TX5, TX2

3487: p_search_ctx_id NUMBER,
3488: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3489: BEGIN
3490: OPEN x_cursor FOR
3491: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
3492: FROM HZ_STAGED_CONTACTS stage
3493: WHERE contains( concat_col, p_contains_str)>0
3494: AND ORG_CONTACT_ID in (
3495: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3492: FROM HZ_STAGED_CONTACTS stage

3488: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3489: BEGIN
3490: OPEN x_cursor FOR
3491: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
3492: FROM HZ_STAGED_CONTACTS stage
3493: WHERE contains( concat_col, p_contains_str)>0
3494: AND ORG_CONTACT_ID in (
3495: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3496: org_contact_id

APPS.HZ_MATCH_RULE_40 dependencies on HZ_STAGED_CONTACTS

Line 1805: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2