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_CMN_RG_OTHERS

Line 1581: FROM JAI_CMN_RG_OTHERS

1577:
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

Line 1596: FROM JAI_CMN_RG_OTHERS

1592: );
1593:
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

Line 1910: SELECT nvl(sum(debit),0) FROM JAI_CMN_RG_OTHERS

1906: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1907: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type
1908: )
1909: IS
1910: SELECT nvl(sum(debit),0) FROM JAI_CMN_RG_OTHERS
1911: WHERE source_register_id IN(
1912: SELECT register_id_part_ii
1913: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items
1914: WHERE ( jrgi.inventory_item_id = p_inventory_item_id

Line 1936: SELECT nvl(sum(debit),0)FROM JAI_CMN_RG_OTHERS

1932: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1933: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type
1934: )
1935: IS
1936: SELECT nvl(sum(debit),0)FROM JAI_CMN_RG_OTHERS
1937: WHERE source_register_id IN(
1938: SELECT register_id_part_ii FROM JAI_CMN_RG_I_TRXS jrgi, JAI_INV_ITM_SETUPS items
1939: WHERE ( jrgi.inventory_item_id = p_inventory_item_id
1940: OR items.item_tariff = p_cetsh )

Line 2003: FROM JAI_CMN_RG_OTHERS

1999:
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

Line 2023: FROM JAI_CMN_RG_OTHERS

2019: );
2020:
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

Line 2075: FROM JAI_CMN_RG_OTHERS

2071: cp_primary_uom_code varchar2
2072: )
2073: IS
2074: SELECT nvl(sum(debit),0)
2075: FROM JAI_CMN_RG_OTHERS
2076: WHERE source_register_id IN
2077: ( SELECT register_id_part_ii
2078: FROM JAI_CMN_RG_23AC_I_TRXS jrgi,
2079: JAI_INV_ITM_SETUPS items

Line 2099: FROM JAI_CMN_RG_OTHERS

2095: cp_primary_uom_code varchar2
2096: )
2097: IS
2098: SELECT nvl(sum(debit),0)
2099: FROM JAI_CMN_RG_OTHERS
2100: WHERE source_register_id IN
2101: ( SELECT register_id_part_ii
2102: FROM JAI_CMN_RG_23AC_I_TRXS jrgi,
2103: JAI_INV_ITM_SETUPS items

Line 2676: FROM JAI_CMN_RG_OTHERS

2672: -- Cursor for opening balance(EDU CESS)
2673: CURSOR cur_opening_bal_edu_cess(cp_start_date IN DATE )
2674: IS
2675: SELECT round(sum(nvl(credit,0) - nvl(debit,0)),0)
2676: FROM JAI_CMN_RG_OTHERS
2677: WHERE source_type = 1
2678: AND source_register_id in (
2679: SELECT register_id
2680: FROM JAI_CMN_RG_23AC_II_TRXS

Line 2689: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_VENDOR_SITES JIPV

2685:
2686: -- Cursors for Credit availed on Input on invoices issued by manufactureres (EDU CESS)
2687: CURSOR Cur_cess_excise_input_manf
2688: IS
2689: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_VENDOR_SITES JIPV
2690: WHERE jro.source_register_id = RG23.register_id
2691: AND RG23.vendor_id = JIPV.vendor_id
2692: AND RG23.vendor_site_id = JIPV.vendor_site_id
2693: AND ( JIPV.vendor_type IN ('Manufacturer', 'Importer')

Line 2706: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_CUS_ADDRESSES JICA,hz_cust_acct_sites_all HZCAS,hz_cust_site_uses_all HZCSU

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
2706: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_CUS_ADDRESSES JICA,hz_cust_acct_sites_all HZCAS,hz_cust_site_uses_all HZCSU
2707: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
2708: and jica.address_id = hzcsu.cust_acct_site_id
2709: and hzcsu.site_use_id = rg23.customer_site_id
2710: and rg23.customer_id = jica.customer_id

Line 2723: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO

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
2723: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO
2724: WHERE jro.source_register_id = RG23.register_id
2725: and abs(rg23.vendor_id) = jiho.organization_id
2726: and abs(rg23.vendor_site_id)= jiho.location_id
2727: and jiho.manufacturing = 'Y'

Line 2741: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_VENDOR_SITES JIPV

2737:
2738: -- Cursor for Credit availed on Input on invoices issued by I or II stage dealers (EDU CESS)
2739: CURSOR Cur_cess_excise_input_stg
2740: IS
2741: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_VENDOR_SITES JIPV
2742: WHERE jro.source_register_id = RG23.register_id
2743: and rg23.vendor_id = jipv.vendor_id(+)
2744: and rg23.vendor_site_id = jipv.vendor_site_id(+)
2745: AND JIPV.vendor_type IN ('First Stage Dealer', 'Second Stage Dealer')

Line 2757: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO

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
2757: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO
2758: WHERE jro.source_register_id = RG23.register_id
2759: AND ABS(RG23.vendor_id) = JIHO.organization_id
2760: AND ABS(RG23.vendor_site_id)= JIHO.location_id
2761: AND JIHO.trading = 'Y'

Line 2775: SELECT round(nvl(sum(credit),0),0) FROM JAI_CMN_RG_OTHERS jro,JAI_CMN_RG_23AC_II_TRXS rg23

2771:
2772: -- Cursor for Credit on capital (EDU CESS) AND Total Credit (EDU CESS)
2773: CURSOR cur_edu_cess_cap(p_register_type IN VARCHAR2,p_source_register IN VARCHAR2)
2774: IS
2775: SELECT round(nvl(sum(credit),0),0) FROM JAI_CMN_RG_OTHERS jro,JAI_CMN_RG_23AC_II_TRXS rg23
2776: WHERE jro.source_register_id = rg23.register_id
2777: AND rg23.location_id = p_location_id
2778: AND rg23.organization_id = p_organization_id
2779: AND trunc(rg23.creation_date) >= p_start_date

Line 2789: SELECT nvl(sum(debit),0) FROM JAI_CMN_RG_OTHERS jro,JAI_CMN_RG_23AC_II_TRXS rg23

2785:
2786: -- Cursor for Credit utilised(EDU CESS)
2787: CURSOR cur_edu_cess_excise
2788: IS
2789: SELECT nvl(sum(debit),0) FROM JAI_CMN_RG_OTHERS jro,JAI_CMN_RG_23AC_II_TRXS rg23
2790: WHERE jro.source_register_id = rg23.register_id
2791: AND rg23.location_id = p_location_id
2792: AND rg23.organization_id = p_organization_id
2793: AND trunc(rg23.creation_date) >= p_start_date

Line 2803: FROM JAI_CMN_RG_OTHERS

2799:
2800: -- Cursor for Credit utilised (input/capital goods) (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

Line 2821: FROM JAI_CMN_RG_OTHERS

2817: );
2818:
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