111: l_item_desc1 ic_item_mst.item_desc1%TYPE;
112: l_item_um ic_item_mst.item_um%TYPE;
113: l_item_um2 ic_item_mst.item_um2%TYPE;
114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
112: l_item_um ic_item_mst.item_um%TYPE;
113: l_item_um2 ic_item_mst.item_um2%TYPE;
114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
166: END IF;
167: /* Selecting Organization details from the organization mst */
168: SELECT orgn_name
169: INTO l_orgn_name
170: FROM sy_orgn_mst
171: WHERE orgn_code = l_orgn_code;
172:
173: /* Selecting Warehouse details from the Warehouse master mst */
174: SELECT whse_name