APPS.ARH_DQM_TREE dependencies on HZ_PARTIES

Line 120: hz_parties p

116: p.party_number,
117: p.party_id,
118: s.score
119: FROM hz_matched_parties_gt s,
120: hz_parties p
121: WHERE s.party_id = p.party_id
122: AND s.search_context_id = i_ctx_id
123: AND NVL(s.score,0) >= 0
124: -- AND DECODE(i_status,'ALL','ALL',NVL(p.status,'A'))= i_status

Line 306: hz_parties p

302: p.party_number
303: from hz_matched_contacts_gt a,
304: hz_org_contacts o,
305: hz_relationships r,
306: hz_parties p
307: where a.search_context_id = i_ctx_id
308: and a.party_id = i_party_id
309: and a.org_contact_id = o.org_contact_id
310: and nvl(a.score,0) >= 0

Line 381: hz_parties p

377: r.relationship_code rel_code
378: FROM hz_matched_contacts_gt gc,
379: hz_org_contacts c,
380: hz_relationships r,
381: hz_parties p
382: WHERE gc.search_context_id = i_ctx_id
383: AND gc.party_id = i_party_id
384: AND gc.org_contact_id = c.org_contact_id
385: AND NVL(gc.score,0) >= 0

Line 458: AND ctpt.owner_table_name = 'HZ_PARTIES'

454: hz_contact_points ctpt
455: WHERE gcpt.search_context_id = i_ctx_id
456: AND gcpt.party_id = i_party_id
457: AND NVL(gcpt.score,0) >= 0
458: AND ctpt.owner_table_name = 'HZ_PARTIES'
459: AND ctpt.owner_table_id = i_rel_pty_id
460: AND gcpt.contact_point_id = ctpt.contact_point_id;
461: -- AND DECODE(i_status, 'ALL', 'ALL', NVL(ctpt.status,'A')) = i_status;
462:

Line 478: AND ctpt.owner_table_name = 'HZ_PARTIES'

474: hz_contact_points ctpt
475: WHERE gcpt.search_context_id = i_ctx_id
476: AND gcpt.party_id = i_party_id
477: AND NVL(gcpt.score,0) >= 0
478: AND ctpt.owner_table_name = 'HZ_PARTIES'
479: AND ctpt.owner_table_id = i_party_id
480: AND gcpt.contact_point_id = ctpt.contact_point_id;
481: -- AND DECODE(i_status, 'ALL', 'ALL', NVL(ctpt.status,'A')) = i_status;
482:

Line 611: hz_parties p

607: p.party_number,
608: p.party_id,
609: s.score
610: FROM hz_matched_parties_gt s,
611: hz_parties p
612: /*hz_matched_parties_gt ca1 Bug2678267 Commented to avoid cartesian join pblm */
613: WHERE s.party_id = p.party_id
614: AND s.search_context_id = i_ctx_id
615: AND NVL(s.score,0) >= 0

Line 686: hz_parties p,

682: p.party_number,
683: p.party_id,
684: s.score
685: FROM hz_matched_parties_gt s,
686: hz_parties p,
687: hz_matched_parties_gt ca1,
688: hz_cust_accounts ca2
689: WHERE s.party_id = p.party_id
690: AND s.search_context_id = i_ctx_id

Line 775: hz_parties p

771: p.party_id,
772: s.score
773: FROM hz_cust_accounts a,
774: hz_matched_parties_gt s,
775: hz_parties p
776: WHERE a.party_id = i_party_id
777: AND a.cust_account_id = -s.party_id
778: AND s.score < 0
779: AND s.search_context_id = i_ctx_id

Line 1046: hz_parties p,

1042: p.party_number,
1043: o.org_contact_id
1044: from hz_matched_contacts_gt a,
1045: hz_relationships r,
1046: hz_parties p,
1047: hz_cust_account_roles ro,
1048: hz_org_contacts o
1049: where a.search_context_id = i_ctx_id
1050: and a.score < 0

Line 1135: hz_parties p,

1131: r.relationship_code rel_code ,
1132: o.org_contact_id
1133: FROM hz_matched_contacts_gt gc,
1134: hz_relationships r,
1135: hz_parties p,
1136: hz_cust_account_roles ro,
1137: hz_cust_acct_sites asite,
1138: hz_org_contacts o
1139: WHERE gc.search_context_id = i_ctx_id

Line 1167: hz_parties p,

1163: r.relationship_code rel_code ,
1164: o.org_contact_id
1165: FROM hz_matched_contacts_gt gc,
1166: hz_relationships r,
1167: hz_parties p,
1168: hz_cust_account_roles ro,
1169: hz_cust_acct_sites_all asite,
1170: hz_org_contacts o
1171: WHERE gc.search_context_id = i_ctx_id