APPS.ARH_DQM_TREE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 924: hz_cust_acct_sites_all a,

920: l.state,
921: l.postal_code,
922: ps.identifying_address_flag
923: FROM hz_matched_party_sites_gt gs,
924: hz_cust_acct_sites_all a,
925: hz_party_sites ps,
926: hz_locations l
927: WHERE gs.search_context_id = p_ctx_id
928: AND gs.score < 0

Line 1169: hz_cust_acct_sites_all asite,

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
1172: AND gc.score < 0
1173: AND -gc.party_id = i_cust_acct_id