# `GetPriorProcessPlan` (function) > 得到上道工序生产情况 - **Type:** FUNCTION - **Returns:** `text` - **Deterministic:** NO - **SQL data access:** CONTAINS SQL ## Parameters | # | Mode | Name | Type | |---|---|---|---| | 1 | IN | `uGuid` | `varchar(100)` | | 2 | IN | `uProcessGuid` | `varchar(100)` | | 3 | IN | `uPrductGuid` | `varchar(100)` | | 4 | IN | `sBrId` | `varchar(100)` | | 5 | IN | `sSuId` | `varchar(100)` | | 6 | IN | `sControlId` | `varchar(100)` | | 7 | IN | `sWorkOrderProcessTbId` | `varchar(100)` | ## Body _Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `GetPriorProcessPlan`'`._ ## Narrative _No human-written narrative yet._