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

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

1530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1531: 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);
1532: END IF;
1533: OPEN x_cursor FOR
1534: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1535: FROM HZ_STAGED_CONTACTS stage
1536: WHERE contains( concat_col, p_contains_str)>0
1537: AND EXISTS (
1538: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 1535: FROM HZ_STAGED_CONTACTS stage

1531: 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);
1532: END IF;
1533: OPEN x_cursor FOR
1534: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1535: FROM HZ_STAGED_CONTACTS stage
1536: WHERE contains( concat_col, p_contains_str)>0
1537: AND EXISTS (
1538: SELECT 1 FROM HZ_STAGED_PARTIES p
1539: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1558: FROM HZ_STAGED_CONTACTS 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 ORG_CONTACT_ID, PARTY_ID
1558: FROM HZ_STAGED_CONTACTS 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 1576: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID

1572: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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: OPEN x_cursor FOR
1576: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1577: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1578: WHERE contains( concat_col, p_contains_str)>0
1579: AND d.search_context_id = p_search_ctx_id
1580: AND d.party_id = stage.party_id

Line 1577: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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: OPEN x_cursor FOR
1576: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1577: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1578: WHERE contains( concat_col, p_contains_str)>0
1579: AND d.search_context_id = p_search_ctx_id
1580: AND d.party_id = stage.party_id
1581: AND( (l_search_merged ='Y' )

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

1592: IF (l_check_dt > 0 ) THEN
1593: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1594: 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);
1595: END IF;
1596: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
1597: ELSIF (l_check > 0 ) THEN
1598: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1599: 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);
1600: END IF;

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

1597: ELSIF (l_check > 0 ) THEN
1598: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1599: 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);
1600: END IF;
1601: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
1602: END IF;
1603: IF l_search_merged = 'Y' THEN
1604: l_status_sql := ' ' ;
1605: ELSIF l_search_merged = 'I' THEN

Line 1611: ' FROM HZ_STAGED_CONTACTS stage'||

1607: ELSE
1608: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
1609: END IF;
1610: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
1611: ' FROM HZ_STAGED_CONTACTS stage'||
1612: ' WHERE contains( concat_col, :cont)>0'||
1613: ' AND EXISTS ('||
1614: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1615: ' WHERE p.party_id = stage.party_id ' ||

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

3166: p_search_ctx_id NUMBER,
3167: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3168: BEGIN
3169: OPEN x_cursor FOR
3170: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3171: FROM HZ_STAGED_CONTACTS stage
3172: WHERE contains( concat_col, p_contains_str)>0
3173: AND ORG_CONTACT_ID in (
3174: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3171: FROM HZ_STAGED_CONTACTS stage

3167: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3168: BEGIN
3169: OPEN x_cursor FOR
3170: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3171: FROM HZ_STAGED_CONTACTS stage
3172: WHERE contains( concat_col, p_contains_str)>0
3173: AND ORG_CONTACT_ID in (
3174: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3175: org_contact_id

APPS.HZ_MATCH_RULE_2 dependencies on HZ_STAGED_CONTACTS

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