Wednesday 1 July 2015

Simple Query to Fetch the Inventory Item Which Does Not have Safety Stock in an Organization

Below Mentioned Query Can Fetch the Inventory Items Which Does Not have Safety Stock in an Organization

SELECT SEGMENT1
FROM MTL_SYSTEM_ITEMS_B
WHERE Inventory_ITEM_ID NOT IN
  (SELECT Inventory_ITEM_ID FROM MTL_SAFETY_STOCKS_VIEW
  )
AND Organization_ID = 'XXX'

No comments:

Post a Comment