APPS.HZ_MATCH_RULE_50 dependencies on HZ_STAGED_CONTACTS

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

1331: l_sqlstr VARCHAR2(4000);
1332: BEGIN
1333: IF p_party_id IS NOT NULL THEN
1334: OPEN x_cursor FOR
1335: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1336: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1337: WHERE
1338: srch.batch_id = -1
1339: AND

Line 1336: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1332: BEGIN
1333: IF p_party_id IS NOT NULL THEN
1334: OPEN x_cursor FOR
1335: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1336: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1337: WHERE
1338: srch.batch_id = -1
1339: AND
1340: (

Line 1356: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage

1352: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1353: IF p_search_ctx_id IS NULL THEN
1354: OPEN x_cursor FOR
1355: SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1356: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage
1357: WHERE
1358: srch.batch_id = -1
1359: AND
1360: (

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

1370: 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)))
1371: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1372: ELSE
1373: OPEN x_cursor FOR
1374: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1375: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1376: WHERE
1377: srch.batch_id = -1
1378: AND

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

1371: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1372: ELSE
1373: OPEN x_cursor FOR
1374: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1375: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1376: WHERE
1377: srch.batch_id = -1
1378: AND
1379: (

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

1388: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1389: END IF;
1390: ELSE
1391: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID , stage.TX2, stage.TX23, stage.TX22'||
1392: ' FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage'||
1393: ' WHERE '||
1394: 'srch.batch_id = -1'||
1395: 'AND'||
1396: '('||

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

2434: p_search_ctx_id NUMBER,
2435: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2436: BEGIN
2437: OPEN x_cursor FOR
2438: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2439: FROM HZ_STAGED_CONTACTS stage
2440: WHERE contains( concat_col, p_contains_str)>0
2441: AND ORG_CONTACT_ID in (
2442: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 2439: FROM HZ_STAGED_CONTACTS stage

2435: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2436: BEGIN
2437: OPEN x_cursor FOR
2438: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2439: FROM HZ_STAGED_CONTACTS stage
2440: WHERE contains( concat_col, p_contains_str)>0
2441: AND ORG_CONTACT_ID in (
2442: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2443: org_contact_id