[Home] [Help]
2052: )
2053: is
2054: SELECT sum( NVL(jrgi.basic_ed,0 ) + NVL(jrgi.other_ed,0) ) Duty_payable,
2055: sum( NVL(jrgi.additional_ed,0)) aed_duty_payable
2056: FROM JAI_CMN_RG_23AC_I_TRXS jrgi,
2057: JAI_INV_ITM_SETUPS items
2058: WHERE jrgi.transaction_type in ( 'RTV', 'I', 'IA', 'IOI', 'PI')
2059: and ( jrgi.inventory_item_id = cp_inventory_item_id
2060: OR items.item_tariff = cp_cetsh
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
2080: WHERE ( items.item_tariff = cp_cetsh
2081: )
2082: and items.inventory_item_id = jrgi.inventory_item_id
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
2104: WHERE items.item_tariff = cp_cetsh
2105: and items.inventory_item_id = jrgi.inventory_item_id
2106: and jrgi.organization_id = p_organization_id
2285: sum( NVL(a.basic_ed,0 ) + NVL(a.additional_ed,0) ) Duty_payable,
2286: sum( NVL(a.other_ed,0)) Other_duties,
2287: a.organization_id
2288: FROM
2289: JAI_CMN_RG_23AC_I_TRXS A ,
2290: mtl_system_items b ,
2291: JAI_INV_ITM_SETUPS c
2292: where a.inventory_item_id = b.inventory_item_id
2293: and c.inventory_item_id = b.inventory_item_id
2639: -- Cursors for Credit utilised (input/capital goods)
2640: CURSOR get_rtv_amount
2641: IS
2642: SELECT sum(nvl(jrg23_ii.DR_BASIC_ED,0) + nvl(jrg23_ii.DR_ADDITIONAL_ED,0) + nvl(jrg23_ii.DR_OTHER_ED,0))
2643: FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i
2644: WHERE jrg23_ii.organization_id = p_organization_id
2645: AND jrg23_ii.location_id = p_location_id
2646: AND trunc(jrg23_ii.creation_date) >= p_start_date
2647: AND trunc(jrg23_ii.creation_date) <= trunc(nvl(p_end_date,sysdate))
2653:
2654: CURSOR get_cgin_sales
2655: IS
2656: SELECT sum(nvl(jrg23_ii.DR_BASIC_ED,0) + nvl(jrg23_ii.DR_ADDITIONAL_ED,0) + nvl(jrg23_ii.DR_OTHER_ED,0))
2657: FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i,JAI_INV_ITM_SETUPS jmsi
2658: WHERE jrg23_ii.organization_id = jrg23_i.organization_id
2659: AND jrg23_ii.location_id = jrg23_i.location_id
2660: AND jrg23_ii.register_id_part_i = jrg23_i.register_id
2661: AND jmsi.organization_id = jrg23_ii.organization_id
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
2810: AND trunc(jrg23_ii.creation_date) >= p_start_date
2811: AND trunc(jrg23_ii.creation_date) <= trunc(nvl(p_end_date,sysdate))
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
2828: AND jrg23_ii.register_id_part_i = jrg23_i.register_id
2829: AND jmsi.organization_id = jrg23_ii.organization_id
3659: sum(nvl(quantity_received,0)) total_quantity,
3660: msi.attribute4 item_tariff,
3661: msi.primary_uom_code
3662: from
3663: JAI_CMN_RG_23AC_I_TRXS jrp,
3664: mtl_system_items msi
3665: where
3666: jrp.organization_id = msi.organization_id
3667: and jrp.inventory_item_id = msi.inventory_item_id