Purchase Order

[anoopyadav]

Hello Everyone,

Please someone can let me know SQL for getting Purchase order pending for "APPROVAL" from purchase officer? ??

Purpose is to wirte one report to know how many purchase order are pending for approval by purchase order.

Thanks
anoop

[arun1203]

Hi Anoop,

Use the following query to get the list of all purchase orders which are pending for approvals.

<font color="red"><b>select * from po_headers_all t WHERE t.authorization_status='IN PROCESS'</b></font id="red">

<font color="blue"><b>Best Regards & Thanks,
Arun Reddy[:)]</b></font id="blue">