69: pum_type OUT NOCOPY VARCHAR2) IS
70:
71: CURSOR get_uom_type IS
72: SELECT um_type 73: FROM sy_uoms_mst 74: WHERE um_code = pum;
75:
76: BEGIN
77:
Line 117: FROM ic_item_mst m, sy_uoms_mst s
113: pum_type OUT NOCOPY VARCHAR2) IS
114:
115: CURSOR get_item_info IS
116: SELECT m.item_um, s.um_type 117: FROM ic_item_mst m, sy_uoms_mst s 118: WHERE m.item_id = pitem_id AND
119: m.item_um = s.um_code;
120:
121: BEGIN