DBA Data[Home] [Help]

APPS.ARH_DQM_TREE dependencies on HZ_CUST_ACCOUNTS

Line 688: hz_cust_accounts ca2

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

Line 773: FROM hz_cust_accounts a,

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