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_EER1_PKG dependencies on JAI_CONSTANTS

Line 1582: WHERE tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )

1578: CURSOR cur_other_credit
1579: IS
1580: SELECT round(sum(nvl(debit,0)),0)
1581: FROM JAI_CMN_RG_OTHERS
1582: WHERE tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )
1583: AND source_type = 1
1584: AND source_register_id in
1585: ( SELECT register_id
1586: FROM JAI_CMN_RG_23AC_II_TRXS

Line 1598: AND tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )

1594: CURSOR cur_other_current IS
1595: SELECT round(SUM(nvl(credit,0)),0)
1596: FROM JAI_CMN_RG_OTHERS
1597: WHERE source_type=2
1598: AND tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )
1599: AND source_register_id in ( SELECT register_id
1600: FROM JAI_CMN_RG_PLA_TRXS
1601: WHERE organization_id = p_organization_id
1602: AND location_id = p_location_id

Line 1927: AND tax_type IN (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess ) ;

1923: AND to_char(jrgi.creation_date, 'YYYY') || to_char(jrgi.creation_date, 'MM') = ln_yyyymm
1924: AND jrgi.transaction_type in ( 'I','IA','PI','IOI')
1925: AND payment_register = 'PLA')
1926: AND source_type = 2
1927: AND tax_type IN (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess ) ;
1928:
1929: CURSOR cur_other_duties_RG23(
1930: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,
1931: p_excise_duty_rate IN NUMBER,

Line 1952: AND tax_type IN (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess ) ;

1948: AND to_char(jrgi.creation_date, 'YYYY') || to_char(jrgi.creation_date, 'MM') = ln_yyyymm
1949: AND jrgi.transaction_type in ( 'I','IA','PI','IOI')
1950: AND payment_register IN ('RG23A','RG23C') )
1951: AND source_type = 1
1952: AND tax_type IN (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess ) ;
1953:
1954: CURSOR cur_dtls (
1955: p_location_id IN NUMBER,
1956: p_organization_id IN NUMBER,

Line 2004: WHERE tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )

2000: cursor c_other_rg23_ii
2001: is
2002: SELECT round(sum(nvl(debit,0)),0)
2003: FROM JAI_CMN_RG_OTHERS
2004: WHERE tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )
2005: AND source_type = 1
2006: AND source_register_id in
2007: ( SELECT register_id
2008: FROM JAI_CMN_RG_23AC_II_TRXS jrgi

Line 2025: AND tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )

2021: CURSOR cur_other_pla IS
2022: SELECT round(SUM(nvl(credit,0)),0)
2023: FROM JAI_CMN_RG_OTHERS
2024: WHERE source_type=2
2025: AND tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )
2026: AND source_register_id in ( SELECT register_id
2027: FROM JAI_CMN_RG_PLA_TRXS
2028: WHERE organization_id = p_organization_id
2029: AND location_id = p_location_id

Line 2684: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);

2680: FROM JAI_CMN_RG_23AC_II_TRXS
2681: WHERE location_id = p_location_id
2682: AND organization_id = p_organization_id
2683: AND trunc(creation_date) < cp_start_date)
2684: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);
2685:
2686: -- Cursors for Credit availed on Input on invoices issued by manufactureres (EDU CESS)
2687: CURSOR Cur_cess_excise_input_manf
2688: IS

Line 2701: AND JRO.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2697: AND TRUNC(rg23.creation_date) >= p_start_date
2698: AND TRUNC(rg23.creation_date) <= TRUNC(NVL(p_end_date,sysdate))
2699: AND RG23.register_type = 'A'
2700: AND JRO.source_register = 'RG23A_P2'
2701: AND JRO.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2702: AND to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2703:
2704: CURSOR Cur_cess_excise_input_cust
2705: IS

Line 2718: and jro.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2714: and trunc(rg23.creation_date) >= p_start_date
2715: and trunc(rg23.creation_date) <= trunc(nvl(p_end_date,sysdate))
2716: and rg23.register_type = 'A'
2717: and jro.source_register = 'RG23A_P2'
2718: and jro.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2719: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2720:
2721: CURSOR Cur_cess_excise_input_manf_iso
2722: IS

Line 2734: and jro.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2730: and trunc(rg23.creation_date) >= p_start_date
2731: and trunc(rg23.creation_date) <= trunc(nvl(p_end_date,sysdate))
2732: and rg23.register_type = 'A'
2733: and jro.source_register = 'RG23A_P2'
2734: and jro.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2735: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2736:
2737:
2738: -- Cursor for Credit availed on Input on invoices issued by I or II stage dealers (EDU CESS)

Line 2752: and jro.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2748: and trunc(rg23.creation_date) >= p_start_date
2749: and trunc(rg23.creation_date) <= trunc(nvl(p_end_date,sysdate))
2750: and rg23.register_type = 'A'
2751: and jro.source_register = 'RG23A_P2'
2752: and jro.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2753: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2754:
2755: CURSOR Cur_cess_excise_input_stg_iso
2756: IS

Line 2768: AND JRO.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2764: AND TRUNC(RG23.creation_date) >= p_start_date
2765: AND TRUNC(RG23.creation_date) <= TRUNC(NVL(p_end_date,sysdate))
2766: AND RG23.register_type = 'A'
2767: AND JRO.source_register = 'RG23A_P2'
2768: AND JRO.tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2769: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2770:
2771:
2772: -- Cursor for Credit on capital (EDU CESS) AND Total Credit (EDU CESS)

Line 2783: AND jro.tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2779: AND trunc(rg23.creation_date) >= p_start_date
2780: AND trunc(rg23.creation_date) <= trunc(nvl(p_end_date,sysdate))
2781: AND rg23.register_type = p_register_type
2782: AND jro.source_register = p_source_register
2783: AND jro.tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2784: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2785:
2786: -- Cursor for Credit utilised(EDU CESS)
2787: CURSOR cur_edu_cess_excise

Line 2797: AND jro.tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2793: AND trunc(rg23.creation_date) >= p_start_date
2794: AND trunc(rg23.creation_date) <= trunc(nvl(p_end_date,sysdate))
2795: AND rg23.register_type IN ('A','C')
2796: AND jro.source_register in ('RG23A_P2','RG23C_P2')
2797: AND jro.tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2798: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2799:
2800: -- Cursor for Credit utilised (input/capital goods) (EDU CESS)
2801: CURSOR get_rtv_cess IS

Line 2805: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2801: CURSOR get_rtv_cess IS
2802: SELECT sum(nvl(debit,0))
2803: FROM JAI_CMN_RG_OTHERS
2804: WHERE source_type = 1
2805: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2806: AND source_register_id in (
2807: SELECT jrg23_ii.register_id FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i
2808: WHERE jrg23_ii.organization_id = p_organization_id
2809: AND jrg23_ii.location_id = p_location_id

Line 2823: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)

2819: CURSOR get_cgin_sales_cess IS
2820: SELECT sum(nvl(debit,0))
2821: FROM JAI_CMN_RG_OTHERS
2822: WHERE source_type = 1
2823: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2824: AND source_register_id in (
2825: SELECT jrg23_ii.register_id FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i,JAI_INV_ITM_SETUPS jmsi
2826: WHERE jrg23_ii.organization_id = jrg23_i.organization_id
2827: AND jrg23_ii.location_id = jrg23_i.location_id