diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2025-10-14 13:58:16 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2025-10-14 13:58:16 +0700 |
| commit | 935fc808a3908151751c6ef01ab96c5ee679691d (patch) | |
| tree | 819d7ec815736b4c413fe14a3ebc2b29a228174c | |
| parent | d282d6f7c4424a21882f57e0f85ad7ff47520d97 (diff) | |
| parent | fc2f0dcf6fd71d01cdadaaff2b0b9dfea4da47c1 (diff) | |
Merge branch 'master' of https://bitbucket.org/altafixco/transformation-job-bi
| -rw-r--r-- | update_reserved_status.ktr | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/update_reserved_status.ktr b/update_reserved_status.ktr index 7fa7a43..20921e1 100644 --- a/update_reserved_status.ktr +++ b/update_reserved_status.ktr @@ -751,7 +751,7 @@ join procurement_group pg on pg.id = sp.group_id where 1=1 --and pg.sale_id > 0 and (sp.picking_type_id = 29 or sp.picking_type_id = 30) -and (sp.state_reserve not in ('done', 'cancel') or sp.state_reserve is null) +and (sp.state_reserve not in ('done', 'cancel', 'partial') or sp.state_reserve is null) and sp.write_date >= (now() - '180 days'::interval) --and sp.name ILIKE '%BU/OUT%' and sp.state in ('assigned', 'confirmed', 'draft', 'waiting') |