garroch
2/26/2015 - 5:37 PM

Open PO Query

Open PO Query

SELECT
	po.purchase_order_id,
	po.expected_received_date::date,
	po.trailer_order--,
	--po.promotion_order
FROM 
	purchase_order po 
	INNER JOIN purchase_order_status postat ON postat.purchase_order_id = po.purchase_order_id
	LEFT JOIN purchase_order_receipt por ON por.purchase_order_id = po.purchase_order_id
WHERE
	postat.purchase_order_status_type_id IN (1,2)
	AND por.purchase_order_id IS NULL
ORDER BY po.expected_received_date::date DESC