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 335: JAI_AR_TRX_TAX_LINES jrcttl ,

331: jtc.tax_type
332: FROM
333: JAI_AR_TRXS jrct ,
334: JAI_AR_TRX_LINES jrctl ,
335: JAI_AR_TRX_TAX_LINES jrcttl ,
336: JAI_CMN_TAXES_ALL jtc ,
337: jai_regime_tax_types_v jrttv
338:
339: WHERE

Line 819: JAI_AR_TRX_TAX_LINES jrcttl ,

815: FROM
816: ra_cust_trx_line_gl_dist_all gl_dist ,
817: JAI_AR_TRXS jrct ,
818: JAI_AR_TRX_LINES jrctl ,
819: JAI_AR_TRX_TAX_LINES jrcttl ,
820: JAI_CMN_TAXES_ALL jtc ,
821: jai_regime_tax_types_v jrttv
822: WHERE
823: gl_dist.customer_trx_id = jrct.customer_trx_id

Line 874: JAI_AR_TRX_TAX_LINES jrcttl ,

870: jrctl.customer_trx_id = cp_customer_trx_id
871: AND NOT EXISTS ( SELECT /*Check that TCS type of taxes are not */
872: 1
873: FROM
874: JAI_AR_TRX_TAX_LINES jrcttl ,
875: JAI_CMN_TAXES_ALL jtc ,
876: jai_regime_tax_types_v jrttv
877: WHERE
878: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id

Line 894: JAI_AR_TRX_TAX_LINES jrcttl ,

890: SELECT
891: count(*) surcharge_cnt
892: FROM
893: JAI_AR_TRX_LINES jrctl ,
894: JAI_AR_TRX_TAX_LINES jrcttl ,
895: JAI_CMN_TAXES_ALL jtc ,
896: jai_regime_tax_types_v jrttv
897: WHERE
898: jrctl.customer_trx_id = cp_customer_trx_id

Line 1340: JAI_AR_TRX_TAX_LINES jrcttl ,

1336: ra_customer_trx_all rcta ,
1337: ra_cust_trx_line_gl_dist_all gl_dist ,
1338: JAI_AR_TRXS jrct ,
1339: JAI_AR_TRX_LINES jrctl ,
1340: JAI_AR_TRX_TAX_LINES jrcttl ,
1341: JAI_CMN_TAXES_ALL jtc ,
1342: jai_regime_tax_types_v jrttv
1343: WHERE
1344: rcta.complete_flag = jai_constants.yes

Line 2052: jai_ar_trx_tax_lines a

2048: IS
2049: SELECT
2050: SUM(a.func_tax_amount)
2051: FROM
2052: jai_ar_trx_tax_lines a
2053: , jai_cmn_taxes_all b
2054: WHERE link_to_cust_trx_line_id IN
2055: ( SELECT
2056: customer_trx_line_id

Line 2062: ln_total_inv_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

2058: jai_ar_trx_lines
2059: WHERE customer_trx_id = p_ract.customer_trx_id )
2060: AND a.tax_id = b.tax_id
2061: AND NVL(b.inclusive_tax_flag,'N') = 'N';
2062: ln_total_inv_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;
2063: ------------------------------------------------------------------
2064:
2065: /*****
2066: || Get the invoice line details

Line 2097: JAI_AR_TRX_TAX_LINES jrcttl ,

2093: jtc.tax_type ,
2094: jrcttl.tax_amount ,
2095: jrcttl.func_tax_amount
2096: FROM
2097: JAI_AR_TRX_TAX_LINES jrcttl ,
2098: JAI_CMN_TAXES_ALL jtc ,
2099: jai_regime_tax_types_v jrttv
2100: WHERE
2101: jrcttl.link_to_cust_trx_line_id = cp_customer_trx_line_id

Line 2400: JAI_AR_TRX_TAX_LINES jrcttl,

2396: AND exists ( SELECT /* TCS type of taxes exist for the corresponding Invoice */
2397: 1
2398: FROM
2399: JAI_AR_TRX_LINES jrctl ,
2400: JAI_AR_TRX_TAX_LINES jrcttl,
2401: JAI_CMN_TAXES_ALL jtc ,
2402: jai_regime_tax_types_v jrttv
2403: WHERE
2404: jrctl.customer_trx_id = ra.applied_customer_trx_id

Line 2754: JAI_AR_TRX_TAX_LINES jrcttl ,

2750: ra_cust_trx_types_all trx_types ,
2751: ra_cust_trx_line_gl_dist_all gl_dist ,
2752: JAI_AR_TRXS jrct ,
2753: JAI_AR_TRX_LINES jrctl ,
2754: JAI_AR_TRX_TAX_LINES jrcttl ,
2755: JAI_CMN_TAXES_ALL jtc ,
2756: jai_regime_tax_types_v jrttv
2757: WHERE
2758: rcta.customer_trx_id = cp_applied_customer_trx_id

Line 2782: jai_ar_trx_tax_lines a

2778: IS
2779: SELECT
2780: SUM(a.func_tax_amount)
2781: FROM
2782: jai_ar_trx_tax_lines a
2783: , jai_cmn_taxes_all b
2784: WHERE link_to_cust_trx_line_id IN
2785: ( SELECT
2786: customer_trx_line_id

Line 2792: ln_total_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

2788: jai_ar_trx_lines
2789: WHERE customer_trx_id = cp_customer_trx_id )
2790: AND a.tax_id = b.tax_id
2791: AND NVL(b.inclusive_tax_flag,'N') = 'N';
2792: ln_total_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;
2793: ------------------------------------------------------------------
2794:
2795: /*
2796: ||Get the type of the document

Line 2858: JAI_AR_TRX_TAX_LINES jrcttl ,

2854: ra_cust_trx_types_all trx_types ,
2855: ra_cust_trx_line_gl_dist_all gl_dist ,
2856: JAI_AR_TRXS jrct ,
2857: JAI_AR_TRX_LINES jrctl ,
2858: JAI_AR_TRX_TAX_LINES jrcttl ,
2859: JAI_CMN_TAXES_ALL jtc ,
2860: jai_regime_tax_types_v jrttv
2861: WHERE
2862: rcta.complete_flag = jai_constants.yes

Line 4009: JAI_AR_TRX_TAX_LINES jrcttl ,

4005: jrct.invoice_currency_code currency_code
4006: FROM
4007: JAI_AR_TRXS jrct ,
4008: JAI_AR_TRX_LINES jrctl ,
4009: JAI_AR_TRX_TAX_LINES jrcttl ,
4010: JAI_CMN_TAXES_ALL jtc ,
4011: jai_regime_tax_types_v jrttv
4012: WHERE
4013: jrct.customer_trx_id = cp_customer_trx_id

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

4093: ***/
4094:
4095: /*commented by csahoo for bug# 6401388
4096: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4097: pv_log_msg => ' copy TAXES From JAI_AR_TRX_TAX_LINES - p_source_document_type -> '||p_source_document_type
4098: );*/
4099: FOR rec_cur_get_inv_taxes IN cur_get_inv_taxes ( cp_customer_trx_id => p_source_document_id ,
4100: cp_customer_trx_line_id => p_source_document_line_id
4101: )