SELECT
SM_CFNM LABEL --公差名
, SM_CD VALUE --公差代码
FROM TBZ00_COMMCD WHERE LG_CD = 'B01012'
SELECT
SM_CD LABEL
, SM_CD VALUE
FROM TBZ00_COMMCD WHERE LG_CD='B01119'
SELECT T1.SM_CD LABEL
,T1.SM_CD VALUE
FROM TBZ00_COMMCD T1
WHERE T1.LG_CD = 'B01120'
AND T1.USED_YN = 'Y'
MINUS
SELECT T2.DEV_SPEC_CD
,T2.DEV_SPEC_CD
FROM TBB01_SPEC_DEL T2
SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD
FROM TBB01_SPEC_STL
WHERE SPEC_STL_GRD LIKE ? || '%'
ORDER BY SPEC_STL_GRD
SELECT 'N' CHK,T.CUSTSTL,t.mark,t.CUSTNAME,t.SPEC_ABBSYM
from TBB01_SPEC_STL t
where t.SPEC_STL_GRD = ?
INSERT INTO TBB01_SPEC_STL(
SPEC_STL_GRD --交付条件标准号
, CUSTSTL
, CUSTNAME
, SPEC_ABBSYM
, MOD_ID --操作人
, MOD_DTIME --操作时间
, MARK
)
VALUES(?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM TBB01_SPEC_STL))
UPDATE TBB01_SPEC_STL
SET CUSTSTL= ?
,CUSTNAME=?
, SPEC_ABBSYM=?
, MOD_ID = ?
, MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
WHERE SPEC_STL_GRD = ? --交付条件标准号
AND MARK = ?
DELETE FROM TBB01_SPEC_STL
WHERE SPEC_STL_GRD = ? --交付条件标准号
DELETE FROM TBB01_SPEC_STL
WHERE MARK=?
INSERT INTO TBB01_SuanXi_smp(
SPEC_STL_GRD --交付条件标准号
, SPEC_ABBSYM
, ORD_USE_TP
)
VALUES(?,?,?)
SELECT SPEC_STL_GRD DEV_SPEC_CD,SPEC_ABBSYM,ORD_USE_TP
FROM TBB01_SuanXi_smp
WHERE SPEC_STL_GRD LIKE ? || '%'
ORDER BY SPEC_STL_GRD
DELETE FROM TBB01_SuanXi_smp
WHERE SPEC_STL_GRD=? AND SPEC_ABBSYM=? AND ORD_USE_TP=?
{call ZL_NORM_MANAGE.COPY_SPEC_DELE(?,?,?,?,?,?)}