DBA Data[Home] [Help]

APPS.ARP_BF_BILL dependencies on HZ_CUST_ACCT_SITES

Line 596: hz_cust_acct_sites acct_site,

592: cp2.cons_bill_level acct_bill_level,
593: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
594: cp2.standard_terms acct_term
595: FROM hz_cust_accounts acct,
596: hz_cust_acct_sites acct_site,
597: hz_cust_site_uses site_uses,
598: hz_customer_profiles cp1,
599: hz_customer_profiles cp2
600: WHERE acct.account_number between P_cust_num_low and P_cust_num_high

Line 925: 'hz_cust_acct_sites acct_site, ' ||

921:
922: -- define generic FROM clause
923: c_site_from :=
924: 'FROM ' ||
925: 'hz_cust_acct_sites acct_site, ' ||
926: 'hz_cust_site_uses site_uses, ' ||
927: 'hz_customer_profiles CP, ' ||
928: 'hz_customer_profiles SP ';
929: