DBA Data[Home] [Help]

APPS.IEX_METRIC_CONCUR_PVT dependencies on HZ_CUST_ACCT_SITES

Line 53: hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses

49: CURSOR c_billto IS
50: SELECT site_uses.site_use_id site_use_id, ca.cust_account_id cust_account_id, p.party_id,
51: acct_site.org_id
52: FROM hz_cust_accounts ca, hz_parties p,
53: hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses
54: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
55: AND acct_site.cust_account_id = ca.cust_account_id
56: AND ca.party_id = p.party_id
57: AND p.status = 'A'