APPS.HZ_MATCH_RULE_52 dependencies on HZ_STAGED_CONTACTS

Line 1381: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22

1377: l_sqlstr VARCHAR2(4000);
1378: BEGIN
1379: IF p_party_id IS NOT NULL THEN
1380: OPEN x_cursor FOR
1381: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1382: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1383: WHERE
1384: srch.batch_id = -1
1385: AND

Line 1382: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1378: BEGIN
1379: IF p_party_id IS NOT NULL THEN
1380: OPEN x_cursor FOR
1381: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1382: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1383: WHERE
1384: srch.batch_id = -1
1385: AND
1386: (

Line 1402: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage

1398: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1399: IF p_search_ctx_id IS NULL THEN
1400: OPEN x_cursor FOR
1401: SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1402: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage
1403: WHERE
1404: srch.batch_id = -1
1405: AND
1406: (

Line 1420: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22

1416: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = p.TX36) AND (g_party_stage_rec.TX46 IS NULL OR g_party_stage_rec.TX46||' ' = p.TX46)))
1417: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1418: ELSE
1419: OPEN x_cursor FOR
1420: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1422: WHERE
1423: srch.batch_id = -1
1424: AND

Line 1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1417: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1418: ELSE
1419: OPEN x_cursor FOR
1420: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1422: WHERE
1423: srch.batch_id = -1
1424: AND
1425: (

Line 1438: ' FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage'||

1434: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1435: END IF;
1436: ELSE
1437: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID , stage.TX2, stage.TX23, stage.TX22'||
1438: ' FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage'||
1439: ' WHERE '||
1440: 'srch.batch_id = -1'||
1441: 'AND'||
1442: '('||

Line 2506: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22

2502: p_search_ctx_id NUMBER,
2503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2504: BEGIN
2505: OPEN x_cursor FOR
2506: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2507: FROM HZ_STAGED_CONTACTS stage
2508: WHERE contains( concat_col, p_contains_str)>0
2509: AND ORG_CONTACT_ID in (
2510: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 2507: FROM HZ_STAGED_CONTACTS stage

2503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2504: BEGIN
2505: OPEN x_cursor FOR
2506: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2507: FROM HZ_STAGED_CONTACTS stage
2508: WHERE contains( concat_col, p_contains_str)>0
2509: AND ORG_CONTACT_ID in (
2510: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2511: org_contact_id