APPS.ARP_ARXVASUM dependencies on RA_CUSTOMER_TRX

Line 357: ra_customer_trx CT_DM,

353: (nvl(cr.reversal_category, cr.status||'X') = cr.status AND
354: 'Y' = (SELECT 'Y'
355: FROM ar_payment_schedules PS_DM,
356: ra_cust_trx_types CTT_DM,
357: ra_customer_trx CT_DM,
358: ra_cust_trx_line_gl_dist DM_GLD
359: WHERE PS_DM.reversed_cash_receipt_id = cr.cash_receipt_id
360: AND PS_DM.class = 'DM'
361: AND PS_DM.cust_trx_type_id = CTT_DM.cust_trx_type_id

Line 1233: ra_customer_trx ct,

1229: into p_BR_pend_acceptance_amt,
1230: p_BR_pend_acceptance_func_amt,
1231: p_BR_pend_acceptance_count
1232: from ar_transaction_history trh,
1233: ra_customer_trx ct,
1234: ra_customer_trx_lines ctl
1235: where trh.gl_date between p_start_date and p_end_date
1236: and trh.status = 'PENDING_ACCEPTANCE'
1237: and nvl(trh.current_record_flag,'Y') = 'Y'

Line 1234: ra_customer_trx_lines ctl

1230: p_BR_pend_acceptance_func_amt,
1231: p_BR_pend_acceptance_count
1232: from ar_transaction_history trh,
1233: ra_customer_trx ct,
1234: ra_customer_trx_lines ctl
1235: where trh.gl_date between p_start_date and p_end_date
1236: and trh.status = 'PENDING_ACCEPTANCE'
1237: and nvl(trh.current_record_flag,'Y') = 'Y'
1238: and ct.customer_trx_id = trh.customer_trx_id