APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 198: Fixed: In function is_accrual_basis, jai_ar_trx_tax_lines should be used instead of table ra_customer_trx_lines_all

194: eligible ar lines to populate into repository.
195: In cursor c_get_incompleted_cm, add rgtr.line_id in the group clause.
196:
197: 24. 08-Jun-2011 Xiao for POT change, reg bug#12631135.
198: Fixed: In function is_accrual_basis, jai_ar_trx_tax_lines should be used instead of table ra_customer_trx_lines_all
199: as for taxes lines, they will be held in jai_ar_trx_tax_lines, not in ra_customer_trx_lines_all.
200:
201: 25. 11-Jul-2011 Bug 11787045
202: Description: Credit Memo unapplication on a Receipt does not work as intended.

Line 199: as for taxes lines, they will be held in jai_ar_trx_tax_lines, not in ra_customer_trx_lines_all.

195: In cursor c_get_incompleted_cm, add rgtr.line_id in the group clause.
196:
197: 24. 08-Jun-2011 Xiao for POT change, reg bug#12631135.
198: Fixed: In function is_accrual_basis, jai_ar_trx_tax_lines should be used instead of table ra_customer_trx_lines_all
199: as for taxes lines, they will be held in jai_ar_trx_tax_lines, not in ra_customer_trx_lines_all.
200:
201: 25. 11-Jul-2011 Bug 11787045
202: Description: Credit Memo unapplication on a Receipt does not work as intended.
203: Fix: Receipt Application ID corresponding to the unapplication is not picked by cursor c_get_rec_app.

Line 301: --ra_customer_trx_lines_all rla

297:
298: CURSOR get_trx_gl_date_cur IS
299: SELECT rda.gl_date
300: FROM ra_cust_trx_line_gl_dist_all rda,
301: --ra_customer_trx_lines_all rla
302: jai_ar_trx_tax_lines rla--Modified by Xiao for bug#12631135.
303: WHERE rda.account_class = 'REV'
304: AND rda.customer_trx_line_id = rla.link_to_cust_trx_line_id
305: -- AND rda.customer_trx_id = rla.customer_trx_id --Commented by Xiao for bug#12631135.

Line 809: ra_customer_trx_lines_all rctla , /*14121914*/

805: JAI_AR_TRXS jtrx ,
806: ra_cust_trx_types_all trx_types ,
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,
809: ra_customer_trx_lines_all rctla , /*14121914*/
810: JAI_CMN_TAXES_ALL jtc ,
811: ra_cust_trx_line_gl_dist_all gd--Added by Qiong for bug13540741
812: WHERE
813: trx.org_id = nvl(p_org_id,trx.org_id) AND

Line 2795: FROM ra_customer_trx_lines_all

2791:
2792: CURSOR c_line_trx_id (cp_cust_trx_line_id NUMBER)
2793: IS
2794: SELECT link_to_cust_trx_line_id
2795: FROM ra_customer_trx_lines_all
2796: WHERE customer_trx_line_id = cp_cust_trx_line_id
2797: AND line_type = 'TAX';
2798:
2799: CURSOR c_tot_tax_amount (cp_cust_trx_line_id NUMBER)

Line 2802: FROM ra_customer_trx_lines_all

2798:
2799: CURSOR c_tot_tax_amount (cp_cust_trx_line_id NUMBER)
2800: IS
2801: SELECT sum(extended_amount)
2802: FROM ra_customer_trx_lines_all
2803: WHERE link_to_cust_trx_line_id = cp_cust_trx_line_id
2804: AND line_type = 'TAX';
2805:
2806: CURSOR c_receipt_tax_amount (cp_cust_trx_line_id NUMBER, cp_cash_receipt_id NUMBER, cp_receivable_appln_id NUMBER)

Line 3447: , ra_customer_trx_lines_all trxl

3443: , jattl.customer_trx_line_id
3444: , jattl.link_to_cust_trx_line_id
3445: , jtrx.st_inv_number --Added by Qiong for Advanced Receipts
3446: FROM jai_ar_trx_tax_lines jattl
3447: , ra_customer_trx_lines_all trxl
3448: , ra_customer_trx_all trx
3449: , ra_cust_trx_types_all trx_types
3450: , jai_ar_trxs jtrx
3451: , ra_cust_trx_line_gl_dist_all gd --Added by Qiong for bug13540741