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.ARH_DQM_CUST_HELPER dependencies on HZ_MATCHED_PARTIES_GT

Line 15: hz_matched_parties_gt mp

11: CURSOR c_exist IS
12: SELECT 'Y'
13: FROM hz_cust_account_roles car,
14: hz_cust_accounts ca,
15: hz_matched_parties_gt mp
16: WHERE car.cust_account_role_id = p_cust_account_role_id
17: AND car.cust_account_id = ca.cust_account_id
18: AND DECODE(p_status,'ALL','ALL',NVL(car.status,'A'))= p_status
19: AND ca.party_id = mp.party_id

Line 33: -- Return Y if the P_CUST_ACCOUNT_ID is already in HZ_MATCHED_PARTIES_GT

29: END;
30:
31: FUNCTION is_cust_acct_in_pty_gt
32: ------------------------------------------------------------------------
33: -- Return Y if the P_CUST_ACCOUNT_ID is already in HZ_MATCHED_PARTIES_GT
34: -- Otherwise N
35: ------------------------------------------------------------------------
36: ( p_ctx_id IN NUMBER,
37: p_cust_account_id IN NUMBER,

Line 43: FROM hz_matched_parties_gt a,

39: RETURN VARCHAR2
40: IS
41: CURSOR c1 IS
42: SELECT 'Y'
43: FROM hz_matched_parties_gt a,
44: hz_cust_accounts b
45: WHERE a.search_context_id = p_ctx_id
46: AND -a.party_id = p_cust_account_id
47: AND b.cust_account_id = p_cust_account_id

Line 150: -- Return Y if the P_CUST_ACCT_SITE_D is associated with a party_id in HZ_MATCHED_PARTIES_GT

146: END;
147:
148: FUNCTION is_as_rel_dqm_pty
149: --------------------------------------------------------------------------------------------
150: -- Return Y if the P_CUST_ACCT_SITE_D is associated with a party_id in HZ_MATCHED_PARTIES_GT
151: -- Otherwise N
152: --------------------------------------------------------------------------------------------
153: ( p_ctx_id IN NUMBER,
154: p_cust_account_id IN NUMBER,

Line 164: hz_matched_parties_gt d,

160: CURSOR c1 IS
161: SELECT 'Y'
162: FROM hz_cust_acct_sites a,
163: hz_party_sites c,
164: hz_matched_parties_gt d,
165: hz_parties e
166: WHERE a.cust_account_id = p_cust_account_id
167: AND a.cust_acct_site_id = p_cust_acct_site_id
168: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status

Line 181: hz_matched_parties_gt d,

177: CURSOR c2 IS
178: SELECT 'Y'
179: FROM hz_cust_acct_sites_all a,
180: hz_party_sites c,
181: hz_matched_parties_gt d,
182: hz_parties e
183: WHERE a.cust_account_id = p_cust_account_id
184: AND a.cust_acct_site_id = p_cust_acct_site_id
185: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status

Line 416: hz_matched_parties_gt f,

412: hz_org_contacts b,
413: hz_relationships c,
414: hz_cust_account_roles d,
415: hz_cust_accounts e,
416: hz_matched_parties_gt f,
417: hz_parties g
418: WHERE a.search_context_id = p_ctx_id
419: AND a.org_contact_id = p_org_contact_id
420: AND NVL(a.score,0) >= 0

Line 465: --{ C Insert Cust Account in HZ_MATCHED_PARTIES_GT

461: ( PARTY_ID , ORG_CONTACT_ID , SCORE , SEARCH_CONTEXT_ID) VALUES
462: ( -lrec.cust_account_id, -lrec.cust_account_role_id, l_score , p_ctx_id );
463:
464: ------------------------------------------------
465: --{ C Insert Cust Account in HZ_MATCHED_PARTIES_GT
466: ------------------------------------------------
467: lyn := is_cust_acct_in_pty_gt( p_ctx_id => p_ctx_id,
468: p_cust_account_id => lrec.cust_account_id,
469: p_status => p_status);

Line 476: INSERT INTO hz_matched_parties_gt

472: l_score := -1;
473: ELSE
474: l_score := -lrec.pty_score;
475: END IF;
476: INSERT INTO hz_matched_parties_gt
477: ( PARTY_ID , SCORE , SEARCH_CONTEXT_ID ) VALUES
478: ( -lrec.cust_account_id, l_score , p_ctx_id );
479: END IF;
480: --}

Line 511: --{ C Insert Cust Account in HZ_MATCHED_PARTIES_GT

507: p_status => p_status);
508: --}
509:
510: ------------------------------------------------
511: --{ C Insert Cust Account in HZ_MATCHED_PARTIES_GT
512: ------------------------------------------------
513: lyn := is_cust_acct_in_pty_gt( p_ctx_id => p_ctx_id,
514: p_cust_account_id => lrec.cust_account_id,
515: p_status => p_status);

Line 522: INSERT INTO hz_matched_parties_gt

518: l_score := -1;
519: ELSE
520: l_score := -lrec.pty_score;
521: END IF;
522: INSERT INTO hz_matched_parties_gt
523: ( PARTY_ID , SCORE , SEARCH_CONTEXT_ID ) VALUES
524: ( -lrec.cust_account_id, l_score , p_ctx_id );
525:
526: END IF;

Line 546: hz_matched_parties_gt b

542: IS
543: CURSOR c1 IS
544: SELECT NVL(score,0)
545: FROM hz_cust_accounts a,
546: hz_matched_parties_gt b
547: WHERE a.cust_account_id = p_cust_account_id
548: AND b.search_context_id = p_ctx_id
549: AND a.party_id = b.party_id
550: AND NVL(b.score,0) >= 0

Line 567: -- If necesary insert also the CUST_ACCOUNT_ID related in HZ_MATCHED_PARTIES_GT

563:
564: PROCEDURE find_as_rel_ps
565: -----------------------------------------------------------------------------------------------
566: -- INSERT all the CUST_ACCT_SITE_ID related to the P_PARTY_SITE_ID in HZ_MATCHED_PARTY_SITES_GT
567: -- If necesary insert also the CUST_ACCOUNT_ID related in HZ_MATCHED_PARTIES_GT
568: -----------------------------------------------------------------------------------------------
569: ( p_ctx_id IN NUMBER,
570: p_party_site_id IN NUMBER,
571: p_score IN NUMBER,

Line 635: INSERT INTO hz_matched_parties_gt

631: l_score := -l_score;
632: ELSE
633: l_score := -1;
634: END IF;
635: INSERT INTO hz_matched_parties_gt
636: ( PARTY_ID , SCORE , SEARCH_CONTEXT_ID ) VALUES
637: ( -l_cust_account_id , l_score , p_ctx_id );
638: END IF;
639: END IF;

Line 911: -- Account / Party Treatement in HZ_MATCHED_PARTIES_GT

907: END;
908:
909: PROCEDURE ac_pty_treatment
910: -------------------------------------------------------
911: -- Account / Party Treatement in HZ_MATCHED_PARTIES_GT
912: -------------------------------------------------------
913: ( p_ctx_id IN NUMBER,
914: p_cur_all IN VARCHAR2,
915: p_status IN VARCHAR2)

Line 920: FROM hz_matched_parties_gt

916: IS
917: CURSOR c1 IS
918: SELECT party_id,
919: NVL(score,0) score
920: FROM hz_matched_parties_gt
921: WHERE NVL(score,0) >= 0
922: AND search_context_id = p_ctx_id;
923: lrec c1%ROWTYPE;
924: lyn VARCHAR2(1);

Line 990: -- INSERT all_cust_account related to P_PARTY_ID in HZ_MATCHED_PARTIES_GT

986: END;
987:
988: PROCEDURE find_all_account_for_party
989: -------------------------------------------------------------------------
990: -- INSERT all_cust_account related to P_PARTY_ID in HZ_MATCHED_PARTIES_GT
991: -------------------------------------------------------------------------
992: ( p_ctx_id IN NUMBER,
993: p_party_id IN NUMBER,
994: p_score IN NUMBER,

Line 1016: INSERT INTO hz_matched_parties_gt

1012: ELSE
1013: l_score := -1;
1014: END IF;
1015: IF p_cur_all = 'ALL' THEN
1016: INSERT INTO hz_matched_parties_gt
1017: ( PARTY_ID , SCORE , SEARCH_CONTEXT_ID ) VALUES
1018: ( -lrec.cust_account_id, l_score , p_ctx_id );
1019: ELSIF p_cur_all = 'CUR' THEN
1020: IF is_any_cs_in_cur_org(lrec.cust_account_id,p_status) = 'Y' THEN

Line 1021: INSERT INTO hz_matched_parties_gt

1017: ( PARTY_ID , SCORE , SEARCH_CONTEXT_ID ) VALUES
1018: ( -lrec.cust_account_id, l_score , p_ctx_id );
1019: ELSIF p_cur_all = 'CUR' THEN
1020: IF is_any_cs_in_cur_org(lrec.cust_account_id,p_status) = 'Y' THEN
1021: INSERT INTO hz_matched_parties_gt
1022: ( PARTY_ID , SCORE , SEARCH_CONTEXT_ID ) VALUES
1023: ( -lrec.cust_account_id, l_score , p_ctx_id );
1024: END IF;
1025: END IF;

Line 1044: hz_matched_parties_gt b

1040: IS
1041: CURSOR c1 IS
1042: SELECT 'Y'
1043: FROM hz_cust_accounts a,
1044: hz_matched_parties_gt b
1045: WHERE a.party_id = p_party_id
1046: AND a.cust_account_id = -b.party_id
1047: AND b.search_context_id = p_ctx_id
1048: AND b.score < 0