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_50 dependencies on HZ_DQM_PARTIES_GT

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

1149: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1150: ELSE
1151: OPEN x_cursor FOR
1152: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , stage.TX2, stage.TX59, lpad(rtrim(stage.TX41),9,chr(48)), stage.TX45
1153: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch
1154: WHERE
1155: srch.batch_id = -1
1156: AND
1157: (

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

1272: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1273: ELSE
1274: OPEN x_cursor FOR
1275: 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
1276: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1277: WHERE
1278: srch.batch_id = -1
1279: AND
1280: (

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

1482: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1483: ELSE
1484: OPEN x_cursor FOR
1485: 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.TX7, stage.TX158, stage.TX10
1486: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1487: WHERE
1488: srch.batch_id = -1
1489: AND
1490: (

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

1709: SAVEPOINT eval_start;
1710: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1711: l_ctx_id := l_search_ctx_id;
1712: FORALL I in 1..H_PARTY_ID.COUNT
1713: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1714: l_search_ctx_id,H_PARTY_ID(I));
1715: H_PARTY_ID.DELETE;
1716: H_PARTY_ID_LIST.DELETE;
1717: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

1716: H_PARTY_ID_LIST.DELETE;
1717: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1718: l_ctx_id := l_search_ctx_id;
1719: FORALL I in 1..H_PARTY_ID.COUNT
1720: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1721: l_search_ctx_id,H_PARTY_ID(I));
1722: l_party_id_idx := H_PARTY_ID.COUNT+1;
1723: ELSE
1724: l_ctx_id := NULL;

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

1775: SAVEPOINT eval_start;
1776: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1777: l_ctx_id := l_search_ctx_id;
1778: FORALL I in 1..H_PARTY_ID.COUNT
1779: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1780: l_search_ctx_id,H_PARTY_ID(I));
1781: H_PARTY_ID.DELETE;
1782: H_PARTY_ID_LIST.DELETE;
1783: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

1782: H_PARTY_ID_LIST.DELETE;
1783: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1784: l_ctx_id := l_search_ctx_id;
1785: FORALL I in 1..H_PARTY_ID.COUNT
1786: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1787: l_search_ctx_id,H_PARTY_ID(I));
1788: l_party_id_idx := H_PARTY_ID.COUNT+1;
1789: ELSE
1790: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

1852: SAVEPOINT eval_start;
1853: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
1854: l_ctx_id := l_search_ctx_id;
1855: FORALL I in 1..H_PARTY_ID.COUNT
1856: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1857: l_search_ctx_id,H_PARTY_ID(I));
1858: H_PARTY_ID.DELETE;
1859: H_PARTY_ID_LIST.DELETE;
1860: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

1859: H_PARTY_ID_LIST.DELETE;
1860: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1861: l_ctx_id := l_search_ctx_id;
1862: FORALL I in 1..H_PARTY_ID.COUNT
1863: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1864: l_search_ctx_id,H_PARTY_ID(I));
1865: l_party_id_idx := H_PARTY_ID.COUNT+1;
1866: ELSE
1867: l_ctx_id := NULL;

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

1927: SAVEPOINT eval_start;
1928: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1929: l_ctx_id := l_search_ctx_id;
1930: FORALL I in 1..H_PARTY_ID.COUNT
1931: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1932: l_search_ctx_id,H_PARTY_ID(I));
1933: H_PARTY_ID.DELETE;
1934: H_PARTY_ID_LIST.DELETE;
1935: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

1934: H_PARTY_ID_LIST.DELETE;
1935: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1936: l_ctx_id := l_search_ctx_id;
1937: FORALL I in 1..H_PARTY_ID.COUNT
1938: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1939: l_search_ctx_id,H_PARTY_ID(I));
1940: l_party_id_idx := H_PARTY_ID.COUNT+1;
1941: ELSE
1942: l_ctx_id := NULL;

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

2372: set_person_party_type;
2373: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2374: l_ctx_id := l_search_ctx_id;
2375: FORALL I in 1..H_PARTY_ID.COUNT
2376: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2377: l_search_ctx_id,H_PARTY_ID(I));
2378: H_PARTY_ID.DELETE;
2379: H_PARTY_ID_LIST.DELETE;
2380: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2379: H_PARTY_ID_LIST.DELETE;
2380: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2381: l_ctx_id := l_search_ctx_id;
2382: FORALL I in 1..H_PARTY_ID.COUNT
2383: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2384: l_search_ctx_id,H_PARTY_ID(I));
2385: l_party_id_idx := H_PARTY_ID.COUNT+1;
2386: ELSE
2387: l_ctx_id := NULL;

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

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
2444: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2445: where d.party_id = r.subject_id
2446: and oc.party_relationship_id = r.relationship_id

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

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
2444: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2445: where d.party_id = r.subject_id
2446: and oc.party_relationship_id = r.relationship_id
2447: and d.search_context_id = p_search_ctx_id);
2448: exception

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

2470: unset_person_party_type;
2471: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2472: l_ctx_id := l_search_ctx_id;
2473: FORALL I in 1..H_PARTY_ID.COUNT
2474: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2475: l_search_ctx_id,H_PARTY_ID(I));
2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2477: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2478: HZ_RELATIONSHIPS r

Line 2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2472: l_ctx_id := l_search_ctx_id;
2473: FORALL I in 1..H_PARTY_ID.COUNT
2474: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2475: l_search_ctx_id,H_PARTY_ID(I));
2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2477: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2478: HZ_RELATIONSHIPS r
2479: WHERE oc.party_relationship_id = r.relationship_id
2480: AND r.object_id = d.party_id

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

2473: FORALL I in 1..H_PARTY_ID.COUNT
2474: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2475: l_search_ctx_id,H_PARTY_ID(I));
2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2477: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2478: HZ_RELATIONSHIPS r
2479: WHERE oc.party_relationship_id = r.relationship_id
2480: AND r.object_id = d.party_id
2481: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2483: H_PARTY_ID_LIST.DELETE;
2484: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2485: l_ctx_id := l_search_ctx_id;
2486: FORALL I in 1..H_PARTY_ID.COUNT
2487: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2488: l_search_ctx_id,H_PARTY_ID(I));
2489: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2490: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2491: HZ_RELATIONSHIPS r

Line 2489: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2485: l_ctx_id := l_search_ctx_id;
2486: FORALL I in 1..H_PARTY_ID.COUNT
2487: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2488: l_search_ctx_id,H_PARTY_ID(I));
2489: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2490: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2491: HZ_RELATIONSHIPS r
2492: WHERE oc.party_relationship_id = r.relationship_id
2493: AND r.object_id = d.party_id

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

2486: FORALL I in 1..H_PARTY_ID.COUNT
2487: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2488: l_search_ctx_id,H_PARTY_ID(I));
2489: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2490: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2491: HZ_RELATIONSHIPS r
2492: WHERE oc.party_relationship_id = r.relationship_id
2493: AND r.object_id = d.party_id
2494: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2562: SAVEPOINT eval_start;
2563: l_ctx_id := l_search_ctx_id;
2564: unset_person_party_type;
2565: FORALL I in 1..H_PARTY_ID.COUNT
2566: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2567: l_search_ctx_id,H_PARTY_ID(I));
2568: l_party_id_idx := H_PARTY_ID.COUNT+1;
2569: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
2570: LOOP

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

2607: unset_person_party_type;
2608: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2609: l_ctx_id := l_search_ctx_id;
2610: FORALL I in 1..H_PARTY_ID.COUNT
2611: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2612: l_search_ctx_id,H_PARTY_ID(I));
2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2614: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2615: HZ_RELATIONSHIPS r

Line 2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2609: l_ctx_id := l_search_ctx_id;
2610: FORALL I in 1..H_PARTY_ID.COUNT
2611: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2612: l_search_ctx_id,H_PARTY_ID(I));
2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2614: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2615: HZ_RELATIONSHIPS r
2616: WHERE oc.party_relationship_id = r.relationship_id
2617: AND r.object_id = d.party_id

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

2610: FORALL I in 1..H_PARTY_ID.COUNT
2611: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2612: l_search_ctx_id,H_PARTY_ID(I));
2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2614: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2615: HZ_RELATIONSHIPS r
2616: WHERE oc.party_relationship_id = r.relationship_id
2617: AND r.object_id = d.party_id
2618: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2620: H_PARTY_ID_LIST.DELETE;
2621: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2622: l_ctx_id := l_search_ctx_id;
2623: FORALL I in 1..H_PARTY_ID.COUNT
2624: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2625: l_search_ctx_id,H_PARTY_ID(I));
2626: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2627: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2628: HZ_RELATIONSHIPS r

Line 2626: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2622: l_ctx_id := l_search_ctx_id;
2623: FORALL I in 1..H_PARTY_ID.COUNT
2624: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2625: l_search_ctx_id,H_PARTY_ID(I));
2626: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2627: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2628: HZ_RELATIONSHIPS r
2629: WHERE oc.party_relationship_id = r.relationship_id
2630: AND r.object_id = d.party_id

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

2623: FORALL I in 1..H_PARTY_ID.COUNT
2624: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2625: l_search_ctx_id,H_PARTY_ID(I));
2626: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2627: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2628: HZ_RELATIONSHIPS r
2629: WHERE oc.party_relationship_id = r.relationship_id
2630: AND r.object_id = d.party_id
2631: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;