[易飞]易飞LRP相关SQL

 朋友发的易飞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

--是否使用维护批次采购计划-按采购