Selecting all open PO's in po_headers_all
Hi Guys,
I'm trying to get select all open approved purchase orders for one of my users. This is for export to a third party system so they can be received against.
I am trying the following sql on the po_headers_all table but it is only showing around 9 results when i know there are a lot more (at last count 30) by running the Open Purchase Orders report (By Buyer) in Oracle Apps.
Here is my sql.
select CLOSED_CODE from PO_HEADERS_ALL
where
AGENT_ID = 15 AND
APPROVED_FLAG = 'Y' AND
CLOSED_CODE <> 'FINALLY CLOSED' AND
CLOSED_CODE <> 'CLOSED'
I am trying the following sql on the po_headers_all table but it is only showing around 9 results when i know there are a lot more (at last count 30) by running the Open Purchase Orders report (By Buyer) in Oracle Apps.
Here is my sql.
select CLOSED_CODE from PO_HEADERS_ALL
where
AGENT_ID = 15 AND
APPROVED_FLAG = 'Y' AND
CLOSED_CODE <> 'FINALLY CLOSED' AND
CLOSED_CODE <> 'CLOSED'
0