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