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_VENDOR_SITES

Line 2572: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_VENDOR_SITES JIPV

2568: -- Cursors for Credit availed on Input on invoices issued by manufactureres
2569: CURSOR Cur_crdit_input_manf
2570: IS
2571: SELECT SUM(DECODE(register_type, 'A', nvl(cr_basic_ed,0) + nvl(cr_additional_ed,0) + nvl(cr_other_ed,0),0)) credit_availed_on_inputs_vend
2572: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_VENDOR_SITES JIPV
2573: WHERE location_id = p_location_id
2574: AND organization_id = p_organization_id
2575: AND JIRP.vendor_id = JIPV.vendor_id
2576: AND JIRP.vendor_site_id = JIPV.vendor_site_id

Line 2616: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_VENDOR_SITES JIPV

2612:
2613: CURSOR Cur_crdit_input_stg
2614: IS
2615: SELECT SUM(DECODE(register_type, 'A', nvl(cr_basic_ed,0) + nvl(cr_additional_ed,0) + nvl(cr_other_ed,0),0)) credit_availed_on_inputs
2616: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_VENDOR_SITES JIPV
2617: WHERE location_id = p_location_id
2618: AND organization_id = p_organization_id
2619: AND JIRP.vendor_id = JIPV.vendor_id
2620: AND JIRP.vendor_site_id = JIPV.vendor_site_id

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 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')