284: from ra_cust_trx_types tt,
285: hz_customer_profiles ap,
286: hz_customer_profiles sp,
287: hz_cust_site_uses su,
288: ra_terms_b apt,
289: ra_terms_b spt
290: where p_trx_type_id = tt.cust_trx_type_id
291: and p_org_id = tt.org_id
292: and p_bill_to_site = su.site_use_id
285: hz_customer_profiles ap,
286: hz_customer_profiles sp,
287: hz_cust_site_uses su,
288: ra_terms_b apt,
289: ra_terms_b spt
290: where p_trx_type_id = tt.cust_trx_type_id
291: and p_org_id = tt.org_id
292: and p_bill_to_site = su.site_use_id
293: and p_bill_to_customer = ap.cust_account_id
344: ra_cust_trx_types tt,
345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
354: and trx.previous_customer_trx_id IS NULL -- invoices only
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
354: and trx.previous_customer_trx_id IS NULL -- invoices only
355: and trx.term_id = invt.term_id
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
354: and trx.previous_customer_trx_id IS NULL -- invoices only
355: and trx.term_id = invt.term_id
356: and trx.cust_trx_type_id = tt.cust_trx_type_id