Open Purchase Orders

select
pha.po_header_id "po header id",
pha.segment1 "po number",
pv.vendor_id "vendor id",
pv.segment1 "vendor number",
pv.vendor_name "vendor name",
pha.authorization_status "authorization status",
pha.approved_date "approved date",
pha.creation_date "creation date",
fu.user_id "created by id",
fu.user_name "created by name",
pha.last_update_date "last update date",
pha.closed_code,
pha.cancel_flag

from
po_headers_all pha,
po_vendors pv,
fnd_user fu

where
pha.vendor_id=pv.vendor_id and
pha.created_by=fu.user_id and
authorization_status like 'APPROVED' and
nvl(closed_code,'OPEN') not in('CLOSED','FINALLY CLOSED') and
nvl(cancel_flag,'N')<>'Y'