查找物料信息

最新推荐文章于 2024-09-29 08:44:52 发布

weixin_47980554

最新推荐文章于 2024-09-29 08:44:52 发布

阅读量58

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_47980554/article/details/132813952

版权



 SELECT QUERYSTRING, BINDHEADER, BINDBODY FROM BSCUSTOMQUERY WHERE queryId = 'MMS_GetMaterialList' and version = '00001'
 select  M.MATERIALNAME from BSMATERIAL M
 BB62305170013059
 
 SELECT *
 FROM BSMATERIAL M
 WHERE M.MATERIALNAME = 'BB62305170013059'
 ORDER BY MATERIALWEIGHT
 
 
 SELECT  ROWNUM,
M.MATERIALNAME,
       M.MATERIALSPECNAME,
       MS.BRIEFDESC AS DESCRIPTION,
       M.MATERIALTYPE,
       M.MATERIALSTATE,
       M.MATERIALLOCATION,
       M.UNFROZENLIMITTIME,
       M.UNFROZENOVERLIMITTIME,
       M.UNFROZENLIMITCOUNT,
       M.EXPIRYDATETIME,
       M.FRIDGEINTIME,
       M.FRIDGEOUTTIME,     
M.MACHINENAME,
M.MATERIALWEIGHT,
M.SERIALNO,
M.UNFROZENCOUNT,
M.ONMACHINETIME,
ROUND((SYSDATE-M.ONMACHINETIME),2) AS KITTINGTIME,
CASE M.MATERIALSTATE WHEN 'InUse' THEN M.MACHINENAME
       WHEN 'Fridge'THEN M.LINEBINNO
         ELSE '' END AS LINEBINNO
  FROM BSMATERIAL M,BSMATERIALSPEC MS
 WHERE M.MATERIALSTATE  IN ('Moving','InUse','Fridge')
  AND M.MATERIALSPECNAME=MS.MATERIALSPECNAME
  AND M.FACTORYNAME=MS.FACTORYNAME
   AND MS.FACTORYNAME= 'LBP'
   AND ('14-0321094' IS NULL OR M.MATERIALSPECNAME = '14-0321094')
   AND M.MATERIALTYPE = 'PR'
   AND ('2' IS NULL OR M.FLOORNAME ='2')
   ORDER BY M.MATERIALSPECNAME,M.MATERIALSTATE,M.UNFROZENCOUNT DESC ,M.EXPIRYDATETIME,M.FRIDGEINTIME ASC
 
 SELECT CONSTANTVALUE FROM CONSTANTDEF
WHERE CONSTANTNAME='Inquery_Day_Term_Default'

SELECT * FROM BSMATERIAL AA WHERE AA.MACHINENAME='6LPTK06' AND AA.MATERIALSTATE='InUse' AND AA.UNITNAME='6LPTK06-COAT'  AND AA.MATERIALPORT='M01'

SELECT * FROM BSMATERIAL AA WHERE AA.MATERIALSTATE='InUse' AND AA.MATERIALPORT='M01'

SELECT * FROM BSMATERIAL AA WHERE AA.MACHINENAME IN ('6LPTK06','6LPTK07','6LPTK26') AND AA.MATERIALSTATE='InUse' AND AA.MATERIALPORT='M01'

SELECT * FROM BSMATERIAL AA WHERE AA.MACHINENAME='6LPTK07' AND AA.MATERIALSTATE='InUse' 


SELECT ENUMVALUE, DECODE (defaultflag, 'Y', 1, 2) PRIORITY FROM ENUMDEFVALUE ORDER BY priority 

select distinct MACHINEGROUPNAME from machine
select MACHINEGROUPNAME from machine
select distinct MACHINEGROUPNAME from machine where machinename in ('6LPTK06','6LPTK07','6LPTK26')