eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_AR_TRX_TAX_LINES

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 302: jai_ar_trx_tax_lines rla--Modified by Xiao for bug#12631135.

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.
306: AND rla.customer_trx_line_id = pn_customer_trx_line_id;

Line 367: from jai_ar_trx_tax_lines

363: FROM ra_customer_trx_lines
364: WHERE customer_trx_line_id IN
365: (
366: select link_to_cust_trx_line_id
367: from jai_ar_trx_tax_lines
368: where customer_trx_line_id = pn_customer_trx_line_id
369: )
370: );
371: --------------------------------------------------------------

Line 808: JAI_AR_TRX_TAX_LINES jtrxtl ,

804: ra_customer_trx_all trx ,
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

Line 1701: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;

1697: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1698: lv_source_trx_type VARCHAR2(50) ;
1699: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1700: ln_tot_effcm_rb_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1701: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
1702: ln_sign_of_credit_memo NUMBER ;
1703: ln_cm_ref_ratio NUMBER ;
1704: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
1705: -- Added ln_func_amount for Bug 7522584

Line 1828: JAI_AR_TRX_TAX_LINES jrttl

1824: SELECT
1825: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1826: FROM
1827: JAI_AR_TRX_LINES jrtl ,
1828: JAI_AR_TRX_TAX_LINES jrttl
1829: WHERE
1830: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1831: jrtl.customer_trx_id = cp_inv_customer_trx_id ;
1832:

Line 1843: JAI_AR_TRX_TAX_LINES jrttl

1839: SELECT
1840: sign(nvl(sum(jrttl.tax_amount),0)) sign_of_credit_memo
1841: FROM
1842: JAI_AR_TRX_LINES jrtl ,
1843: JAI_AR_TRX_TAX_LINES jrttl
1844: WHERE
1845: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1846: jrtl.customer_trx_id = cp_cm_customer_trx_id;
1847:

Line 1859: , JAI_AR_TRX_TAX_LINES jrttl

1855: SELECT
1856: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1857: FROM
1858: JAI_AR_TRX_LINES jrtl
1859: , JAI_AR_TRX_TAX_LINES jrttl
1860: , jai_cmn_taxes_all tax
1861: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1862: AND jrtl.customer_trx_id = pn_cm_customer_trx_id
1863: AND jrttl.tax_id = tax.tax_id

Line 2568: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;

2564: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ;
2565: ln_eff_cr_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
2566: ln_eff_cr_disc_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ;
2567: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
2568: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
2569: -- Added for Bug 7522584
2570: ln_func_tax_amt NUMBER ;
2571: lv_process_flag VARCHAR2(2) ;
2572: lv_process_message VARCHAR2(1996) ;

Line 2698: JAI_AR_TRX_TAX_LINES jrttl ,

2694: SELECT
2695: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
2696: FROM
2697: JAI_AR_TRX_LINES jrtl ,
2698: JAI_AR_TRX_TAX_LINES jrttl ,
2699: jai_cmn_taxes_all tax
2700: WHERE
2701: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
2702: jrtl.customer_trx_line_id = nvl(cp_inv_cus_trx_line_id, jrtl.customer_trx_line_id) AND

Line 2722: , JAI_AR_TRX_TAX_LINES jrttl

2718: SELECT
2719: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
2720: FROM
2721: JAI_AR_TRX_LINES jrtl
2722: , JAI_AR_TRX_TAX_LINES jrttl
2723: , jai_cmn_taxes_all tax
2724: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
2725: AND jrtl.customer_trx_id = pn_inv_customer_trx_id
2726: AND jrtl.customer_trx_line_id = nvl(pn_inv_cus_trx_line_id, jrtl.customer_trx_line_id)

Line 3446: FROM jai_ar_trx_tax_lines jattl

3442: , gd.gl_date --Added by Qiong for bug13540741
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

Line 3513: FROM jai_ar_trx_tax_lines jattl

3509: ----------------------------------------------------------------------------------------------
3510: CURSOR get_reversal_entries_cur (pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
3511: SELECT jcta.tax_type, jattl.customer_trx_line_id, trx.trx_date,
3512: jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100 tax_amt
3513: FROM jai_ar_trx_tax_lines jattl
3514: , ra_customer_trx_all trx
3515: , jai_cmn_taxes_all jcta
3516: WHERE trx.customer_trx_id = pn_invoice_id
3517: AND jattl.link_to_cust_trx_line_id = pn_line_number

Line 3551: FROM jai_ar_trx_tax_lines jattl

3547:
3548: CURSOR get_claim_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
3549: SELECT jcta.tax_type, (jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt,
3550: jattl.customer_trx_line_id, trx.trx_date
3551: FROM jai_ar_trx_tax_lines jattl
3552: , ra_customer_trx_all trx
3553: , jai_cmn_taxes_all jcta
3554: WHERE trx.customer_trx_id = pn_invoice_id
3555: AND jattl.link_to_cust_trx_line_id = pn_line_number

Line 3857: jai_ar_trx_tax_lines tax,

3853: trx.location_id,
3854: line.service_type_code
3855: from jai_rgm_trx_refs refs,
3856: jai_ar_trxs trx,
3857: jai_ar_trx_tax_lines tax,
3858: jai_ar_trx_lines line
3859: where refs.reference_id = cp_reference_id--r_ar_ref_records.reference_id
3860: and refs.line_id = tax.customer_trx_line_id
3861: and refs.invoice_id = trx.customer_trx_id