DBA Data[Home] [Help]

APPS.ARP_BF_BILL dependencies on HZ_CUST_ACCT_SITES

Line 615: hz_cust_acct_sites acct_site,

611: cp2.cons_bill_level acct_bill_level,
612: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
613: cp2.standard_terms acct_term
614: FROM hz_cust_accounts acct,
615: hz_cust_acct_sites acct_site,
616: hz_cust_site_uses site_uses,
617: hz_customer_profiles cp1,
618: hz_customer_profiles cp2
619: WHERE acct.account_number between P_cust_num_low and P_cust_num_high

Line 943: 'hz_cust_acct_sites acct_site, ' ||

939:
940: -- define generic FROM clause
941: c_site_from :=
942: 'FROM ' ||
943: 'hz_cust_acct_sites acct_site, ' ||
944: 'hz_cust_site_uses site_uses, ' ||
945: 'hz_customer_profiles CP, ' ||
946: 'hz_customer_profiles SP ';
947: