Sp_BillOfNoPicking_Cljg (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sBrId	varchar(100)
2	IN	sSuId	varchar(100)
3	IN	sLoginId	varchar(100)
4	IN	bFilter	text
5	IN	pageNum	int
6	IN	pageSize	int
7	IN	sUnTaskFormId	varchar(100)
8	OUT	totalCount	int
9	IN	countCloumn	varchar(5000)
10	OUT	countMapJson	longtext
11	IN	sFilterOrderBy	varchar(5000)
12	IN	sGroupby_select_sql	varchar(5000)
13	IN	sGroupby_group_sql	varchar(5000)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpBillOfNoPicking_Cljg'._

Narrative

Business context: 生产执行 / 现场物料管理 / 未领料清单 — customer-variant (suffix _Cljg) of the base Sp_BillOfNoPicking "unpicked-materials list" datasource. The base proc is wired on five 未领料清单 forms (sIds 192116810113315311392412610, 101251240115015959855666640, etc.); this _Cljg variant is a side-build apparently for one site's costing/计件 view.

What it does: Same paged-list shape as the base, with the in-body header comment 因增加了[物料需求]，在[系统参数设定]中加了,领料数据来源管制,故将[未领料清单]改为根据设定来取数据的形式 add by DengWH 2013-01-23. Reads SysSystemSettings.领料数据来源管制 to choose its source set, joins eleproduct, EleMaterials / elematerialsstock, elecustomer, eleprocess, MftWorkOrderControl, and the viw_purpurchaseorder view, then materialises rows where applied quantity exceeds picked quantity into P_Tmp_List.

Invocation: Status: appears orphaned. The base Sp_BillOfNoPicking is wired to five forms; this _Cljg variant has no form-master, gdsmodule, DB-routine, or xly-src caller — only the install-script script/标版/30100101/Sp_BillOfNoPicking_Cljg.sql references it. Candidate for maintainer audit — likely a customer-specific fork that lost its form binding during migration.