APPS.JAI_OM_RG_PKG dependencies on MTL_SYSTEM_ITEMS

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

1804: v_other_ed NUMBER; -- := p_other_ed; --Ramananda for File.Sql.35
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;

Line 1859: FROM mtl_system_items

1855: -- End, Vijay Shankar for Bug# 3408210
1856:
1857: CURSOR primary_uom_cur IS
1858: SELECT primary_uom_code
1859: FROM mtl_system_items
1860: WHERE inventory_item_id = p_inventory_item_id AND
1861: organization_id = p_org_id;
1862:
1863: CURSOR serial_no_cur IS

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

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

Line 2030: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS

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:

Line 2436: FROM mtl_system_items

2432: v_excise_quantity NUMBER; -- := p_excise_quantity; --Ramananda for File.Sql.35
2433:
2434: CURSOR primary_uom_cur IS
2435: SELECT primary_uom_code
2436: FROM mtl_system_items
2437: WHERE inventory_item_id = p_inventory_item_id AND
2438: organization_id = p_org_id;
2439: CURSOR serial_no_cur IS
2440: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1