pgsql/x-fifo-invfifo-cohead-void-flag.sql
authorEdward <edward@roojs.com>
Mon, 14 Jul 2014 04:59:43 +0000 (12:59 +0800)
committerEdward <edward@roojs.com>
Mon, 14 Jul 2014 04:59:43 +0000 (12:59 +0800)
pgsql/x-fifo-invfifo-cohead-void-flag.sql

index 857bbb4..c9924fe 100644 (file)
@@ -119,8 +119,8 @@ BEGIN
                 invhist_ordtype = 'SO'
             AND
                 invfifo_cohead_id = i_cohead_id
---             AND
---                 invdetail_qty > 0
+            AND
+                invdetail_qty > 0
              
             ORDER BY
                 invdetail_id ASC;
@@ -337,7 +337,7 @@ DECLARE
 BEGIN
     
     
---     if (i_qty > 0) THEN
+    if (i_qty > 0) THEN
         
         --- got return - look for issues
         
@@ -407,7 +407,7 @@ BEGIN
         
         
         
---     END IF;
+    END IF;
      
     
     RETURN FALSE;