DBA Data[Home] [Help]

APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 455: FROM RA_CUSTOMER_TRX_LINES_ALL rctl

451: WHERE customer_trx_id = cp_invoice_id;
452:
453: CURSOR c_total_ar_line_amount(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
454: SELECT sum(rctg.acctd_amount)
455: FROM RA_CUSTOMER_TRX_LINES_ALL rctl
456: ,ra_cust_trx_line_gl_dist_all rctg
457: WHERE rctg.customer_trx_id =cp_invoice_id
458: AND rctg.customer_trx_id = rctl.customer_trx_id
459: AND rctg.customer_trx_line_id = rctl.customer_trx_line_id