# `sp_getAllPartsName` (procedure)

> 实际库存


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProductclassifyld` | `varchar(4000)` |
| 2 | IN | `sBrId` | `varchar(100)` |
| 3 | IN | `sSuId` | `varchar(100)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `sp_getAllPartsName`'`._

## Narrative

**Business context:** Splits the comma-delimited `sAllPartsName` string stored on `sisproductclassify` (产品分类's pre-aggregated parts list) into a per-row sId/sName resultset. The carried `COMMENT '实际库存'` is a copy-paste leftover; the actual purpose is a dropdown/lookup helper that returns each `部件名称` (parts name) configured for a product classification.

**What it does:** Looks up `sAllPartsName` from `sisproductclassify` for the given `sProductclassifyld`. If non-empty, walks the comma-split tokens via `Fn_spit_length` and `Fn_split_string` (split-string helpers), inserting each non-blank token as a row into the temporary table `p_t_sId(sId, sName)` where both columns hold the same string. Then `SELECT * FROM p_t_sId` — returning the parts-name list to the caller. No reads from any stock/inventory table.

**Invocation:** Status: appears orphaned via static scan. No `gdsmodule` hook, no `gdsconfigformmaster` reference, no other proc CALLs it, no xly-src grep hit. The proc's signature and output shape match the conventional 下拉选项 (dropdown options) data-source — most likely wired into a front-end cascade selector through a registration channel outside `gdsconfigformmaster`. Candidate for maintainer audit to confirm.