APPS.ARH_DQM_TREE dependencies on HZ_MATCHED_PARTIES_GT

Line 119: FROM hz_matched_parties_gt s,

115: SELECT p.party_name,
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

Line 610: FROM hz_matched_parties_gt s,

606: SELECT distinct p.party_name,
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

Line 612: /*hz_matched_parties_gt ca1 Bug2678267 Commented to avoid cartesian join pblm */

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
616: -- AND DECODE(i_status, 'ALL', 'ALL', NVL(p.status,'A')) = i_status

Line 685: FROM hz_matched_parties_gt s,

681: SELECT distinct p.party_name,
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

Line 687: hz_matched_parties_gt ca1,

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
691: AND NVL(s.score,0) >= 0

Line 774: hz_matched_parties_gt s,

770: p.party_number,
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