INSERT INTO po_tran (po_id,indent_tran_id,item_description,uom,indent_qty,po_qty,rate,tax_per,VALUE,include_in_order,ACTIVE,delivery_sch,bill_no,remarks) SELECT 307, id, item_description, uom, reqd_qty, reqd_qty, rate, tax_per, VALUE, 'Y','Y','','','' FROM indent_tran WHERE indent_no=1350