DBA Data[Home] [Help]

APPS.ARP_BF_BILL dependencies on HZ_CUST_SITE_USES

Line 616: hz_cust_site_uses site_uses,

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
620: AND acct_site.cust_account_id = acct.cust_account_id

Line 944: 'hz_cust_site_uses site_uses, ' ||

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:
948: -- define generic WHERE clause