DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_INTERFACE_ERRORS_ALL

Line 197: FROM ra_interface_errors_all ie

193: AND ct.term_id = tl.term_id
194: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
195: AND NOT EXISTS
196: (SELECT 'errors'
197: FROM ra_interface_errors_all ie
198: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
199: AND NOT EXISTS
200: (SELECT 'prevent duplicate contingency'
201: FROM ar_line_conts_all alc

Line 431: FROM ra_interface_errors_all ie

427: AND ar_revenue_management_pvt.creditworthy
428: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
429: AND NOT EXISTS
430: (SELECT 'errors'
431: FROM ra_interface_errors_all ie
432: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
433: AND NOT EXISTS
434: (SELECT 'prevent duplicate contingency'
435: FROM ar_line_conts_all alc