View all the purchase order details from the creation dates which is very useful to identify status & details of PO. /* Formatted on 8/22/2021 12:02:13 PM (QP5 v5.136.908.31019) */...
/ Posted by KapilGenerate list of purchase order which are open yet. SELECT ph.segment1 po_num, ph.creation_date, hou.NAME "Operating Unit", ppx.full_name "Buyer Name", ph.type_lookup_code "PO Type", plc.displayed_field "PO Status", ph.comments, pl.line_num, plt.order_type_lookup_code "Line Type",...
/ Posted by Kapil