DBA Data[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on RA_TERMS

Line 258: ra_terms_b apt,

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
262: from hz_customer_profiles cp,

Line 259: ra_terms_b spt,

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
262: from hz_customer_profiles cp,
263: hz_cust_site_uses_all su1,

Line 294: ra_terms rt

290: begin
291: select rt.name
292: into l_term_name
293: from hz_cust_accounts hca,
294: ra_terms rt
295: where nvl(hca.payment_term_id,4) = rt.term_id
296: and cust_account_id = p_ra_line.customer_id;
297:
298: exception