PR_Short_Items_Work_Dup (MRP1011)

SELECT
       ['PR_Short_Items_Work_Dup'].USERID AS 'PR_Short_Items_Work_Dup-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PR_Short_Items_Work_Dup'].USERID = ['Users Master'].USERID

SELECT
       ['PR_Short_Items_Work_Dup'].ITEMNMBR AS 'PR_Short_Items_Work_Dup-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PR_Short_Items_Work_Dup'].ITEMNMBR = ['Item Master'].ITEMNMBR

SELECT
       ['PR_Short_Items_Work_Dup'].LOCNCODE AS 'PR_Short_Items_Work_Dup-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['PR_Short_Items_Work_Dup'].LOCNCODE = ['Site Setup'].LOCNCODE

SELECT
       ['PR_Short_Items_Work_Dup'].VENDORID AS 'PR_Short_Items_Work_Dup-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PR_Short_Items_Work_Dup'].VENDORID = ['PM Vendor Master File'].VENDORID