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) */...

Generate 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",...

Generate tax invoice for supplier. User have to change currency code in below script as per requirement. /* Formatted on 8/22/2021 11:39:45 AM (QP5 v5.136.908.31019) */ SELECT DISTINCT RCTL.LINE_NUMBER AS...

In depth details of supplier with status of supplier & status of items.   SELECT DISTINCT msi.segment1 "ITEM CODE", pla.item_id, msi.description "ITEM DESCRIPTION", msi.inventory_item_status_code "ITEM STATUS", mp.organization_code, msi.item_type, PV.SEGMENT1 VENDOR_NUMBER, PV.VENDOR_NAME,...

Find out items returned up against the purchase order to supplier.  SELECT APS.VENDOR_NAME "SUPPLIER", ph.segment1 "PO NUM", MSI.DESCRIPTION, TO_NUMBER (QUANTITY_RECEIVED) " NET RECIEVED", (QUANTITY_SHIPPED - QUANTITY_RECEIVED) "RETURNED", rct.transaction_type, TRUNC (RCT.TRANSACTION_DATE)...

Find out items received against the purchase order from the supplier.  SELECT APS.VENDOR_NAME "SUPPLIER", ph.segment1 "PO NUM", MSI.DESCRIPTION, RCT.SOURCE_DOC_QUANTITY "RECIEVED", TO_NUMBER (QUANTITY_RECEIVED) " NET RECIEVED", rct.transaction_type, TRUNC (RCT.TRANSACTION_DATE) TRANSACTION_DATE FROM...

All the history of PO SELECT PHA.SEGMENT1 PO_NUM, PHA.REVISION_NUM, PLA.LINE_NUM PO_LINE_NUM, PLLA.SHIPMENT_NUM, PLA.ITEM_DESCRIPTION, PLA.UNIT_MEAS_LOOKUP_CODE, PLA.LIST_PRICE_PER_UNIT, PLA.CANCEL_FLAG, PLA.CANCEL_DATE, PLA.QUANTITY PO_LINE_QUANTITY, PHA.AUTHORIZATION_STATUS HEADER_APPROVAL_STATUS,PHA.APPROVED_FLAG HEADER_APPROVED_FLAG,PHA.APPROVED_DATE HEADER_APPROVED_DATE, PHA.CLOSED_CODE HEADER_CLOSURE_STATUS, PLA.CLOSED_CODE LINE_CLOSURE_STATUS, PLLA.CLOSED_CODE SHIPMENT_CLORSURE_STATUS, PLLA.APPROVED_FLAG...

Check the approval status of purchase order  SELECT poh.segment1 "PO NUM", poh.authorization_status "STATUS", pla.line_num "SEQ NUM", plla.line_location_id, d.po_distribution_id, poh.type_lookup_code "TYPE" FROM po.po_headers_all poh, po.po_lines_all pla, po.po_line_locations_all plla, po.po_distributions_all d WHERE...