loc_warehouse_id sanity check

user_0223141589

sql

a year ago

294 B

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