Query retrieve order TAVI 'ready to pick'

minta tolong dibuatkan query untuk ngeretrieve order TAVI yang status nya 'ready to pick' (hanya ready to pick), minta tolong disiapin query nya, nanti aku akan butuh datanya ketika proses di magpie v2 sudah di cut-off dan mulai masuk periode SO.

select 
	"M8N3DATW9AP" as "StoreName",
	"ScYd0rirVdr" as "TrackingNum",
	"L9wUG36QNvd" as "OrderNum",
	"uvg23nGg8MR" as "OrderTime",
	"zCxpGlOMvw3" as "WarehouseStatus",
	"bKz0opEHSwS" as "OriginalStatus",
	"jenb7K4iFMX" as "DCName",
	"Vm7l04RQ6xI" as "OrganizationName",
	"fD5XlcDez6B" as "ShipperName"
from "e8b83099-7cca-4c26-abd1-67120be3dfbd"."ZcZi3bFNlL5" as "MO"
where "zCxpGlOMvw3" = 'Ready to Pick'
	AND ("M8N3DATW9AP" = 'SHOPEE TAVI' OR "M8N3DATW9AP" = 'LAZADA TAVI' OR "M8N3DATW9AP" = 'TOKOPEDIA TAVI')

Editor is loading...