Award Result According to Procurement Plan Announcement
[ผลการปฏิบัติตามแผนการจัดซื้อจัดจ้าง]



Plan Year Procurement Planning Title
(ปีงบประมาณ) (A.D./B.E./ค.ศ./พ.ศ.) (ชื่อโครงการที่จะจัดซื้อจัดจ้าง)
Regulation Publish date -
(ระเบียบ) (วันที่ประกาศแผนฯ)

Total : 0 Records
declare @PlanYear nvarchar(max) = '2024' declare @MPPTitle nvarchar(max) = '%%' declare @Regulation nvarchar(max) = '' declare @Regulation_Con_Regulation_1 nvarchar(max) = '1' declare @MPPType_Con_Regulation_1_1 nvarchar(max) = 'Normal' declare @MPPEstimatedValueTHB_Con_Regulation_1_From nvarchar(max) = '10000000.01' declare @PlanYear_Con_Regulation_1_From nvarchar(max) = '2019' declare @PlanYear_Con_Regulation_1_To nvarchar(max) = '2024' declare @ProcStrategyCode_Con_Regulation_1_1 nvarchar(max) = '01' declare @ProcStrategyCode_Con_Regulation_1_2 nvarchar(max) = '02' declare @ProcStrategyCode_Con_Regulation_1_3 nvarchar(max) = '05' declare @ProcStrategyCode_Con_Regulation_1_4 nvarchar(max) = '06' declare @ProcStrategyCode_Con_Regulation_1_5 nvarchar(max) = '07' declare @ProcStrategyCode_Con_Regulation_1_6 nvarchar(max) = '08' declare @ProcStrategyCode_Con_Regulation_1_7 nvarchar(max) = '09' declare @ProcStrategyCode_Con_Regulation_1_8 nvarchar(max) = '10' declare @ProcStrategyCode_Con_Regulation_1_9 nvarchar(max) = '11' declare @ProcStrategyCode_Con_Regulation_1_10 nvarchar(max) = '12' declare @ProcStrategyCode_Con_Regulation_1_11 nvarchar(max) = '13' declare @ProcStrategyCode_Con_Regulation_1_12 nvarchar(max) = '14' declare @ProcStrategyCode_Con_Regulation_1_13 nvarchar(max) = '15' declare @Regulation_Con_Regulation_2 nvarchar(max) = '2' declare @MPPType_Con_Regulation_2_1 nvarchar(max) = 'Normal' declare @MPPEstimatedValueUSD_Con_Regulation_2_From nvarchar(max) = '1000000.01' declare @PlanYear_Con_Regulation_2_From nvarchar(max) = '2019' declare @PlanYear_Con_Regulation_2_To nvarchar(max) = '2024' declare @ProcStrategyCode_Con_Regulation_2_1 nvarchar(max) = '01' declare @ProcStrategyCode_Con_Regulation_2_2 nvarchar(max) = '02' declare @ProcStrategyCode_Con_Regulation_2_3 nvarchar(max) = '05' declare @ProcStrategyCode_Con_Regulation_2_4 nvarchar(max) = '06' declare @ProcStrategyCode_Con_Regulation_2_5 nvarchar(max) = '07' declare @ProcStrategyCode_Con_Regulation_2_6 nvarchar(max) = '08' declare @ProcStrategyCode_Con_Regulation_2_7 nvarchar(max) = '09' declare @ProcStrategyCode_Con_Regulation_2_8 nvarchar(max) = '10' declare @ProcStrategyCode_Con_Regulation_2_9 nvarchar(max) = '11' declare @ProcStrategyCode_Con_Regulation_2_10 nvarchar(max) = '12' declare @ProcStrategyCode_Con_Regulation_2_11 nvarchar(max) = '13' declare @ProcStrategyCode_Con_Regulation_2_12 nvarchar(max) = '14' declare @ProcStrategyCode_Con_Regulation_2_13 nvarchar(max) = '15' declare @PublishDate_EffDate nvarchar(max) = '2018-07-23 00:00:00'
SELECT * FROM VIEW_WORKLIST_PUBLISH WHERE
( PlanYear = @PlanYear ) AND ( ( Regulation = @Regulation_Con_Regulation_1 AND ( MPPType = @MPPType_Con_Regulation_1_1 ) AND MPPEstimatedValueTHB >= @MPPEstimatedValueTHB_Con_Regulation_1_From AND PlanYear >= @PlanYear_Con_Regulation_1_From AND PlanYear <= @PlanYear_Con_Regulation_1_To AND ( ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_1 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_2 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_3 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_4 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_5 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_6 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_7 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_8 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_9 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_10 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_11 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_12 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_1_13 ) ) OR ( Regulation = @Regulation_Con_Regulation_2 AND ( MPPType = @MPPType_Con_Regulation_2_1 ) AND MPPEstimatedValueUSD >= @MPPEstimatedValueUSD_Con_Regulation_2_From AND PlanYear >= @PlanYear_Con_Regulation_2_From AND PlanYear <= @PlanYear_Con_Regulation_2_To AND ( ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_1 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_2 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_3 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_4 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_5 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_6 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_7 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_8 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_9 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_10 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_11 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_12 OR ProcStrategyCode = @ProcStrategyCode_Con_Regulation_2_13 ) ) ) AND ( AwardedVendor <> '' AND AwardedVendor IS NOT NULL ) AND ( PublishDate >= @PublishDate_EffDate )