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 86: JAI_CMN_TAXES_ALL jtc ,

82: jtc.tax_type
83: FROM
84: JAI_OM_WSH_LINES_ALL jspl ,
85: JAI_OM_WSH_LINE_TAXES jsptl,
86: JAI_CMN_TAXES_ALL jtc ,
87: jai_regime_tax_types_v jrttv
88: WHERE
89: jspl.delivery_detail_id = jsptl.delivery_detail_id
90: AND jspl.delivery_id = p_delivery_id

Line 336: JAI_CMN_TAXES_ALL jtc ,

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

Line 571: JAI_CMN_TAXES_ALL jtc ,

567: 1
568: FROM
569: JAI_OM_OE_SO_LINES jsl ,
570: JAI_OM_OE_SO_TAXES jstl ,
571: JAI_CMN_TAXES_ALL jtc ,
572: jai_regime_tax_types_v jrttv
573: WHERE
574: jsl.header_id = cp_header_id
575: AND jsl.line_id = jstl.line_id

Line 599: JAI_CMN_TAXES_ALL jtc ,

595: SELECT
596: 1
597: FROM
598: JAI_OM_OE_SO_TAXES jstl ,
599: JAI_CMN_TAXES_ALL jtc ,
600: jai_regime_tax_types_v jrttv
601: WHERE
602: jsl.line_id = jstl.line_id
603: AND jtc.tax_id = jstl.tax_id

Line 820: JAI_CMN_TAXES_ALL jtc ,

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

Line 875: JAI_CMN_TAXES_ALL jtc ,

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

Line 895: JAI_CMN_TAXES_ALL jtc ,

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

Line 1341: JAI_CMN_TAXES_ALL jtc ,

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

Line 2053: , jai_cmn_taxes_all b

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

Line 2098: JAI_CMN_TAXES_ALL jtc ,

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

Line 2356: JAI_CMN_TAXES_ALL jtc ,

2352: jdt.tax_amt ,
2353: jdt.func_tax_amt
2354: FROM
2355: jai_cmn_document_taxes jdt ,
2356: JAI_CMN_TAXES_ALL jtc ,
2357: jai_regime_tax_types_v jrttv
2358: WHERE
2359: jdt.tax_id = jtc.tax_id
2360: AND jtc.tax_type = jrttv.tax_type

Line 2401: JAI_CMN_TAXES_ALL jtc ,

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

Line 2755: JAI_CMN_TAXES_ALL jtc ,

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

Line 2783: , jai_cmn_taxes_all b

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

Line 2859: JAI_CMN_TAXES_ALL jtc ,

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

Line 3773: JAI_CMN_TAXES_ALL

3769: IS
3770: SELECT
3771: orig_tax_percentage
3772: FROM
3773: JAI_CMN_TAXES_ALL
3774: WHERE
3775: tax_id = p_tax_id;
3776:
3777: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;

Line 3782: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;

3778: lv_process_flag VARCHAR2(2) ;
3779: lv_process_message VARCHAR2(2000) ;
3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
3782: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
3783: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
3784: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
3785: BEGIN
3786:

Line 4010: JAI_CMN_TAXES_ALL jtc ,

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