朋友发的易飞LRP相关SQL
--批次需求计划系统
--重点作业的使用(日志)
--是否使用生成批次需求计划:
SELECT CASE WHEN
EXISTS(
SELECT TOP 1 PROGID
FROM DSCSYS.dbo.WORKLOG WITH (NOLOCK)
WHERE PROGID='LRPB01' AND COMPANYID='KANGPU'
) THEN 'Y' ELSE 'N' END AS WLOG
--是否使用维护批次生产计划-按品号:
SELECT CASE WHEN
EXISTS(
SELECT TOP 1 PROGID
FROM DSCSYS.dbo.WORKLOG WITH (NOLOCK)
WHERE PROGID='LRPI01' AND COMPANYID='KANGPU'
) THEN 'Y' ELSE 'N' END AS WLOG
--是否使用维护批次生产计划-按开工日:
SELECT CASE WHEN
EXISTS(
SELECT TOP 1 PROGID
FROM DSCSYS.dbo.WORKLOG WITH (NOLOCK)
WHERE PROGID='LRPI02' AND COMPANYID='KANGPU'
) THEN 'Y' ELSE 'N' END AS WLOG
--是否使用维护批次采购计划-按品号:
SELECT CASE WHEN
EXISTS(
SELECT TOP 1 PROGID
FROM DSCSYS.dbo.WORKLOG WITH (NOLOCK)
WHERE PROGID='LRPI03' AND COMPANYID='KANGPU'
) THEN 'Y' ELSE 'N' END AS WLOG
--是否使用维护批次采购计划-按采购