APPS.HZ_MATCH_RULE_52 dependencies on HZ_STAGED_PARTY_SITES

Line 1284: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22

1280: l_sqlstr VARCHAR2(4000);
1281: BEGIN
1282: IF p_party_id IS NOT NULL THEN
1283: OPEN x_cursor FOR
1284: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1285: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1286: WHERE
1287: srch.batch_id = -1
1288: AND

Line 1285: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch

1281: BEGIN
1282: IF p_party_id IS NOT NULL THEN
1283: OPEN x_cursor FOR
1284: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1285: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1286: WHERE
1287: srch.batch_id = -1
1288: AND
1289: (

Line 1305: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p

1301: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1302: IF p_search_ctx_id IS NULL THEN
1303: OPEN x_cursor FOR
1304: SELECT /*+ ORDERED USE_NL(srch stage p) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1305: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p
1306: WHERE
1307: srch.batch_id = -1
1308: AND
1309: (

Line 1321: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22

1317: 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))
1318: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1319: ELSE
1320: OPEN x_cursor FOR
1321: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1322: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1323: WHERE
1324: srch.batch_id = -1
1325: AND

Line 1322: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch

1318: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1319: ELSE
1320: OPEN x_cursor FOR
1321: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1322: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1323: WHERE
1324: srch.batch_id = -1
1325: AND
1326: (

Line 1339: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||

1335: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1336: END IF;
1337: ELSE
1338: l_sqlstr := 'SELECT /*+ ORDERED USE_NL(srch stage p) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID , stage.TX26, stage.TX9, stage.TX14, stage.TX22'||
1339: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||
1340: ' WHERE' ||
1341: 'srch.batch_id = -1'||
1342: 'AND'||
1343: '('||