DBA Data[Home] [Help]

APPS.IEX_METRIC_CONCUR_PVT dependencies on HZ_CUST_ACCT_SITES

Line 42: hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses

38: CURSOR c_billto IS
39: SELECT site_uses.site_use_id site_use_id, ca.cust_account_id cust_account_id, p.party_id,
40: acct_site.org_id
41: FROM hz_cust_accounts ca, hz_parties p,
42: hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses
43: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
44: AND acct_site.cust_account_id = ca.cust_account_id
45: AND ca.party_id = p.party_id
46: AND p.status = 'A'