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'
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