[Home] [Help]
726: SELECT jtc.tax_type , sum(jsptl.func_tax_amount) tax_amount /*Removed rounding factor by mmurtuza for bug 16534065*/
727: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
728: JAI_OM_WSH_LINES_ALL jspl ,
729: JAI_CMN_TAXES_ALL jtc ,
730: JAI_INV_ITM_SETUPS jmsi /* Added by Ramananda for bug#5912620*/
731: WHERE jtc.tax_id = jsptl.tax_id
732: AND jspl.delivery_id = p_delivery_id
733: AND jspl.delivery_detail_id = jsptl.delivery_detail_id
734: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
1805: v_conversion_rate NUMBER := 1;
1806: v_assessable_value NUMBER; -- := p_assessable_value;
1807: -- Commente and Added by Brathod, For Bug# 4299606 (DFF Elimination)
1808: -- V_ITEM_CLASS_ISSUE MTL_SYSTEM_ITEMS.ATTRIBUTE3%TYPE; ---- 20-APR-01 Vijay Jagdish
1809: V_ITEM_CLASS_ISSUE JAI_INV_ITM_SETUPS.ITEM_CLASS%TYPE;
1810:
1811: -- Start, Vijay Shankar for Bug# 3408210
1812: v_to_other_fact_n_pay_ed_qty NUMBER;
1813: v_to_other_fact_n_pay_ed_val NUMBER;
1887:
1888: /***added by Jagdish and vijay on */
1889: CURSOR rg_manufactured_loose_cur IS
1890: SELECT item_class -- Commented attribute3 by Brathod, For Bug# 4299606 (DFF Elimination)
1891: FROM JAI_INV_ITM_SETUPS -- Commneted mtl_system_items by Brathod for Bug# 4299606 (DFF Elimination)
1892: WHERE inventory_item_id=p_inventory_item_id
1893: AND organization_id = p_org_id;
1894:
1895: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';
2026: Issue:-
2027: Item DFF Elimination
2028: Fix:-
2029: Changed the code that references attributeN (where N=1,2,3,4,5,15) of
2030: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS
2031:
2032: Dependency :-
2033: IN60106 + 4239736 (Service Tax) + 4245089 (VAT)
2034: