DBA Data[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 256: hz_customer_profiles ap,

252: -- if bill level is not set
253: , -91)))
254: into l_term_id
255: from --ra_cust_trx_types tt,
256: hz_customer_profiles ap,
257: hz_cust_site_uses_all su,
258: ra_terms_b apt,
259: ra_terms_b spt,
260: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,

Line 262: from hz_customer_profiles cp,

258: ra_terms_b apt,
259: ra_terms_b spt,
260: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
261: su2.site_use_id profile_bill_to_site_use_id
262: from hz_customer_profiles cp,
263: hz_cust_site_uses_all su1,
264: hz_cust_site_uses_all su2
265: where cp.site_use_id = su1.site_use_id
266: and cp.status ='A'