云星空 按组织查询即时库存

SELECT t0.FMATERIALID fmaterialid_id,
       st04.FMASTERID fmasterid_id,
	   st04.FNUMBER fmaterialid_no,
       t0.FSTOCKID fstockid_id,
       t0.FLOT flot_id,
       t0.FSTOCKUNITID fstockunitid_id,
       t0.FQTY fqty,
       t0.FAVBQTY favbqty,
       t0.FSTOCKSTATUSID fstockstatusid_id,
       t0.FSTOCKORGID fstockorgid_id,
       t0.FOWNERTYPEID fownertypeid,
       t0.FOWNERID fownerid_id,
       t0.FKEEPERTYPEID fkeepertypeid,
       t0.FKEEPERID fkeeperid_id,
       t0.FBASEQTY fbaseqty,
       t0.FBASELOCKQTY fbaselockqty,
       t0.FBASEAVBQTY fbaseavbqty,
       t0.FSTOCKORGID fstockorgid,
       t0.FOBJECTTYPEID fobjecttypeid,
       t0.FID fid
       ,ROW_NUMBER() OVER (ORDER BY t0.FID ASC) fidentityid
	   ,CASE st05.FSTOCKID WHEN t0.FSTOCKID THEN '1' ELSE '0' END FISDEFAULTSTOCK
FROM T_STK_INVENTORY t0
    LEFT OUTER JOIN T_BD_MATERIAL st04
        ON   st04.FMATERIALID = t0.FMATERIALID
	LEFT JOIN t_BD_MaterialStock st05
	    ON st05.FMATERIALID = t0.FMATERIALID

WHERE 1=1 AND FSTOCKSTATUSID!=10006 /*不含报废品*/
AND (
          (
              (
                  (
                      (
                          (
                              (
                               --AND t0.FSTOCKORGID IN ( @FSTOCKORGID ) AND 
								  t0.FSTOCKORGID IN ( 1, 100436, 105552, 105553 )
                              )
                             --AND (st04.FNUMBER LIKE N'%'+@FMATERIALID+'%')
                          )
                        /* AND
                          (
                              (t0.FBASEQTY <> 0)
                              OR (t0.FSECQTY <> 0)
                          )*/
                      )
                      AND FISEFFECTIVED = '1'
                  )
                --  AND (st04.FNUMBER LIKE N'%0101-00000927%')
              )
              AND EXISTS
(
    SELECT FID
    FROM
    (
        SELECT t0.FID
        FROM T_STK_INVENTORY t0
        WHERE t0.FSTOCKORGID IN ( 1, 100436, 105552, 105553 )
    ) txs
    WHERE txs.FID = t0.FID
)
          )
          AND
          (
              t0.FSTOCKORGID IN ( 100436, 1, 0 )
              AND t0.FOBJECTTYPEID = 'STK_Inventory'
          )
      )
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值