Skip to content

Instantly share code, notes, and snippets.

@johnvilsack

johnvilsack/InventoryPull

Created July 22, 2015 15:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johnvilsack/b167b1037f7860f8f4b4 to your computer and use it in GitHub Desktop.
Save johnvilsack/b167b1037f7860f8f4b4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
InventoryPull
SELECT
RTRIM(ITEM_ID) AS ITEM_ID
FROM INVENTOR
WHERE
(
ENTRY_DATE >= '2015-01-01'
OR
(AVAILABLE > 0 OR ON_ORDER_QTY > 0 OR COMMITTED_QTY > 0)
)
AND
PROD_CLASS_ID NOT IN ('GIFTC', 'REPAIR', 'OUTLET', 'MISC', 'DROP', 'CUST', 'CREDIT', 'CAT')
AND
A2 <> 'DJS'
OR
(DROP_SHIP IN ('Y', 'O'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment