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_TCS_REP_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 765: JAI_AR_TRX_TAX_LINES jrcttl ,

761: jtc.tax_type
762: FROM
763: JAI_AR_TRXS jrct ,
764: JAI_AR_TRX_LINES jrctl ,
765: JAI_AR_TRX_TAX_LINES jrcttl ,
766: JAI_CMN_TAXES_ALL jtc ,
767: jai_regime_tax_types_v jrttv
768:
769: WHERE

Line 1309: JAI_AR_TRX_TAX_LINES jrcttl ,

1305: FROM
1306: ra_cust_trx_line_gl_dist_all gl_dist ,
1307: JAI_AR_TRXS jrct ,
1308: JAI_AR_TRX_LINES jrctl ,
1309: JAI_AR_TRX_TAX_LINES jrcttl ,
1310: JAI_CMN_TAXES_ALL jtc ,
1311: jai_regime_tax_types_v jrttv
1312: WHERE
1313: gl_dist.customer_trx_id = jrct.customer_trx_id

Line 1368: JAI_AR_TRX_TAX_LINES jrcttl ,

1364: AND NVL (rctla.interface_line_attribute11,0) = 0 --Added by JMEENA to filter discount line. for bug#8241099, discount line will have interface_line_attribute11 greater than zero.
1365: AND NOT EXISTS ( SELECT /*Check that TCS type of taxes are not */
1366: 1
1367: FROM
1368: JAI_AR_TRX_TAX_LINES jrcttl ,
1369: JAI_CMN_TAXES_ALL jtc ,
1370: jai_regime_tax_types_v jrttv
1371: WHERE
1372: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id

Line 1388: JAI_AR_TRX_TAX_LINES jrcttl ,

1384: SELECT
1385: count(*) surcharge_cnt
1386: FROM
1387: JAI_AR_TRX_LINES jrctl ,
1388: JAI_AR_TRX_TAX_LINES jrcttl ,
1389: JAI_CMN_TAXES_ALL jtc ,
1390: jai_regime_tax_types_v jrttv
1391: WHERE
1392: jrctl.customer_trx_id = cp_customer_trx_id

Line 1855: JAI_AR_TRX_TAX_LINES jrcttl ,

1851: ra_customer_trx_all rcta ,
1852: ra_cust_trx_line_gl_dist_all gl_dist ,
1853: JAI_AR_TRXS jrct ,
1854: JAI_AR_TRX_LINES jrctl ,
1855: JAI_AR_TRX_TAX_LINES jrcttl ,
1856: JAI_CMN_TAXES_ALL jtc ,
1857: jai_regime_tax_types_v jrttv
1858: WHERE
1859: rcta.complete_flag = jai_constants.yes

Line 2567: jai_ar_trx_tax_lines a

2563: IS
2564: SELECT
2565: SUM(a.func_tax_amount)
2566: FROM
2567: jai_ar_trx_tax_lines a
2568: , jai_cmn_taxes_all b
2569: WHERE link_to_cust_trx_line_id IN
2570: ( SELECT
2571: customer_trx_line_id

Line 2577: ln_total_inv_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

2573: jai_ar_trx_lines
2574: WHERE customer_trx_id = p_ract.customer_trx_id )
2575: AND a.tax_id = b.tax_id
2576: AND NVL(b.inclusive_tax_flag,'N') = 'N';
2577: ln_total_inv_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;
2578: ------------------------------------------------------------------
2579:
2580: /*****
2581: || Get the invoice line details

Line 2612: JAI_AR_TRX_TAX_LINES jrcttl ,

2608: jtc.tax_type ,
2609: jrcttl.tax_amount ,
2610: jrcttl.func_tax_amount
2611: FROM
2612: JAI_AR_TRX_TAX_LINES jrcttl ,
2613: JAI_CMN_TAXES_ALL jtc ,
2614: jai_regime_tax_types_v jrttv
2615: WHERE
2616: jrcttl.link_to_cust_trx_line_id = cp_customer_trx_line_id

Line 2915: JAI_AR_TRX_TAX_LINES jrcttl,

2911: AND exists ( SELECT /* TCS type of taxes exist for the corresponding Invoice */
2912: 1
2913: FROM
2914: JAI_AR_TRX_LINES jrctl ,
2915: JAI_AR_TRX_TAX_LINES jrcttl,
2916: JAI_CMN_TAXES_ALL jtc ,
2917: jai_regime_tax_types_v jrttv
2918: WHERE
2919: jrctl.customer_trx_id = ra.applied_customer_trx_id

Line 3275: JAI_AR_TRX_TAX_LINES jrcttl ,

3271: ra_cust_trx_types_all trx_types ,
3272: ra_cust_trx_line_gl_dist_all gl_dist ,
3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,
3275: JAI_AR_TRX_TAX_LINES jrcttl ,
3276: JAI_CMN_TAXES_ALL jtc ,
3277: jai_regime_tax_types_v jrttv
3278: WHERE
3279: rcta.customer_trx_id = cp_applied_customer_trx_id

Line 3303: jai_ar_trx_tax_lines a

3299: IS
3300: SELECT
3301: SUM(a.func_tax_amount)
3302: FROM
3303: jai_ar_trx_tax_lines a
3304: , jai_cmn_taxes_all b
3305: WHERE link_to_cust_trx_line_id IN
3306: ( SELECT
3307: customer_trx_line_id

Line 3313: ln_total_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

3309: jai_ar_trx_lines
3310: WHERE customer_trx_id = cp_customer_trx_id )
3311: AND a.tax_id = b.tax_id
3312: AND NVL(b.inclusive_tax_flag,'N') = 'N';
3313: ln_total_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;
3314: ------------------------------------------------------------------
3315:
3316: /*
3317: ||Get the type of the document

Line 3383: JAI_AR_TRX_TAX_LINES jrcttl ,

3379: ra_cust_trx_types_all trx_types ,
3380: ra_cust_trx_line_gl_dist_all gl_dist ,
3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,
3383: JAI_AR_TRX_TAX_LINES jrcttl ,
3384: JAI_CMN_TAXES_ALL jtc ,
3385: jai_regime_tax_types_v jrttv
3386: WHERE
3387: rcta.complete_flag = jai_constants.yes

Line 4580: JAI_AR_TRX_TAX_LINES jrcttl ,

4576: jrct.invoice_currency_code currency_code
4577: FROM
4578: JAI_AR_TRXS jrct ,
4579: JAI_AR_TRX_LINES jrctl ,
4580: JAI_AR_TRX_TAX_LINES jrcttl ,
4581: JAI_CMN_TAXES_ALL jtc ,
4582: jai_regime_tax_types_v jrttv
4583: WHERE
4584: jrct.customer_trx_id = cp_customer_trx_id

Line 4668: pv_log_msg => ' copy TAXES From JAI_AR_TRX_TAX_LINES - p_source_document_type -> '||p_source_document_type

4664: ***/
4665:
4666: /*commented by csahoo for bug# 6401388
4667: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4668: pv_log_msg => ' copy TAXES From JAI_AR_TRX_TAX_LINES - p_source_document_type -> '||p_source_document_type
4669: );*/
4670: FOR rec_cur_get_inv_taxes IN cur_get_inv_taxes ( cp_customer_trx_id => p_source_document_id ,
4671: cp_customer_trx_line_id => p_source_document_line_id
4672: )