DBA Data[Home] [Help]

APPS.AR_TP_STMT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 265: ,ra_customer_trx_all rct

261: UNION ALL
262: SELECT 'A' trx_type
263: ,SUM(NVL(aa.acctd_amount,0)) accounted_amount
264: FROM ar_adjustments aa
265: ,ra_customer_trx_all rct
266: ,ra_cust_trx_types_all rctt
267: WHERE rct.customer_trx_id = aa.customer_trx_id
268: AND rct.org_id = aa.org_id
269: AND rct.cust_trx_type_id = rctt.cust_trx_type_id