DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 233: ar_receivable_applications_all ra_cm,

229: ra_customer_trx prev_trx,
230: ra_cust_trx_types ctt,
231: ra_terms rt,
232: ra_terms_lines rtl,
233: ar_receivable_applications_all ra_cm,
234: ar_payment_schedules_all cm_app_ps,
235: ar_trx_summary trx_sum
236: where trx.customer_trx_id = ps.customer_trx_id
237: and trx.request_id = p_req_id

Line 6139: ar_receivable_applications_all ra_cm,

6135: ra_customer_trx prev_trx,
6136: ra_cust_trx_types ctt,
6137: ra_terms rt,
6138: ra_terms_lines rtl,
6139: ar_receivable_applications_all ra_cm,
6140: ar_payment_schedules_all cm_app_ps,
6141: ar_trx_summary trx_sum
6142: where trx.customer_trx_id = ps.customer_trx_id
6143: and trx.request_id = p_req_id

Line 7246: ar_receivable_applications_all rap

7242: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7243: crh.amount))
7244: FROM ar_cash_receipts_all cr,
7245: ar_cash_receipt_history_all crh,
7246: ar_receivable_applications_all rap
7247: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7248: AND cr.reversal_date IS NULL
7249: AND cr.cash_receipt_id = crh.cash_receipt_id
7250: AND crh.current_record_flag = 'Y'

Line 7288: ar_receivable_applications_all rap

7284: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7285: crh.amount))
7286: FROM ar_cash_receipts_all cr,
7287: ar_cash_receipt_history_all crh,
7288: ar_receivable_applications_all rap
7289: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7290: AND cr.reversal_date IS NULL
7291: AND cr.cash_receipt_id = crh.cash_receipt_id
7292: AND crh.current_record_flag = 'Y'