loc_warehouse_id sanity check
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