diff options
Diffstat (limited to 'db/schema/vendorDocu.ts')
| -rw-r--r-- | db/schema/vendorDocu.ts | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 624ce11d..de9dc7fb 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -1949,7 +1949,8 @@ export const stageSubmissionView = pgView("stage_submission_view", { FROM stage_documents sd LEFT JOIN projects p ON sd.project_id = p.id LEFT JOIN vendors v ON sd.vendor_id = v.id - WHERE sd.buyer_system_status = '승인(DC)' + WHERE + ( sd.buyer_system_status = '승인(DC)' OR sd.buyer_system_status = 'Completed' ) -- 승인(DC)라고 하였으나 실제 값은 Completed로 옴 AND sd.status = 'ACTIVE' ), |