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

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

1859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1860: 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);
1861: END IF;
1862: OPEN x_cursor FOR
1863: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
1864: FROM HZ_STAGED_CONTACTS stage
1865: WHERE contains( concat_col, p_contains_str)>0
1866: AND EXISTS (
1867: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 1864: FROM HZ_STAGED_CONTACTS stage

1860: 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);
1861: END IF;
1862: OPEN x_cursor FOR
1863: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
1864: FROM HZ_STAGED_CONTACTS stage
1865: WHERE contains( concat_col, p_contains_str)>0
1866: AND EXISTS (
1867: SELECT 1 FROM HZ_STAGED_PARTIES p
1868: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1887: FROM HZ_STAGED_CONTACTS stage

1883: 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);
1884: END IF;
1885: OPEN x_cursor FOR
1886: SELECT ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
1887: FROM HZ_STAGED_CONTACTS stage
1888: WHERE contains( concat_col, p_contains_str)>0
1889: AND EXISTS (
1890: SELECT 1 FROM HZ_STAGED_PARTIES p
1891: WHERE p.PARTY_ID = stage.PARTY_ID

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

1901: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1902: 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);
1903: END IF;
1904: OPEN x_cursor FOR
1905: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX2, TX6, TX5
1906: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1907: WHERE contains( concat_col, p_contains_str)>0
1908: AND d.search_context_id = p_search_ctx_id
1909: AND d.party_id = stage.party_id

Line 1906: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1902: 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);
1903: END IF;
1904: OPEN x_cursor FOR
1905: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX2, TX6, TX5
1906: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1907: WHERE contains( concat_col, p_contains_str)>0
1908: AND d.search_context_id = p_search_ctx_id
1909: AND d.party_id = stage.party_id
1910: AND( (l_search_merged ='Y' )

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

1921: IF (l_check_dt > 0 ) THEN
1922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1923: 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);
1924: END IF;
1925: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
1926: ELSIF (l_check > 0 ) THEN
1927: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1928: 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);
1929: END IF;

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

1926: ELSIF (l_check > 0 ) THEN
1927: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1928: 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);
1929: END IF;
1930: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
1931: END IF;
1932: IF l_search_merged = 'Y' THEN
1933: l_status_sql := ' ' ;
1934: ELSIF l_search_merged = 'I' THEN

Line 1940: ' FROM HZ_STAGED_CONTACTS stage'||

1936: ELSE
1937: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
1938: END IF;
1939: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX2, TX6, TX5'||
1940: ' FROM HZ_STAGED_CONTACTS stage'||
1941: ' WHERE contains( concat_col, :cont)>0'||
1942: ' AND EXISTS ('||
1943: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1944: ' WHERE p.party_id = stage.party_id ' ||

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

3511: p_search_ctx_id NUMBER,
3512: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3513: BEGIN
3514: OPEN x_cursor FOR
3515: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
3516: FROM HZ_STAGED_CONTACTS stage
3517: WHERE contains( concat_col, p_contains_str)>0
3518: AND ORG_CONTACT_ID in (
3519: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3516: FROM HZ_STAGED_CONTACTS stage

3512: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3513: BEGIN
3514: OPEN x_cursor FOR
3515: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
3516: FROM HZ_STAGED_CONTACTS stage
3517: WHERE contains( concat_col, p_contains_str)>0
3518: AND ORG_CONTACT_ID in (
3519: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3520: org_contact_id

APPS.HZ_MATCH_RULE_6 dependencies on HZ_STAGED_CONTACTS

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