FACO Floor Plan System

https://docs.google.com/spreadsheets/d/1tzD0wY3DZDsR-4otDe1WJ7qMvxr8o5Nk20bJNVqfJ1w/edit#gid=886226435

เงื่อนไข
--Maker param = null *New Model
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde = 'O'

--Maker param = O แสดง Model ที่มีการบันทึกไว้แล้ว
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde = 'O'

--Checker param = O,
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde IN ('O','P')

--Maker/Checker param = A,
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde IN ('A')

--Maker param = E,
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde IN ('E', 'RE')

--Checker param = E,
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde IN ('E')

--Maker param = RE,
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde IN ('RE')

--Checker param = RE,
SELECT prmCde,thDesc FROM FPTBGNP011 WHERE prmtyp = 'PRODACT' AND prmCde IN ('RE','P')