String query = "Select type_details as \"TYPE\" ,trans_no as \"#\", reference as Reference ,loc_code AS Location,tran_date as \"Date\", qty as Quantity, CASE WHEN qty >0 THEN 'In' WHEN qty <0 THEN 'Out' END as \"Inventory In - Out \" from inv_dcl_stock_moves where stock_id=? and trunc(tran_date) BETWEEN TO_DATE('" + Date_From + "', 'yyyy-mm-dd') AND TO_DATE('" + Date_To+ "', 'yyyy-mm-dd')";
No comments:
Post a Comment