loc_warehouse_id sanity check

 avatar
user_0223141589
sql
a year ago
294 B
3
Indexable
Never
SELECT
sl.name,
sl.WAREHOUSE_ID,
sl.LOC_WAREHOUSE_ID,
sl.CREATE_DATE,
sl.usage,
sl.PARENT_PATH

FROM BIZ.POSTGRES_RDS_ODOO_PUBLIC.STOCK_LOCATION sl

--excludee customers and consignment
WHERE sl.parent_path NOT LIKE '%11169%'
AND sl.usage NOT IN ('customer','transit')

ORDER BY 4 DESC
LIMIT 50