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.

APPS.HZ_MATCH_RULE_51 dependencies on HZ_DQM_PARTIES_GT

Line 983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch

979: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
980: ELSE
981: OPEN x_cursor FOR
982: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , stage.TX2, stage.TX59, stage.TX45
983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch
984: WHERE
985: srch.batch_id = -1
986: AND
987: (

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 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 1215: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1212: ELSE
1213: OPEN x_cursor FOR
1214: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX158, stage.TX10
1215: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1216: WHERE
1217: srch.batch_id = -1
1218: AND
1219: (

Line 1439: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1435: SAVEPOINT eval_start;
1436: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1437: l_ctx_id := l_search_ctx_id;
1438: FORALL I in 1..H_PARTY_ID.COUNT
1439: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1440: l_search_ctx_id,H_PARTY_ID(I));
1441: H_PARTY_ID.DELETE;
1442: H_PARTY_ID_LIST.DELETE;
1443: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 1446: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1442: H_PARTY_ID_LIST.DELETE;
1443: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1444: l_ctx_id := l_search_ctx_id;
1445: FORALL I in 1..H_PARTY_ID.COUNT
1446: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1447: l_search_ctx_id,H_PARTY_ID(I));
1448: l_party_id_idx := H_PARTY_ID.COUNT+1;
1449: ELSE
1450: l_ctx_id := NULL;

Line 1505: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1501: SAVEPOINT eval_start;
1502: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1503: l_ctx_id := l_search_ctx_id;
1504: FORALL I in 1..H_PARTY_ID.COUNT
1505: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1506: l_search_ctx_id,H_PARTY_ID(I));
1507: H_PARTY_ID.DELETE;
1508: H_PARTY_ID_LIST.DELETE;
1509: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 1512: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1508: H_PARTY_ID_LIST.DELETE;
1509: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1510: l_ctx_id := l_search_ctx_id;
1511: FORALL I in 1..H_PARTY_ID.COUNT
1512: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1513: l_search_ctx_id,H_PARTY_ID(I));
1514: l_party_id_idx := H_PARTY_ID.COUNT+1;
1515: ELSE
1516: l_party_id_idx := H_PARTY_ID.COUNT+1;

Line 1582: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1578: SAVEPOINT eval_start;
1579: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
1580: l_ctx_id := l_search_ctx_id;
1581: FORALL I in 1..H_PARTY_ID.COUNT
1582: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1583: l_search_ctx_id,H_PARTY_ID(I));
1584: H_PARTY_ID.DELETE;
1585: H_PARTY_ID_LIST.DELETE;
1586: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 1589: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1585: H_PARTY_ID_LIST.DELETE;
1586: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1587: l_ctx_id := l_search_ctx_id;
1588: FORALL I in 1..H_PARTY_ID.COUNT
1589: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1590: l_search_ctx_id,H_PARTY_ID(I));
1591: l_party_id_idx := H_PARTY_ID.COUNT+1;
1592: ELSE
1593: l_ctx_id := NULL;

Line 1657: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1653: SAVEPOINT eval_start;
1654: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1655: l_ctx_id := l_search_ctx_id;
1656: FORALL I in 1..H_PARTY_ID.COUNT
1657: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1658: l_search_ctx_id,H_PARTY_ID(I));
1659: H_PARTY_ID.DELETE;
1660: H_PARTY_ID_LIST.DELETE;
1661: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 1664: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

1660: H_PARTY_ID_LIST.DELETE;
1661: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1662: l_ctx_id := l_search_ctx_id;
1663: FORALL I in 1..H_PARTY_ID.COUNT
1664: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1665: l_search_ctx_id,H_PARTY_ID(I));
1666: l_party_id_idx := H_PARTY_ID.COUNT+1;
1667: ELSE
1668: l_ctx_id := NULL;

Line 2100: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2096: set_person_party_type;
2097: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2098: l_ctx_id := l_search_ctx_id;
2099: FORALL I in 1..H_PARTY_ID.COUNT
2100: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2101: l_search_ctx_id,H_PARTY_ID(I));
2102: H_PARTY_ID.DELETE;
2103: H_PARTY_ID_LIST.DELETE;
2104: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 2107: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2103: H_PARTY_ID_LIST.DELETE;
2104: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2105: l_ctx_id := l_search_ctx_id;
2106: FORALL I in 1..H_PARTY_ID.COUNT
2107: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2108: l_search_ctx_id,H_PARTY_ID(I));
2109: l_party_id_idx := H_PARTY_ID.COUNT+1;
2110: ELSE
2111: l_ctx_id := NULL;

Line 2166: SELECT /+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)/

2162: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
2163: FROM HZ_STAGED_CONTACTS stage
2164: WHERE contains( concat_col, p_contains_str)>0
2165: AND ORG_CONTACT_ID in (
2166: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2167: org_contact_id
2168: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2169: where d.party_id = r.subject_id
2170: and oc.party_relationship_id = r.relationship_id

Line 2168: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

2164: WHERE contains( concat_col, p_contains_str)>0
2165: AND ORG_CONTACT_ID in (
2166: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2167: org_contact_id
2168: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2169: where d.party_id = r.subject_id
2170: and oc.party_relationship_id = r.relationship_id
2171: and d.search_context_id = p_search_ctx_id);
2172: exception

Line 2198: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2194: unset_person_party_type;
2195: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2196: l_ctx_id := l_search_ctx_id;
2197: FORALL I in 1..H_PARTY_ID.COUNT
2198: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2199: l_search_ctx_id,H_PARTY_ID(I));
2200: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2201: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2202: HZ_RELATIONSHIPS r

Line 2200: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2196: l_ctx_id := l_search_ctx_id;
2197: FORALL I in 1..H_PARTY_ID.COUNT
2198: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2199: l_search_ctx_id,H_PARTY_ID(I));
2200: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2201: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2202: HZ_RELATIONSHIPS r
2203: WHERE oc.party_relationship_id = r.relationship_id
2204: AND r.object_id = d.party_id

Line 2201: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2197: FORALL I in 1..H_PARTY_ID.COUNT
2198: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2199: l_search_ctx_id,H_PARTY_ID(I));
2200: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2201: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2202: HZ_RELATIONSHIPS r
2203: WHERE oc.party_relationship_id = r.relationship_id
2204: AND r.object_id = d.party_id
2205: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

Line 2211: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2207: H_PARTY_ID_LIST.DELETE;
2208: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2209: l_ctx_id := l_search_ctx_id;
2210: FORALL I in 1..H_PARTY_ID.COUNT
2211: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2212: l_search_ctx_id,H_PARTY_ID(I));
2213: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2214: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2215: HZ_RELATIONSHIPS r

Line 2213: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2209: l_ctx_id := l_search_ctx_id;
2210: FORALL I in 1..H_PARTY_ID.COUNT
2211: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2212: l_search_ctx_id,H_PARTY_ID(I));
2213: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2214: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2215: HZ_RELATIONSHIPS r
2216: WHERE oc.party_relationship_id = r.relationship_id
2217: AND r.object_id = d.party_id

Line 2214: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2210: FORALL I in 1..H_PARTY_ID.COUNT
2211: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2212: l_search_ctx_id,H_PARTY_ID(I));
2213: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2214: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2215: HZ_RELATIONSHIPS r
2216: WHERE oc.party_relationship_id = r.relationship_id
2217: AND r.object_id = d.party_id
2218: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

Line 2290: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2286: SAVEPOINT eval_start;
2287: l_ctx_id := l_search_ctx_id;
2288: unset_person_party_type;
2289: FORALL I in 1..H_PARTY_ID.COUNT
2290: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2291: l_search_ctx_id,H_PARTY_ID(I));
2292: l_party_id_idx := H_PARTY_ID.COUNT+1;
2293: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
2294: LOOP

Line 2335: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2331: unset_person_party_type;
2332: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2333: l_ctx_id := l_search_ctx_id;
2334: FORALL I in 1..H_PARTY_ID.COUNT
2335: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2336: l_search_ctx_id,H_PARTY_ID(I));
2337: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2338: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2339: HZ_RELATIONSHIPS r

Line 2337: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2333: l_ctx_id := l_search_ctx_id;
2334: FORALL I in 1..H_PARTY_ID.COUNT
2335: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2336: l_search_ctx_id,H_PARTY_ID(I));
2337: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2338: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2339: HZ_RELATIONSHIPS r
2340: WHERE oc.party_relationship_id = r.relationship_id
2341: AND r.object_id = d.party_id

Line 2338: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2334: FORALL I in 1..H_PARTY_ID.COUNT
2335: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2336: l_search_ctx_id,H_PARTY_ID(I));
2337: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2338: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2339: HZ_RELATIONSHIPS r
2340: WHERE oc.party_relationship_id = r.relationship_id
2341: AND r.object_id = d.party_id
2342: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

Line 2348: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2344: H_PARTY_ID_LIST.DELETE;
2345: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2346: l_ctx_id := l_search_ctx_id;
2347: FORALL I in 1..H_PARTY_ID.COUNT
2348: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2349: l_search_ctx_id,H_PARTY_ID(I));
2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2351: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2352: HZ_RELATIONSHIPS r

Line 2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2346: l_ctx_id := l_search_ctx_id;
2347: FORALL I in 1..H_PARTY_ID.COUNT
2348: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2349: l_search_ctx_id,H_PARTY_ID(I));
2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2351: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2352: HZ_RELATIONSHIPS r
2353: WHERE oc.party_relationship_id = r.relationship_id
2354: AND r.object_id = d.party_id

Line 2351: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2347: FORALL I in 1..H_PARTY_ID.COUNT
2348: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2349: l_search_ctx_id,H_PARTY_ID(I));
2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2351: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2352: HZ_RELATIONSHIPS r
2353: WHERE oc.party_relationship_id = r.relationship_id
2354: AND r.object_id = d.party_id
2355: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;