APPS.EAM_WORKORDERBILLING_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 191: HZ_CUST_SITE_USES_ALL SITE,

187: FROM
188: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
189: HZ_PARTY_SITES PARTY_SITE,
190: HZ_LOCATIONS LOC,
191: HZ_CUST_SITE_USES_ALL SITE,
192: HZ_CUST_ACCOUNTS CUST_ACCT
193: WHERE
194: site.site_use_code = 'BILL_TO'
195: and site.status='A'

Line 257: hz_cust_site_uses_all su,

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,
261: su2.site_use_id profile_bill_to_site_use_id

Line 263: hz_cust_site_uses_all su1,

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'
267: and su1.cust_acct_site_id =su2.cust_acct_site_id

Line 264: hz_cust_site_uses_all su2

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'
267: and su1.cust_acct_site_id =su2.cust_acct_site_id
268: and su2.site_use_code = 'BILL_TO'