APPS.HZ_MATCH_RULE_51 dependencies on HZ_STAGED_PARTY_SITES

Line 1057: 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

1053: l_sqlstr VARCHAR2(4000);
1054: BEGIN
1055: IF p_party_id IS NOT NULL THEN
1056: OPEN x_cursor FOR
1057: 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
1058: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1059: WHERE
1060: srch.batch_id = -1
1061: AND

Line 1058: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch

1054: BEGIN
1055: IF p_party_id IS NOT NULL THEN
1056: OPEN x_cursor FOR
1057: 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
1058: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1059: WHERE
1060: srch.batch_id = -1
1061: AND
1062: (

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

1074: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1075: IF p_search_ctx_id IS NULL THEN
1076: OPEN x_cursor FOR
1077: 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
1078: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p
1079: WHERE
1080: srch.batch_id = -1
1081: AND
1082: (

Line 1094: 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

1090: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = p.TX36))
1091: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1092: ELSE
1093: OPEN x_cursor FOR
1094: 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
1095: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1096: WHERE
1097: srch.batch_id = -1
1098: AND

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

1091: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1092: ELSE
1093: OPEN x_cursor FOR
1094: 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
1095: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1096: WHERE
1097: srch.batch_id = -1
1098: AND
1099: (

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

1108: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1109: END IF;
1110: ELSE
1111: 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'||
1112: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||
1113: ' WHERE' ||
1114: 'srch.batch_id = -1'||
1115: 'AND'||
1116: '('||