DBA Data[Home] [Help]

APPS.OZF_TP_UTIL_QUERIES dependencies on HZ_CUST_ACCOUNTS

Line 305: hz_cust_accounts e

301: Select p.party_name||' '||d.location into x_return_value
302: from hz_parties p,
303: hz_cust_acct_sites c,
304: hz_cust_site_uses d,
305: hz_cust_accounts e
306: where d.site_use_id = p_site_use_id
307: and d.cust_acct_site_id = c.cust_acct_site_id
308: and e.cust_account_id = c.cust_account_id
309: and p.party_id = e.party_id;