DBA Data[Home] [Help]

APPS.ARH_DQM_TREE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1047: hz_cust_account_roles ro,

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
1051: and -a.party_id = i_cust_acct_id

Line 1136: hz_cust_account_roles ro,

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
1140: AND gc.score < 0

Line 1168: hz_cust_account_roles ro,

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
1172: AND gc.score < 0