DBA Data[Home] [Help]

APPS.AR_BFB_UTILS_PVT dependencies on RA_TERMS_B

Line 288: ra_terms_b apt,

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

Line 289: ra_terms_b spt

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

Line 348: ra_terms_b sut,

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

Line 349: ra_terms_b apt,

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

Line 350: ra_terms_b spt,

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

Line 351: ra_terms_b ttt,

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

Line 352: ra_terms_b invt

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