APPS.GMD_FETCH_VALIDITY_RULES dependencies on MTL_SYSTEM_ITEMS

Line 97: FROM mtl_system_items

93: ORDER BY preference;
94:
95: CURSOR cur_item_uom(p_item_id NUMBER) IS
96: SELECT primary_uom_code
97: FROM mtl_system_items
98: WHERE inventory_item_id = p_item_id;
99:
100: CURSOR Cur_std_um (v_yield_type VARCHAR2 ) IS
101: SELECT uom_code

Line 819: FROM mtl_system_items_kfv

815: p_from_um IN VARCHAR2,
816: p_to_um IN VARCHAR2) IS
817: CURSOR Cur_get_item IS
818: SELECT concatenated_segments
819: FROM mtl_system_items_kfv
820: WHERE inventory_item_id = p_item_id;
821: X_item_no VARCHAR2(32);
822: BEGIN
823: OPEN Cur_get_item;