projects
/
Pman.Xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
19abac7
)
pgsql/x-fifo-invfifo-cohead-void-flag.sql
author
Edward
<edward@roojs.com>
Mon, 14 Jul 2014 04:59:43 +0000
(12:59 +0800)
committer
Edward
<edward@roojs.com>
Mon, 14 Jul 2014 04:59:43 +0000
(12:59 +0800)
pgsql/x-fifo-invfifo-cohead-void-flag.sql
patch
|
blob
|
history
diff --git
a/pgsql/x-fifo-invfifo-cohead-void-flag.sql
b/pgsql/x-fifo-invfifo-cohead-void-flag.sql
index
857bbb4
..
c9924fe
100644
(file)
--- a/
pgsql/x-fifo-invfifo-cohead-void-flag.sql
+++ b/
pgsql/x-fifo-invfifo-cohead-void-flag.sql
@@
-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;