APPS.JAI_OM_RG_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1762: -- V_ITEM_CLASS_ISSUE MTL_SYSTEM_ITEMS.ATTRIBUTE3%TYPE; ---- 20-APR-01 Vijay Jagdish

1758: v_other_ed NUMBER; -- := p_other_ed; --Ramananda for File.Sql.35
1759: v_conversion_rate NUMBER := 1;
1760: v_assessable_value NUMBER; -- := p_assessable_value;
1761: -- Commente and Added by Brathod, For Bug# 4299606 (DFF Elimination)
1762: -- V_ITEM_CLASS_ISSUE MTL_SYSTEM_ITEMS.ATTRIBUTE3%TYPE; ---- 20-APR-01 Vijay Jagdish
1763: V_ITEM_CLASS_ISSUE JAI_INV_ITM_SETUPS.ITEM_CLASS%TYPE;
1764:
1765: -- Start, Vijay Shankar for Bug# 3408210
1766: v_to_other_fact_n_pay_ed_qty NUMBER;

Line 1778: FROM mtl_system_items

1774: -- End, Vijay Shankar for Bug# 3408210
1775:
1776: CURSOR primary_uom_cur IS
1777: SELECT primary_uom_code
1778: FROM mtl_system_items
1779: WHERE inventory_item_id = p_inventory_item_id AND
1780: organization_id = p_org_id;
1781:
1782: CURSOR serial_no_cur IS

Line 1810: FROM JAI_INV_ITM_SETUPS -- Commneted mtl_system_items by Brathod for Bug# 4299606 (DFF Elimination)

1806:
1807: /***added by Jagdish and vijay on */
1808: CURSOR rg_manufactured_loose_cur IS
1809: SELECT item_class -- Commented attribute3 by Brathod, For Bug# 4299606 (DFF Elimination)
1810: FROM JAI_INV_ITM_SETUPS -- Commneted mtl_system_items by Brathod for Bug# 4299606 (DFF Elimination)
1811: WHERE inventory_item_id=p_inventory_item_id
1812: AND organization_id = p_org_id;
1813:
1814: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';

Line 1937: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS

1933: Issue:-
1934: Item DFF Elimination
1935: Fix:-
1936: Changed the code that references attributeN (where N=1,2,3,4,5,15) of
1937: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS
1938:
1939: Dependency :-
1940: IN60106 + 4239736 (Service Tax) + 4245089 (VAT)
1941:

Line 2277: FROM mtl_system_items

2273: v_excise_quantity NUMBER; -- := p_excise_quantity; --Ramananda for File.Sql.35
2274:
2275: CURSOR primary_uom_cur IS
2276: SELECT primary_uom_code
2277: FROM mtl_system_items
2278: WHERE inventory_item_id = p_inventory_item_id AND
2279: organization_id = p_org_id;
2280: CURSOR serial_no_cur IS
2281: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1