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_CMN_TAXES_ALL

Line 162: JAI_CMN_TAXES_ALL jtc ,

158: jtc.tax_type
159: FROM
160: JAI_OM_WSH_LINES_ALL jspl ,
161: JAI_OM_WSH_LINE_TAXES jsptl,
162: JAI_CMN_TAXES_ALL jtc ,
163: jai_regime_tax_types_v jrttv
164: WHERE
165: jspl.delivery_detail_id = jsptl.delivery_detail_id
166: AND jspl.delivery_id = p_delivery_id

Line 420: jai_cmn_taxes_all jtc ,

416: jrtl.created_by,
417: jrttv.regime_id
418: FROM
419: jai_rcv_line_taxes jrtl,
420: jai_cmn_taxes_all jtc ,
421: jai_regime_tax_types_v jrttv
422: WHERE
423: jrtl.shipment_line_id = p_shipment_line_id
424: AND jrtl.tax_id = jtc.tax_id

Line 766: JAI_CMN_TAXES_ALL jtc ,

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
770: jrct.customer_trx_id = jrctl.customer_trx_id

Line 1057: JAI_CMN_TAXES_ALL jtc ,

1053: 1
1054: FROM
1055: JAI_OM_OE_SO_LINES jsl ,
1056: JAI_OM_OE_SO_TAXES jstl ,
1057: JAI_CMN_TAXES_ALL jtc ,
1058: jai_regime_tax_types_v jrttv
1059: WHERE
1060: jsl.header_id = cp_header_id
1061: AND jsl.line_id = jstl.line_id

Line 1089: JAI_CMN_TAXES_ALL jtc ,

1085: SELECT
1086: 1
1087: FROM
1088: JAI_OM_OE_SO_TAXES jstl ,
1089: JAI_CMN_TAXES_ALL jtc ,
1090: jai_regime_tax_types_v jrttv
1091: WHERE
1092: jsl.line_id = jstl.line_id
1093: AND jtc.tax_id = jstl.tax_id

Line 1310: JAI_CMN_TAXES_ALL jtc ,

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
1314: AND gl_dist.account_class = jai_constants.account_class_rec

Line 1369: JAI_CMN_TAXES_ALL jtc ,

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
1373: AND jtc.tax_id = jrcttl.tax_id

Line 1389: JAI_CMN_TAXES_ALL jtc ,

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
1393: AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id

Line 1856: JAI_CMN_TAXES_ALL jtc ,

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
1860: AND rcta.customer_trx_id = cp_customer_trx_id

Line 2568: , jai_cmn_taxes_all b

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
2572: FROM

Line 2613: JAI_CMN_TAXES_ALL jtc ,

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
2617: AND jrcttl.tax_id = jtc.tax_id

Line 2871: JAI_CMN_TAXES_ALL jtc ,

2867: jdt.tax_amt ,
2868: jdt.func_tax_amt
2869: FROM
2870: jai_cmn_document_taxes jdt ,
2871: JAI_CMN_TAXES_ALL jtc ,
2872: jai_regime_tax_types_v jrttv
2873: WHERE
2874: jdt.tax_id = jtc.tax_id
2875: AND jtc.tax_type = jrttv.tax_type

Line 2916: JAI_CMN_TAXES_ALL jtc ,

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
2920: AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id

Line 3276: JAI_CMN_TAXES_ALL jtc ,

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
3280: AND rcta.complete_flag = jai_constants.yes

Line 3304: , jai_cmn_taxes_all b

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
3308: FROM

Line 3384: JAI_CMN_TAXES_ALL jtc ,

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
3388: AND trx_types.cust_trx_type_id = rcta.cust_trx_type_id

Line 4314: JAI_CMN_TAXES_ALL

4310: IS
4311: SELECT
4312: orig_tax_percentage
4313: FROM
4314: JAI_CMN_TAXES_ALL
4315: WHERE
4316: tax_id = p_tax_id;
4317:
4318: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;

Line 4323: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;

4319: lv_process_flag VARCHAR2(2) ;
4320: lv_process_message VARCHAR2(2000) ;
4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
4323: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
4324: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
4325: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
4326: BEGIN
4327:

Line 4581: JAI_CMN_TAXES_ALL jtc ,

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
4585: AND jrct.customer_trx_id = jrctl.customer_trx_id