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

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

1195: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1196: ELSE
1197: OPEN x_cursor FOR
1198: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , stage.TX2, stage.TX59, lpad(rtrim(stage.TX41),9,chr(48)), stage.TX45
1199: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch
1200: WHERE
1201: srch.batch_id = -1
1202: AND
1203: (

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 1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1417: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1418: ELSE
1419: OPEN x_cursor FOR
1420: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1422: WHERE
1423: srch.batch_id = -1
1424: AND
1425: (

Line 1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1538: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1539: ELSE
1540: OPEN x_cursor FOR
1541: 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.TX7, stage.TX10, stage.TX158
1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1543: WHERE
1544: srch.batch_id = -1
1545: AND
1546: (

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

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

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

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

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

1842: SAVEPOINT eval_start;
1843: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1844: l_ctx_id := l_search_ctx_id;
1845: FORALL I in 1..H_PARTY_ID.COUNT
1846: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1847: l_search_ctx_id,H_PARTY_ID(I));
1848: H_PARTY_ID.DELETE;
1849: H_PARTY_ID_LIST.DELETE;
1850: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

1849: H_PARTY_ID_LIST.DELETE;
1850: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
1851: l_ctx_id := l_search_ctx_id;
1852: FORALL I in 1..H_PARTY_ID.COUNT
1853: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1854: l_search_ctx_id,H_PARTY_ID(I));
1855: l_party_id_idx := H_PARTY_ID.COUNT+1;
1856: ELSE
1857: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

1919: SAVEPOINT eval_start;
1920: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
1921: l_ctx_id := l_search_ctx_id;
1922: FORALL I in 1..H_PARTY_ID.COUNT
1923: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1924: l_search_ctx_id,H_PARTY_ID(I));
1925: H_PARTY_ID.DELETE;
1926: H_PARTY_ID_LIST.DELETE;
1927: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

1994: SAVEPOINT eval_start;
1995: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
1996: l_ctx_id := l_search_ctx_id;
1997: FORALL I in 1..H_PARTY_ID.COUNT
1998: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
1999: l_search_ctx_id,H_PARTY_ID(I));
2000: H_PARTY_ID.DELETE;
2001: H_PARTY_ID_LIST.DELETE;
2002: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2001: H_PARTY_ID_LIST.DELETE;
2002: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2003: l_ctx_id := l_search_ctx_id;
2004: FORALL I in 1..H_PARTY_ID.COUNT
2005: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2006: l_search_ctx_id,H_PARTY_ID(I));
2007: l_party_id_idx := H_PARTY_ID.COUNT+1;
2008: ELSE
2009: l_ctx_id := NULL;

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

2440: set_person_party_type;
2441: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2442: l_ctx_id := l_search_ctx_id;
2443: FORALL I in 1..H_PARTY_ID.COUNT
2444: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2445: l_search_ctx_id,H_PARTY_ID(I));
2446: H_PARTY_ID.DELETE;
2447: H_PARTY_ID_LIST.DELETE;
2448: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2447: H_PARTY_ID_LIST.DELETE;
2448: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2449: l_ctx_id := l_search_ctx_id;
2450: FORALL I in 1..H_PARTY_ID.COUNT
2451: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2452: l_search_ctx_id,H_PARTY_ID(I));
2453: l_party_id_idx := H_PARTY_ID.COUNT+1;
2454: ELSE
2455: l_ctx_id := NULL;

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

2506: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2507: FROM HZ_STAGED_CONTACTS stage
2508: WHERE contains( concat_col, p_contains_str)>0
2509: AND ORG_CONTACT_ID in (
2510: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2511: org_contact_id
2512: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2513: where d.party_id = r.subject_id
2514: and oc.party_relationship_id = r.relationship_id

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

2508: WHERE contains( concat_col, p_contains_str)>0
2509: AND ORG_CONTACT_ID in (
2510: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2511: org_contact_id
2512: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2513: where d.party_id = r.subject_id
2514: and oc.party_relationship_id = r.relationship_id
2515: and d.search_context_id = p_search_ctx_id);
2516: exception

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

2538: unset_person_party_type;
2539: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2540: l_ctx_id := l_search_ctx_id;
2541: FORALL I in 1..H_PARTY_ID.COUNT
2542: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2543: l_search_ctx_id,H_PARTY_ID(I));
2544: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2545: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2546: HZ_RELATIONSHIPS r

Line 2544: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2540: l_ctx_id := l_search_ctx_id;
2541: FORALL I in 1..H_PARTY_ID.COUNT
2542: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2543: l_search_ctx_id,H_PARTY_ID(I));
2544: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2545: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2546: HZ_RELATIONSHIPS r
2547: WHERE oc.party_relationship_id = r.relationship_id
2548: AND r.object_id = d.party_id

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

2541: FORALL I in 1..H_PARTY_ID.COUNT
2542: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2543: l_search_ctx_id,H_PARTY_ID(I));
2544: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2545: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2546: HZ_RELATIONSHIPS r
2547: WHERE oc.party_relationship_id = r.relationship_id
2548: AND r.object_id = d.party_id
2549: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2551: H_PARTY_ID_LIST.DELETE;
2552: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2553: l_ctx_id := l_search_ctx_id;
2554: FORALL I in 1..H_PARTY_ID.COUNT
2555: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2556: l_search_ctx_id,H_PARTY_ID(I));
2557: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2558: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2559: HZ_RELATIONSHIPS r

Line 2557: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2553: l_ctx_id := l_search_ctx_id;
2554: FORALL I in 1..H_PARTY_ID.COUNT
2555: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2556: l_search_ctx_id,H_PARTY_ID(I));
2557: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2558: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2559: HZ_RELATIONSHIPS r
2560: WHERE oc.party_relationship_id = r.relationship_id
2561: AND r.object_id = d.party_id

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

2554: FORALL I in 1..H_PARTY_ID.COUNT
2555: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2556: l_search_ctx_id,H_PARTY_ID(I));
2557: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2558: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2559: HZ_RELATIONSHIPS r
2560: WHERE oc.party_relationship_id = r.relationship_id
2561: AND r.object_id = d.party_id
2562: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2630: SAVEPOINT eval_start;
2631: l_ctx_id := l_search_ctx_id;
2632: unset_person_party_type;
2633: FORALL I in 1..H_PARTY_ID.COUNT
2634: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2635: l_search_ctx_id,H_PARTY_ID(I));
2636: l_party_id_idx := H_PARTY_ID.COUNT+1;
2637: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
2638: LOOP

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

2675: unset_person_party_type;
2676: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2677: l_ctx_id := l_search_ctx_id;
2678: FORALL I in 1..H_PARTY_ID.COUNT
2679: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2680: l_search_ctx_id,H_PARTY_ID(I));
2681: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2682: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2683: HZ_RELATIONSHIPS r

Line 2681: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2677: l_ctx_id := l_search_ctx_id;
2678: FORALL I in 1..H_PARTY_ID.COUNT
2679: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2680: l_search_ctx_id,H_PARTY_ID(I));
2681: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2682: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2683: HZ_RELATIONSHIPS r
2684: WHERE oc.party_relationship_id = r.relationship_id
2685: AND r.object_id = d.party_id

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

2678: FORALL I in 1..H_PARTY_ID.COUNT
2679: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2680: l_search_ctx_id,H_PARTY_ID(I));
2681: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2682: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2683: HZ_RELATIONSHIPS r
2684: WHERE oc.party_relationship_id = r.relationship_id
2685: AND r.object_id = d.party_id
2686: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2688: H_PARTY_ID_LIST.DELETE;
2689: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2690: l_ctx_id := l_search_ctx_id;
2691: FORALL I in 1..H_PARTY_ID.COUNT
2692: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2693: l_search_ctx_id,H_PARTY_ID(I));
2694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2695: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2696: HZ_RELATIONSHIPS r

Line 2694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)

2690: l_ctx_id := l_search_ctx_id;
2691: FORALL I in 1..H_PARTY_ID.COUNT
2692: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2693: l_search_ctx_id,H_PARTY_ID(I));
2694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2695: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2696: HZ_RELATIONSHIPS r
2697: WHERE oc.party_relationship_id = r.relationship_id
2698: AND r.object_id = d.party_id

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

2691: FORALL I in 1..H_PARTY_ID.COUNT
2692: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2693: l_search_ctx_id,H_PARTY_ID(I));
2694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2695: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2696: HZ_RELATIONSHIPS r
2697: WHERE oc.party_relationship_id = r.relationship_id
2698: AND r.object_id = d.party_id
2699: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;